擅长:python、mysql、java
<p>您要做的是一个透视表<code>pandas</code>已经有一个名为<code>pd.pivot_table</code>的方法</p>
<p>尝试:</p>
<pre><code># import pandas
import pandas as pd
# the example dataframe
df = pd.DataFrame((['Sep-2015', 'Adam',3 ],
['Sep-2015', 'David',3],
['Sep-2015', 'Adam',4],
['Sep-2015', 'Adam' ,3],
['Sep-2015', 'David',6],
['Sep-2015' , 'Hardik',1],
['Sep-2015' , 'David' ,3]),columns=['Date','Name','Count'])
# drop duplicates
df = df.drop_duplicates(['Date', 'Name'], keep='last')
#pivot table
pd.pivot_table(data = df, values = 'Count', columns = 'Name', index = 'Date').reset_index()
</code></pre>
<p>输出:</p>
<pre><code>Date Adam David Hardik
Sep-2015 3 3 1
</code></pre>