[Gretl-users] WG: append horizontal and vertical

Schaff, Frederik Frederik.Schaff at fernuni-hagen.de
Tue Sep 19 05:36:57 EDT 2017


Dear all,

I am trying to load a bunch of data into gretl, with a structure similar to the attached files (time 1600), i.e. I have horizontal and vertical appending at the same time. I basically use a script that opens the first file (like parameters_1.tsv) and then via a loop appends all the other files. However, the horizontal appending works only for the first files (belonging to *_1.tsv) and even there not completely, afterwards a single entry is done for each file, with "missing" values. There is a common key in the first column, so I thought the "update-overlap" option should work (after the first record is complete (all 9 files above appended) and the first "item" of each record is added (see script attached). It does not, however....

PS: the "--quiet" option is not present in the tool-tip of "append".

A WE is given with the script and the 18 files (first 2 records of my simulation experiment). The operation should lead to two records, but it ends up with 11... Take a look at the common key "ABMAT_ConfigID" to see what I mean with one glance, after you imported the data.

Any idea what I am missing?

Best Frederik
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1999_1.tsv
Type: text/tab-separated-values
Size: 3727 bytes
Desc: stat_1500-1999_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0020.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: parameters_1.tsv
Type: text/tab-separated-values
Size: 509 bytes
Desc: parameters_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0021.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_0-499_1.tsv
Type: text/tab-separated-values
Size: 3715 bytes
Desc: stat_0-499_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0022.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_500-999_1.tsv
Type: text/tab-separated-values
Size: 3731 bytes
Desc: stat_500-999_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0023.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1000-1499_1.tsv
Type: text/tab-separated-values
Size: 3730 bytes
Desc: stat_1000-1499_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0024.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1504_1.tsv
Type: text/tab-separated-values
Size: 3650 bytes
Desc: stat_1500-1504_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0025.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1519_1.tsv
Type: text/tab-separated-values
Size: 3743 bytes
Desc: stat_1500-1519_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0026.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1549_1.tsv
Type: text/tab-separated-values
Size: 3740 bytes
Desc: stat_1500-1549_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0027.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1599_1.tsv
Type: text/tab-separated-values
Size: 3735 bytes
Desc: stat_1500-1599_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0028.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1749_1.tsv
Type: text/tab-separated-values
Size: 3722 bytes
Desc: stat_1500-1749_1.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0029.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1999_2.tsv
Type: text/tab-separated-values
Size: 3729 bytes
Desc: stat_1500-1999_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0030.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: parameters_2.tsv
Type: text/tab-separated-values
Size: 509 bytes
Desc: parameters_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0031.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_0-499_2.tsv
Type: text/tab-separated-values
Size: 3707 bytes
Desc: stat_0-499_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0032.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_500-999_2.tsv
Type: text/tab-separated-values
Size: 3734 bytes
Desc: stat_500-999_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0033.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1000-1499_2.tsv
Type: text/tab-separated-values
Size: 3719 bytes
Desc: stat_1000-1499_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0034.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1504_2.tsv
Type: text/tab-separated-values
Size: 3694 bytes
Desc: stat_1500-1504_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0035.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1519_2.tsv
Type: text/tab-separated-values
Size: 3748 bytes
Desc: stat_1500-1519_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0036.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1549_2.tsv
Type: text/tab-separated-values
Size: 3755 bytes
Desc: stat_1500-1549_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0037.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1599_2.tsv
Type: text/tab-separated-values
Size: 3725 bytes
Desc: stat_1500-1599_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0038.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stat_1500-1749_2.tsv
Type: text/tab-separated-values
Size: 3726 bytes
Desc: stat_1500-1749_2.tsv
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0039.tsv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: import-script.inp
Type: application/octet-stream
Size: 2915 bytes
Desc: import-script.inp
URL: <http://lists.wfu.edu/pipermail/gretl-users/attachments/20170919/bd65e77f/attachment-0001.obj>


More information about the Gretl-users mailing list