擅长:python、mysql、java
<p>尝试将数据组合成<code>list</code>而不是<code>dict</code>。使用<code>dict</code>将删除具有重复名称的行</p>
<p>此外,在对计数求和之前,必须将计数转换为整数</p>
<p>下面是一个例子:</p>
<pre><code>import pandas as pd
orders = ["screws:20", "nails:15", "brushes:5", "screws:15", "nails:20"]
items_0 = [s.split(':') for s in orders]
items = [[item[0], int(item[1])] for item in items_0] # convert counts to integer
# create the data frame
df = pd.DataFrame(items, columns=['Item', 'Count'])
# show the data frame
print(df)
# print again, summing the counts for each item
print(df.groupby('Item').sum())
</code></pre>
<p>哪张照片</p>
<pre><code> Item Count
0 screws 20
1 nails 15
2 brushes 5
3 screws 15
4 nails 20
Count
Item
brushes 5
nails 35
screws 35
</code></pre>