Home » Python » Python Programs

How to insert rows in pandas DataFrame?

Given a Pandas DataFrame, we have to insert rows in it.
Submitted by Pranit Sharma, on June 11, 2022

Rows in pandas are the different cell (column) values which are aligned horizontally and also provides uniformity. Each row can have same or different value. Rows are generally marked with the index number but in pandas we can also assign index name according to the needs. In pandas, we can create, read, update and delete a column or row value.

To insert rows in pandas DataFrame - We will first create a DataFrame and then we will concat it with the previous DataFrame.

To work with pandas, we need to import pandas package first, below is the syntax:

import pandas as pd

Let us understand with the help of an example,

# Import pandas Package
import pandas as pd

# Creating dictionary
d = {
    'Name':['Ankit', 'Tushar', 'Saloni','Jyoti', 'Anuj', 'Rajat'],
    'Salary':[23000, 21000, 22000, 21000, 24000, 25000],
    'Department':['Production', 'Production', 'Marketing', 'Marketing', 'Sales', 'Sales']
}

# Creating a Dataframe
df = pd.DataFrame(d,index = ['a', 'b', 'c', 'd', 'e', 'f'])

print("Created Dataframe:\n", df,"\n")

# Creating a new Dataframe with one row
new_df = pd.DataFrame({
    'Name':['Anuj'],
    'Salary':[40000],
    'Department':['Manager']},index=['g'])

# Concatenating new dataframe and old dataframe
result = pd.concat([new_df,df])

# Display result
print("Modified DataFrame\n",result)

Output:

Python Pandas Programs »

---