Python – re-ordering columns in a csv

by

You can use the csv module to read, reorder, and then and write your file.

Sample File:

$ cat file.csv
A,B,C,D,E
a1,b1,c1,d1,e1
a2,b2,c2,d2,e2

Code

import csv

with open('file.csv', 'r') as infile, open('reordered.csv', 'a') as outfile:
    # output dict needs a list for new column ordering
    fieldnames = ['A', 'C', 'D', 'E', 'B']
    writer = csv.DictWriter(outfile, fieldnames=fieldnames)
    # reorder the header first
    writer.writeheader()
    for row in csv.DictReader(infile):
        # writes the reordered rows to the new file
        writer.writerow(row)

output

$ cat reordered.csv
A,C,D,E,B
a1,c1,d1,e1,b1
a2,c2,d2,e2,b2

More Related Contents:

  1. How to write a python code which copies a unique column from an output file to a .csv file
  2. Skip the headers when editing a csv file using Python
  3. How to add a new column to a CSV file?
  4. Skip rows during csv import pandas
  5. How to avoid Python/Pandas creating an index in a saved csv?
  6. datetime dtypes in pandas read_csv
  7. Python CSV error: line contains NULL byte
  8. How do I convert this list of dictionaries to a csv file?
  9. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  10. sort csv by column
  11. csv.Error: iterator should return strings, not bytes
  12. Pandas read csv file with float values results in weird rounding and decimal digits
  13. Why does csvwriter.writerow() put a comma after each character?
  14. Key error when selecting columns in pandas dataframe after read_csv
  15. How to delete columns in a CSV file?
  16. Prevent pandas read_csv treating first row as header of column names
  17. Modify an existing Excel file using Openpyxl in Python
  18. How to avoid pandas creating an index in a saved csv
  19. Pythonically add header to a csv file
  20. How to add header row to a pandas DataFrame
  21. How can I merge 200 CSV files in Python?
  22. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  23. How can I use io.StringIO() with the csv module?
  24. how to skip blank line while reading CSV file using python
  25. Multiple delimiters in single CSV file
  26. UnicodeDecodeError when reading CSV file in Pandas
  27. How to upload a CSV file in FastAPI and convert it into JSON?
  28. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  29. ValueError: x and y must be the same size
  30. Python: Writing Nested Dictionary to CSV

Leave a Comment