Public
Edited
Jul 16, 2023
licenseData = FileAttachment("NYC_Dog_Licensing_Dataset.csv").csv()
biteData = FileAttachment("DOHMH_Dog_Bite_Data.csv").csv()
akcBreedInfo = FileAttachment("AKC Breed Info.csv").csv()
licenseData.map(d=> {
d['Breed'] = d.BreedName
})
akcBreedInfo[18].weight_low_lbs= 85
akcBreedInfo[18].weight_high_lbs = 85
akcBreedInfo[111].weight_low_lbs = 8
akcBreedInfo[111].weight_high_lbs = 15
akcBreedInfo.map(function (d) {
d.Average = (parseInt(d.weight_low_lbs) + parseInt(d.weight_high_lbs))/2
if(d.Average >= 75){
d.Category = "Giant"
giant.push(d.Breed)
}
else if (d.Average < 75 && d.Average >= 55){
d.Category = "Large"
large.push(d.Breed)
}
else if (d.Average < 55 && d.Average >= 35){
d.Category = "Medium"
medium.push(d.Breed)
}
else if (d.Average < 35 && d.Average >= 7){
d.Category = "Small"
small.push(d.Breed)
}
else if (d.Average < 7) {
d.Category = "Toy"
toy.push(d.Breed)
}
return d
})
cleanData = data => {
data.map(function (d) {
if (d.Breed.toLowerCase().endsWith(" x")){
d.Breed = d.Breed.slice(0, -2)}
else if (d.Breed.toLowerCase().endsWith("crossbreed")){
d.Breed = d.Breed.slice(0, -11)}
else if (d.Breed.toLowerCase().endsWith("cross")){
d.Breed = d.Breed.slice(0, -6)}
else if (d.Breed.toLowerCase().endsWith("mix")){
d.Breed = d.Breed.slice(0, -4)}
else if (d.Breed.toLowerCase() === "german shepherd" || d.Breed.toLowerCase() === "shepherd" || d.Breed.toLowerCase() === "sheperd"||
d.Breed.toLowerCase() === "shepard"){
d.Breed = "German Shepherd Dog"}
else if (d.Breed.toLowerCase() === "labrador" || d.Breed.toLowerCase() === "lab" ){
d.Breed = "Labrador Retriever"}
else if (d.Breed.toLowerCase() === "west high white terrier"){
d.Breed = "West Highland White Terrier"}
else if (d.Breed.toLowerCase() === "terrier" || d.Breed.toLowerCase() === "mixed terrier"){
d.Breed = "Terrier, Misc"}
else if (d.Breed.toLowerCase() === "husky"){
d.Breed = "Siberian Husky"}
else if (d.Breed.toLowerCase() === "wheaton terrier" || d.Breed.toLowerCase() === "soft coated wheaten terrier"){
d.Breed = "Soft-Coated Wheaten Terrier"}
else if (d.Breed.toLowerCase() === "corgi" || d.Breed.toLowerCase() ==="welsh corgi, pembroke"){
d.Breed = "Pembroke Welsh Corgi"}
else if (d.Breed.toLowerCase() === "collie"){
d.Breed = "Collie (Rough) & (Smooth)"}
else if (d.Breed.toLowerCase() === "collie, border"){
d.Breed = "Border Collie"}
else if (d.Breed.toLowerCase() === "schnauzer, standard" || d.Breed.toLowerCase() === "schnauzer" ){
d.Breed = "Standard Schnauzer"}
else if (d.Breed.toLowerCase() === "australian cattle" || d.Breed.toLowerCase() === "australian cattledog" ){
d.Breed = "Australian Cattle Dog"}
else if (d.Breed.toLowerCase() === "american pit bull mix / pit bull mix" || d.Breed.toLowerCase() === "american pit bull mix / pit bull" ||
d.Breed.toLowerCase() === "pit bull" || d.Breed.toLowerCase() === "american pit bull terrier/pit bull"){
d.Breed = "Pitbull"}
else if (d.Breed.toLowerCase() === "bulldog"){
d.Breed = "Bull Dog"}
else if (d.Breed.toLowerCase() === "miniature schnauzer"){
d.Breed = "Schnauzer, Miniature"}
else if (d.Breed.toLowerCase() === "bassett hound"){
d.Breed = "Basset Hound"}
else if (d.Breed.toLowerCase() === "shetland sheepdog"){
d.Breed = "Shetland Sheepdog (Sheltie)"}
else if (d.Breed.toLowerCase() === "plott"){
d.Breed = "Plott Hound"}
else if(d.Breed.toLowerCase() === "st. bernard"){
d.Breed = "Saint Bernard"}
else if(d.Breed.toLowerCase() === "chinese shar-pei") {
d.Breed = "Shar-Pei, Chinese"}
else if (d.Breed.toLowerCase() === "cotton de tulear"){
d.Breed = "Coton De Tulear"}
else if (d.Breed.toLowerCase() === "welsh corgi, cardigan"){
d.Breed = "Cardigan Welsh Corgi"}
else if (d.Breed.toLowerCase() === "collie, bearded"){
d.Breed = "Bearded Collie"}
else if (d.Breed.toLowerCase() === "collie, smooth coat" || d.Breed.toLowerCase() === "collie, rough coat"){
d.Breed = "Collie (Rough) & (Smooth)"}
else if (d.Breed.toLowerCase() === "flat-coated retriever") {
d.Breed = "Flat Coated Retriever"}
else if (d.Breed.toLowerCase() === "schnauzer, giant"){
d.Breed = "Giant Schnauzer"}
else if (d.Breed.toLowerCase() === "manchester terrier"){
d.Breed = "Manchester Terrier (Standard)"}
else if (d.Breed.toLowerCase() === "pharoh hound"){
d.Breed = "Pharaoh Hound"}
else if (d.Breed.toLowerCase() === "jack russ" || d.Breed.toLowerCase() === "jack russell" || d.Breed.toLowerCase() === "russell terrier" ){d.Breed = "Jack Russell Terrier"}
else if (d.Breed.toLowerCase().startsWith("pit") || d.Breed.toLowerCase().includes("Pit Bull")) {
d.Breed = "Pitbull"}
if (large.includes(d.Breed)){
d.Category = "Large"
return d
}
else if (medium.includes(d.Breed)){
d.Category = "Medium"
return d
}
else if (small.includes(d.Breed)){
d.Category = "Small"
return d
}
else if (toy.includes(d.Breed)){
d.Category = "Toy"
return d
}
else if (giant.includes(d.Breed)){
d.Category = "Giant"
return d
}
else {
d.Category = "Unknown"
return d
}
})
return data}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
