
        
        
            
                
                
                    import pandas as pd
df = pd.DataFrame({'A':['i love python', 'hello world']})
df
                
            
               A
0  i love python
1  hello world

To split the strings in column A by space:


        
        
            
                
                
                    df_split = df['A'].str.split(' ', expand=True)
df_split
                
            
               0      1      2
0  i      love   python
1  hello  world  None

Note the following:

None is returned for the third column for the second string because there are only two tokens (hello and world)
expand=True returns a DataFrame where each cell contains the split token - the default expand=False returns a DataFrame:
df['A'].str.split(' ') # expand=False 0 [i, love, python] 1 [hello, world] Name: A, dtype: object

To concatenate the initial DataFrame with the new DataFrame created by split(~), use Pandas' concat(~) method:


        
        
            
                
                
                    pd.concat([df, df_split], axis=1)
                
            
               A              0      1      2
0  i love python  i      love   python
1  hello world    hello  world  None

Here, axis=1 means we wish to concatenate the DataFrames horizontally.

Splitting string based on the first occurrence of a space

Consider the same DataFrame as before:


        
        
            
                
                
                    df = pd.DataFrame({'A':['i love python', 'hello world']})
df
                
            
               A
0  i love python
1  hello world

To split based on the first occurrence of a space, set n=1 like so:


        
        
            
                
                
                    df['A'].str.split(' ', n=1, expand=True)
                
            
               0      1
0  i      love python
1  hello  world

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!