[R] Wide to long format in R

[Admire Tarisirayi Chirume]

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: addtarris using icloud.com/TChirume using rbz.co.zw
Skype: admirechirume
Call: +263773369884
whatsapp: +818099861504

	[[alternative HTML version deleted]]