SeattleHousingwithPets

Exploratory Data Analysis of Seattle Pet License data set combined with US Census Housing Survey.

Purpose: Try to determine if there is any correlation between dog ownership and housing data.

Use the API for the Seattle pet licence open data to get the breed and ZIP code location:

https://data.seattle.gov/Community/Seattle-Pet-Licenses/jguv-t9rb

Standard AKC breed names and characteristics can be found in this data set:

https://www.kaggle.com/datasets/paultimothymooney/best-in-show-data-about-dogs?resource=download

It had to be augmented with data from AKC.

Census data can be found at:

https://data.census.gov/cedsci/table?t=Housing%3AHousing%20Units%3AOccupancy%20Characteristics%3AOwner%2FRenter%20%28Householder%29%20Characteristics%3AOwner%2FRenter%20%28Tenure%29&g=860XX00US98101,98102,98103,98104,98105,98106,98107,98108,98109,98110,98112,98115,98116,98117,98118,98119,98121,98122,98125,98126,98133,98134,98136,98144,98146,98177,98178,98199&y=2020

Conclusion

Dog ownership percentage in ZIP codes is highly correlated with owner occupancy percentage. Moderatly correlated with ZIP codes that have 3 bedrooms and Median rent amounts in the ZIP codes.

Moderatly negatively correlated with areas that have no bedrooms or 1 bedroom.

Interestingly, not much of a correlation with owner occupied property value.