The at
method in pandas is used to get a single value from a dataframe based on the row index and column name. The at
method needs two parameters: the row index and column name.
It then returns the value of the specified position.
The
at
method is similar to theloc
method since it supports label-based indexing.
The illustration below shows how the at
method works in pandas:
The syntax of the at
method is as follows:
Dataframe.at[rowIndex, columnLabel]
The at
method takes a rowIndex
and a columnLabel
.
The at
method returns the value at the corresponding position.
The key error is raised if the parameters passed as row index and column labels are out of bound or not present in the dataframe.
The code snippet below shows how the at
method works in pandas:
We can also use the
at
method to assign a value on a particular index. This is shown in Line 14:
import pandas as pddf = pd.DataFrame([[0, 2, 3], [0, 4, 1], [10, 20, 30]],columns=['A', 'B', 'C'])print("Original Dataframe")print(df)print('\n')print("Get a value")print(df.at[1, 'B'])print('\n')df.at[1, 'C'] = 10print("New Dataframe")print(df)
Free Resources