如何附加2个具有不同列名的不同数据框
a = pd.DataFrame({
"id": [0,1,2,3],
"countryid": [22,36,21,64],
"famousfruit": ["banana", "apple", "mango", "orange"],
"famousanimal": ["monkey", "elephant", "monkey", "horse"],
"waterlvl": [23, 43, 41, 87]
}).set_index("id")
>> a
b = pd.DataFrame({
"id": [0,1,2,3],
"cid": [25,27,98,67],
"FAM_FRUIT": ["grapes", "pineapple", "avacado", "orange"],
"FAM_ANI": ["giraffe", "dog", "cat", "horse"],
}).set_index("id")
>>b
如何追加行b在相应的列上(其名称与a)并产生如下结果 c