Insert a given column at a specific position in a Pandas DataFrame



Insert a given column at a specific position in a Pandas DataFrame

In this article, we will use Dataframe.insert() method of Pandas to insert a new column at a specific column index in a dataframe.

Syntax: DataFrame.insert(loc, column, value, allow_duplicates = False)

Return: None

Code: Let’s create a Dataframe.

# Importing pandas library
import pandas as pd
 
# dictionary
values = {'col2': [6, 7, 8
                   9, 10],
          'col3': [11, 12, 13,
                   14, 15]}
 
# Creating dataframe
df = pd.DataFrame(values)
 
# show the dataframe
df

Output:

Dataframe

Example 1: Inserting column at the beginning of the dataframe.

# Importing pandas library
import pandas as pd
 
# dictionary
values = {'col2': [6, 7, 8
                   9, 10], 
          'col3': [11, 12, 13,
                   14, 15]}
 
# Creating dataframe
df = pd.DataFrame(values)
 
# New column to be added
new_col = [1, 2, 3, 4, 5
 
# Inserting the column at the
# beginning in the DataFrame
df.insert(loc = 0,
          column = 'col1',
          value = new_col)
# show the dataframe
df

Output:

Insert new column at beginning of the dataframe

Example 2: Inserting column in the middle of the dataframe

# Importing pandas library
import pandas as pd
 
# dictionary
values = {'col2': [6, 7, 8
                   9, 10], 
          'col3': [11, 12, 13,
                   14, 15]}
 
# Creating dataframe
df = pd.DataFrame(values)
 
# New column to be added
new_col = [1, 2, 3, 4, 5
 
# Inserting the column at the
# middle of the DataFrame
df.insert(loc = 1,
          column = 'col1',
          value = new_col)
# show the dataframe
df

Output:

Insert new column at middle of the dataframe

Example 3: Inserting column at the end of the dataframe

# Importing pandas library
import pandas as pd
 
# dictionary
values = {'col2': [6, 7, 8
                   9, 10], 
          'col3': [11, 12, 13,
                   14, 15]}
 
# Creating dataframe
df = pd.DataFrame(values)
 
# New column to be added
new_col = [1, 2, 3, 4, 5
 
# Inserting the column at the
# end of the DataFrame
# df.columns gives index array 
# of column names
df.insert(loc = len(df.columns),
          column = 'col1',
          value = new_col)
# show the dataframe
df

Output:

Insert new column at end of the dataframe

 

Last Updated on October 18, 2021 by admin

Leave a Reply

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

Recommended Blogs