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 moduleimport pandas as pd # creating 2 DataFrameslocation = pd.DataFrame({'area': ['new-york', 'columbo', 'mumbai']})food = pd.DataFrame({'food': ['pizza', 'crabs', 'vada-paw']}) # concatenating the DataFramesdet = pd.concat([location, food], join = 'outer', axis = 1) # displaying the DataFrameprint(det) |
Output :
Example 2 : Using the append() method.
# importing the moduleimport pandas as pd # creating 2 DataFramesfirst = pd.DataFrame([['one', 1], ['three', 3]], columns =['name', 'word'])second = pd.DataFrame([['two', 2], ['four', 4]], columns =['name', 'word']) # concatenating the DataFramesdt = first.append(second, ignore_index = True) # displaying the DataFrameprint(dt) |
Output :
Example 3 : Using the .join() method.
# importing the moduleimport pandas as pd # creating 2 DataFrameslocation = pd.DataFrame({'area' : ['new-york', 'columbo', 'mumbai']})food = pd.DataFrame({'food': ['pizza', 'crabs', 'vada-paw']}) # concatenating the DataFramesdt = location.join(food) # displaying the DataFrameprint(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.
How to Concatenate Column Values in Pandas DataFrame?
Difference of two columns in Pandas dataframe
Split a text column into two columns in Pandas DataFrame
Sort the Pandas DataFrame by two or more columns
Delete duplicates in a Pandas Dataframe based on two columns
How to Subtract Two Columns in Pandas DataFrame?
How To Concatenate Two or More Pandas DataFrames?
Python Psycopg2 – Concatenate columns to new column
Python | Delete rows/columns from DataFrame using Pandas.drop()
How to select multiple columns in a pandas dataframe
Please Login to comment…