string split on capital letters a large dataframe column

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, Jun 21 '19 at 04:10

amasoudfam · Answer 1 · 2019-06-21T04:32:51.690

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 '19 at 04:32

answered Jun 21 '19 at 04:26

amasoudfam

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 Jun 21 '19 at 05:08
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 Jun 21 '19 at 05:12
How bloody can I upload a picture to show the issue? – ANGELO WATT Jun 21 '19 at 05:13
ٌWhat's the dtype of df1['Edition Statement']? – amasoudfam Jun 21 '19 at 05:43

1 Answers1