Concatenate two columns of Pandas dataframe



Concatenate two columns of Pandas dataframe

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 on October 9, 2021 by admin

Leave a Reply

Your email address will not be published. Required fields are marked *

Recommended Blogs