![]() ![]() I’m not sure why I didn’t find it earlier, but his solution was somewhat more general than what I have been looking for. Writer a word processor you can use for anything from writing a quick letter to producing an entire book. Timezone issues, perhaps? On Jeff Ryan’s advice to keep all my date transformations in POSIX, I finally found a better solution in r-help that had been posted by Whit Armstrong years and years ago. Compatible with other major office suites, Apache OpenOffice is free to download, use, and distribute. DataPilot is an advanced technology that makes it easy. Newcomers find it intuitive and easy to learn professional data miners and number crunchers will appreciate the comprehensive range of advanced functions. That’s worked fine for me until I recently found strange, eight-second misalignments between my data sets that seemed to be caused by the transformation above. The solution to storing all your numbers and lists Calc is the spreadsheet application you’ve always wanted. ![]() ![]() Provides features not in Excel Natural language formulas. Create spreadsheets with raw data and use DataPilot technology to cross-tabulate, summarize and convert into meaningful information. I said it wasn’t pretty, didn’t I? You are reading that right – convert the index first to yearmon, then to Date (with frac representing the fraction of a month with a number between 1 and 0), then finally to POSIXct. Calc is an easy to understand spreadsheet program that appeals to novice users and professional data miners and number crunchers alike. I’d looked around, and the best solution I’d found on r-help was something of a kludge: index(x) = as.POSIXct(as.Date(as.yearmon(index(x)),frac=1), tz="UTC") The solution for this isn’t obvious in Excel or OpenOffice, either, but I thought it would be at least similarly simple in R. For what I want to do, I’m content to align the data to the last day of the month. The different sources report the timestamp of the monthly data differently – one reports the date without the day, another as the last business day, and another as the last day of the month. I have different sets of monthly data that I want to align and evaluate once a month.
0 Comments
Leave a Reply. |