Python CSV library returning 1 item instead of a list of items
Question: Im trying to use the CSV library to do some excel processing, but when I use
the code posted below, row returns the entirety of data as 1 item, so row[0]
returns the entire file and row[1] returns index out of range. Is there a way
to make each row a list with each cell being an item? Making the final product
a list of lists. I was thinking of using split everytime ther was a close
bracket ']' . If needed I can post the excel file

Heres a sample of what some of the output looks like. This is all one item in
the list:

    
    
    ['3600035671,"$13,668",8/11/2008,8/11/2013,,,2,4A,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,']
    ['3910435005,"$34,872",4/1/2010,10/8/2016,,,2,4A,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,']
    ['5720636344,"$1,726",8/30/2010,9/5/2011,,,3,6C,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,']
    ['15260473510,"-$1,026,580",7/22/2005,3/5/2008,,,6,1C2A,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,']
    
    
    import csv    
    csvfile = open('Invictus.csv', 'rU')
    data = csv.reader(csvfile, dialect=csv.excel_tab)    
    for char in data:
        char = filter(None, char)
        print char
    


Answer: Assuming you are giving examples of your data above the line `import csv`, it
looks like your data is comma delimited but you are setting up your CSV reader
to expect tab delimited data (`dialect=csv.excel_tab`).

What happens if you change that line to:

    
    
    data = csv.reader(csvfile, dialect=csv.excel)
    

