回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个数据帧,例如:</p>
<pre><code>Groups Names Numbers Value
G1 Canis_lupus1 10.0 NaN
G1 Cattus_cattus4 10.0 NaN
G1 Homo_sapiens2 3.0 NaN
G1 Danio_rerio 1.0 NaN
G2 Canis_lupus2 10.0 0.3
G2 Cattus_cattus5 10.0 0.3
G3 Elaph_strangus2 2.0 NaN
G3 Elaph_strangus3 2.0 NaN
</code></pre>
<p>我只想把<code>Groups</code>和<code>Numbers</code>值相同的<code>Names</code>和<strong>NaN</strong>值保持在<code>Groups</code>之内</p>
<p>因此,我应该得到:</p>
<pre><code>Groups Names Numbers Value
G1 Canis_lupus1 10.0 NaN
G1 Cattus_cattus4 10.0 NaN
G3 Elaph_strangus2 2.0 NaN
G3 Elaph_strangus3 2.0 NaN
</code></pre>
<p>有人有主意吗</p>
<p>以下是dict格式的数据帧(如果有帮助):</p>
<pre><code>{'Groups': {0: 'G1', 1: 'G1', 2: 'G1', 3: 'G1', 4: 'G2', 5: 'G2', 6: 'G3', 7: 'G3'}, 'Names': {0: 'Canis_lupus1', 1: 'Cattus_cattus4', 2: 'Homo_sapiens2', 3: 'Danio_rerio1.0', 4: 'Canis_lupus2', 5: 'Cattus_cattus5', 6: 'Elaph_strangus2', 7: 'Elaph_strangus3'}, 'Numbers': {0: 10.0, 1: 10.0, 2: 3.0, 3: nan, 4: 10.0, 5: 10.0, 6: 2.0, 7: 2.0}, 'Value ': {0: nan, 1: 'NaN ', 2: nan, 3: nan, 4: '0.3', 5: '0.3', 6: nan, 7: 'NaN '}}
</code></pre>