python csv headers

csv, python

Solution

Based on your edit, you need to skip the initial space after the comma.

This should do it:

>>> reader = csv.DictReader(open(PathFile),skipinitialspace=True)

Problem

I have a set of csv headers that I am trying to match with uploads. It's not really working. Not all headers are required -- I just have to match what's in the file. ``` reader = csv.DictReader(open(PathFile)) headers = reader.fieldnames for header in sorted(set(headers)): if (header == 'ip') or (header == 'IP'): print "IP found in Header" ``` In this case, IP is not found. ``` for row in reader: if row.get('IP'): print "IP found in Row" ``` It's not found again. I did search on this site -- there was: ``` IP = row.get('IP', None) ``` That did not work either. This is the file I'm using for testing: ``` Email, IP, Name, City, State, zip, country, garbage ghfddgf@gfgs.com, 34.4.34.34,Mr GH, chicago, il ,60601, us,erw ewr 5t4g@fdsf.com, 34.45.23.34, Mr 5t,NY,NY,10101, us, er ```

Original source