类似于excel中的vlookup功能

def xx_pandas(duiying_path, input_path=None, output_path=None):
    data = pd.read_excel(duiying_path, sheetname=‘name‘)
    en_ch = {}  # 英文字段到中文字段的映射
    col1 = data[‘数据库名称‘.decode(‘utf8‘)]
    col2 = data[‘字段名称‘.decode(‘utf8‘)]
    for i in range(len(col1)):
        if str(col1[i]) == ‘nan‘:
            continue
        en_ch[col1[i]] = col2[i].strip()
    old_data = pd.read_excel(input_path, sheetname=‘Sheet1‘)
    ch_names = {}
    index = []
    for l in old_data.index:
        ch_name = ‘‘
        if l in en_ch:
            ch_name = en_ch[l]
        ch_names[l] = ch_name
        index.append(l)
    s = Series(ch_names, name=‘数据库字段‘)
    old_data.insert(0, ‘数据库字段‘, s)
    print old_data.head(100)
    old_data.to_excel(output_path)