2 messages · Bernardo Rangel Tura, Gabor Grothendieck
Hi people, I need reorganization several databases. I would like to know if that is possible in R. My problem is like that: original data base: Age x1980 x1981 1 5 8 3 7 9 5 9 15 7 11 20 future data base year age x 1980 1 5 1980 3 7 1980 5 9 1980 7 11 1981 1 8 1981 3 9 1981 5 15 1981 7 20 Thanks in advance Bernardo Rangel Tura, MD, MSc National Institute of Cardiology Laranjeiras Rio de Janeiro Brazil
No virus found in this outgoing message. Checked by AVG Anti-Virus.
Bernardo Rangel Tura <tura <at> centroin.com.br> writes: : original data base: : : Age x1980 x1981 : 1 5 8 : 3 7 9 : 5 9 15 : 7 11 20 : : future data base : : year age x : 1980 1 5 : 1980 3 7 : 1980 5 9 : 1980 7 11 : 1981 1 8 : 1981 3 9 : 1981 5 15 : 1981 7 20 Use reshape like this: yn <- names(D)[2:3] reshape(D, dir = "long", varying = list(yn), times = yn, v.names = "x") and then do whatever fix ups you need on the result.