How to Concatenate Column Values in Pandas DataFrame?

Concatenate two columns of Pandas dataframe

Last Updated : 01 Aug, 2020

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.

How to Concatenate Column Values in Pandas DataFrame?

J

jainanjali733985

Improve

Article Tags :

Practice Tags :

python

Similar Reads

How to Concatenate Column Values in Pandas DataFrame?

Many times we need to combine values in different columns into a single column. There can be many use cases of this, like combining first and last names of people in a list, combining day, month, and year into a single column of Date, etc. Now we'll see how we can achieve this with the help of some

How To Concatenate Two or More Pandas DataFrames?

In real-world data the information is often spread across multiple tables or files. To analyze it properly we need to bring all that data together. This is where the pd.concat() function in Pandas comes as it allows you to combine two or more DataFrames in: Vertically (stacking rows on top of each o

How To Add Identifier Column When Concatenating Pandas dataframes?

We generally want to concat two or more dataframes when working with some data. So, when we concat these dataframes we need to actually want to provide an identifier column in order to identify the concatenated dataframes. In this article, we'll see with the help of examples of how we can do this. E

How to Convert Pandas DataFrame columns to a Series?

It is possible in pandas to convert columns of the pandas Data frame to series. Sometimes there is a need to converting columns of the data frame to another type like series for analyzing the data set. Case 1: Converting the first column of the data frame to Series C/C++ Code # Importing pandas modu

How to Convert Index to Column in Pandas Dataframe?

Pandas is a powerful tool which is used for data analysis and is built on top of the python library. The Pandas library enables users to create and manipulate dataframes (Tables of data) and time series effectively and efficiently. These dataframes can be used for training and testing machine learni

Count number of columns of a Pandas DataFrame

Let's discuss how to count the number of columns of a Pandas DataFrame. Lets first make a dataframe. Example: C/C++ Code # Import Required Libraries import pandas as pd import numpy as np # Create a dictionary for the dataframe dict = {'Name': ['Sukritin', 'Sumit Tyagi', 'Akriti Goel', 'Sanskriti',

Concatenate two PySpark dataframes

In this article, we are going to see how to concatenate two pyspark dataframe using Python. Creating Dataframe for demonstration: C/C++ Code # Importing necessary libraries from pyspark.sql import SparkSession # Create a spark session spark = SparkSession.builder.appName('pyspark - example join').ge

Show all columns of Pandas DataFrame

Pandas sometimes hides some columns by default if the DataFrame is too wide. To view all the columns in a DataFrame pandas provides a simple way to change the display settings using the pd.set_option() function. This function allow you to control how many rows or columns are displayed in the output.

Pandas DataFrame.columns

In Pandas, DataFrame.columns attribute returns the column names of a DataFrame. It gives access to the column labels, returning an Index object with the column labels that may be used for viewing, modifying, or creating new column labels for a DataFrame. Note: This attribute doesn't require any para

Count number of rows and columns in Pandas dataframe

In Pandas understanding number of rows and columns in a DataFrame is important for knowing structure of our dataset. Whether we're cleaning the data, performing calculations or visualizing results finding shape of the DataFrame is one of the initial steps. In this article, we'll explore various ways