pandas.DataFrame.at#

propertyDataFrame.at[source]#

Access a single value for a row/column label pair.

Similar toloc, in that both provide label-based lookups. Useat if you only need to get or set a single value in a DataFrameor Series.

Raises:

KeyError

If getting a value and ‘label’ does not exist in a DataFrame or Series.

ValueError

If row/column label pair is not a tuple or if any labelfrom the pair is not a scalar for DataFrame.If label is list-like (excluding NamedTuple) for Series.

See also

DataFrame.at

Access a single value for a row/column pair by label.

DataFrame.iat

Access a single value for a row/column pair by integer position.

DataFrame.loc

Access a group of rows and columns by label(s).

DataFrame.iloc

Access a group of rows and columns by integer position(s).

Series.at

Access a single value by label.

Series.iat

Access a single value by integer position.

Series.loc

Access a group of rows by label(s).

Series.iloc

Access a group of rows by integer position(s).

Notes

SeeFast scalar value getting and settingfor more details.

Examples

>>>df=pd.DataFrame([[0,2,3],[0,4,1],[10,20,30]],...index=[4,5,6],columns=['A','B','C'])>>>df    A   B   C4   0   2   35   0   4   16  10  20  30

Get value at specified row/column pair

>>>df.at[4,'B']2

Set value at specified row/column pair

>>>df.at[4,'B']=10>>>df.at[4,'B']10

Get value within a Series

>>>df.loc[5].at['B']4