Open In App

Concatenate two columns of Pandas dataframe

Last Updated : 01 Aug, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

Let’s discuss how to Concatenate two columns of dataframe in pandas python. We can do this by using the following functions :

  • concat()
  • append()
  • join()

Example 1 : Using the concat() method.




# importing the module
import pandas as pd
  
# creating 2 DataFrames
location = pd.DataFrame({'area': ['new-york', 'columbo', 'mumbai']})
food = pd.DataFrame({'food': ['pizza', 'crabs', 'vada-paw']})
  
# concatenating the DataFrames
det = pd.concat([location, food], join = 'outer', axis = 1)
  
# displaying the DataFrame
print(det)


Output :

Example 2 : Using the append() method.




# importing the module
import pandas as pd
  
# creating 2 DataFrames
first = pd.DataFrame([['one', 1], ['three', 3]], columns =['name', 'word'])
second = pd.DataFrame([['two', 2], ['four', 4]], columns =['name', 'word'])
  
# concatenating the DataFrames
dt = first.append(second, ignore_index = True)
  
# displaying the DataFrame
print(dt)


Output :

Example 3 : Using the .join() method.




# importing the module
import pandas as pd
  
# creating 2 DataFrames
location = pd.DataFrame({'area' : ['new-york', 'columbo', 'mumbai']})
food = pd.DataFrame({'food': ['pizza', 'crabs', 'vada-paw']})
  
# concatenating the DataFrames
dt = location.join(food)
  
# displaying the DataFrame
print(dt)


Output :

For the three methods to concatenate two columns in a DataFrame, we can add different parameters to change the axis, sort, levels etc.



Like Article
Suggest improvement
Previous
Next
Share your thoughts in the comments

Similar Reads