I’ve two dataframes with same shape. I’m doing left merge operation with pandas on both dataframes using
oppmaster_india1 = pd.merge(opp_master_india, email_ind[['Customer ID', 'Email']], on='Customer ID', how='left')
& left join using
oppmaster_india3 = sqldf("select [opp_master_india].*, [email_ind].[Email] as 'Email' from opp_master_india left join email_ind on [opp_master_india].[Customer ID] = [email_ind].[Customer ID]")
but the shape of resultant dataframes in both operations is coming different. Any idea, why?
Out: (3772516, 14)
Out: (3772644, 14)