python pandas dataframe 转json_python将相类不同key的json对象转化为pandas的dataframe(上篇)...

1. python添加package包

import json

import pandas as pd

2. json文件中保存的格式

{"key1": "value1", "key2": "value2", "key3": "value3"}

{"key1": "value1", "key2": "value2", "key4": "value4"}

3. 读取方式

with open(file_path, 'r') as file:

final = pd.DataFrame()

for line in file:

line = line.strip()

line = json.loads(line)

df = pd.io.json.json_normalize(line) # 调用pandas方法

final = final.append(df, ignore_index=True, sort=True) # 利用追加的方式

print(final.head)

4. 重点方法

4.1 pd.io.json.json_normalize(line)

4.2 final.append(df, ignore_index=True, sort=True)

ignore_index：设置为True，索引会递增，而不都是0

sort：设置为True，否则报To accept the future behavior, pass 'sort=False'.To retain the current     behavior and silence the warning, pass 'sort=True'.sort=sort)， 这个提示.

5. 执行结果