/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

2 votes170 views1 answer
How do I mock an uploaded file in django?
Python Django
0 vote122 views1 answer
Replace substrings to float
Python
0 vote91 views1 answer
Python count number of combinations
Python
0 vote206 views1 answer
Python how to code discord bot kick members
Python
1 vote151 views1 answer
Python strftime microseconds
Python
0 vote137 views1 answer
Iterating over the two ranges simultaneously and saving it in database
Python
0 vote132 views1 answer
One liner if else statement python
Python
144 votes134 views6 answers
Write in file python
Python
0 vote138 views1 answer
Decode html python
Python
1 vote126 views3 answers
Pandas rename index values
Python