How to fill df with data from another df - Python
First answers is close, the only thing you need to do is merge both data frames using two fields. You do not need both data frames to have the same length at all
Try:
pd.merge(df1, df2, on = [&quot;number&quot;,&quot;trans&quot;], how = &quot;left&quot;)