Insert 1's random into a column pandas dataframe python

Question

I have a dataframe with 182 rows. I want to add a column to it full of 0's except for twelve 1's distributed random in the df. Is it possible? Thanks

Tom Ron · Accepted Answer · 2020-11-06 17:24:52Z

1

df['x']=0
df.loc[df.sample(12).index.tolist(), 'x'] =  1

answered Nov 6, 2020 at 17:24

Tom Ron

6,2413 gold badges28 silver badges43 bronze badges

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

1 Comment

ti7 Over a year ago

This is probably the best answer as it makes great use of native methods.

ti7 · Accepted Answer · 2020-11-06 17:24:15Z

0

You can use random.shuffle for this

# create members
contents = [1 for _ in range(12)] + [0 for _ in range(182 - 12)]
# shuffle contents in-place
random.shuffle(contents)
# add to df
df["colname"] = contents

answered Nov 6, 2020 at 17:24

ti7

19.9k8 gold badges50 silver badges87 bronze badges

Comments

avarice · Accepted Answer · 2020-11-06 17:24:19Z

0

You can use random.choice along with list comprehension:

import random
df['NEW_COL'] = [0]*182
df['NEW_COL'][[random.choice(range(182)) for x in range(12)]] = 1

answered Nov 6, 2020 at 17:24

avarice

15.6k3 gold badges19 silver badges38 bronze badges

Collectives™ on Stack Overflow

Insert 1's random into a column pandas dataframe python

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related