program to manipulate csv files

hedron · 05-29-2019, 11:54 PM

Is there a program like Open OFfice that can manipulate .csv files? Like, simple copy/pasting cells into rows, merging columns, change/insert delimiter, etc. I've been trying with OO, but it's just painful.

It also must be able to handle csv files that are possibly a million+ rows long.

Thanks.

ondoho · 05-30-2019, 12:39 AM

a quick search of my package manager for "csv edit" turned up these projects:
https://github.com/swilmet/gCSVedit
https://github.com/aksr/mange

michaelk · 05-30-2019, 04:17 AM

Technically you are importing a csv file into a spreadsheet table then exporting back to a csv file. I agree that inserting or changing the delimiter and merging columns could be difficult.

sed, awk or maybe writing a python/perl script might be better with manipulating a csv file in this case.

WideOpenSkies · 05-30-2019, 10:02 AM

Quote:

Originally Posted by michaelk

sed, awk or maybe writing a python/perl script might be better with manipulating a csv file in this case.

No need. There are several command line tools that are perfect for manipulating CSVs. Trust me. I do this as a full-time job.

These are my favorite:

csvkit
Visidata

I also use R to manipulate data, but that might be too advanced if you don't know the language.

michaelk · 05-30-2019, 10:14 AM

Thanks for the update.

WideOpenSkies · 05-30-2019, 10:34 AM

Quote:

Originally Posted by escobarrr

Is there other Links ? these ones don't work for me

Which links?