/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 vote252 views1 answer
Get py version
Python
0 vote264 views1 answer
Python detect color on screen
Python
1 vote257 views1 answer
Remove duplicate columns python dataframe
Python
71 votes254 views6 answers
Clear console in python
Python
2 votes270 views1 answer
Load custom font pygame
Python
0 vote305 views1 answer
Cannot access modules from neighbouring directories jupyter notebook
Python
0 vote258 views1 answer
Pandas removing outliers from dataframe
Python
6 votes289 views2 answers
Google search api python
Python
1 vote254 views1 answer
Python sqlite dict
Python
0 vote247 views1 answer
Find word position in string python
Python