How to delete columns in a CSV file?

by 
import csv
with open("source","rb") as source:
    rdr= csv.reader( source )
    with open("result","wb") as result:
        wtr= csv.writer( result )
        for r in rdr:
            wtr.writerow( (r[0], r[1], r[3], r[4]) )

BTW, the for loop can be removed, but not really simplified.

        in_iter= ( (r[0], r[1], r[3], r[4]) for r in rdr )
        wtr.writerows( in_iter )

Also, you can stick in a hyper-literal way to the requirements to delete a column. I find this to be a bad policy in general because it doesn’t apply to removing more than one column. When you try to remove the second, you discover that the positions have all shifted and the resulting row isn’t obvious. But for one column only, this works.

            del r[2]
            wtr.writerow( r )

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How can I convert JSON to CSV?
  3. Skip the headers when editing a csv file using Python
  4. How to add a new column to a CSV file?
  5. Skip rows during csv import pandas
  6. How to avoid Python/Pandas creating an index in a saved csv?
  7. datetime dtypes in pandas read_csv
  8. Python CSV error: line contains NULL byte
  9. How do I convert this list of dictionaries to a csv file?
  10. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  11. sort csv by column
  12. csv.Error: iterator should return strings, not bytes
  13. Compare two CSV files and search for similar items
  14. Why does csvwriter.writerow() put a comma after each character?
  15. Key error when selecting columns in pandas dataframe after read_csv
  16. Is it possible to keep the column order using csv.DictReader?
  17. OSError: Initializing from file failed on csv in Pandas
  18. ValueError : I/O operation on closed file
  19. Writing to a particular cell using csv module in python
  20. Writing List of Strings to Excel CSV File in Python
  21. Load CSV file with PySpark
  22. Python UTF-16 CSV reader
  23. Read specific columns with pandas or other python module
  24. load csv into 2D matrix with numpy for plotting
  25. Read random lines from huge CSV file
  26. How to count top 10 most common values in a dict in python
  27. Why is the Python CSV reader ignoring double-quoted fields?
  28. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment