按某列合并两表(python)
可代替Excel表格做连表查询
# -*- coding: utf-8 -*-
"""
按字段合并
"""
import pandas as pd
import os
file1 = r'考勤\***.csv'
file2 = r'慕课成绩\***.csv'
# 实验1
# file3 = r'实验\***.csv'
# 实验2
# file3 = r'实验\***.csv'
root_dir = r'H:\助教数据'
add_file = os.path.join(root_dir,file3)
df1 = pd.read_csv(os.path.join(root_dir,'提供顺序的表.csv'), encoding='gbk')
df2 = pd.read_csv(add_file, encoding='gbk')
outfile = pd.merge(df1, df2, how='left', left_on=u'姓名',right_on=u'姓名')#set 合并两表的字段
outfile.to_csv(os.path.join(root_dir,'merge.csv'), index=False, encoding='gbk')