Get value as list in pandas

Question

My dataframe has one colum of type list, it looks something like this:

Genre                                              Band
['deep pop r&b', 'indie r&b', 'r&b', 'trap soul'], Elijah Blake

I'm iterating the dataframe using iterrows(), but when I get the column value it is a string, how can I can load as a list?

for i, row in df.iterrows():
    artist_genres = row['Genres']  #this is a string
    print(artist_genres)   
    for artist_genre in artist_genres:
        print(artist_genre)        #this prints each character, I want to iterate each genre

artist_genres should be a list, how did you get it as a string? — ipramusinto
– ipramusinto, Commented Nov 4, 2018 at 5:37
@pygo tolist() returns a list of each character ['[', '\'', 'd', ...] — Hohenheimsenberg
– Hohenheimsenberg, Commented Nov 4, 2018 at 5:41
@bakka row['Genres'] returns a string, even if I saved a list in that dataframe — Hohenheimsenberg
– Hohenheimsenberg, Commented Nov 4, 2018 at 5:42

Space Impact · Accepted Answer · 2018-11-08 06:54:39Z

4

Use ast.literal_eval:

import ast
df['Genre'] = df['Genre'].apply(ast.literal_eval)

edited Nov 8, 2018 at 6:54

answered Nov 4, 2018 at 5:25

Space Impact

13.3k26 silver badges51 bronze badges

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

Comments

Vishnudev Krishnadas · Accepted Answer · 2018-11-04 05:26:27Z

2

Use eval to convert a string that is actually a list to list

artist_genres = eval(row['Genres'])

answered Nov 4, 2018 at 5:26

Vishnudev Krishnadas

11k2 gold badges29 silver badges58 bronze badges

Collectives™ on Stack Overflow

Get value as list in pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related