擅长:python、mysql、java
<p><code>groupby</code>+<code>first</code></p>
<pre><code>df=df.replace('NAN',np.nan) # make sure it is np.nan not string NAN
df.groupby(['id_1','id_2'],as_index=False).first()
Out[37]:
id_1 id_2 value1 value2
0 1 2 100 101
1 10 2 345 345
2 10 20 200 202
</code></pre>