Delete blank rows from CSV?

by

Use the csv module:

import csv
...

with open(in_fnam, newline="") as in_file:
    with open(out_fnam, 'w', newline="") as out_file:
        writer = csv.writer(out_file)
        for row in csv.reader(in_file):
            if row:
                writer.writerow(row)

If you also need to remove rows where all of the fields are empty, change the if row: line to:

if any(row):

And if you also want to treat fields that consist of only whitespace as empty you can replace it with:

if any(field.strip() for field in row):

Note that in Python 2.x and earlier, the csv module expected binary files, and so you’d need to open your files with e 'b' flag. In 3.x, doing this will result in an error.

More Related Contents:

  1. create a loop inside a loop in python
  2. Python import csv to list
  3. Writing a pandas DataFrame to CSV file
  4. How to write to a CSV line by line?
  5. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  6. Python out of memory on large CSV file (numpy)
  7. Writing a dictionary to a csv file with one line for every ‘key: value’
  8. How do I write data into CSV format as string (not file)?
  9. Save results to csv file with Python
  10. How to write UTF-8 in a CSV file
  11. Using numpy.genfromtxt to read a csv file with strings containing commas
  12. Split string on commas but ignore commas within double-quotes?
  13. Read CSV file with comma within fields in Python
  14. How to keep leading zeros in a column when reading CSV with Pandas?
  15. How to transpose a dataset in a csv file?
  16. Writing Python lists to columns in csv
  17. Reading rows from a CSV file in Python
  18. CSV new-line character seen in unquoted field error
  19. How to read a CSV file from a URL with Python?
  20. Read CSV into a dataFrame with varying row lengths using Pandas
  21. Can you upload to S3 using a stream rather than a local file?
  22. Convert percent string to float in pandas read_csv
  23. How do you replace all the occurrences of a certain character in a string?
  24. Easiest way to read csv files with multiprocessing in Pandas
  25. Python 3 CSV file giving UnicodeDecodeError: ‘utf-8’ codec can’t decode byte error when I print
  26. Plot NetworkX Graph from Adjacency Matrix in CSV file
  27. How do I split a line by commas, but ignore commas within quotes Python [duplicate]
  28. Most efficient way to parse a large .csv in python?
  29. Pandas df.to_csv(“file.csv” encode=”utf-8″) still gives trash characters for minus sign
  30. Python3: writing csv files

Leave a Comment