In this article, we will discuss how to set cell values in Pandas DataFrame in Python.
Method 1: Set value for a particular cell in pandas using dataframe.at
This method is used to set the value of an existing value or set a new record.
Python3
# import pandas moduleimport pandas as pd# create a dataframe# with 3 rows and 3 columnsdata = pd.DataFrame({ 'name': ['sireesha', 'ravi', 'rohith', 'pinkey', 'gnanesh'], 'subjects': ['java', 'php', 'html/css', 'python', 'R'], 'marks': [98, 90, 78, 91, 87]})# set value at 6 th location for name columndata.at[5, 'name'] = 'sri devi'# set value at 6 th location for subjects columndata.at[5, 'subjects'] = 'jsp'# set value at 6 th location for marks columndata.at[5, 'marks'] = 100# displaydata |
Output:
Method 2: Set value for a particular cell in pandas using loc() method
Here we are using the Pandas loc() method to set the column value based on row index and column name
Python3
# create a dataframe# with 3 rows and 3 columnsdata = pd.DataFrame({ 'name': ['sireesha', 'ravi', 'rohith', 'pinkey', 'gnanesh'], 'subjects': ['java', 'php', 'html/css', 'python', 'R'], 'marks': [98, 90, 78, 91, 87]})data.loc[4, 'name'] = 'siva nagulu' # set value at 4 th location for subjects columndata.loc[4, 'subjects'] = 'react-js' # set value at 4 th location for marks columndata.loc[4, 'marks'] = 80# displaydata |
Output:
Method 3: Update the value for a particular cell in pandas using replace
Here, we are updating the “suraj” value to “Lazyroar” using Pandas replace.
Python3
# import pandas moduleimport pandas as pddata.replace("suraj", "Lazyroar", inplace=True)#displaydisplay(data) |
Output:
Method 4: Update the value for a particular cell in pandas using iloc
Here, we are updating the value of multiple indexes of the 0th column to 45 using Python iloc.
Python3
# import pandas moduleimport pandas as pddata.iloc[[0,1,3],[0]] = 45#displaydisplay(data) |
Output:
