[R] How to split a Spell Data Frame into long format (irregular episode length)
PabloNeruda
s_ysinm5 at uni-bremen.de
Sat Mar 22 11:06:18 CET 2014
Dear R-Users and developers,
I am used to work with singular data but now I have to get my data of an
spell-data-frame conducted in a big German longitudinal survey.
The data structure is:
persnr spelltyp begin end
xf105 10 1 5
xf105 1 6 15
xf106 4 7 12
xf106 7 13 15
xf106 1 16 20
The variable "spelltyp" means a type of employment, 1 meaning
full-time-employment, 4 meaning small part-time employment and so on. The
begin and end are months, beginning with the first month of survey data
collection as 1 (goes up to month 340).
My goal is to transform it into a long-format file such as
persnr spelltyp month
xf105 10 1
xf105 10 2
xf105 10 3
xf105 10 4
xf105 10 5
xf105 1 6
xf105 1 7
xf105 1 8
xf105 1 9
xf105 1 10
xf105 1 11
xf105 1 12
xf105 1 13
xf105 1 14
xf105 1 15
xf106 4 7
xf106 4 8
xf106 4 9
xf106 4 10
xf106 4 11
xf106 4 12
xf106 7 13
xf106 7 14
xf106 7 15
xf106 1 16
xf106 1 17
xf106 1 18
xf106 1 19
xf106 1 20
So what I want to do with R is to write a new row for every month and create
a new variable where the number of the month is written in (one could keep
the variables begin and end).
Later on I want to reshape it into I wide-format to perform a sequence
analysis.
I am grateful for any advise - Thanks!
--
View this message in context: http://r.789695.n4.nabble.com/How-to-split-a-Spell-Data-Frame-into-long-format-irregular-episode-length-tp4687335.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list