How to create data frame from a list of results?

0
votes

I have a list of results like this [1.0, 3.0, 5.0, 2.0, 0.3, 1.0, 1.6, 0.6, 0.2, 0.5, 1.0, 0.4, 0.5, 1.5, 2.5, 1.0].

But I needed this data as the following data frame follow (I need to do this for really long tables). 

     a    b     c     d 
0  1.0  0.3   0.2   0.5 
1  3.0  1.0   0.5   1.5  
2  5.0  1.6   1.0   2.5 
3  2.0  0.6   0.5   1.0

This is the way I've got the data. Can you help me please? 

data1 = {"a":[1.,3.,5.,2.],
         "b":[4.,8.,3.,7.],
         "c":[5.,45.,67.,34]}

df = pd.DataFrame(data1)

data2 =[]

for index, row in df.iterrows():
    constante = row[0]

    for index, celda in df.iterrows():
        hey = celda[0]/constante

        data2.append(hey)

print data2
1
pythonlistpandasmatrixdataframe

1 Answers

3
votes

You can convert it to a numpy array and reshape:

lst = [1.0, 3.0, 5.0, 2.0, 0.3, 1.0, 1.6, 0.6, 0.2, 0.5, 1.0, 0.4, 0.5, 1.5, 2.5, 1.0]

pd.DataFrame(np.array(lst).reshape(4, 4).T, columns = list("abcd"))
Out[94]: 
     a    b    c    d
0  1.0  0.3  0.2  0.5
1  3.0  1.0  0.5  1.5
2  5.0  1.6  1.0  2.5
3  2.0  0.6  0.4  1.0