Ignore consecutive whitespaces with CSV.read(...)

[nalimilan]

If that’s indeed a fixed-width file, see:

Is there no standard way to read files with fixed width columns in the new DataFrames ecosystem?

I’ve been using DataFrames.readtable() to read files with fixed width columns, but that function is now deprecated in favor of CSV.read(). However it seems that CSV.read() lacks the flag to “treat consecutive whitespace delimiters as one” that would be required to make it handle fixed width data. Here’s a sample file from climate science (standardized scenarios of greenhouse gas concentrations called “Representative Concentration Pathways”). More similar files available here. DataFrames.readtab…

Reading Fixed-Width Column Data

Hi All, I’m trying to read in a file with rows that look like 13 MEXICO 130971 14 INDONESIA 126582 15 UNITED KINGDOM 114486 Note the possible presence of spaces in the 2nd column. I haven’t been able to find any tool that will easily do this for me (saw this, but the suggestion there doesn’t work here). Does one exist that I’m not finding, or do I hav…