GitXplorerGitXplorer
t

DMV_Capstone

public
0 stars
2 forks
0 issues

Commits

List of commits on branch master.
Unverified
2d90c54be7f4ced884462ee9a11d7da91f8c4a0c

fixed some of the locatoin code

ttylerhutcherson committed 8 years ago
Unverified
e6edc534efd8504f4c9680a0acf01c58834002fd

update for presentation - work to be done

ttylerhutcherson committed 8 years ago
Unverified
ac95d5d4a4b392ff87df51bdb00aa238c0e2c97f

fixed typo

ttylerhutcherson committed 8 years ago
Unverified
a14adefe8ca77d489f1c2c7795c625171188374b

added .Rdata

ttylerhutcherson committed 8 years ago
Unverified
6de1852c3ace9bad4efd460c8e45c22f36c89429

property damage scatter plot and crash count, more work needed

ttylerhutcherson committed 8 years ago
Unverified
e9bbedd87d72920a60d474cc3eef2adaf4de7466

2014 crash location plots

qqtang1993 committed 8 years ago

README

The README file for this repository.

DMV_Capstone

Collaborative work for 2016-2017 UVA DSI Capstone Project.

  • DataCleaning.R: Merge data with same attributes but in different years into a single data frame. Variable name and type checking have been done before merging raw text files. Nine data frames will be created including:

    1. crash location
    2. vehicle
    3. driver
    4. passenger
    5. pedestrain
    6. license
    7. property damage
    8. vehicle commercial
    9. uva-vt
  • merge_fatal&injury_only.R Merge all the text files into a single data frame. Here the data contains only fatal and injury crashes caused by unrestraint fatalities, which is a subset of the old data. Data created will be used to analyze any correlation between unrestraint fatalities and serious car crashes.

  • mergeOldData.R
    Merge all the nine data frames (from DataCleaning.R) together into a huge data frame. Any observations that are mistyped will be removed. After this, we will obtain the cleaned data for analysis.

  • plots.R Created different plots to help us understand the problems. There are two types of plots:

    1. plot of number of car crashes by month for each year from 2010 to 2015 (different plots for fatal, injury and property damage crashes)
    2. plot of car crash by location for each year from 2010 to 2015 (different plots for fatal, injury and property damage crashes)