Get item of list in dataframe column using loop

Question

I have dataframe df like this :

    date        item
    2019-03-29  [book,pencil]
    ...

I want to get every item in list using loop. this is what I've tried:

    for i in range(len(df)):
        for x in df['attributeName'][i]:
            print(x)

But i got every single character. The desired output is:

    book
    pencil

How do I solve this problem?

@YashKumarAtri No, don't try df.iterrows(). There's bad advice flying from every direction. — cs95
– cs95, Commented Jul 1, 2019 at 5:27

iamklaus · Accepted Answer · 2019-07-01 05:17:01Z

3

df2['item'].apply(pd.Series).unstack().reset_index(drop=True)

pd.DataFrame(df2['item'].tolist()).unstack().reset_index(drop=True)

Output

0      book
1    pencil
dtype: object

answered Jul 1, 2019 at 4:57

iamklaus

3,7682 gold badges14 silver badges21 bronze badges

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

1 Comment

Don't use apply(pd.Series) (you'll need to scroll to find it). pd.DataFrame(df['col'].tolist()) is always better.