gretl fails to import time series data from csv
by Grześ Andruszkiewicz
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
11 years, 8 months
R: Re: Happy New Year
by mastro2387＠tiscali.it
sorry for the delay..Happy New Year to all of you!!!
Thanks to you I
coped with my final MS dissertation!
Ciao!
----Messaggio
originale----
Da: cottrell(a)wfu.edu
Data: 31/12/2012 20.35
A: <r.
lucchetti(a)univpm.it>, "Gretl list"<gretl-users(a)lists.wfu.edu>
Ogg: Re:
[Gretl-users] Happy New Year
On Mon, 31 Dec 2012, Riccardo (Jack)
Lucchetti wrote:
> On Mon, 31 Dec 2012, Henrique Andrade wrote:
>
>>
Dear Gretl Community,
>>
>> I wish you Happy New Year! Thank you for
the great discussions we had here
>> in our mailing-list!
>
> Happy
new year, everbody!
It's not quite 2013 here in Scotland yet, but...
me too ;-)
Allin Cottrell
_______________________________________________
Gretl-users mailing
list
Gretl-users(a)lists.wfu.edu
http://lists.wfu.
edu/mailman/listinfo/gretl-users
Invita i tuoi amici e Tiscali ti premia! Il consiglio di un amico vale più di uno spot in TV. Per ogni nuovo abbonato 30 € di premio per te e per lui! Un amico al mese e parli e navighi sempre gratis: http://freelosophy.tiscali.it/
11 years, 8 months
Concerning raport writing
by Nabil Brandl
Thanks for your useful reply. I can transfere my results from Gretl to
Microsoft word to write report or transfere results to Microsoft excel and
enter excel file to SAS system to write report using proc tabulate. Both
system can be converted to HTML to be publish on web.
Thanks again
Nabil Brandl
http://nabilnabil.homestead.com
11 years, 8 months
gnuplot issue with histogram
by artur tarassow
Hi gretl-list members,
actually this is a gnuplot issue but I thought that somebody may help me
with this.
I set up a function (see file attached) to plot some barplots but it does
not work as it is planned. I have a matrix
A = { 1999, 2.2, 3, 2 ; 2000, 2.8, 1.1, 2 ; 2001, 3, 2.2, 2; 2002, 2.2, 3,
2 } for which I want to plot columns 2 to 4 for each year but at the moment
only column 2 is plotted.
I suspect to the problem being with the following line in the code:
printf "plot '-' using 2:xtic(1) ti col, '' u 3 ti col, '' u 4 ti col\n"
I tried different ways but for some reason columns 3 and 4 don't appear .
Does anybody have an idea what's wrong with the code here? I am using
current CVS on windows.
Best,
Artur
11 years, 8 months
Rapport writing
by Nabil Brandl
Happy new year 2013 and I wish the new year will be a good year for Gretl
community. I tried the Gretl system and after one week I wrote a program to
analysis my data and run statistics process. I learned very fast because the
system is very user friendly.
I want to write the results in report form. If anyone has idea to solve this
problem, I want to know that.
Best regards and keep in touch
Nabil Brandl
<http://nabilnabil.homestead.com> http://nabilnabil.homestead.com
11 years, 8 months
Re: [Gretl-users] Gretl-users Digest, Vol 72, Issue 1
by Francisco López Herrera
Happy New Year, God Bless you!...flh(Parameswara das anudas)
>________________________________
> De: "gretl-users-request(a)lists.wfu.edu" <gretl-users-request(a)lists.wfu.edu>
>Para: gretl-users(a)lists.wfu.edu
>Enviado: Martes, 1 de enero, 2013 11:00:01
>Asunto: Gretl-users Digest, Vol 72, Issue 1
>
>Send Gretl-users mailing list submissions to
> gretl-users(a)lists.wfu.edu
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.wfu.edu/mailman/listinfo/gretl-users
>or, via email, send a message with subject or body 'help' to
> gretl-users-request(a)lists.wfu.edu
>
>You can reach the person managing the list at
> gretl-users-owner(a)lists.wfu.edu
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Gretl-users digest..."
>
>
>Today's Topics:
>
> 1. Re: Happy New Year (Allin Cottrell)
> 2. Re: Happy New Year (nicolas arturo nunez gomez)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Mon, 31 Dec 2012 19:35:40 +0000 (GMT)
>From: Allin Cottrell <cottrell(a)wfu.edu>
>Subject: Re: [Gretl-users] Happy New Year
>To: r.lucchetti(a)univpm.it, Gretl list <gretl-users(a)lists.wfu.edu>
>Message-ID:
> <alpine.DEB.2.00.1212311934170.2022(a)localhost6.localdomain6>
>Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
>
>On Mon, 31 Dec 2012, Riccardo (Jack) Lucchetti wrote:
>
>> On Mon, 31 Dec 2012, Henrique Andrade wrote:
>>
>>> Dear Gretl Community,
>>>
>>> I wish you Happy New Year! Thank you for the great discussions we had here
>>> in our mailing-list!
>>
>> Happy new year, everbody!
>
>It's not quite 2013 here in Scotland yet, but... me too ;-)
>
>Allin Cottrell
>
>
>------------------------------
>
>Message: 2
>Date: Mon, 31 Dec 2012 14:45:00 -0500
>From: nicolas arturo nunez gomez <ninugo(a)usco.edu.co>
>Subject: Re: [Gretl-users] Happy New Year
>To: Gretl list <gretl-users(a)lists.wfu.edu>
>Message-ID:
> <CANtrjSVVLcY=2B23MwtM63MQODjwsLneKYVgLmr5gVn6835BTw(a)mail.gmail.com>
>Content-Type: text/plain; charset="iso-8859-1"
>
>you too
>nicolas
>El 31/12/2012 14:44, "Allin Cottrell" <cottrell(a)wfu.edu> escribi?:
>
>> On Mon, 31 Dec 2012, Riccardo (Jack) Lucchetti wrote:
>>
>> > On Mon, 31 Dec 2012, Henrique Andrade wrote:
>> >
>> >> Dear Gretl Community,
>> >>
>> >> I wish you Happy New Year! Thank you for the great discussions we had
>> here
>> >> in our mailing-list!
>> >
>> > Happy new year, everbody!
>>
>> It's not quite 2013 here in Scotland yet, but... me too ;-)
>>
>> Allin Cottrell
>> _______________________________________________
>> Gretl-users mailing list
>> Gretl-users(a)lists.wfu.edu
>> http://lists.wfu.edu/mailman/listinfo/gretl-users
>>
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: http://lists.wfu.edu/pipermail/gretl-users/attachments/20121231/bf45410d/...
>
>------------------------------
>
>_______________________________________________
>Gretl-users mailing list
>Gretl-users(a)lists.wfu.edu
>http://lists.wfu.edu/mailman/listinfo/gretl-users
>
>End of Gretl-users Digest, Vol 72, Issue 1
>******************************************
>
>
>
11 years, 8 months
