How to split this data in Python pandas dataframe?

Question

The is my pandas data frame, In the index column i want to keep only the values after double underscore(__) and remove the rest.

jezrael · Accepted Answer · 2019-01-18 07:28:55Z

3

Use str.split with parameter n=1 for split by first splitter (if possible multiple __) and select second lists:

df['index'].str.split('__', n=1).str[1]

Or use list comprehension if no missing values and performance is important:

df['last'] = [x.split('__', 1)[1] for x in df['index']]

answered Jan 18, 2019 at 7:28

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Why is a list comprehension a good alternative for string operations? For more information, see my writeup here.

It works fine. Along with the index field, i just want to get all the columns? Any way?

@ShankarPanda - So need df1 = df.join(df['index'].str.split('__', expand=True)) ?

perfect !! Thanks

Chris · Accepted Answer · 2019-01-18 07:26:21Z

1

df['index'].apply(lambda x: x.split('__')[-1]) will do the trick

answered Jan 18, 2019 at 7:26

Chris

29.8k3 gold badges34 silver badges56 bronze badges