An Analysis of Boston Neighborhood Government Statistics in Open Refine and Tableau:

• Which Boston neighborhood has the most 311 cases in 2022?

• Dorchester - 39,209

• What is the most common subject in Dorchester, Greater Mattapan, South Boston/Waterfront, Downtown?

• Dorchester: Enforced and Abandoned Vehicles: 8,578

• Greater Mattapan: Sanitation: 2,296

• South Boston/Waterfront: Enforced and Abandoned Vehicles: 9,868

• Downtown: Enforced and abandoned vehicles: 4,128

• Open in Open Refine facet it by neighborhood and clean up the neighborhood to match those defined by Boston Planning and Development Agency.

  • I deleted all of the blank zip codes.

  • I split up the zip codes from neighborhoods not listed in the Boston Planning and Development Agency and added them to neighborhoods that were listed. 

  • Chestnut Hill - I added zip code 2132 to West Roxbury and zip code 2467 to Jamaica Plain.

  • Greater Mattapan - I added zip code 2121 to Roxbury, zip code 2124 to Dorchester, zip code 2126 to Mattapan and zip code 2130 to Jamaica Plain.

• Which month has the most and least cases (hint transform the open_data column then facet it by timeline)

  • Most cases - August:21, 695; Least Cases -  December:14,161

• Export the clean data set form open refined and import into tableau to make a bar chart in cases and create a map.