Sample Header Ad - 728x90

How to standardise this nonstandard CSV file for Weka?

0 votes
1 answer
2208 views
I insert the data into the service csvlint.io because I get the error 22 Problem encountered on line 2 in Weka in trying to import CSV file the following way. java -jar weka.jar > Explorer > Preprocess > Open file > [select file format CSV] > [Choose CSV file] Similar error message is in the thread Not recognised as an csv file in Weka which I have before solved by inserting the data into LibreOffice, autofixing there and saving as CSV but I would like to find a commandline solution there. I get the following warning in the *csvlint.io* service from there although I have generated *Data* in Debian 9. > Structural problem: Non-standard Line Breaks on row 1 > > Your CSV appears to use LF line-breaks. While this will be fine in > most cases, RFC 4180 specifies that CSV files should use CR-LF (a > carriage-return and line-feed pair, e.g. \r\n). This may be labelled > as "Windows line endings" on some systems. *Data* Ni, Aika, Aika_l, Un, Unen, Unen_kesto, Uniluokat_R, Uniluokat_k, Uniluokat_s, HRV_RMSSD_a, HRV_RMSSD_i, Kokonaisp, Palautumisen_k, Hermoston_t, Syke_ave_m, Syke_a, Syke_l, Hengitystiheys_ave_m, Hengitystiheys_a, Hengitystiheys_min_a, Liikeaktiivisuus_l, Liikeaktiivisuus_a, Paivamaara_l "Masi", 23072010-2200+0300, 24072010-0600+0300, 70, 7h40, 6h30, 1h40, 3h40, 1h10, 67.0, 43.0, 24.0, 430, 30, 70, 50, 40, 20, 10, 10, 150, 260, 24.10.2010 "Masi", 23072010-2200+0300, 24072010-0600+0300, 70, 7h40, 6h30, 1h40, 3h40, 1h10, 67.0, 43.0, 24.0, 430, 30, 70, 50, 40, 20, 10, 10, 150, 260, 24.10.2010 To remove horizontal white space there, you can run tr -d "[:blank:]" on the data but it should not necessary. I think line-endings are not an issue here because fixing the file with dos2unix or unix2dos (meuh) does not solve the issue. OS: Debian 9
Asked by Léo Léopold Hertz 준영 (7138 rep)
Jul 25, 2017, 05:25 PM
Last activity: Sep 15, 2017, 02:40 PM