New paste
Download
Show/Hide line no.
Copy text to clipboard- import pandas as pd
- df1=pd.read_csv("C:\\Users\\vivek.viswanathan02\\OneDrive - Infosys Limited\\Documents\\vv1.csv")
- df2=pd.read_csv("C:\\Users\\vivek.viswanathan02\\OneDrive - Infosys Limited\\Documents\\vv2.csv")
- a=df1[df1['Station'].isin(df2['Keys'])]
- b=pd.merge(a,df2, left_on='Station',right_on='Keys',how='inner')
- b['Station']=b['Values']
- b.drop(['Keys','Values'],axis=1,inplace=True)
- c=pd.concat([a,df1]).drop_duplicates(keep=False)
- out=pd.concat([b,c])
- print(out)
Menu