How can I make list in a pandas dataframe by using jupyter notebook

Question

This is Korean basketball player's stats in 2011.

I need the list of players who have more than 55% of 2-point shot percentage. So I made a code like this and it doesn't work

it gives me this error

ValueError from pandas\core\generic.py in nonzero(self)

The truth value of a Series is ambiguous. Usse a.empty(), a.bool(), a.item(), a.any() or a.all().

Please avoid screenshots, copy paste few data in order to create a [mcve] — jlandercy, Dec 22 '18 at 07:16
FYI, Jupyter notebook has no effect on the possible solutions here. — pstatix, Dec 22 '18 at 07:17
You've successfully loaded the `csv`. Now you have a `pandas` Dataframe. So it's no longer a `csv` topic - your title should reflect that. — hpaulj, Dec 22 '18 at 07:18

score 2 · Accepted Answer · answered Dec 22 '18 at 07:35

2

Just create a new DataFrame using df.loc:

import pandas as pd
df = pd.read_excel('filepath')
df = df.loc[df['Average 2-point %'] > 55]]

answered Dec 22 '18 at 07:35

pstatix

3,611
4
18
40

How can I make list in a pandas dataframe by using jupyter notebook

1 Answers1