pandas学习之DateFrame的拼接整合

更新：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