Pandas get elements from a column containing list of values using index slicing

Question

Posting minimal reproducible example

I have a dataframe say

df  
           combined
0    [0, 0, 1, 0, 0, 1, 0, 1]
1    [1, 0, 0, 0, 0, 1, 1, 0]
2             [1, 0, 0, 0, 1]

I need to create a new column where values will be only from the alternate index.

       new_column
0    [0, 1, 0, 0]
1    [1, 0, 0, 1]
2    [1, 0, 1]

This is what I tried, but this does not work

df['combined'].str[::2]

P.S : There are numerous ways in which this can be achieved I am looking for a more pandaic approach

BENY · Accepted Answer · 2022-07-01 17:06:02Z

1

You may need to check your cell type is list if not do ast

import ast
df['combined'] = df['combined'].apply(ast.literal_eval)
df['combined'].str[::2]

answered Jul 1, 2022 at 17:06

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Answer 1