NA values on Dataframe

Asked Jul 12 '18 at 10:43

Active Jul 12 '18 at 11:14

Viewed 153 times

so I'm working with python and data frames. I have a list of movies from which I create a subset and I'm trying to plot or just figure out the mean for that matter but there is a lot of missing information and the frame just has an "NA" instead of data.

I use np library to ignore does values but I still get an error saying the type of input is not supported by isfinite

    data = pd.read_csv("C:\\Users\Bubbles\Documents\CS241\week 13\movies.csv")
Action = data[(data.Action == 1)]
Action = Action[np.isfinite(Action.budget)]

print(Action.budget.mean())

the budget list would just contain "NA" and integers as possible values

edited Jul 12 '18 at 11:14

asked Jul 12 '18 at 10:43

SkylarR95

What return `Action.budget.isnull()` ? There are `True` for missing values? – jezrael Jul 12 '18 at 11:15
it returns false for the whole list – SkylarR95 Jul 12 '18 at 11:20

NA values on Dataframe

0 Answers0