How do I turn this table into a time series table?

Question

I am new to programming. I have a data set that look like this.

  col1                                       info
number      {'date':'2012-01-01', 'sign-ups':5023}
number      {'date':'2012-02-01', 'sign-ups':3060}
number      {'date':'2012-03-01', 'sign-ups':2400}
number      {'date':'2012-04-01', 'sign-ups':6700}

I want to turn it into a time series table like so..

     Date           sign-ups
2012-01-01            5023
2012-02-01            3060
2012-03-01            2400
2012-04-01            6700

I can't figure it out.

I tried to used for loop to strip all the 'num's out so that I can be left with just the dictionary. But that didn't even work. I tried typing df[0] to see if the first item would show up and I get an error message.

Any suggestion?