Pandas conditional split

Question

I want to split a column in pandas dataframe and I am using this code:

df['entry'] = df['entry'].str.split('.')

Now the problem is that I want to split bigger text elements such as:

I am content. I am another content.

But in the data there is also stuff like this:

I am 10.2 content.

I don't want to split the numbers. So I would need some conditional such as:

If dot between numbers, don't split.

How can I do this with pandas?

Toto · Accepted Answer · 2017-06-17 12:14:27Z

2

Use negative lookarround:

Update to deal with " I am St. Content."

rx = re.compile(r'(?<!\d)(?<!\b\w\w)\.(?!\d)')
str = 'I am content. I am another content. I am 10.2 content. I am St. Content.'
str = rx.split(str)
print(str)

Output:

['I am content', ' I am another content', ' I am 10.2 content', ' I am St. Content', '']

edited Jun 17, 2017 at 12:14

answered Jun 17, 2017 at 11:04

Toto

91.7k63 gold badges97 silver badges135 bronze badges

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

2 Comments

Felix Over a year ago

If I have another exception such as: I am St. Content. And it is always the two letters St where I don't want to split. Can I add a second lockaround?

Felix Over a year ago

Unfortunately, your solution looked promising but doesn't work on my data.

Collectives™ on Stack Overflow

Pandas conditional split

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related