Create dataframe from loop

Question

I have a loop which runs 3 times, and each time produces 4 values, e.g. below.

for i in range(0, 3):
    val1 = something
    val2 = something
    val3 = something
    val4 = something

From this loop, how can I create a dataframe of size (3x4) as follows?

val1  val2  val3  val4
2     4     5     42
12    23    54    65 
4     12    2     89

Alexander · Accepted Answer · 2019-11-12 00:24:26Z

2

data = []
for i in range(0, 3):
    val1 = something
    val2 = something
    val3 = something
    val4 = something
    data.append([val1, val2, val3, val4])
df = pd.DataFrame(data, columns=['val1', 'val2', 'val3', 'val4'])

answered Nov 12, 2019 at 0:24

Alexander

110k32 gold badges212 silver badges208 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Celius Stingher · Accepted Answer · 2019-11-12 00:23:59Z

1

You can make a dictionary from those lists, and then turn them into a Dataframe. The following is an example:

import pandas as pd
example_dict = {'val1':val1,'val2':val2,'val3':val3,'val4':val4}
df = pd.DataFrame(example_dict)

And now you df is as you requested.

If you wish to do all this in a go, I would do something a bit different:

import pandas as pd
example_dict = {'val1':[],'val2':[],'val3':[],'val4':[]}
for i in range(0,3):
    example_dict['val1'].append(something)
    example_dict['val2'].append(something)
    example_dict['val3'].append(something)
    example_dict['val4'].append(something)
df = pd.DataFrame(example_dict)

answered Nov 12, 2019 at 0:23

Celius Stingher

18.4k6 gold badges26 silver badges54 bronze badges

Collectives™ on Stack Overflow

Create dataframe from loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related