import numpy as np
import pandas as pd
vstable = pd.read_csv("http://facweb.cs.depaul.edu/mobasher/classes/csc478/data/Video_Store_3.csv", index_col=0, na_values=["?"])
vstable.shape
vstable.head(10)
vstable.info()
vstable.describe(include="all")
vstable.isnull()[0:10]
vstable[vstable.isnull().any(axis=1)]
vstable[vstable.Gender.isnull()]
vstable[vstable.Age.isnull()]
age_mean = vstable.Age.mean()
vstable.Age.fillna(age_mean, axis=0, inplace=True)
vstable.head(10)
vstable.drop(vstable[vstable.Gender.isnull()].index, axis=0).head(10)
vstable.head(10)
vstable.drop(vstable[vstable.Gender.isnull()].index, axis=0, inplace=True)
vstable.head(10)
vstable2 = pd.read_csv("http://facweb.cs.depaul.edu/mobasher/classes/csc478/data/Video_Store_3.csv", index_col=0, na_values=["?"])
vstable2.head(10)
vstable2.dropna(axis=0, inplace=True)
vstable2.shape
vstable2.head(10)