add random elemnt from list to existing dataframe string

Question

I have a dataframe. df['Skill']=python, sql, java. Now for each string I want to add random element (high, low, medium). For Eg: df['Skill']=python:high, sql:low, java:medium.

I have tried one code but it adds score['low', 'high', 'medium'] at the end of the string.

Can someone please suggest how can i do it.

score=['low','medium','high']
df[Skill']=df['Skill'].apply(lambda x:[x + ": " + "".join(w for w in random.choice(score))])

Output:

['python, java, sql: medium']

But i want is python: low, java: high, sql: medium

lambda x: " ".join(w": "+s for w, s in zip(x.split(' '), random.choice(score, x.count(' ')))) you have to apply on each word by splitting — Naga kiran
– Naga kiran, Commented Aug 11, 2021 at 11:14
df['Skills']= d['Skills'].apply(lambda x: ", ".join(w +": "+s for w, s in zip(x.split(', '), random.choice(score)))) output I get is --- python: l , java: o, sql: w — 10sha25
– 10sha25, Commented Aug 11, 2021 at 11:35
Is there a value sql: medium in your 'Skill' column or apply() is giving out this result? — Anurag Dabas
– Anurag Dabas, Commented Aug 11, 2021 at 11:39
There is no [sql: medium] in the skill column only [sql] is present in the skill column output I get is using apply function — 10sha25
– 10sha25, Commented Aug 11, 2021 at 11:49

Satya · Accepted Answer · 2021-08-11 11:48:36Z

1

Check this:

df['Skill']= df['Skill'].apply(lambda x:','.join([y+': '+random.choice(score) for y in x.split(',')]))

edited Aug 11, 2021 at 11:48

answered Aug 11, 2021 at 11:17

Satya

5,94719 gold badges55 silver badges74 bronze badges

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

3 Comments

10sha25 Over a year ago

'Series' object has no attribute 'split' this is the error I get

Satya Over a year ago

sorry i used variable name x inside the apply function, edited it, check now

10sha25 Over a year ago

Yes, I understood the error also understood the logic and I have resolved my problem Thankyou.

Mahdi F. · Accepted Answer · 2021-08-11 12:00:43Z

1

try this:

import random
skill = ['python','java', 'sql', 'html']
score=['low','medium','high']
select_score = list()
for i in range(len(skill)):
    select_score.append(random.choice(score))

select_score

freq_s = (dict(zip(skill, select_score)))
freq_s

output:

{'python': 'medium', 'java': 'low', 'sql': 'medium', 'html': 'low'}

edited Aug 11, 2021 at 12:00

answered Aug 11, 2021 at 11:16

Mahdi F.

24.1k5 gold badges25 silver badges32 bronze badges

Collectives™ on Stack Overflow

add random elemnt from list to existing dataframe string

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related