Re: [Gretl-users] Data Import - non-numeric values
Thank you for your time!
I am using a windows machine, unfortunately (and not used to using linux/unix os)... I
took a look again into gretl and hansl guides, but with join and/or append I could not
find such an option. However your answer already suggested that there is no
"easy" way I missed. So I'll set out to pre-process the data via python or
so.
Perhaps, if it is not much of a problem, such a "non-numeric-->NA" import
option would be something for a future version?
Regards and thanks for the quick answer
Frederik
------------
Frederik Schaff, Dipl.-Volkswirt
University of Hagen
Department of Business and Economics
Chair of Economic Theory (Prof. A. Endres)
Universitätsstraße 11 (TGZ)
58097 Hagen
Phone: +49 (0) 2331 987-4454
E-Mail: Frederik.Schaff(a)FernUni-Hagen.de
http://www.fernuni-hagen.de/wirtschaftstheorie/en/team/frederik.schaff.shtml
-----Ursprüngliche Nachricht-----
Von: gretl-users-bounces(a)lists.wfu.edu [mailto:gretl-users-bounces@lists.wfu.edu] Im
Auftrag von Riccardo (Jack) Lucchetti
Gesendet: Sonntag, 27. September 2015 10:30
An: Gretl list
Betreff: Re: [Gretl-users] Data Import - non-numeric values
On Sun, 27 Sep 2015, Schaff, Frederik wrote:
Hello everybody,
I have a data-set with some non-numeric values according to gretl (but not to CSVed).
[1]: Problematic values (examples):
4.13108e-312 5.27295e-270 4.3172e-227 1.51922e-184 3.97655e-142 1.42149e-144 1.94409e-143 2.79222e-144
(These values stem from uninitialised double variables in my c++ model, I guess).
Is there an option unbeknown to me to simply substitute such
non-numerics by Gretl "NA" directly with the import? I.e. make the
error messages quiet and gretl process nonetheless?
I cannot find one and an old request
(http://sourceforge.net/p/gretl/feature-requests/47/) is long closed...
In principle, anything is possible, since in Hansl you get several string-related function
for importing your file as a big string and manipulating it later.
However, if you're using a Unix-like system (Linux, BSD, OSX...) you might want to
pre-process the data and produce a more user-friendly csv file via the trusty, old,
all-powerful unix tools. Or at least, that's what *I* would do. Something like
sed yourdata.csv -e 's/[0-9].[0-9]*[Ee]-[1-3][0-9]2/NA/g' > cleandata.csv
-------------------------------------------------------
Riccardo (Jack) Lucchetti
Dipartimento di Scienze Economiche e Sociali (DiSES)
Università Politecnica delle Marche
(formerly known as Università di Ancona)
r.lucchetti(a)univpm.it
http://www2.econ.univpm.it/servizi/hpp/lucchetti
-------------------------------------------------------