擅长:python、mysql、java
<p>如果要根据列表筛选<code>gen</code>列,可以执行以下操作:</p>
<pre><code>df["gen"] = df["gen"].apply(lambda x: [g for g in x if g in genre_code])
print(df)
</code></pre>
<p>印刷品:</p>
<pre><code> id tit gen
0 620 AAA []
1 843 BBB [Science Fiction]
2 986 CCC [Mystery]
</code></pre>
<hr/>
<p>附言:为了加快这个过程,您可以在以下步骤之前将<code>genre_code</code>转换为<code>set()</code>:</p>
<pre><code>genre_code = set(["Science Fiction", "Mystery", "Non-fiction"])
df["gen"] = df["gen"].apply(lambda x: [g for g in x if g in genre_code])
</code></pre>