split pandas column into two code example
Example 1: pandas split by space
import pandas as pd
data["Team"]= data["Team"].str.split(" ", n = 1, expand = True)
data
Example 2: how to use split in pandas
import pandas as pd
data["Team"]= data["Team"].str.split(" ", n = 1, expand = True)
data
Example 3: pandas split column into multiple columns by delimiter
df[['A', 'B']] = df['AB'].str.split(' ', 1, expand=True)
Example 4: split pandas dataframe in two
df_new1, df_new2 = df[:10, :], df[10:, :] if len(df) > 10 else df, None
Example 5: 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
Example 6: pandas split column into multiple columns
df.Name.str.split(expand=True,)
0 1
0 Steve Smith
1 Joe Nadal
2 Roger Federer