Adding values to pandas dataframe in a loop

Question

I am trying to iteratively add values to rows and columns through loops. If i increase the number of rolls in this case, loop should add new 1000 values to columns for each specific number of rolls creating new rows each with 1000 columns. However, I am getting the error "ValueError: setting an array element with a sequence."

import random
import pandas as pd
A = [2,6,7]
B = [1,5,9]
C = [3,4,8]
a = pd.DataFrame(); b = pd.DataFrame()
N = 1000
rolls = -1
while rolls != 0:
    rolls += 1
    for i in range(N):
        a.at[rolls,i] = [random.choice(A)]
        b.at[rolls,i] = [random.choice(B)]

jezrael · Accepted Answer · 2020-02-22 10:30:03Z

3

Set scalar instead one element list:

a.at[rolls,i] = random.choice(A)
b.at[rolls,i] = random.choice(B)

answered Feb 22, 2020 at 10:30

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Adding values to pandas dataframe in a loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related