How can I remove a row from csv file with python where a value of any column is missing

Question

How can I use the csv module to remove all rows where any of the column values is missing? I my case I have two columns a and b, so if I have a value on a but nothing on b, that row should be removed. How an I achieve this?

Does this answer your question? Deleting rows with Python in a CSV file — snakecharmerb
– snakecharmerb, Commented Dec 15, 2019 at 10:29

Alex Hall · Accepted Answer · 2019-12-15 10:23:53Z

2

Try this:

with open(in_filename) as infile:
    with open(out_filename, 'w') as outfile:
        reader = csv.reader(infile)
        writer = csv.writer(outfile)
        writer.writerows(filter(all, reader))

answered Dec 15, 2019 at 10:23

Alex Hall

36.2k5 gold badges63 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I remove a row from csv file with python where a value of any column is missing

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related