Hi,
I think that the name of the Date field is missing (there are some
rules for Gretl recognize CSV as time series).
Good luck.
Helio
Date,shillerRet,state,consSentiment,PMI
On Thu, Jan 3, 2013 at 4:03 PM, Grześ Andruszkiewicz <gandrusz(a)gmail.com> wrote:
Hi,
As in the documentation, I am trying to import data to gretl from a csv
file.
The data is monthly, so it looks something like this:
,shillerRet,state,consSentiment,PMI
1987:02,0.0045773162,1,90.4,54.9
1987:03,0.004080661,1,90.2,52.6
1987:04,0.0045113495,1,90.8,55
1987:05,0.0050701111,1,92.8,55.5
1987:06,0.004516603,1,91.1,57.2
(...)
but gretl fails to interpret is as timeseries data:
parsing /home/ga1009/PhD/cpp/pmi/gretlInput.csv...
using delimiter ','
longest line: 43 characters
number of columns = 5
number of variables: 4
number of non-blank lines: 297
scanning for variable names...
line: ,shillerRet,state,consSentiment,PMI
scanning for row labels and data...
the cell for variable 3, obs 294 is empty: treating as missing value
the cell for variable 3, obs 295 is empty: treating as missing value
the cell for variable 3, obs 296 is empty: treating as missing value
first row label "1987:02", last label "2011:09"
trying to parse row labels as dates...
1987: probably a year... month 02?
1987:01: not a consistent date
but the dates are not complete and consistent
treating these as undated data
Am I doing something wrong?
Regards,
Grzegorz
_______________________________________________
Gretl-users mailing list
Gretl-users(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users