I have two dataframes named clock_in_df and clock_out_df.
clock_in_df has 3150 rows while clock_out_df has 2921 rows. Both of these dataframes have the columns tag_id, tag_holder, location, clock_times, and temp_location_status common between them.
I tried to merge them using clock_in_df.merge(clock_out_df, how='left', on=['tag_id', 'tag_holder'])
but the result after the merge has 285 525 rows which is weird, but it has the correct 8 columns as expected.
How can I fix this?
