/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 vote282 views1 answer
How to make a instagram report bot python
Python
5 votes295 views1 answer
Find all files in a directory with extension python
Python
2 votes295 views1 answer
Python sort multiple lists based on sorting of single list
Python
1 vote293 views1 answer
Split string form url last slash
Python
2 votes294 views1 answer
Add colour to text in python
Python
21 votes282 views2 answers
Convert column to datetime format python
Python
30 votes318 views4 answers
How to convert data type of a column in pandas
Python
0 vote283 views1 answer
Most popular python libraries
Python
12 votes299 views5 answers
Python UUID
Python
0 vote277 views1 answer
Powershell get list of groups and members
Python