pandas修改列名，json格式

 1 import pandas as pd
 2 import json
 3 
 4 
 5 df = pd.DataFrame(
 6    data = [["a", "b"], ["c", "d"]],
 7     index=["row 1", "row 2"],
 8      columns=["col 1", "col 2"])
 9 
10 print(df,'\n')
11 
12 #必须加上inplace参数才能修改列名成功
13 df.rename(columns = {'col 1':'sales', 'col 2':'num'}, inplace = True)
14 print('修改列名：\n',df,'\n')
15 
16 
17 
18 result = df.to_json(orient="split")
19 print('to_json之后：\n',result)  #都是使用双引号，{"columns":["sales","num"],"index":["row 1","row 2"],"data":[["a","b"],["c","d"]]}
20 print(type(result))  #<class 'str'>
21 
22 
23 
24 parsed = json.loads(result)
25 print('\n解码成python对象字典，以便使用索引：\n',parsed)
26 print(type(parsed))