/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 vote196 views1 answer
Extract first letter of column python
Python
0 vote203 views1 answer
Add metadata png PIL
Python
0 vote206 views1 answer
Python update flask
Python Flask
0 vote207 views1 answer
Extends template django
Python Django
0 vote188 views1 answer
Float infinity python
Python
42 votes178 views5 answers
How to print today's date in python
Python
17 votes164 views4 answers
Python optional arguments
Python
0 vote204 views1 answer
Torch.nn.Linear(in_features, out_features, bias=True) discription
Python
0 vote194 views1 answer
How to get count by using group by in python
Python
1 vote192 views2 answers
Python set recursion limit
Python