/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 vote235 views1 answer
Django-filter field name greater than
Python
3 votes156 views2 answers
How to take multiple input python
Python
0 vote174 views1 answer
Raise keyerror(key) from none os.environ
Python
0 vote218 views1 answer
Django import excel file from same directory
Python Django
3 votes193 views1 answer
Python replace backslash with forward slash
Python
18 votes185 views5 answers
Plot histogram python
Python
13 votes208 views2 answers
How to flip a list backwards in python
Python
2 votes201 views1 answer
Expected ")" python
Python
11 votes169 views3 answers
Fibonacci recursive python
Python
2 votes161 views1 answer
Set http response content type django
Python