Splitting at specific string from a dataframe column in Python

Question

I have a dataframe with a column called "Spl" with the values below: I am trying to extract the values next to 'name': strings (some rows have multiple values) but I see the new column generated with the specific location of the memory. I used the below code to extract. Any help how to extract the values after "name:" string is much appreciated.

Column values:

'name': 'Chirotherapie', 'name': 'Innen Medizin'
'name': 'Manuelle Medizin'
'name': 'Akupunktur', 'name': 'Chirotherapie', 'name': 'Innen Medizin'

Code:

df['Spl'] = lambda x: len(x['Spl'].str.split("'name':"))

Output:

<function <lambda> at 0x0000027BF8F68940>

Anurag Dabas · Accepted Answer · 2021-03-29 13:32:08Z

1

Just simply do:-

df['Spl']=df['Spl'].str.split("'name':").str.len()

answered Mar 29, 2021 at 13:32

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

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

Comments

BENY · Accepted Answer · 2021-03-29 13:32:51Z

1

Just do count

df['Spl'] = df['Spl'].str.count("'name':")+1

answered Mar 29, 2021 at 13:32

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

Splitting at specific string from a dataframe column in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related