如何使用多个数据帧中的列名查找另一个数据帧

Question

我有三个不同的数据帧：

贝塔重量：

+----------+-----+----------+--------+
| PersonID | HCW | Adaptive | Static |
+----------+-----+----------+--------+
|      111 | 0.3 | 0.3      | 0.3    |
|      112 | 0.3 | 0.3      | 0.3    |
|      113 | 0.3 | 0.3      | 0.3    |
+----------+-----+----------+--------+

贝塔矩阵：

+---+-----+----------+--------+
|   | HCW | Adaptive | Static |
+---+-----+----------+--------+
| N |   0 | 0.5      | 0.5    |
| S |   0 | 0.4      | 0.6    |
| A |   0 | 0.3      | 0.7    |
+---+-----+----------+--------+

（注意，N、S和A是此数据帧的索引）

和Dyna：

+----------+-----+
| PersonID | nsa |
+----------+-----+
|      111 | S   |
|      112 | A   |
|      113 | N   |
+----------+-----+

我想使用Beta_矩阵作为查找更新Beta_权重，并使用Dyna检查此人是“N”、“S”还是“a”

生成的Beta_权重应如下所示：

+----------+-----+----------+--------+
| PersonID | HCW | Adaptive | Static |
+----------+-----+----------+--------+
|      111 |   0 | 0.4      | 0.6    |
|      112 |   0 | 0.3      | 0.7    |
|      113 |   0 | 0.5      | 0.5    |
+----------+-----+----------+--------+

Answer 1

使用update

Beta_Matrix['PersonID']=Dyna.set_index('nsa')['PersonID'].reindex(Beta_Matrix.index)
# here is try to using one key map with another , then we can do merge or others later on

Beta_Weights.set_index('PersonID',inplace=True)
Beta_Weights.update(Beta_Matrix.set_index('PersonID'))
Beta_Weights.reset_index(inplace=True)