Python CSV reader return Row as list

Question

Im trying to parse a CSV using python and would like to be able to index items in a row so they can be accessed using `row[0]`, `row[1]` and so on. So far this is my code: ``` def get_bitstats(): url = 'http://bitcoincharts.com/t/trades.csv?symbol=mtgoxUSD' data = urllib.urlopen(url).read() dictReader = csv.DictReader(data) obj = BitData() for row in dictReader: obj.datetime = datetime.datetime.fromtimestamp(int(row['0'])/1000000) q = db.Query(BitData).filter('datetime', obj.datetime) if q != None: raise ValueError(obj.datetime + 'is already in database') else: obj.price = row['1'] obj.amount = row['2'] obj.put() ``` This returns `KeyError: '0'` and I have no idea how to set it up. I did input this into an interactive shell and when running ``` for row in dictReader: print row ``` I get this as the output: ``` {'1': '3'} {'1': '6'} {'1': '2'} {'1': '6'} {'1': '9'} {'1': '8'} {'1': '6'} {'1': '4'} {'1': '4'} {'1': '', None: ['']} {'1': '4'} {'1': '2'} {'1': '.'} {'1': '0'} {'1': '5'} {…

Accepted Answer

`csv.reader` will return each row as a list

```
reader = csv.reader(data)

for line_list in reader:
   pass
   # line_list is a list of the data contained in a row so you can access line_list[0]
```

Python CSV reader return Row as list

Solution

Problem