擅长:python、mysql、java
<p>您可以使用以下选项:</p>
<pre><code>df1 = pd.DataFrame([[1221,"aptq",[{'id': 100051}, {'id': 100050}]]], columns = ["offid","name","sub_ids"])
df2 = pd.DataFrame([[100051,"zonal"],
[100050,"upper"],
[100056,"capital | national"]], columns = [ "id","name"])
df2 = df2.set_index("id").T.to_dict(orient='records')[0]
</code></pre>
<p>现在我们只需创建一个列表并在字典中查找它:</p>
<pre><code>df1["sub_ids"] = df1["sub_ids"].apply(lambda row: [item for sublist in [list(row[i].values()) for i in range(len(row))] for item in sublist] if len(row) > 0 else "-")
df1["sub_ids"] = df1["sub_ids"].apply(lambda row: [df2[row[i]] for i in range(len(row))] if len(row)>0 else "-")
df1
offid name sub_ids
0 1221 aptq [zonal, upper]
</code></pre>