Delete blank entries in CSV file Python

Question

I need to read in a CSV file, from Excel, whose rows may be an arbitrary length.

The problem is the python retains these blank entries, but need to delete them for a future algorithm. Below is the output, I don't want the blank entries.

     ['5', '1', '5', '10', '4', '']
     ['3', '1', '5', '10', '2', '']
     ['6', '1', '5', '10', '5', '2']
     ['9', '10', '5', '10', '7', '']
     ['8', '5', '5', '10', '7', '']
     ['1', '1', '5', '10', '', '']
     ['2', '1', '5', '10', '1', '']
     ['7', '1', '5', '10', '6', '4']
     ['4', '1', '5', '10', '3', '1']

Robᵩ · Accepted Answer · 2013-10-02 01:25:54Z

3

Here's a list comprehension integrated with the csv library:

import csv

with open('input.csv') as in_file:
    reader = csv.reader(in_file)
    result = [[item for item in row if item != ''] for row in reader]

print result

answered Oct 2, 2013 at 1:25

Robᵩ

170k20 gold badges251 silver badges323 bronze badges

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

Comments

jgritty · Accepted Answer · 2013-10-01 23:48:43Z

1

This is about as verbose a function as I could write to do what you want. There are certainly slicker ways.

def remove_blanks(a_list):
    new_list = []
    for item in a_list:
        if item != "":
            new_list.append(item)
    return new_list

answered Oct 1, 2013 at 23:48

jgritty

12k3 gold badges41 silver badges62 bronze badges

Comments

roippi · Accepted Answer · 2013-10-02 00:27:53Z

1

List comprehension version:

a = ['5', '1', '5', '10', '4', '']

[x for x in a if x != '']
Out[19]: ['5', '1', '5', '10', '4']

You may be better served by filtering at the csv read step instead.

answered Oct 2, 2013 at 0:27

roippi

26k4 gold badges52 silver badges75 bronze badges

Collectives™ on Stack Overflow

Delete blank entries in CSV file Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related