Export data to R
Posted: Wed Feb 06, 2019 6:51 am
I want to use the prophet package in R from EViews. Exporting data I have problems getting rid of dates.
My EViews code is
smpl 2000 2018
xopen(type=r)
xput(rtype=data.frame, name=df) @strdate("mm/dd/yyyy") a55
xon 'Turn on external R programming mode
names(df)<-c("ds","y")
print(df)
which yield a data frame in R that starts like
ds y
2000Q1 1/1/2000 257.89279
2000Q2 4/1/2000 166.89793
2000Q3 7/1/2000 203.12648
2000Q4 10/1/2000 449.24030
2001Q1 1/1/2001 334.18130
2001Q2 4/1/2001 232.18542
:
The quarter entry first in the ds column (e.g. 2000q1) seems to stick with every EViews object.How can I avoid it or get rid of it?
My EViews code is
smpl 2000 2018
xopen(type=r)
xput(rtype=data.frame, name=df) @strdate("mm/dd/yyyy") a55
xon 'Turn on external R programming mode
names(df)<-c("ds","y")
print(df)
which yield a data frame in R that starts like
ds y
2000Q1 1/1/2000 257.89279
2000Q2 4/1/2000 166.89793
2000Q3 7/1/2000 203.12648
2000Q4 10/1/2000 449.24030
2001Q1 1/1/2001 334.18130
2001Q2 4/1/2001 232.18542
:
The quarter entry first in the ds column (e.g. 2000q1) seems to stick with every EViews object.How can I avoid it or get rid of it?