im preprocessing two dataframes and now I wanted to match these two with the identifier ProductNo. In the first datadframe i habe 6 mio rows and I want to match the second df to each row of the first one, where ProductNo = ProductNo. So that I still have 6 mio rows in the end. What I did:
df = pd.merge(df1, df2, on='ProductNo')
After that I have the matched df, but only 36k rows left. Do i need to use another fuction or add parameters? Thank you so much in advance!
