/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 vote106 views1 answer
TypeError: 'tuple' object does not support item assignment
Python
0 vote118 views1 answer
Cross entropy
Python
0 vote101 views1 answer
Encoding read_csv
Python
0 vote123 views1 answer
Python inline web server
Python
0 vote129 views1 answer
Django.core.exceptions.ImproperlyConfigured: Application labels aren't unique, duplicates: auth
Python Django
0 vote104 views1 answer
Form valid django created by
Python
1 vote111 views1 answer
Pandas multiple string contains
Python
3 votes110 views2 answers
Python set cwd to script directory
Python
0 vote112 views1 answer
Create virtual environments python
Python
1 vote112 views1 answer
How to remove numbers from string in python pandas
Python