我有两个数据框
数据框1:
index cust_id rank opt
0 customer_1 1 test1
2 customer_1 2 test3
3 customer_1 3 test4
4 customer_2 1 test1
5 customer_2 2 test4
7 customer_2 3 test3
9 customer_3 1 test3
10 customer_3 2 test4
11 customer_3 3 test1
数据框2:
index cust_id rank opt
1 customer_1 1 new_opt
2 customer_2 2 new_opt
3 customer_3 3 new_opt
我希望将这两个数据框合并在一起,并获得以下输出结果:
index cust_id rank opt
0 customer_1 1 new_opt
1 customer_1 2 test1
2 customer_1 3 test3
3 customer_1 4 test4
4 customer_2 1 test1
5 customer_2 2 new_opt
6 customer_2 3 test4
7 customer_2 4 test3
8 customer_3 1 test3
9 customer_3 2 test4
10 customer_3 3 new_opt
11 customer_3 4 test1
基本上我希望数据框2的排名保持不变,在将数据框连接在一起后,数据框1中剩余选项的排名会增加。
任何帮助将不胜感激!