How to do Match Merge either in Python or in Python Pandas | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

How to do Match Merge either in Python or in Python Pandas

How to do Match Merge in Python or Python Pandas ( Like match Merge in SAS) Data set A Dataset B S.No X Y X Y 1 12 6 12 5 2 5 8 5 10 3 11 11 12 4 12 7 12 9 5 5 5 5 Result A Matching Col. is S.NO S.No X Y 1 12 6 2 5 8 3 11 12 4 12 7 5 5 5

7th Oct 2017, 7:57 AM
Bhavani
2 Answers
+ 1
can you please make your data set clear?
17th May 2018, 1:51 PM
$ยข๐Žโ‚น๐”ญ!๐จ๐“
$ยข๐Žโ‚น๐”ญ!๐จ๐“ - avatar
- 1
If i understand your question correctly I would make the datasets into lists and compare them in an If statement. Here is an example: https://code.sololearn.com/cfSleqMvCVAv/?ref=app [EDIT] I'm not sure how you are merging the two sets, but it shouldn't be hard to add it to your 'equals' list.
17th May 2018, 2:05 PM
Aaron Nelson
Aaron Nelson - avatar