[R] After sorting a dataframe by date
martiny
my2108 at outlook.com
Tue Oct 23 18:34:19 CEST 2012
HI,
I have created a dataframe "df" and try to sort it by its date using the
order() as below:
df<-read.csv(constr,header=T)
sorted.df<-df[order(as.Date(df$Date), decreasing = F),]
print(sorted.df)
The dataframe was sorted, but the output from the command console shows
reserved line order..rather than starting at "1"....it does not really
affect my result, but I want to understand why is that...
Date Open High Low Close Volume Adj.Close
252 2011-01-03 325.64 330.26 324.84 329.57 15897800 328.16
251 2011-01-04 332.44 332.50 328.15 331.29 11038600 329.87
250 2011-01-05 329.55 334.34 329.50 334.00 9125700 332.57
249 2011-01-06 334.72 335.25 332.90 333.73 10729600 332.30
248 2011-01-07 333.99 336.35 331.90 336.12 11140400 334.68
247 2011-01-10 338.83 343.23 337.17 342.45 16020000 340.99
246 2011-01-11 344.88 344.96 339.47 341.64 15861000 340.18
245 2011-01-12 343.25 344.43 342.00 344.42 10806800 342.95
244 2011-01-13 345.16 346.64 343.85 345.68 10599300 344.20
...
...
3 2011-12-28 406.89 408.25 401.34 402.64 8166500 400.92
2 2011-12-29 403.40 405.65 400.51 405.12 7713500 403.39
1 2011-12-30 403.51 406.28 403.49 405.00 6416500 403.27
Any advice would be highly appreciated.
--
View this message in context: http://r.789695.n4.nabble.com/After-sorting-a-dataframe-by-date-tp4647173.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list