How to move column or swap two columns with csvkit?

Question

I'm using csvkit to manipulate csv files, but can't find how to do this:

Does someone know how to do it?

score 3 · Answer 1 · answered Oct 25 '15 at 15:48

3

You could use csvcut

csvcut -c column_c,column_a data.csv > new.csv

csvsql --table=x --query "select column_c,column_a from x" data.csv

If you are used to sql queries the second might be easier for you.

answered Oct 25 '15 at 15:48

Yisrael Dov

Thanks but what about other fields? Do I need to list them explicitly even if there are many? – Freewind Oct 26 '15 at 06:13
yes you would need to list them explicitly. on csvsql you can use `*` for all rows like in a regular sql query. You might want to check out `awk` – Yisrael Dov Oct 26 '15 at 10:27

score 1 · Accepted Answer · answered Oct 25 '15 at 11:43

1

According to the documentation you linked to, csvcut can do the job. A disadvantage would be that you have to list all of the columns.

An alternative would be to use pandas.

answered Oct 25 '15 at 11:43

Roland Smith

There are at least six answered questions about swapping columns in a pandas dataframa on StackOverflow alone. I don't think adding one more will make it more clear. – Roland Smith Jul 30 '17 at 07:58

2 Answers2