pandas修改列名，json格式

 

 

import pandas as pd
import json


df = pd.DataFrame(
   data = [["a", "b"], ["c", "d"]],
    index=["row 1", "row 2"],
     columns=["col 1", "col 2"])

print(df,'\n')

#必须加上inplace参数才能修改列名成功
df.rename(columns = {'col 1':'sales', 'col 2':'num'}, inplace = True)
print('修改列名：\n',df,'\n')



result = df.to_json(orient="split")
print('to_json之后：\n',result)  #都是使用双引号，{"columns":["sales","num"],"index":["row 1","row 2"],"data":[["a","b"],["c","d"]]}
print(type(result))  #<class 'str'>



parsed = json.loads(result)
print('\n解码成python对象字典，以便使用索引：\n',parsed)
print(type(parsed))