how can I call multiple columns from my data frame in pandas

Question

I'm trying to get the top 10 longest songs in my data frame by calling two columns using the code df.loc[['duration_min','name']].head(). I have already sorted the relevant columns by descending order but when I run the code, I keep getting this error:

KeyError: "None of [Index(['duration_min', 'name'], dtype='object')] are in the [index]"

I was expecting the code to run without any problems

Use: `df[['duration_min','name']].head(10)`, `loc` with 1 parameter is for indices — mozway, Dec 21 '22 at 18:47
You need to use: `df.loc[:, ['duration_min', 'name']]`, if you don't supply ':', `loc` thinks it is an index and tries to find it in the index. — SomeDude, Dec 21 '22 at 18:47

VegTo91 · Answer 1 · 2022-12-21T18:50:20.853

0

Error shows that there are no indices called 'duration_min' and 'name'. You should use:

df[['duration_min', 'name']].head(x)

with x, an integer.

edited Dec 21 '22 at 18:50

answered Dec 21 '22 at 18:49

VegTo91

3
3

how can I call multiple columns from my data frame in pandas

1 Answers1