How to use regular expressions for making dummies?

Question

For instance, I have reviews column and I want to extract words and create dummy variables based on them.

I use that but can't use regular expressions here:

df = df['reviews'].str.contains('good').astype(int)

How can I use regular expressions here for extracting good, goid, goof etc.

you can try `df['reviews'].str.extract('(your_favourite_regex)')` — warped, Jun 09 '20 at 16:08

Mark Zhang · Answer 1 · 2020-06-09T14:40:41.313

0

You can use the .map method after the .contains method. Here's a concise example:

import pandas as pd

df = pd.DataFrame({'id': [1,2,3],
                  'review': ['this is a good one',
                            'this is a bad one',
                            'this one seems to be fine']})

df['review_good'] = df.review.str.contains('good').map({True: 1, False: 0})

edited Jun 09 '20 at 14:40

answered Jun 09 '20 at 14:35

Mark Zhang

1
1

I know that one when I name it and put in my df it is dummy but I want to use regular expressions – Said Taxmezov Jun 09 '20 at 14:51

How to use regular expressions for making dummies?

1 Answers1