Adding new column using string contains python

Question

I need some help, I want to add a new column from parts of a existing column. I used str.contains but it gives me this error: unsupported operand type(s) for &: 'str' and 'int'

This is my code:

df['VVD'] = df[df['hashtags'].str.contains('rutte', 'mark', 'vvd')]

I know this is not the correct way of doing this but I'm struggling to find out how I can do this.

Thankyou! I think this is almost it, but now the new column just contains true or false and I want it to contain the text — Sophia
– Sophia, Commented May 8, 2021 at 0:49
hi @Sophia, kindly add an example dataframe with expected output. Easier to work with visuals and give a more detailed/appropriate solution. Kindly share data, not pics. — sammywemmy
– sammywemmy, Commented May 8, 2021 at 1:22
@Sophia did you pass the boolean index back into df? df['VVD'] = df[df['hashtags'].str.contains("rutte|mark|vvd")] — Henry Ecker
– Henry Ecker ♦, Commented May 8, 2021 at 2:20

Code Different · Accepted Answer · 2021-05-08 05:18:12Z

2

You are assigning a column to a dataframe!

Try this:

cond = df['hashtags'].str.contains('rutte|mark|vvd')
df['VVD'] = df.loc[cond, 'hashtags']

answered May 8, 2021 at 5:18

Code Different

93.4k16 gold badges154 silver badges175 bronze badges

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

Collectives™ on Stack Overflow

Adding new column using string contains python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related