Pages

Merge two CSV file (outer join)

#python read csv files and merge it with outer join

import pandas as pd

a= pd.read_csv("1.csv")
b=pd.read_csv("2.csv")


#key is for index (column name for ID) two IDmerge=a.merge(b,on=["key1","key2"],how='outer' )

#exmport csv file
result.to_csv("output.csv",index=False)
Share:

No comments:

Post a Comment

Powered by Blogger.

Popular Posts