How to iterate over a specific column in a already existing pandas dataframe

Question

I want to add a new column to the dataframe that will create a unique random number between 15 and 33.

i have tried this:

import random
df[new_col] = random.randint(15,33)

The problem with this code is that it creates one random number and distribute in all the columns, whereas I want each row to have its unique random number.

I think I should use a for loop but kinda don't know how to start.

Does this answer your question? How to create a DataFrame of random integers with Pandas? — some_programmer
– some_programmer, Commented Oct 11, 2020 at 16:21
@Junkrat, This is not working. I implemented it in my code and it throws an a typ error. import random import numpy as np ride_sharing['tyre_size_2'] = pd.DataFrame(np.random.randint(15,33, size=(25760,1)), columns='tyre_size_2') — Taylars Rikhotso
– Taylars Rikhotso, Commented Oct 11, 2020 at 23:34

Mehdi Golzadeh · Accepted Answer · 2020-10-11 17:40:45Z

0

Use apply function:

df['new_col'] = df.apply(lambda s: random.randint(15,33),axis=1)

answered Oct 11, 2020 at 17:40

Mehdi Golzadeh

2,5931 gold badge18 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

How to iterate over a specific column in a already existing pandas dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related