擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.core.groupby.GroupBy.first.html" rel="nofollow noreferrer">^{<cd1>}</a>函数</p>
<p>我试图复制数据,但只复制了前几行</p>
<pre><code>import pandas as pd
source = {'ID': ['MEXU ','RFGT','RFGT', 'OJKU', 'TYED'], 'TYPE': ['DOL','DOL','DOL', 'RET', 'NaN'], 'HEIGHT': ['NaN', 140, 'NaN', 90, 'NaN'], 'KG': [40, 47, 'NaN', 'NaN', 'NaN']}
df = pd.DataFrame(data=source)
grouped = df.groupby('ID', as_index=False).first()
print(grouped)
</code></pre>
<p>印刷品</p>
<pre><code>
ID TYPE HEIGHT KG
0 MEXU DOL NaN 40
1 OJKU RET 90 NaN
2 RFGT DOL 140 47
3 TYED NaN NaN NaN
</code></pre>