[R] how to read a df like that and transform it?

Yao He yao.h.1988 at gmail.com
Wed Jan 23 13:42:36 CET 2013


Dear all

I have a data.frame like that :

father	mother	num_daughter	daughter
291	3906	0	NULL
275	4219	0	NULL
273	4236	1	49410
281	4163	1	49408
274	4226	1	49406
295	3869	2	49403
			        49404
287	4113	0	NULL
295	3871	1	49401
292	3895	4	49396
			        49397
			        49398
			        49399
291	3900	3	49392

How to read it into R and transform it like that:

father mother	num_daughter   daughter1  daughter2  daughter3 daughter4
291	3906	0	NULL
275	4219	0	NULL
273	4236	1	49410
281	4163	1	49408
274	4226	1	49406
295	3869	2	49403      49404
287	4113	0	NULL
295	3871	1	49401
292	3895	4	49396      49397    49398   49399
291	3900	3	49392

library (plyr) and library (reshape2) and other good packages are  OK for me.

Thanks a lot!

Yao He
—————————————————————————
Master candidate in 2rd year
Department of Animal genetics & breeding
Room 436,College of Animial Science&Technology,
China Agriculture University,Beijing,100193
E-mail: yao.h.1988 at gmail.com
——————————————————————————



More information about the R-help mailing list