HI All,
I am able to get the desired result. Thanks for extending help.
while reading the csv file I made some changes as :
Test<-read.csv("Testdata.csv", head=TRUE, stringsAsFactors = FALSE,
strip.white = TRUE)
with this character var were not changed to factors.
Then aggregation was simple:
aggregate(test$CHG_WT, list(test$CR_DT), sum)
However the output is not sorted based on Dates and the columns names
appearing as very different:
Group.1 x
1 1-Mar-15 909791
2 10-Mar-15 822436
3 11-Mar-15 848609
4 12-Mar-15 924842
5 13-Mar-15 895270
6 14-Mar-15 93238
7 2-Mar-15 731600
Can you all please suggest why the column names are so different and how I
could sort based on dates. I added the sort option in the above syntax
aggregate(test$CHG_WT, list(test$CR_DT), sum,sort(test$CR_DT,decreasing =
TRUE))
But it gave me an error:
Error in FUN(X[[i]], ...) : invalid 'type' (character) of argument
Thanks All.
--
View this message in context:
http://r.789695.n4.nabble.com/Summarizing-data-based-on-Date-tp4708328p4708423.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
