I know this is likely very simple. I want to change a matrix that was given to me not sorted by timestamp to sorted by timestamp. It was sorted by CRAH_Name. There are 264k records initially. The CRAH names start at 11 and go to 98 but there are a number of missing values (CRAH_Name), total approx. 50.
A small example of the given matrix Time_Stamp Power CRAH_Name 4/16/2012 00:00 3.4862 11 4/16/2012 00:01 3.4862 11 4/16/2012 00:02 3.61035 11 4/16/2012 00:03 3.57215 11 4/16/2012 00:04 3.6008 11 4/16/2012 00:05 3.64855 11 4/16/2012 00:06 3.64855 11 4/16/2012 00:07 3.6008 11 4/16/2012 00:08 3.639 11 4/16/2012 00:09 3.6581 11 4/16/2012 00:10 3.6963 11 4/16/2012 00:00 2.618646 98 (timestamping starts over again at 00:00) 4/16/2012 00:01 2.195102 98 4/16/2012 00:02 2.758223 98 4/16/2012 00:03 2.796727 98 4/16/2012 00:04 2.652337 98 4/16/2012 00:05 2.233606 98 4/16/2012 00:06 2.811166 98 4/16/2012 00:07 2.690841 98 4/16/2012 00:08 2.406874 98 4/16/2012 00:09 2.811166 98 4/16/2012 00:10 2.286549 98 I want to transform into a dataframe that looks like this.. CRAH Name 11 12 13............ 98 timestamp ..01 power value power value power value ...........power value timestamp ..02 power value power value power value ...........power value timestamp ..03 power value power value power value ...........power value This is how I'm used to dealing with time series data. Thanks very much for any help. I would like to use standard R function if not too complicated. -- View this message in context: http://r.789695.n4.nabble.com/Simple-matrix-transformation-question-tp4585044p4585044.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list 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.
