title: Python, dataframes: How to make dictionary/series/dataframe for each value whose key is duplicate in python dataframe?
body: <p>I have dataframes created like this:</p>
  
  <pre><code>+---------+--------+-----+-------------+
  | VideoID |   long | lat | viewerCount |
  +---------+--------+-----+-------------+
  | 123     |   -1.1 | 1.1 |     25      |
  +---------+--------+-----+-------------+
  | 123     |   -1.1 | 1.1 |     20      |
  +---------+--------+-----+-------------+
  </code></pre>
  
  <p>The <code>videoIDs</code> are the <code>IDs</code> for video live streaming on facebook. And <code>viewerCount</code> is the number of viewers watching them.
  I add the values refreshing after every 30 seconds. The <code>videoIDs</code> mostly will be duplicates but the <code>viewerCount</code> can will change. 
  So what I am trying is to store the new <code>viewerCount</code> also but no duplication of videoIDs 
  (i.e.: the viewerCount is now not a single columns but can be a dictionary or series). Something like this:
  <img src="https://i.stack.imgur.com/55yzg.png" alt="the table showing the format i expect (to clear the point)"></p>