Hi Please do not post in HTML formating, your messages are then messy. Better to show how your data frame look like is something like
dput(bop.df[1:10,]) Anyway, melt/cast functions from reshape2 package are quite handy for such tasks. Cheers Petr > -----Original Message----- > From: R-help <r-help-boun...@r-project.org> On Behalf Of Admire Tarisirayi > Chirume > Sent: Monday, May 17, 2021 9:44 AM > To: r-help@r-project.org > Subject: [R] Wide to long format in R > > I need help on reshaping my data frame which is currently in wide format. > > I ran the following codes to create panel ids based on the variable for country > names "*Country"; * > > *bop.df$id<-as.numeric(as.factor(bop.df$Country))* > > then ran the code below to reshape from wide to long format; > > *reshaped.bop <- pivot_longer(bop.df,3:17,names_to = "year", values_to = > "value")* > > by running the code: *print( reshaped.bop), the following table in long > format came out;* > > > Country year bank_ratio Reserve_ratio broad_money id Angola 2006 24 77 > 163 1 Angola 2007 25 59 188 1 Botswana 2008 38 64 317 1 Botswana 2009 34 65 > 361 1 Zimbabwe 2010 42 57 150 1 Zimbabwe 2006 49 86 288 2 > > > This, however, is not what i wanted. kindly help with the code that formats > my table in the following way? > > Country Variables id year value > Angola bank_ratio 1 2006 24 > Angola bank_ratio 1 2007 25 > Angola Reserve_ratio 1 2008 77 > Angola Reserve_ratio 1 2009 59 > Angola broad_money 1 2010 163 > Angola broad_money 1 2006 188 > Botswana bank_ratio 2 2006 38 > Botswana bank_ratio 2 2007 34 > Botswana Reserve_ratio 2 2008 64 > Botswana Reserve_ratio 2 2009 65 > Botswana broad_money 2 2010 317 > Botswana broad_money 2 2006 361 > Zimbabwe bank_ratio 3 2006 42 > Zimbabwe bank_ratio 3 2007 49 > Zimbabwe Reserve_ratio 3 2008 57 > Zimbabwe Reserve_ratio 3 2009 86 > Zimbabwe broad_money 3 2010 150 > Zimbabwe broad_money 3 2006 288 > > Thank you > > Alternative email: addtar...@icloud.com/tchir...@rbz.co.zw > Skype: admirechirume > Call: +263773369884 > whatsapp: +818099861504 > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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.
______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
