Pandas different random string for each row

Question

I'm trying a fill a dataframe column with random string characters - but using the code below I get a new 10 character string each time I run it - but it's the same for every row.

How do I generate a new string for each row?

print(df)

0          eqFSwEJQqD
1          eqFSwEJQqD
2          eqFSwEJQqD
3          eqFSwEJQqD
4          eqFSwEJQqD
              ...    
1019920    eqFSwEJQqD
1019921    eqFSwEJQqD
1019922    eqFSwEJQqD
1019923    eqFSwEJQqD
1019924    eqFSwEJQqD

I'd like, eg:

0 fGtryghjuYt
1 jUiKlOpYtrd

etc...

The code:

import random
from string import ascii_letters

df['ff'] = ''.join(random.choice(ascii_letters) for x in range(10))

Keith · Accepted Answer · 2022-12-08 15:03:46Z

2

I am not sure that it is actually going to give unique values but it is pretty likely to do so.

import random
import string
alphabet = string.ascii_letters + string.digits
df['ff'] = [''.join(random.choices(alphabet,k=10)) for _ in df.index]

answered Dec 8, 2022 at 15:03

Keith

4,9508 gold badges46 silver badges78 bronze badges

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

Comments

Dani Mesejo · Accepted Answer · 2021-10-01 09:32:15Z

1

Use:

df['ff'] = [''.join(random.choice(ascii_letters) for x in range(10)) for _ in range(len(df))]
print(df)

Like in the example below:

import random
from string import ascii_letters
import pandas as pd

df = pd.DataFrame(data=list(range(10)), columns=["id"])
df['ff'] = [''.join(random.choice(ascii_letters) for x in range(10)) for _ in range(len(df))]
print(df)

Output

   id          ff
0   0  UKCYsUXRYi
1   1  vvYweriLfb
2   2  eYcCCnXfhW
3   3  xiyPisioWt
4   4  cjMOxAcULS
5   5  lgkxtFCbBx
6   6  pPeEOmfgkB
7   7  EBhBfticnM
8   8  hdQxePBmCq
9   9  KCPosrHfgz

The problem with your approach is that it creates a unique single value and uses it to assign it to the whole 'ff' column

answered Oct 1, 2021 at 9:32

Dani Mesejo

62.2k6 gold badges56 silver badges86 bronze badges

Comments

jezrael · Accepted Answer · 2021-10-01 09:43:41Z

1

Use:

df['ff'] = df['col'].apply(''.join(random.choice(ascii_letters) for x in range(10)))

Or:

df['ff'] = [''.join(random.choice(ascii_letters) for x in range(10)) for _ in df.index]

Or:

from string import ascii_letters
a = np.random.choice(list(ascii_letters), size=(10, len(df)))
df['ff'] = np.apply_along_axis(''.join, 0, a)

edited Oct 1, 2021 at 9:43

answered Oct 1, 2021 at 9:31

jezrael

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

1 Comment

Keith Over a year ago

These are not guaranteed to be unique since no seed or anything is used

Collectives™ on Stack Overflow

Pandas different random string for each row

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related