DC Pull-Over Analysis

Ruiqi Sun, shijin gai, xiaolin wu
Last updated on Aug 14, 2020 R, Shiny app

We are analyzing Stop Data Report from Metropolitan Police Department. We visualized the data and made it easy to understand for readers to absorb information. The data we use is Stop data from July 22 to December 29 (161 days, 23 weeks).

In our shiny app, one could find 5 tabs:

  • Explore Variable

    Readers could choose variables and see the relationship between the variable of select and the number of counts(being pulled over). In addition, we also provide two options for you. One could choose to view the total case of selected variable or could choose to view the daily cases.

  • Explore Time Duration

    Again, Readers could choose variables. Furthermore, we provided a box-plot to show the relationship between the selected variable and log_stop_duration_minutes. One could find out the distribution of each category of selected variables. Readers could also see the results of anova table (partialy), which shouw the test results about comparing the average duration time in different groups.

  • Pull-Over Map

    We provided a map of DC and used shadow to present how frequently polices will pull over drivers on average in seven Police District (defined by DC Metropolitan Police Department). The darker the color, polices will pull-over more frequently. Here, we provide two options: One could choose to view the map by weekday or by hourly.

  • Spreadsheet

    Here is the data set we found from https://mpdc.dc.gov/node/1464816. Readers could find specific row if you want to.

Reference

1, Alex, & jdharrison. (2014, April 27). Outputting multiple lines of text with renderText() in R shiny. Stack Overflow.

https://stackoverflow.com/questions/23233497/outputting-multiple-lines-of-text-with-rendertext-in-r-shiny.

2, leaflet for R – Choropleths.

https://rstudio.github.io/leaflet/choropleths.html.

3, Parker, E. COVID-19 tracker.

https://shiny.rstudio.com/gallery/covid19-tracker.html.

4, Soltoff, B. (2020, April 10). Drawing interactive maps with Leaflet.

https://cfss.uchicago.edu/notes/leaflet/.

5, warship, & DeanAttali. (2017, February 5). Create URL hyperlink in R Shiny? Stack Overflow.

https://stackoverflow.com/questions/42047422/create-url-hyperlink-in-r-shiny.

Data Sources:

1, Police Districts. (2019, June 25).

https://opendata.dc.gov/datasets/d2a63e5246ff41bdaca8ea9be95c8a4b_9/data.

2, Stop Data Report: 2020. Stop Data Report: 2020. (2020, March 4).

https://mpdc.dc.gov/node/1464816.

Data Visualization Statistics
Ruiqi Sun
Ruiqi Sun

My research interests include data science and artificial intelligence.

Related