/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

0 vote154 views1 answer
Geopy set proxy
Python
0 vote204 views2 answers
Install pyttsx3
Python
0 vote199 views1 answer
Python count empty lines in text file
Python
3 votes180 views1 answer
How clear everything on canvas in tkinter
Python
0 vote198 views1 answer
What does triple quotes mean in python
Python
0 vote199 views1 answer
Pandas read_csv drop column
Python
7 votes178 views5 answers
Convert categorical variable to numeric python
Python
0 vote202 views1 answer
Sns.distplot fit
Python
22 votes182 views4 answers
Empty dataframe
Python
0 vote201 views1 answer
Get the list of column names whose data type is float python
Python