/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 vote297 views1 answer
How to find second maximum element of an array python
Python
2 votes293 views1 answer
Python finally keyword
Python
0 vote316 views1 answer
Extract all capital words dataframe
Python
23 votes454 views3 answers
Django rest framework
Python Django
0 vote292 views1 answer
Skip error python
Python
5 votes326 views3 answers
How to print multiple lines in one line python
Python
0 vote299 views2 answers
Error: Could not locate a Flask application. You did not provide the "FLASK_APP" environment variable, and a "wsgi.py" or "app.py" module was not found in the current directory.
Python
21 votes331 views2 answers
Fast api
Python
0 vote288 views1 answer
Write to file in p
Python
2 votes309 views1 answer
Pycharm why won't os work
Python