suppose I have two dataframes:
import pandas
....
....
test1 = pandas.DataFrame([1,2,3,4,5])
....
....
test2 = pandas.DataFrame([4,2,1,3,7])
....
I tried test1.append(test2)
but it is the equivalent of R's rbind
.
How can I combine the two as two columns of a dataframe similar to the cbind
function in R?
test3 = pd.concat([test1, test2], axis=1)
test3.columns = ['a','b']