pipe delimited data
System dynamics program with additional features for economics
Brought to you by:
hpcoder,
profstevekeen
Ravel 3.1.0-beta v30; win64; Windows 10Pro.
I'm trying to import a census dataset SIPP2021, which is pipe delimited.
https://www.census.gov/programs-surveys/sipp/data/datasets/2021-data/2021.html
I entered | as Separator.
After Load nothing seems to change.
(It's a huge dataset: 5 GB after unpacking.)
Changing the separator should automatically reload the file, and rerun the guessing algorithm. But pressing load does seem to work, albeit it took a lot longer than expected. I didn't go all the way to importing the data, though, as there were a lot of columns, and it is not immediately obvious which columns, if any, contain data.
But I grabbed a small example csv I had here, and replaced all commas with "pipes", and then successfully went through the import process.
Ticket moved from /p/minsky/tickets/1576/
Can't be converted:
Reload on separator change now implemented.