I have 2 dataframes. The first one looks like this
print (df1)
id rating cl6
0 43 1 text
1 21 0 text2
2 31 1 text3
3 32 4 text4
The second one looks like this, the ids in total rank from 1-100.
print (df2)
id mean_deliverytime
0 42 12
1 43 10
2 49 3
3 33 45
I now want to add a new column to df1 with the deliverytime for each id. so that it looks like this:
print (df1)
id rating cl6 mean_deliverytime
0 43 1 text 10
1 21 0 text2 12
2 31 1 text3 46
3 32 4 text4 48
How can I do this so the delivery time matches the id in df1?
