I have different dataframes in pandas for different years data like this:
Table 2019:
Name    A    B    C    D    Total
row_1   8    5    1    4     18
row_2   2    2    2    6     12
row_3   4    7    7    4     22
Table 2020:
Name    A    B    C    D    Total
row_1   4    6    2    3     15
row_3   5    4    7    7     23
row_4   3    9    8    9     29
And would like to combine them in:
Table A
Name    2019A    2020A
row_1     8        4
row_2     2        -
row_3     4        5
row_4     -        3
But I'm having trouble combining the tables and recognizing it hast different rows. How could I do it?
Combine dataframes in Pandas
