# !/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time : 2020/7/11 11:48
import pandas as pd
import numpy as np
import json
pd.set_option('display.max_rows', 50, 'display.max_columns', 50, 'display.width', 10000)
def to_data(x):
try:
return (pd.Series(json.loads(x)['data']))
except:
return np.nan
def main():
data = pd.read_csv('data.csv', sep='\t')
data_temp = data.copy()
data_temp = data_temp.drop(['name', 'cert_no'], axis=1)
# 解析json
data_temp['json'] = data_temp['response'].map(lambda x: list(json.loads(x).keys()))
columns = data_temp['json'][1]
for col in columns:
data_temp[col] = data_temp['response'].map(lambda x: json.loads(x).get(col))
# response 这一列是json格式,data节点是字典转Dataframe
score_result = data_temp['response'].apply(to_data)
if __name__ == '__main__':
main()
将json转换成Dataframe,Dataframe某一列是字典转成DataFrame
最新推荐文章于 2024-05-11 11:32:28 发布