index.Rmd

---
title: "Stay safe at Columbia University"
output: html_document
---

<style type="text/css">

h1.title {
  font-size: 45px;
  color: DarkBlue;
  text-align: center;
  font-weight:700;
}
</style>

<center>

**by Haochen Sun, Yuanhao Zhang, Zhenyu Zhou, Yuze Yuan, Anzhuo Xie**

<img src="images/columbia.jpg" style="width:100%">

<br/>

# Demonstration Video
<iframe width="560" height="315" src="https://www.youtube.com/embed/wG9TcMH0ZV4" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

<br/>

# Motivation and intention

<div align="left"> 
Studying at Columbia University, except enjoying fascinating school life, we should always be concerned about the safety problem. Frequent email alerts, Citizen apps popping up, and terrifying news, they are all reminding us that there are many underlying unsafe factors around us. The New York government has made a public crime map at https://maps.nyc.gov/crime/.
The information in it, however, is way too redundant for a student as we are more concerned about the safety conditions around our campus and our places of residence. Luckily, NYPD has posted the up-to-date dataset that includes all valid felony, misdemeanor, and violation crimes reported to the New York City Police Department, and it includes more information that we are interested in, for example, the time of occurrence of the complaint, the victim’s statistics. After analyzing the dataset, we can have a more comprehensive understanding about the crimes around us. Finally, we want to draw a fine map locating the crime incidents around our campus, informing us what time may be more dangerous and we can avoid activities at that time. We also want this result to help all the staff and students in Columbia University have an opportunity to evaluate the risk, avoid the danger, and allow them to access crime rates in the areas they care about to keep themselves safe.

<br/>
</div>

# Anticipated data sources

<div align="left"> 
The more current data is from NYC Opendata,  https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Current-Year-To-Date-/5uac-w243, including approximately 400,000 crime recordes of 2021-2022, and is recently updated. The historical data set is from https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i, which includes more data (approximately 8,000,000 recordes) but is not sufficient in data of 2022. We combined these two datasets and the final output dataset have around 8 million records. Therefore, this dataset is expected to be accurate, authoritative, prompt and worth analyzing.

<br/>
</div>

# Nevigation
<div align="left"> 

* [Project Report](code/report.html)

* [Exploratory Analyses](code/EDA.html)

* [Statistical Analysis](code/Hypothesis-testing-and-linear-model.html)

* [Map for CU Safety](https://samuelsun.shinyapps.io/cu_shinymap/) 

<br/>
</div>

# Group Members
<div align="left"> 
* Haochen Sun ( hs3393 )

* Yuanhao Zhang ( yz4436 )

* Zhenyu Zhou ( zz2900 )

* Yuze Yuan ( yy3296 )

* Anzhuo Xie ( ax2173 )
</div>