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.
I didn't say how I would read it in... I assume just read in using read.table but I didn't try that. So I guess that is another part of the question. -- View this message in context: http://r.789695.n4.nabble.com/Simple-matrix-transformation-question-tp4585044p4585112.html Sent from the R help mailing list archive at Nabble.com.
library(reshape2)
?dcast
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
Henry <hccoles at lbl.gov> wrote:
>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 at 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.
Jeff, Thanks we are looking at that (reshape2 and dcast) now. -Henry -- View this message in context: http://r.789695.n4.nabble.com/Simple-matrix-transformation-question-tp4585044p4585246.html Sent from the R help mailing list archive at Nabble.com.
Jeff, Thanks we are looking at that (reshape2 and dcast) now. -Henry -- View this message in context: http://r.789695.n4.nabble.com/Simple-matrix-transformation-question-tp4585044p4585247.html Sent from the R help mailing list archive at Nabble.com.