pandas split column into multiple columns by delimiter
df[['A', 'B']] = df['AB'].str.split(' ', 1, expand=True)
                                
                            pandas split column into multiple columns by delimiter
df[['A', 'B']] = df['AB'].str.split(' ', 1, expand=True)
                                
                            split pandas dataframe in two
df_new1, df_new2 = df[:10, :], df[10:, :] if len(df) > 10 else df, None
                                
                            split coumn of df into multiple dynamic columns
d = [pd.DataFrame(df[col].tolist()).add_prefix(col) for col in df.columns]
df = pd.concat(d, axis=1)
   id0  id1   id2  value0  value1  value2
0   10   10   NaN   apple  orange    None
1   15   67   NaN  banana  orange    None
2   12   34  45.0   apple  banana  orange
                                
                            pandas split column into multiple columns
df.Name.str.split(expand=True,)
          0  1
0   Steve   Smith
1   Joe Nadal
2   Roger   Federer
                                
                            Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us