擅长:python、mysql、java
<p>你可以做:</p>
<pre class="lang-py prettyprint-override"><code>df2=df.pivot_table(index=[df.index, "QNumber"], columns=df.groupby("QNumber").cumcount(), values=["Supplier_name"], aggfunc=''.join)
#in order to reset multilevel index for columns:
df2.columns=[f"Supplier{i}" for i in range(len(df2.columns.values))]
df2.reset_index("QNumber", inplace=True)
</code></pre>
<p>和输出:</p>
<pre class="lang-py prettyprint-override"><code>QNumber Supplier0 Supplier1
0 0005267 BOWER CORP NaN
1 0005267 NaN ROLLWAY
2 0005788 AIRCRAFT PRODUCTS NaN
</code></pre>