更新:Pandas使用
DateFrame串联及附加操作
先通过字典创建一个DateFrame
import pandas as pd
import numpy as np
data=dict.fromkeys(['first','second','third'])
for i in data:
i=[]
for i in range(20):
data['first'].append(i)
data['second'].append(i*i)
data['third'].append(2*i+1)
df=pd.DataFrame(data)
- 使用concat()串联DateFrame,以便重组新的DateFrame
建议先help(pd.concat)查看有哪些参数和用法
ignore_index=True
keys=[‘s1’, ‘s2’,]
names=[‘Series name’, ‘Row ID’]
PANDAS 数据合并与重塑(concat篇)
#axis=0列对齐,=1行对齐,空缺处以NaN补齐
pd.concat([df[:3],df[5:8]],axis=1,keys=['s1','s2'])
s1 s2
first second third first second third
0 0.0 0.0 1.0 NaN NaN NaN
1 1.0 1.0 3.0 NaN NaN NaN
2 2.0 4.0 5.0 NaN NaN NaN
5 NaN NaN NaN 5.0 25.0 11.0
6 NaN NaN NaN 6.0 36.0