And for the other case, assuming it are strings that look like tuples:
In [74]: df['stats'].str[1:-1].str.split(',', expand=True).astype(float)
Out[74]:
0 1 2 3 4
0 -0.009242 0.410000 -0.742016 0.003683 0.002517
1 0.041154 0.318231 0.758717 0.002640 0.010654
2 -0.014435 0.168438 -0.808703 0.000817 0.003166
3 0.034346 0.288731 0.950845 0.000001 0.003373
4 0.009052 0.151031 0.670257 0.012179 0.003022
5 -0.004797 0.171615 -0.552879 0.050032 0.002180
(note: for older versions of pandas (< 0.16.1), you need to use return_type="frame"
instead of the expand keyword)
By the way, if it are tuples and not strings, you can simply do the following:
pd.DataFrame(df['stats'].tolist(), index=df.index)