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]