话不多说,看测试代码(对join,merge,concat三种方法的简单测试,更细节的参数可以用到再查。)
In [1]: import numpy as np
In [2]: import pandas as pd
#测试concat()------------------------------发现concat()的连接是直接连接,不会去重----------------------------------
In [6]: data1 = pd.DataFrame([[1,2,3,4],[2,3,4,5]],columns=list("abcd"))
In [7]: data2 = pd.DataFrame([[1,1,2,2],[5,5,7,7]],columns=list("gfsh"))
In [8]: data1
Out[8]:
a b c d
0 1 2 3 4
1 2 3 4 5
In [9]: data2
Out[9]:
g f s h
0 1 1 2 2
1 5 5 7 7
In [10]: resdata = pd.concat((data1,data2),axis=1)
In [11]: resdata
Out[11]:
a b c d g f s h
0 1 2 3 4 1 1 2 2
1 2 3 4 5 5 5 7 7
In [12]: resdata = pd.concat((data1,data2),axis=0)
In [13]