Pandas使用（五）--dataframe之间的关联

python复现excel功能
Talk is Cheap, show me the code.

1.merge()函数关联两个dataframe

问题描述：dataframe1、dataframe2具有相同的列，通过关联相同的列实现两个dataframe的合并

# 加载package
import pandas as pd

# 已知df1，df2
df1.columns = ['列1','列2','列A']
df2.columns = ['列3','列4','列A']

df = pd.merge(df1, df2, on = ['列A'])

2.concat()函数合并两个dataframe

问题描述：将两个dataframe横向合并、纵向合并

#加载package
import pandas as pd

#已知df3，df4
df3.columns = ['列1','列2','列A']
df4.columns = ['列3','列4','列A']
# 按照列进行横向合并:要求列数相等且一致
df_pro_col = pd.concat([df1,df3],axis = 0)

# 按照行进行纵向合并：要求行数相等尽量一致
df_pro_row = pd.concat([df2,df4],axis = 1)