sslfk的博客

def get_data(): conn = pymysql.connect(host=RSYS_HOST, port=RSYS_PORT, user=RSYS_USER, passwd=RSYS_PASSWORDD, db=RSYS_DB_NAME, charset='utf.

1、json转化为dataframe简单json转化方法：import pandas as pddf = pd.read_json("test.json",encoding="utf-8", orient='records')print(df)复杂json转化方法2，中间可以对json做一些转化处理使其满足dataframe的格式要求：import json from pandas.io.json import json_normalizedata=open("test.json