城市自行车: JSON到Dataframe

Question

我正在使用python (https://pypi.org/project/python-citybikes/)来检索一些数据。但是，我无法找到导出数据的方法

import citybikes
import pandas as pd
client = citybikes.Client()
GlasgowNextBike = citybikes.Network(client, uid='nextbike-glasgow')
list(GlasgowNextBike.stations)
Stations = list(GlasgowNextBike.stations)
 pd.read_json(Stations)

我得到了

Traceback (most recent call last):

  File "<ipython-input-15-5a1904def0e8>", line 1, in <module>
    pd.read_json(Stations)

  File "/Users/noor/opt/anaconda3/lib/python3.7/site-packages/pandas/util/_decorators.py", line 214, in wrapper
    return func(*args, **kwargs)

  File "/Users/noor/opt/anaconda3/lib/python3.7/site-packages/pandas/io/json/_json.py", line 585, in read_json
    path_or_buf, encoding=encoding, compression=compression

  File "/Users/noor/opt/anaconda3/lib/python3.7/site-packages/pandas/io/common.py", line 200, in get_filepath_or_buffer
    raise ValueError(msg)

ValueError: Invalid file path or buffer object type: <class 'list'>

我的问题是：

如何将结果导出/保存为JSON或CSV文件

Answer 1

尝试使用json模块，如下所示：

import citybikes, json

client = citybikes.Client()
GlasgowNextBike = citybikes.Network(client, uid='nextbike-glasgow')

with open('GlasgowNextBike.json', 'w') as f:
    json.dump(GlasgowNextBike.data, f, indent=2)