I tried to change the date format using a regular expression (on the editor
"geany").
This was the search expression: ^(\d+-\w{3}-)(\d+)(,.*)
This was the replace expression: \120\2\3
Then in a second pass, I made two digits for days, with:
This was the search expression: ^(\d{1})(-\w+.*)
This was the replace expression: 0\1\2
Then as I saw on the report, it was expecting 4 digits year starting dates:
This was the search expression: ^(\d{2})-(\w{3})-(\d{4})(,.*)
This was the replace expression: \3-\2-\1\4
Finally, changed 3 letters months to digits.
Then changed missing values to -999.
Removed first label, and finally recognized as dates. But:
Error: date '2015-12-17' is repeated
Deleted the line and it imported correctly. File is attached.
*My Favorite Open Source Projects awsome-lists
<
On Tue, Oct 24, 2017 at 6:10 PM, Sangvinatsos, Antonios <
Antonios.Sangvinatsos(a)pimco.com> wrote:
Hi Allin,
Please find attached the CSV file.
Another attempt I had is the following: I inserted the file but did not
accept that gretl recognizes it as time series or panel. So I did not go to
the next windows that create the date index.
But the problem now is that I am not allowed to create a time series plot.
I can create though a scatter plot of the two variables I sent you. But I
would prefer to have a continuous line and not crosses.
Thanks,
A.
-----Original Message-----
From: gretl-devel-bounces(a)lists.wfu.edu [mailto:gretl-devel-bounces@
lists.wfu.edu] On Behalf Of Allin Cottrell
Sent: Tuesday, October 24, 2017 10:01 AM
To: Gretl development
Subject: Re: [Gretl-devel] Time series data with gaps and plots
On Tue, 24 Oct 2017, Sangvinatsos, Antonios wrote:
> I have a daily time series (weekdays) that has some missing data in
> dates of holidays. When I insert the CSV file a window prompt asks me
> if it is a time series and then to select if it is daily. I select
> daily with 5 days per week and give the starting date but then gretl
> creates its own date index assuming all the weekdays are available and
> hence there is a mismatch of the time index and the time series. Why
> gretl totally ignores the date series provided in the csv file and it
> just thinks it is one more time series variable?
What exactly do your daily dates look like?
If you care to send me your CSV file offlist I will take a look at it.
Gretl recognizes dates in several forms, but apparently not the form given
in your file.
Allin Cottrell
_______________________________________________
Gretl-devel mailing list
Gretl-devel(a)lists.wfu.edu
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.
wfu.edu_mailman_listinfo_gretl-2Ddevel&d=DwICAg&c=
91HTncUBNS9Yv-Uuv2IlCA&r=E7D_CHy_hIJ7pRRDWHTeorb4B3Ubq4JxRJjE-NbzNLw&m=
nLDLDI7DT09H5MCpMEJx0BxGywAJP_eVnt4yHCSL5qc&s=B27_gZ-RhiLo6zXNjs1nGjM7_
FQVYzewHwnvpSI5uCY&e=
This message contains confidential information and is intended only for
the individual named. If you are not the named addressee, you should not
disseminate, distribute, alter or copy this e-mail. Please notify the
sender immediately by e-mail if you have received this e-mail by mistake
and delete this e-mail from your system. E-mail transmissions cannot be
guaranteed to be secure or without error as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses. The sender, therefore, does not accept liability for any
errors or omissions in the contents of this message which arise during or
as a result of e-mail transmission. If verification is required, please
request a hard-copy version. This message is provided for information
purposes and should not be construed as a solicitation or offer to buy or
sell any securities or related financial instruments in any jurisdiction.
Securities are offered in the U.S. through PIMCO Investments LLC,
distributor and a company of PIMCO LLC.
The individual providing the information herein is an employee of Pacific
Investment Management Company LLC ("PIMCO"), an SEC-registered investment
adviser. To the extent such individual advises you regarding a PIMCO
investment strategy, he or she does so as an associated person of PIMCO.
To the extent that any information is provided to you related to a
PIMCO-sponsored investment fund ("PIMCO Fund"), it is being provided to you
in the individual's capacity as a registered representative of PIMCO
Investments LLC ("PI"), an SEC-registered broker-dealer. PI is not
registered, and does not intend to register, as a municipal advisor and
therefore does not provide advice with respect to the investment of the
proceeds of municipal securities or municipal escrow investments. In
addition, unless otherwise agreed by PIMCO, this communication and any
related attachments are being provided on the express basis that they will
not cause PIMCO LLC, or its affiliates, to become an investment advice
fiduciary under ERISA or the Internal Revenue Code.
_______________________________________________
Gretl-devel mailing list
Gretl-devel(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-devel