使用SODA API将数据导入到dataframe

Question

我正在尝试使用SODA API从下面的链接导入数据，并将其加载到dataframe中。我以前从来没有使用过SODA API，有没有人能推荐一个好的模块或者怎么做？

https://health.data.ny.gov/Health/Medicaid-Potentially-Preventable-Emergency-Visit-P/cr7a-34ka

Answer 1

下面的代码做到了这一点：

代码：

import pandas as pd
from sodapy import Socrata

# Unauthenticated client only works with public data sets. Note 'None'
# in place of application token, and no username or password:
client = Socrata("health.data.ny.gov", None)

# First 2000 results, returned as JSON from API / converted to Python list of
# dictionaries by sodapy.
Results = client.get("cr7a-34ka", limit=2000)

# Convert to pandas DataFrame
df = pd.DataFrame.from_records(Results)

Answer 2

对于Python来说，非官方的sodapy库是一个很好的起点！