Python DataFrame的安装与使用 dict转DataFrame

最新推荐文章于 2024-08-28 09:04:41 发布

c小刺猬

最新推荐文章于 2024-08-28 09:04:41 发布

阅读量3.1k

点赞数 2

文章标签： DataFrame Python

本文链接：https://blog.csdn.net/qq_21744873/article/details/81977201

版权

python3安装pandas：

命令行执行 pip install pandas

字典转DataFrame：

from pandas.io.json import json_normalize
d={"a":123,"b":234,"c":345}
dataf=json_normalize(d) #dataframe对象

多个DataFrame合并为一个DataFrame：

import pandas as pd
from pandas import DataFrame
df1=DataFrame({'A':['A0','A1','A2','A3'],
               'B':['B0','B1','B2','B3'],
               'C':['C0','C1','C2','C3'],
               'D':['D0','D1','D2','D3']},
               index=[0,1,2,3])

df2=DataFrame({'A':['A4','A5','A6','A7'],
               'B':['B4','B5','B6','B7'],
               'C':['C4','C5','C6','C7'],
               'D':['D4','D5','D6','D7']},
               index=[4,5,6,7])

df3=DataFrame({'A':['A8','A9','A10','A11'],
               'B':['B8','B9','B10','B11'],
               'C':['C8','C9','C10','C11'],
               'D':['D8','D9','D10','D11']},
               index=[8,9,10,11])

frames=[df1,df2,df3]
result=pd.concat(frames)