擅长:python、mysql、java
<p>使用<code>pandas</code>、<code>zip</code>和元组解包:</p>
<pre><code>prices = pd.DataFrame(index=df['Item Name'])
for idx, s_no, item, *row in df.itertuples():
# print(item, row)
iters = [iter(row)] * 2
for source, price in zip(*iters):
# print(source, price)
prices.loc[item, source] = price
</code></pre>
<blockquote>
<pre><code>Item Name website1 website2 website3
coffee 3.5 3.5 na
Tea 4.5 na 4.5
Soft Drink 1.5 2.5 na
</code></pre>
</blockquote>
<p>如果<code>s.No</code>是索引,则从for循环中删除<code>idx</code></p>