data mining customer-related subway incidents.pptVIP

Findings: Robberies (Simple Theft) Findings: Robberies (Simple Theft) David Budet Mariel Castro Jason Jaworski Yevgeny Khait Florangel Marte Client: Richard Washington, NYC Transit Authority  Data Mining Customer Employee-RelatedSubway Incidents: Phase II Presentation Summary Project Description Review Progression City Crime vs. Subway Crime Results: Customer Assaults Results: Employee Assaults Results: Robberies (Simple Theft) Results: Train Delays Weka ID3 Decision Trees Future Research Avenues Project Description Phase I concentrated on looking at incidents and identifying reasons for aggression, specifically what effects delays had on aggression incidents Phase II is more specifically concentrated on subway assaults and possible correlations with the data’s attributes Main focus of both phases: analysis of a dataset of incidents which occurred in the New York City Subway system over multiple years and mining of the data to establish relationships and trends Review Violent assaults against customers and employees Delays Simple thefts (unarmed robberies, pick-pocketing, etc.) The first half of the study focused on mining data with Microsoft SQL Server 2008 and the program Weka. Utilizing these tools and team methodologies, we determined which stations and train lines had the most: Progression Acquired US Census data regarding crime and population in NYC Normalized the Census crime data and subway crime data by population for Manhattan, Brooklyn, Queens and the Bronx? Analyzed Subway crime as a microcosm of overall NYC crime for 2007 Created an interactive Javascript map pinpointing stations with most violent incidents and delays The second half of the study had a more regional focus. The team: City Crime vs. Subway Crime We found that Manhattan, though the third largest borough in terms of population, accounted for over half the crime in NYC The Bronx has the smallest population, but in terms of crime per resident, had the second highest rate