回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<blockquote>
<p>This is my <code>dataframe</code></p>
</blockquote>
<pre><code> Date Name Count
0 Sep-2015 Adam 3
1 Sep-2015 David 3
2 Sep-2015 Adam 4
3 Sep-2015 Adam 3
4 Sep-2015 David 6
5 Sep-2015 Hardik 1
6 Sep-2015 David 3
</code></pre>
<blockquote>
<p>Now I want to unique <code>Name</code> with respect to <code>Date</code> and enter in other <code>dataframe</code>.
I tried this</p>
</blockquote>
<pre><code> 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'])
df = df.drop_duplicates(['Date', 'Name'], keep='last')
df2 = pd.DataFrame ({i : [j for j in df['Count']] for i in df['Name']},index = [i for i in df['Date']])
</code></pre>
<blockquote>
<p>I am getting this</p>
</blockquote>
<pre><code> Adam Hardik David
Sep-2015 3 3 3
Sep-2015 1 1 1
Sep-2015 3 3 3
</code></pre>
<blockquote>
<p>Here data entry is somewhere wrong. The following is the expected output.</p>
</blockquote>
<pre><code> Adam Hardik David
Sep-2015 3 1 3
</code></pre>