pd.concat()函数可以沿着指定的轴将多个dataframe或者series拼接到一起。
基本语法:
import pandas as pd d1 = [["xiaolei",20,10081],["xiaowu",30,10082]] t1 = pd.DataFrame(d1) print(t1) print('*'*50) d2 = [["xiaowang",22,10083],["xiaoming",25,10084]] t2 = pd.DataFrame(d2) print(t2) print('*'*25+'合并结果如下(默认是上下堆叠)'+'*'*25) t = pd.concat([t1,t2]) print(t)
运行结果:
0 1 2
0 xiaolei 20 10081
1 xiaowu 30 10082
**************************************************
0 1 2
0 xiaowang 22 10083
1 xiaoming 25 10084
********************合并结果如下(默认是上下堆叠)********************
0 1 2
0 xiaolei 20 10081
1 xiaowu 30 10082
0 xiaowang 22 10083
1 xiaoming 25 10084
import pandas as pd d1 = [["xiaolei",20,10081],["xiaowu",30,10082]] t1 = pd.DataFrame(d1) print(t1) print('*'*50) d2 = [["xiaowang",22,10083],["xiaoming",25,10084]] t2 = pd.DataFrame(d2) print(t2) print('*'*20+'合并结果如下(左右拼接)'+'*'*20) t = pd.concat([t1,t2], axis=1) print(t)
运行结果:
0 1 2
0 xiaolei 20 10081
1 xiaowu 30 10082
**************************************************
0 1 2
0 xiaowang 22 10083
1 xiaoming 25 10084
********************合并结果如下(左右拼接)********************
0 1 2 0 1 2
0 xiaolei 20 10081 xiaowang 22 10083
1 xiaowu 30 10082 xiaoming 25 10084