column bind in python pandas – concatenate columns in python pandas

Column bind in python pandas. In this tutorial we will learn how to concatenate columns to the python pandas dataframe using concat() Function with example i.e. how to column bind two data frames in python pandas.

Column binding is pictographically shown below

column bind in python pandas 0

Create dataframe 1:


import pandas as pd
import numpy as np


#Create a DataFrame

d = {
'Name':['Alisa','Bobby','Cathrine','Madonna','Rocky','Sebastian','Jaqluine',
'Rahul','David'],
'Score1':[62,47,55,74,31,77,85,63,42],
'Score2':[89,87,67,55,47,72,76,79,44]}

df1 = pd.DataFrame(d)
df1

so the resultant dataframe will be

concatenate columns in python pandas – column bind python pandas 1

 

Create dataframe 2:


import pandas as pd
import numpy as np

#Create a DataFrame
d = {
'Score3':[56,86,77,45,73,62,74,89,71]}

df2 = pd.DataFrame(d)
df2

and the resultant dataframe will be

concatenate columns in python pandas – column bind python pandas 2

 

Column bind or concatenate columns of two dataframes in python pandas:

Now lets concatenate or column bind two dataframes df1 and df2


pd.concat([df1, df2], axis=1, ignore_index=True)

argument axis=1 binds the dataframes on column wise, so the resultant column binded dataframe will be

concatenate columns in python pandas – column bind python pandas 3

 

previous-small Append or concatenate columns in python pandas – column bind                                                                                                                next_small Append or concatenate columns in python pandas – column bind