# SD212 Lab 01

## [name] Type your name on the next line


## [Q1]
> How many total rows are in this dataset (not counting the header row)?



## [Q2]
> Which district (not counting the odd `SD5` district) had the
> *fewest* number of car thefts?

> (Do not include car jackings, just regular thefts.)



## [Q3]
> There is only one neighborhood which had over 100 homicides.
> What is this neighborhood called?



## [Q4]
> Which *district* is that neighborhood in?



## [Q5]
> There is a column for gender. Do you think this is the gender of the
> victim or the assailant? Explain how you figured this out.
> (Hint: Use the data! Some types of crimes disproportionately impact
> one gender or another.)



## [Q6]
> What is the **year** (only) of the first date in `crimes.csv` that
> pandas could not convert to a datetime object?



## [Q7]
> How many crimes were committed in 2015?



## [Q8]
> How many crimes were committed between March 14 and December 14,
> 2020 (including both those dates)?



## [Q9]
> How many *robberies* occurred on Fridays which were the 13th day of
> the month?



## [Q10]
> Which hour of the day had the most "common assaults" occur?



## [Q11]
> Which year in the plotted range had the highest number of thefts?
> (The fancy term for theft is "larceny".)



## [Q12]
> Considering the years most affected by the COVID pandemic, what
> kind(s) of crime decreased during those years, and what kind(s) did
> not?
> Give a brief explanation of why that might be the case.



## [Q13]
> Give the website where you got your NFL data from.



## [Q14]
> How many home games did the Ravens play in the *calendar year* 2013?



## [Q15]
> How many total points did the Ravens score at home on Mondays between
> January 1, 2012 and December 31, 2022?



## [Q16]
> Based on your data, what kinds of crimes (if any) significantly increased or decreased
> during Ravens home games compared to all other days of the year?



## [Q17]
> Do the crime rates during Ravens games look more or less significant
> compared to the "random fall Sundays" group or the "random day of
> the year" group? What is your final conclusion on the effect of
> Ravens games (if any) on crime in the city of Baltimore?