I have a dataframe with values, which refer to the index of another Dataframe. If I have two dataframes such as:
index | A | B |
---|---|---|
0 | 1 | hello |
1 | 0 | bye |
2 | 1 | bye |
3 | 2 | ready |
4 | 3 | hello |
index | value |
---|---|
0 | V |
1 | W |
2 | X |
3 | Y |
4 | Z |
I need to replace values in A by value in Table 2 based on index. Result must be:
index | A | B |
---|---|---|
0 | W | hello |
1 | V | bye |
2 | W | bye |
3 | X | ready |
4 | Y | hello |
Any help, please?
Thank you!