Open In App

Concatenate two columns of Pandas dataframe

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.



Last Updated : 01 Aug, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads