处理嵌套函数

pd.json_normalize(data['row'])

具体实现：

  1. def json_excel(fi,filename):
  2.     dfs=[]
  3.     filename=fi+'\\'+filename+'.xlsx'
  4.     for i in os.listdir(fi):
  5.         ff=fi+'\\'+i
  6.         # print(ff)
  7.         if ff[-4:] == 'json':
  8.             print(ff)
  9.             with open(ff,'r',encoding='utf-8') as f:
  10.                 data = json.loads(f.read())
  13.             df2=pd.json_normalize(data['xxxx'])
  14.             dfs.append(df2)
  15.     dff=pd.concat(dfs,ignore_index=True)
  16.     dff.to_excel(filename)
  17.     return '已经转换完成，请查看转换文件夹！！！'