Pandas: select cell value using pd.at with condition

As Anton vBR has pointed out, this should solve your problem

df.loc[df['Column A'] == column_A_value]['Column B']

And if you like to get just one value you can do:

list(df.loc[df['Column A'] == column_A_value]['Column B'])[0]