利用python通过API解析json数据串的方法
from urllib.request import urlopen
import pandas as pd
import json
## 获取json数据并转换为dataframe
def getAndSaveJSON(start, end, step):
# 生成访问目标url
url_get_base = "your base url"
start_time = str(start)
end_time = str(end)
step = str(step)
fullurl = url_get_base + "start=" + start_time + "&end=" + end_time + "&step=" + step
try:
# 获取json数据
rawtext = urlopen(fullurl).read()
jsonStr = json.loads(rawtext.decode('utf-8'))
str_data = json.dumps(jsonStr['data']['result'], ensure_ascii=False) + "\n"
# 转换为dataframe格式
df = pd.read_json(str_data, orient='record')
return df
except Exception as err:
print(err)
print(fullurl)
print('url 访问出错')
一般还需要继续对df进行转换获取自己需要的字段。
# dataframe写入txt文件
df.to_csv('filename.txt',header=True, index=False, sep='\t', mode='a')