A Retrospective- Data Study on Rats in NYC
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.
32 million dollars.
Take a while, let that data sink in.
Three months ago, mayor de Blasio presented a $32 million dollar plan to “Ice” some rats. He said that this city wants more rat corpses.1
Are rats that big a deal? Can the government even curb the problem if they are?
I looked at governmental rat-reduction initiatives over the last 7 years, analyzed the effect of the three of these initiatives, and then took a look at what drives rat sightings.
The short of it is that:
- There seems to be little to no impact on rat sightings from governmental intervention
- The data the government likely uses for their success metrics may be in need of some better controls
- The recent trend in rat sightings may have little to do with the actual rat population.
Three initiatives, mixed data results
- In 2010 the city cut their budget for pest control by 1.5 million dollars.2 The the average time to “close out” a rat sighting is the highest during this period; however, this has no observable impact on the trend of rat sightings.
- In 2013, plans to mass sterilize female rats were announced.3 While this may have had some level of success (I don’t know how widely the tests were being conducted) in 2014 we see a sizable increase in the reports of rat sightings. This trend continues all the way through the start of 2017.
- In 2014, 9 new inspectors and 600 thousand dollars used to target major infestations in bronx and manhattan with the goal of returning the average closing time to below 10 days.4 While the average closing time does decrease, the total reported sightings increase substantially.
So why don’t I like the average closing time metric?
My problem with this metric is that it doesn’t look like it has any actual impact on the rat sightings (see above) and that if it uses the same data that I worked with, it likely isn’t automatically updated in the system, and thus is prone to input error. While cleaning up the data, I found approximately 10% of the over 102k sightings were missing a closing date, and that approximately 16.6% had closing dates that preceded their created date. While I did filter that data out and use median for my average to filter out any input error that would create outliers, i’m still not sure that i’d put much confidence in it.
What drives rat sightings?
I originally decided on a map format to display all the rat sightings by whatever selected time period so we could see if there’s any major shifts in rats due to relocation or migration- unfortunately we did not see much of a shift in that way- however that does corroborate one of the documents I came across later which suggests that rats rarely travel more than 600 feet from their birthplace.13
The seasonal portion of rat sightings seems to have a pretty strong correlation with temperature.5
Precipitation?6 not so much. in 2010 to 2012 we see that the data all falls basically along the same line. The line shifts a little in 2013. In 2014 that line shifts up. The line shifts again in 2015, 2016, and 2017. When we change the data into a time series then decompose it (or rather, break the time series down into its seasonal change, its trend, and the ‘white noise’ remainder) we can see that the trend shifts substantially at the end of 2013/start of 2014
What changes the data trend?
Honestly, I don’t know. I looked into trash strikes, income shifts (thinking more disposable income could lead to more garbage), but nothing I could find could have led to such a surge in rat population. However, I’m not measuring rat population- just reported rat sightings. Something may have shifted the way New Yorkers think of rats in late 2013/early 2014.
So what happened in 2014?
- A study found that New York rats carry Salmonella, E. coli, Seoul hantavirus, Leptospira, etc. -at least 18 viruses that are known to cause disease in humans7
- Jonathan Auerback used a statistical model to argue that the rat population in NYC was closer to 2 million than 8 million8
- YouTube videos of rats in NYC went viral9-11
- Rent strike demanding rat problem taken care of- their slogan? “No rent for rats!”12
Whether or not the rat population is actually increasing, the increased reports of rats indicate that New Yorkers perceive this as a growing problem. While prior attempts to curb the rat problem have been largely unsuccessful, there is the chance that this time it might work. But probably not.14
- As Rats Escape Death, MTA Turns to Sterilization - The New York Times
- ”Rodents winning New York rat race, but humans fight back"
- Avg temperature data source- Average Monthly & Annual Temperatures at Central Park
- Avg precipitation data source - Monthly & Annual Precipitation at Central Park
- Does New York City really have as many rats as ... - Wiley Online Library
- "Rats scurry through food at Dunkin' Donuts in Manhattan (VIDEO)"
- Upper West Siders rat-chet up protest - NY Daily News
- Source for reported rat sightings- https://www.kaggle.com/new-york-city/nyc-rat-sightings
- Link to my Shiny App: https://bdbrunson.shinyapps.io/myshineyapp/
- Link to my Github Code for the app: https://github.com/Bdbrunson/NYRats