import pandas as pd

CES4 = pd.read_excel("calenviroscreen40resultsdatadictionary_F_2021.xlsx", sheet_name='CES4.0FINAL_results')

CES4

CES4.columns

CES4.shape

#How many missging values are there in each column?
CES4.isnull().sum()

# count the number of counties in the data
CES4['California County'].nunique()

# count the number of unique census tracts in the data
CES4['Census Tract'].nunique()

# count the number of ZIP codes in the data
CES4['ZIP'].nunique()

# count the number of cities in the data
CES4['Approximate Location'].nunique()

# how many censustracts are in each city
CES4['Approximate Location'].value_counts()