What is the at method in pandas?

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 the loc method since it supports label-based indexing.

The illustration below shows how the at method works in pandas:

Syntax

The syntax of the at method is as follows:

Dataframe.at[rowIndex, columnLabel]

Parameters

The at method takes a rowIndex and a columnLabel.

Return value

The at method returns the value at the corresponding position.

Errors

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.

Example

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 pd
df = 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'] = 10
print("New Dataframe")
print(df)
New on Educative
Learn to Code
Learn any Language as a beginner
Develop a human edge in an AI powered world and learn to code with AI from our beginner friendly catalog
🏆 Leaderboard
Daily Coding Challenge
Solve a new coding challenge every day and climb the leaderboard

Free Resources

Copyright ©2025 Educative, Inc. All rights reserved