string split on capital letters a large dataframe column [duplicate]

Question

I have a dataframe df1 with multiple columns. I need to separate each string in this column by capital letters; looks easy but it's not (for me).

I have tried str.split and regex but not working

df1['Edition Statement]=df1['Edition Statement'].str.split('A', expand=True) df1

Would like to have string separated by capital letters

df['Edition Statement'] = df['Edition Statement'].str.split(r'[A-Z]') — Madhur Yadav
– Madhur Yadav, Commented Jun 21, 2019 at 4:10

amasoudfam · Accepted Answer · 2019-06-21 04:32:51Z

1

Try this one:

df1['Edition Statement'].str.split('[A-Z]', expand=True)

[A-Z] is the regular expression for one capital letter.

edited Jun 21, 2019 at 4:32

answered Jun 21, 2019 at 4:26

amasoudfam

995 bronze badges

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

4 Comments

ANGELO WATT Over a year ago

df1['Edition Statement'].str.split('[A-Z]', expand=True) returns the following error: Can only use .str accessor with string values, which use np.object_ dtype in pandas

ANGELO WATT Over a year ago

str.split and I think regex wont work as I Can only use .str accessor with string values, which use np.object_ dtype in pandas

ANGELO WATT Over a year ago

How bloody can I upload a picture to show the issue?

amasoudfam Over a year ago

ٌWhat's the dtype of df1['Edition Statement']?

Collectives™ on Stack Overflow

string split on capital letters a large dataframe column [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related