使用for循环的Vlookup

import pandas as pd

# 创建示例数据
data = {
    'ID': [1, 2, 3, 4, 5],
    'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
    'Age': [25, 30, 35, 40, 45]
}
df = pd.DataFrame(data)

# 查找值
lookup_value = 3
result = None

# 使用 for 循环实现 VLOOKUP
for index, row in df.iterrows():
    if row['ID'] == lookup_value:
        result = row['Name']
        break

print(result)  # 输出: Charlie

import pandas as pd

# 创建示例数据
data = {
    'ID': [1, 2, 3, 4, 5],
    'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
    'Age': [25, 30, 35, 40, 45]
}
df = pd.DataFrame(data)

# 查找值
lookup_value = 3
result = df.loc[df['ID'] == lookup_value, 'Name'].values[0]

print(result)  # 输出: Charlie