Home »
Python »
Python Programs
Set value for particular cell in Pandas DataFrame using index
Set value for particular cell in Pandas DataFrame using index.
Submitted by Pranit Sharma, on April 12, 2022
Pandas DataFrame allows you to store data in the form of rows and columns. Sometimes you need to manipulate this data for effective analytics. Also, sometimes you may need to set the value of particular cell using index.
Here, Index refers to the number of rows which ranges from 0 to n-1.
To set the value of a particular cell using index, you should use the following property:
Syntax:
DataFrame.at['index','column_name']
pandas.DataFrame.at Property
The at property is used to find the position of a cell value. It takes two arguments; Index number and column name and it returns the respective cell value. This method can also be used to set the value of a particular cell.
To work with Python Pandas, we need to import the pandas library. Below is the syntax,
import pandas as pd
Example:
# Importing pandas package
import pandas as pd
# Creating a dictionary
d = {
"Name":['Hari','Mohan','Neeti','Shaily'],
"Age":[25,36,26,21],
"Gender":['Male','Male','Female','Female'],
"Profession":['Doctor','Teacher','Singer','Student']
}
# Now, we will create DataFrame
df = pd.DataFrame(d)
# Printing the original DataFrame
print("Original DataFrame:\n")
print(df,"\n\n")
# Now, we will change the cell value
# In the name column, we will change the value
# from Shaily to Astha
# For this we need to pass its row number i.e.
# index and also the column name.
df.at[3,'Name'] = 'Astha'
# Now, Printing the modified DataFrame
print("Modified DataFrame:\n")
print(df)
Output:
Original DataFrame:
Name Age Gender Profession
0 Hari 25 Male Doctor
1 Mohan 36 Male Teacher
2 Neeti 26 Female Singer
3 Shaily 21 Female Student
Modified DataFrame:
Name Age Gender Profession
0 Hari 25 Male Doctor
1 Mohan 36 Male Teacher
2 Neeti 26 Female Singer
3 Astha 21 Female Student
Python Pandas Programs »