Pandas Dataframe根据某一列的值查找另一列对应行的值

import pandas as pd  
  
# 创建一个DataFrame  
data = {  
    'A': ['foo', 'bar', 'baz', 'foo', 'bar'],  
    'B': [10, 20, 30, 40, 50],  
    'C': [100, 200, 300, 400, 500]  
}  
  
df = pd.DataFrame(data)  
  
# 根据列A的值查找列C对应行的值  
# 假设想查找列A值为'foo'的所有行对应的列C的值  
values_to_find = 'foo'  
corresponding_values_in_C = df.loc[df['A'] == values_to_find, 'C']  

print(corresponding_values_in_C)

'''
输出：
0    100  
3    400  
Name: C, dtype: int64
'''