python pandas csv数据匹配 merge函数
import numpy as np
import pandas as pd
df=pd.read_csv('C:/Users/yumin/Desktop/data/global_death_total.csv')
loanstats = pd.DataFrame(df) #读取第一个数据表
df1=pd.read_csv('C:/Users/yumin/Desktop/data/2014_world_gdp_with_codes.csv')
member_grade = pd.DataFrame(df1) #读取第两个数据表
loan_left=pd.merge(loanstats,member_grade,how='right')
print(loan_left) #classic method- merge
loan_left.to_csv("C:/Users/yumin/Desktop/data/update1_death_global.csv") #save csv