Skip the headers when editing a csv file using Python

by

Your reader variable is an iterable, by looping over it you retrieve the rows.

To make it skip one item before your loop, simply call next(reader, None) and ignore the return value.

You can also simplify your code a little; use the opened files as context managers to have them closed automatically:

with open("tmob_notcleaned.csv", "rb") as infile, open("tmob_cleaned.csv", "wb") as outfile:
   reader = csv.reader(infile)
   next(reader, None)  # skip the headers
   writer = csv.writer(outfile)
   for row in reader:
       # process each row
       writer.writerow(row)

# no need to close, the files are closed automatically when you get to this point.

If you wanted to write the header to the output file unprocessed, that’s easy too, pass the output of next() to writer.writerow():

headers = next(reader, None)  # returns the headers or `None` if the input is empty
if headers:
    writer.writerow(headers)

More Related Contents:

  1. Writing a Python list of lists to a csv file
  2. Reading a huge .csv file
  3. Read and Write CSV files including unicode with Python 2.7
  4. Python parse CSV ignoring comma with double-quotes
  5. portable way to write csv file in python 2 or python 3
  6. Use Multiple Character Delimiter in Python Pandas read_csv
  7. How can I use io.StringIO() with the csv module?
  8. Python Pandas – Read csv file containing multiple tables
  9. How to count top 10 most common values in a dict in python
  10. Get data from Twitter using Tweepy and store in csv file
  11. How to sort a dataFrame in python pandas by two or more columns?
  12. Python import csv to list
  13. How to remove \xa0 from string in Python?
  14. Understanding recursion in Python
  15. Python Requests – No connection adapters
  16. Check if a process is running or not on Windows?
  17. Creating a dictionary from a CSV file
  18. Python handling socket.error: [Errno 104] Connection reset by peer
  19. Most pythonic way to interleave two strings
  20. How to remove duplicates from a csv file
  21. selecting across multiple columns with python pandas?
  22. Not able to parse a .csv file uploaded using Flask
  23. How can I do a batch insert into an Oracle database using Python?
  24. Python: CSV write by column rather than row
  25. Unable to install sasl-0.1.3 python package on windows machine
  26. Python read csv – BOM embedded into the first key
  27. Read csv from Google Cloud storage to pandas dataframe
  28. What are the differences between bool() and operator.truth()?
  29. python_2_unicode_compatible error
  30. How to display charts in Spyder

Leave a Comment