python - How to get the updated csv file after deleting blank rows?

Question

I have csv file with many entire blank rows.

Step 1: I follow the first answer in this link Delete blank rows from CSV? to get rid of the blank rows. The code in this link is

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

My csv file name is "Profit.csv". I wrote my code like this

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

Step 2: I then checked the missing values and blank rows in "Profit_1.csv" but they are the same as the missing values and blank rows in "Profit.csv"

QUESTION: What should I do now to get the updated csv file after deleting blank rows? Thanks in advance!

question from:https://stackoverflow.com/questions/65935611/how-to-get-the-updated-csv-file-after-deleting-blank-rows

Answer 1

An empty row in a CSV file will result in a row object that is a list of many empty strings (['','','','','']). In this case, if row: returns True.

Change

if row:

to

if any(row):

in order to remove rows that consist solely of empty strings.