擅长:python、mysql、java
<p>你可以做:</p>
<pre class="lang-py prettyprint-override"><code>filter_=df.loc[df["col2"].str.contains("_Lh"), "col1"].drop_duplicates()
df=df.merge(filter_, on="col1")
</code></pre>
<p>产出:</p>
<pre class="lang-py prettyprint-override"><code> col1 col2
0 G1 OP2
1 G1 OP0
2 G1 OPP
3 G1 OPL_Lh
4 G4 TUI
5 G4 TYUI
6 G4 TR_Lh
</code></pre>