R help - Aug 2021 - Long Format data

Hi Admire,
I think rep_n_stack in the prettyR package may do what you want:

# download and install the prettyR package
install.packages("prettyR")
# load the prettyR package
library(prettyR)
# read in your data
ATCdf<-read.csv("BOP_All_Countries.csv",stringsAsFactors=TRUE)
# convert the values you want to long format
ATClong<-rep_n_stack(ATCdf,to.stack=3:17,stack.names=c("year","value"))
# as your column names in Excel will be coerced to character values by
prepending "X",
# coerce them back to numeric
ATClong$year<-as.numeric(substr(ATClong$year,2,5))
# check the first row
ATClong[1,]

As the "Variables" column is messy, you may want to substitute the
numeric value in the long output and print a table of the numeric and
character values of the factor:

unique(ATClong$Variables)
ATClong$Variables<-as.numeric(ATClong$Variables)

Jim

On Tue, Aug 3, 2021 at 9:53 PM Admire Tarisirayi Chirume
<atchirume at gmail.com> wrote:
>
>
>
> Hello Jim, i hope you are well. I think my msg was rejected beacuse of the
size of my files. I was kindly help me to structure data in the folder attached
herewith in file BOP_All_Countries.csv. I am doing panel data analysis. I need
it to be structured as it is on the file R_help.csv.
>
> Please kindly see the r-script below (r_help.R) that i ran which did not
yield what i wanted.
>
> Thank you in advance for your help.
>
>
> Alternative email: addtarris at icloud.com/TChirume at rbz.co.zw
> Skype: admirechirume
> Call: +263773369884
> whatsapp: +818099861504

Thank you very much, the code worked the trick. Thank you, i appreciate.

Alternative email: addtarris at icloud.com/TChirume at rbz.co.zw
Skype: admirechirume
Call: +263773369884
whatsapp: +818099861504


On Thu, Aug 5, 2021 at 11:53 AM Jim Lemon <drjimlemon at gmail.com> wrote:
> Hi Admire,
> I think rep_n_stack in the prettyR package may do what you want:
>
> # download and install the prettyR package
> install.packages("prettyR")
> # load the prettyR package
> library(prettyR)
> # read in your data
> ATCdf<-read.csv("BOP_All_Countries.csv",stringsAsFactors=TRUE)
> # convert the values you want to long format
>
ATClong<-rep_n_stack(ATCdf,to.stack=3:17,stack.names=c("year","value"))
> # as your column names in Excel will be coerced to character values by
> prepending "X",
> # coerce them back to numeric
> ATClong$year<-as.numeric(substr(ATClong$year,2,5))
> # check the first row
> ATClong[1,]
>
> As the "Variables" column is messy, you may want to substitute
the
> numeric value in the long output and print a table of the numeric and
> character values of the factor:
>
> unique(ATClong$Variables)
> ATClong$Variables<-as.numeric(ATClong$Variables)
>
> Jim
>
> On Tue, Aug 3, 2021 at 9:53 PM Admire Tarisirayi Chirume
> <atchirume at gmail.com> wrote:
> >
> >
> >
> > Hello Jim, i hope you are well. I think my msg was rejected beacuse of
> the size of my files. I was kindly help me to structure data in the folder
> attached herewith in file BOP_All_Countries.csv. I am doing panel data
> analysis. I need it to be structured as it is on the file R_help.csv.
> >
> > Please kindly see the r-script below (r_help.R) that i ran which did
not
> yield what i wanted.
> >
> > Thank you in advance for your help.
> >
> >
> > Alternative email: addtarris at icloud.com/TChirume at rbz.co.zw
> > Skype: admirechirume
> > Call: +263773369884
> > whatsapp: +818099861504
>
	[[alternative HTML version deleted]]