I have a data-frame and one of its columns are a string which separated with dash. I want to get the part before the dash. Could you help me with that? The desire output is: Answer You could use str.replace to remove the - and all characters after it: Output:

split the string in dataframe in python

I have a data-frame and one of its columns are a string which separated with dash. I want to get the part before the dash. Could you help me with that?

import pandas as pd 
df = pd.DataFrame()
df['a'] = [1, 2, 3, 4, 5]
df['b'] = ['C-C02','R-C05','R-C01','C-C06', 'RC-C06']

JavaScript
​x
 
import pandas as pd 
df = pd.DataFrame()
df['a'] = [1, 2, 3, 4, 5]
df['b'] = ['C-C02','R-C05','R-C01','C-C06', 'RC-C06']
​

The desire output is:

Answer

You could use str.replace to remove the - and all characters after it:

df['b'] = df['b'].str.replace(r'-.*$', '', regex=True)

JavaScript
 
df['b'] = df['b'].str.replace(r'-.*$', '', regex=True)
​

Output:

JavaScript
 
   a   b
0  1   C
1  2   R
2  3   R
3  4   C
4  5  RC
​

Advertisement

Answer