python dataframe 横向拼接

网上好像没有我自己写了一个

import pandas as pd
data = pd.read_csv("data.csv")
L=['season', 'size', 'speed','mxPH', 'mnO2', 'Cl', 'NO3', 'NH4', 'oPO4', 'PO4', 'Chla',
   'y1','y2','y3','y4','y5','y6','y7']
data.columns=L
data.head()

 

test_x = pd.read_csv("test_x.csv")
L=['season', 'size', 'speed','mxPH', 'mnO2', 'Cl', 'NO3', 'NH4', 'oPO4', 'PO4', 'Chla']
test_x.columns=L
test_x

test_y = pd.read_csv("test_y.csv")
L=['y1','y2','y3','y4','y5','y6','y7']
test_y.columns=L
test_y

 

test=test_x.copy()
L=['y1', 'y2', 'y3', 'y4', 'y5', 'y6', 'y7']
for ele in L:
    test[ele]=test_y[ele]
test