rpython-3.xpandasconcatenationcbind

pandas equivalent of R's cbind (concatenate/stack vectors horizontally)

Suppose I have two dataframes:

import pandas as pd

test1 = pd.DataFrame([1,2,3,4,5])

test2 = pd.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?

Solution 
  • test3 = pd.concat([test1, test2], axis=1)
test3.columns = ['a','b']

    (But see the detailed answer by @feng-mai, below)