title: Getting a data frame from other data frame
body: <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>