Import a CoreLogic pipe delimited file and check for num of missing values in single col

corelogic_nulls.py

import pandas as pd

# Read in delimited file, setting delimiter, and keeping only single col of interest
df = pd.read_table("StanfordUniversity_TAX_201906_IL.txt", delimiter="|", usecols=["YEAR BUILT"])

# Check unique values
df["YEAR BUILT"].unique()

# Count the number of null/NaN values
df["YEAR BUILT"].isnull().sum()