/Python/Split string by delimiter string

Split string by delimiter string

Split strings around given separator/delimiter

# split strings around given separator/delimiter
# import Pandas as pd 
import pandas as pd 
   
# create a new data frame 
df = pd.DataFrame({'Location': ['Cupertino,California', 'Los Angles, California', 'Palo Alto, California']
                   }) 
   
df[['City','State']] = df.Location.str.split(',',expand=True) 
df
print(df)

Source: grepper.com

Similar codes

1 vote314 views1 answer
Can variables have spaces python
Python
0 vote333 views1 answer
Pandas merge sort columns
Python
2 votes340 views2 answers
Python last index of item in list
Python
0 vote290 views1 answer
How to make python open a link
Python
0 vote361 views1 answer
Base64 python flask html
Python
73 votes294 views6 answers
Remove duplicates python
Python
0 vote343 views1 answer
How to python string up
Python
-2 votes369 views2 answers
Where to import reverse_lazy in django
Python Django
0 vote386 views1 answer
Del no of elements in lis
Python
0 vote328 views1 answer
Concatenate dataframes using one column
Python