/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 vote207 views2 answers
Python read and write pdf data
Python
1 vote197 views2 answers
Pygame window at center
Python
-4 votes207 views4 answers
Latest django version
Python
0 vote209 views1 answer
Compress excel file in python
Python
0 vote207 views1 answer
Crank nicholson scheme python
Python
0 vote183 views1 answer
Violajones python opencv
Python
1 vote211 views1 answer
Jupyter notebook delete the output
Python
0 vote218 views1 answer
Two labels on one axis python
Python
0 vote214 views1 answer
How to check if a cell is empty in openpyxl
Python
-1 vote238 views2 answers
Python datetime to string iso 8601
Python