Functions
df.colName.function()
# function varients listed below
Drop
.dropna(inplace = True) - drops rows with missing values
.dropna(axis = 1) - drops columns with missing values
Count
.value_counts() - counts number of True and False Values
NULL
.fillna(value, inplace = True) - replaces NULL values with value
.isna() - checks for NaN, returns True and False DataFrame
.isnull() - checks for NULL, returns True and False DataFrame
Manual check for NULL
missing_values = ["n.a.","?","NA","n/a", "na", "--"]
df = pd.read_csv(url, na_values = missing_values)