Visualizing Data with R

Languages: R, SQL (SQLite)

Purpose of the project: To store, clean, and visualize a https://www.data.gov/ CSV file using R and SQLite.

The CSV file used for this project was downloaded from: Index_Crimes_by_County_and_Agency__Beginning_1990.csv.

The file includes data on various types of New York State crimes committed from 1990 through 2016.

Note: I deleted 393 rows with empty data/0 months reported after importing the CSV to a SQLite database.

Project information:

• Imported CSV file into a SQLite database using DB Browser
• Used/Installed RSQLite and ggplot2 packages for R
• Used R 3.4.2 and R Studio to connect to database and visualize data/queries

Queries visualized include:

• 2015 NYS Violent Crimes by County - Scatter Plot
• 1990-2016 Nassau County Violent Crimes - Bar Chart
• 1990-2016 SUNY Robberies - Bar Chart
• 1990-2016 Saratoga County Larcenies - Line Graph
• 1990-2016 New York State Murders by County - Scatter Plot

All of these graphs and their corresponsing R scripts, as well as the CSV file and SQLite database, are available in this repository.