pandas - at/iat

import numpy as np
import pandas as pd

df = pd.DataFrame([[7, 3, 4], [1, 5, 5], [10, 26, 4]],
                  index=[1, 2, 3], columns=['fir', 'sec', 'thi'])
df

 Get value at specified row/column pair:

#df.at["行名","列名"]
df.at[1, 'fir']

Set value at specified row/column pair:

df.at[2, 'sec'] = 20
df.at[2, 'sec']

 Get value within a Series:

df.loc[2].at['thi']

 

iat

#按照行、列索引进行选值。
data = pd.DataFrame([[1, 2, 3, 4], [5, 6, 7, 8], [17, 18, 19, 20]],
                  columns=['col1', 'col2', 'col3','col4'])
data

 Get value at specified row/column pair:

data.iat[1, 2] #索引都是从0开始， 第二行，第三列

 Set value at specified row/column pair:

data.iat[1, 2] = 888

Get value within a series:

data.loc[0].iat[1]

 2