如何使用Python将JSON解析为CSV中的两列

Question

由于某种原因，我无法在家用计算机上登录与工作计算机相同的帐户。

我能够使Bo10的代码正常工作，但不能使abernert的代码正常工作，我真的很想知道为什么。

这是我对abernert代码的更新：

    import csv

    import sys

    import json

    import urllib2

    j = urllib2.urlopen('https://citibikenyc.com/stations/json')

    js = json.load(j)

    citi = js['stationBeanList']

    columns = ('stationName', 'totalDocks', 'availableDocks', 

               'latitude', 'longitude', 'availableBikes')

    stations = (operator.itemgetter(columns)(station) for station in citi)

    with open('output.csv', 'w') as csv_file:

        csv_writer = csv.writer(csv_file)

        csv_file.writerows(stations)

I thought adding this line `csv_writer = csv.writer(csv_file)` would fix the object has no attirbute error, but I am still getting it.  This is the actual error:

Andrews-MacBook:coding Andrew$ python citibike1.py

Traceback (most recent call last):

  File "citibike1.py", line 17, in <module>

    csv_file.writerows(stations)

AttributeError: 'file' object has no attribute 'writerows'

因此，现在我将代码更改为此，并且输出仅将列的名称重复322次。我在第14行上更改了它，因为出现了此错误：

Traceback (most recent call last):

  File "citibike1.py", line 17, in <module>

    csv_writer.writerows(stations)

  File "citibike1.py", line 13, in <genexpr>

    stations = (operator.itemgetter(columns)(station) for station in citi)

NameError: global name 'operator' is not defined: 

import csv

import sys

import json

import urllib2

import operator

j = urllib2.urlopen('https://citibikenyc.com/stations/json')

js = json.load(j)

citi = js['stationBeanList']

columns = ('stationName', 'totalDocks', 'availableDocks', 

           'latitude', 'longitude', 'availableBikes')

stations = (operator.itemgetter(0,1,2,3,4,5)(columns) for station in citi)

with open('output.csv', 'w') as csv_file:

    csv_writer = csv.writer(csv_file)

    csv_writer.writerows(stations)