title: use python's pandas to treat aws dynamodb data
body: <p>I'm getting data from a dynamodb table, using boto3 for python 2.7 and I would use pandas to group by and sort the data.</p>
  
  <p>Unfortunately the dynamodb data format is quite a bit tricky. Like this:</p>
  
  <pre><code>data = [{
        u 'permaname': {
          u 'S': u 'facebook'
        },
        u 'uuid': {
          u 'S': u '4b873085-c995-4ce4-9325-cfc70fcd4040'
        },
        u 'tags': {
          u 'L': []
        },
        u 'type': {
          u 'S': u 'xxxxxx'
        },
        u 'createdOn': {
          u 'N': u '1502099627'
        },
        u 'source': {
          u 'S': u 'xxxxxxx'
        },
        u 'data': {
          u 'NULL': True
        },
        u 'crawler': {
          u 'S': u 'xxxxxxx'
        }
      }, {
        u 'permaname': {
          u 'S': u 'facebook'
        },
        u 'uuid': {
          u 'S': u '25381aef-a7db-4b79-b599-89fd060fcf73'
        },
        u 'tags': {
          u 'L': []
        },
        u 'type': {
          u 'S': u 'xxxxxxx'
        },
        u 'createdOn': {
          u 'N': u '1502096901'
        },
        u 'source': {
          u 'S': u 'xxxxxxx'
        },
        u 'data': {
          u 'NULL': True
        },
        u 'crawler': {
          u 'S': u 'xxxxxxx'
        }
      }]
  </code></pre>
  
  <p>To do my group by and sort stuffs I must create a pandas object and I can not figure out how to do.</p>
  
  <p>This is how I'm trying:</p>
  
  <pre><code>obj = pandas.DataFrame(data)
  print list(obj.sort_values(['createdOn'],ascending=False).groupby('source'))
  </code></pre>
  
  <p>If I print obj like this: </p>
  
  <pre><code>print list(obj)
  </code></pre>
  
  <p>I have :</p>
  
  <blockquote>
    <p>[u'crawler', u'createdOn', u'data', u'permaname', u'source', u'tags',
    u'type', u'uuid']</p>
  </blockquote>
  
  <p>Does someone know how to create the dataFrame obj with the dynamodb data ?</p>