Need some help- tidying my data and calculation for diurnal root growth

[Kare mahmut]

Hi Everyone,

I have some root observation data with 13088 obs. of 16 variables and I tried to tidy my data. I made reference from Prof.Hadley Wickham`s tidy data and tools, but still could not slove my problem. I tried to attach some of my data and unfortunately it did not work. Therefore, I have attached some of  my data here. Please give me some advice.

Thanks

Mahmut

Observation time	Elapsed time	Rootstock	REP	pot side	Root ID	Length	Diamater	Color	Conditon	Soil temperature	Air temparature	Houly growth rate	Average root groth arte  Root ID	Root type
25/10/2013 21:07	0	RAM	RAM1	1	1	14.5	1.83	White	NO_CODE	18.34	10.4	0	0.149829	Moderate
26/10/2013 6:28	9	RAM	RAM1	1	1	15.52	1.83	White	NO_CODE	12.49	2.5	0.108376	0.149829	Moderate
26/10/2013 13:12	16	RAM	RAM1	1	1	15.52	1.83	White	NO_CODE	19.01	19.8	0	0.149829	Moderate
26/10/2013 20:09	23	RAM	RAM1	1	1	17.37	1.83	White	NO_CODE	24.02	13	0.269061	0.149829	Moderate
27/10/2013 6:14	33	RAM	RAM1	1	1	18.76	1.83	White	NO_CODE	11.66	4.9	0.136734	0.149829	Moderate
27/10/2013 13:26	40	RAM	RAM1	1	1	18.76	1.83	White	NO_CODE	21.68	22.1	0	0.149829	Moderate
27/10/2013 20:24	47	RAM	RAM1	1	1	20.28	1.83	White	NO_CODE	26.68	15.8	0.221212	0.149829	Moderate
28/10/2013 6:43	58	RAM	RAM1	1	1	21.6	1.83	White	NO_CODE	15.34	10.3	0.126264	0.149829	Moderate
28/10/2013 11:02	62	RAM	RAM1	1	1	21.6	1.83	White	NO_CODE	16.84	21.4	0	0.149829	Moderate
28/10/2013 20:09	71	RAM	RAM1	1	1	24.13	1.83	White	NO_CODE	27.02	18	0.27855	0.149829	Moderate
29/10/2013 6:14	81	RAM	RAM1	1	1	24.94	1.83	White	NO_CODE	17.34	9.5	0.080117	0.149829	Moderate
29/10/2013 13:40	88	RAM	RAM1	1	1	24.94	1.83	White	NO_CODE	19.01	22	0	0.149829	Moderate
29/10/2013 21:07	96	RAM	RAM1	1	1	28.57	1.83	White	NO_CODE	27.52	14.9	0.481163	0.149829	Moderate
.	.	.	.
till	.	.	.
			RAM4	2
30/10/2013 21:00	121	RUG	RUG 1,2,3,4	1,2	up to 66
		SCH	SCH1,2,3,4
		SHZ	SHZ1,2,3,4

[Dipanjan Deb]

Hi Kare,

I am not sure what you meant by 'tidy' up the data. You need to specify how would you like to see the output as. You might want to use plyr or reshape2 libraries to melt and cast the data. It might be a little confusing to start and there is a GUI version available called reshapeGUI. Let us know if that helps.

Just to let you know, this group is specific to ggplot2 which is meant for plotting charts (a very understatement of ggplot2 though!)

--
--
You received this message because you are subscribed to the ggplot2 mailing list.
Please provide a reproducible example: https://github.com/hadley/devtools/wiki/Reproducibility
 
To post: email ggp...@googlegroups.com
To unsubscribe: email ggplot2+u...@googlegroups.com
More options: http://groups.google.com/group/ggplot2

---
You received this message because you are subscribed to the Google Groups "ggplot2" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ggplot2+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Regards,
Dipanjan