原始数据如下
a = pd.DataFrame({'药品名':['感康','感冒灵','皮炎平'], '商品号':['8124','0023','0045'],'条形码':['69000000001','69000002103','69000000003'], '规格':['12片','8袋','15克']})
b = pd.DataFrame({'批准文号':['国药准字Z43018942','国药准字Z23010042','国药准字H13018942', '国药准字B12018332'], '商品号':['0012','0023','1023','0045'],'条形码':['69000000001','69000000002','69000000003', '69000000553'], '零售价':[10, 9, 7.5, 25]})
我想通过‘商品号’和‘条形码’这两列,合并这两个表格
但这两列,只要其中一列相等即可合并,我要的结果如下:
如何用最短的代码实现这个目的呢