How to split string using multiple characters in Pandas?

Question

I am using Pandas and I would like to split the following strings:

pd.DataFrame(data = ['String1 - String2',
                     'This > That',
                     'One <-> Two'], columns = ["Value"])

Index	Value
0	String1 - String2
1	String1 > String2
2	One <-> Two

The string splitter could be - or >. How could I split the string such that I would get the following result:

Index	Value	String1	String2
0	String1 - String2	String1	String2
1	This > That	This	That
2	One <-> Two	One	Two

Thanks in advance

try re.split instead also possible duplicate https://stackoverflow.com/questions/4998629/split-string-with-multiple-delimiters-in-python — mj_codec, Aug 30 '22 at 05:38

jezrael · Accepted Answer · 2022-08-30T05:57:29.057

3

Use Series.str.split with regex \s+ for spaces before separators - or >:

df[['String1','String2']] = df['Value'].str.split('\s+[->]\s+', expand=True)
print (df)
               Value  String1  String2
0  String1 - String2  String1  String2
1        This > That     This     That

edited Aug 30 '22 at 05:57

answered Aug 30 '22 at 05:38

jezrael

822,522
95
1,334
1,252

Sorry it is possible that the splitter is `<->`. Would like to how could I add the new one on the regex? Thanks a lot – Winston Aug 30 '22 at 06:12
@Winston - change `[->]` to `[<->]` – jezrael Aug 30 '22 at 06:13
Thanks I modifed the code, then I found that it now only works on `>` but not `<->` and `-` anymore. – Winston Aug 30 '22 at 06:28
@Winston - Can you try `df[['String1','String2']] = df['Value'].str.split('\s+[->]\s+|\s+<->\s+', expand=True)` ? – jezrael Aug 30 '22 at 06:38

How to split string using multiple characters in Pandas?

1 Answers1