擅长:python、mysql、java
<p>IIUC,我会用:</p>
<pre><code>df_out = df.set_index(['QNumber', df.groupby('QNumber').cumcount()], append=True).unstack()
df_out.columns = [f'{i}_{j}' for i, j in df_out.columns]
df_out = df_out.reset_index(level=1)
print(df_out)
</code></pre>
<p>输出:</p>
<pre><code> QNumber Supplier_name_0 Supplier_name_1
0 5267 BOWER CORP NaN
1 5267 NaN ROLLWAY
2 5788 AIRCRAFT PRODUCTS NaN
</code></pre>