HTML BIO
Nikhil Reddy Mothe
2025-01-27
Introduction
Hi, I’m Nikhil Reddy Mothe! I’m excited to share a little about myself.
Academic Background
I have a Bachelor’s in Business Administration and Management and a Master’s in Information Systems.
Professional Background
Currently, I’m working as a Software Developer Intern. Previously, I’ve worked as a Software Engineer Intern back in India for 11 months.
Experience with R
I have some basic knowledge of R and have worked with it for data manipulation, analysis, and creating simple visualizations, though I’m still building on my experience to tackle more advanced tasks.
Experience with Other Analytic Software
Beyond R, I’ve worked with tools like Python, Tableau, and Excel.
My Picture
Dataset Analysis
## INSTANCEID INCIDENT_NO DATE_REPORTED DATE_FROM
## Length:15155 Length:15155 Length:15155 Length:15155
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## DATE_TO CLSD UCR DST
## Length:15155 Length:15155 Min. : 100.0 Length:15155
## Class :character Class :character 1st Qu.: 600.0 Class :character
## Mode :character Mode :character Median : 600.0 Mode :character
## Mean : 872.9
## 3rd Qu.:1001.0
## Max. :2761.0
## NA's :10
## BEAT OFFENSE LOCATION THEFT_CODE
## Length:15155 Length:15155 Length:15155 Length:15155
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## FLOOR SIDE OPENING HATE_BIAS
## Length:15155 Length:15155 Length:15155 Length:15155
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## DAYOFWEEK RPT_AREA CPD_NEIGHBORHOOD WEAPONS
## Length:15155 Length:15155 Length:15155 Length:15155
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## DATE_OF_CLEARANCE HOUR_FROM HOUR_TO ADDRESS_X
## Length:15155 Min. : 0 Min. : 0.0 Length:15155
## Class :character 1st Qu.: 120 1st Qu.: 140.0 Class :character
## Mode :character Median : 230 Median : 811.5 Mode :character
## Mean : 780 Mean : 915.8
## 3rd Qu.:1535 3rd Qu.:1645.0
## Max. :2359 Max. :2359.0
## NA's :2 NA's :9
## LONGITUDE_X LATITUDE_X VICTIM_AGE VICTIM_RACE
## Min. :-84.82 Min. :39.07 Length:15155 Length:15155
## 1st Qu.:-84.57 1st Qu.:39.12 Class :character Class :character
## Median :-84.52 Median :39.14 Mode :character Mode :character
## Mean :-84.52 Mean :39.14
## 3rd Qu.:-84.49 3rd Qu.:39.16
## Max. :-84.26 Max. :39.27
## NA's :1714 NA's :1714
## VICTIM_ETHNICITY VICTIM_GENDER SUSPECT_AGE SUSPECT_RACE
## Length:15155 Length:15155 Length:15155 Length:15155
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## SUSPECT_ETHNICITY SUSPECT_GENDER TOTALNUMBERVICTIMS TOTALSUSPECTS
## Length:15155 Length:15155 Min. : 1.000 Min. : 1.000
## Class :character Class :character 1st Qu.: 1.000 1st Qu.: 1.000
## Mode :character Mode :character Median : 1.000 Median : 1.000
## Mean : 1.389 Mean : 1.609
## 3rd Qu.: 1.000 3rd Qu.: 2.000
## Max. :13.000 Max. :24.000
## NA's :33 NA's :7082
## UCR_GROUP ZIP COMMUNITY_COUNCIL_NEIGHBORHOOD
## Length:15155 Min. : 4523 Length:15155
## Class :character 1st Qu.:45206 Class :character
## Mode :character Median :45216 Mode :character
## Mean :45209
## 3rd Qu.:45227
## Max. :45248
## NA's :1
## SNA_NEIGHBORHOOD
## Length:15155
## Class :character
## Mode :character
##
##
##
## | INSTANCEID | INCIDENT_NO | DATE_REPORTED | DATE_FROM | DATE_TO | CLSD | UCR | DST | BEAT | OFFENSE | LOCATION | THEFT_CODE | FLOOR | SIDE | OPENING | HATE_BIAS | DAYOFWEEK | RPT_AREA | CPD_NEIGHBORHOOD | WEAPONS | DATE_OF_CLEARANCE | HOUR_FROM | HOUR_TO | ADDRESS_X | LONGITUDE_X | LATITUDE_X | VICTIM_AGE | VICTIM_RACE | VICTIM_ETHNICITY | VICTIM_GENDER | SUSPECT_AGE | SUSPECT_RACE | SUSPECT_ETHNICITY | SUSPECT_GENDER | TOTALNUMBERVICTIMS | TOTALSUSPECTS | UCR_GROUP | ZIP | COMMUNITY_COUNCIL_NEIGHBORHOOD | SNA_NEIGHBORHOOD |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 803 | 2 | 2 | MENACING | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 99 - NONE | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.43017 | 39.15166 | 18-25 | WHITE | NOT OF HISPANIC ORIG | MALE | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | |||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 803 | 2 | 2 | MENACING | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 99 - NONE | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.43140 | 39.15350 | UNKNOWN | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | ||||||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 803 | 2 | 2 | MENACING | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 99 - NONE | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.43091 | 39.15360 | 31-40 | WHITE | NOT OF HISPANIC ORIG | FEMALE | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | |||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 1493 | 2 | 2 | CRIMINAL DAMAGING/ENDANGERING | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 80 - OTHER WEAPON | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.42995 | 39.15224 | 18-25 | WHITE | NOT OF HISPANIC ORIG | MALE | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | |||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 1493 | 2 | 2 | CRIMINAL DAMAGING/ENDANGERING | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 80 - OTHER WEAPON | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.43008 | 39.15209 | UNKNOWN | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | ||||||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 1493 | 2 | 2 | CRIMINAL DAMAGING/ENDANGERING | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 80 - OTHER WEAPON | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.42980 | 39.15228 | 31-40 | WHITE | NOT OF HISPANIC ORIG | FEMALE | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | |||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 810 | 2 | 2 | ASSAULT | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 40 - PERSONAL WEAPONS (HANDS, FEET, TEETH, ETC.) | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.43070 | 39.15345 | UNKNOWN | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | ||||||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 810 | 2 | 2 | ASSAULT | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 40 - PERSONAL WEAPONS (HANDS, FEET, TEETH, ETC.) | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.43146 | 39.15272 | 31-40 | WHITE | NOT OF HISPANIC ORIG | FEMALE | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | |||||||
| 4B312B08-FE95-4DD4-8A62-20D1A1138E82 | 229000003 | 01/01/2022 12:09:00 AM | 12/31/2021 11:50:00 PM | 01/01/2022 12:08:00 AM | F–CLEARED BY ARREST - ADULT | 810 | 2 | 2 | ASSAULT | 26-BAR | N–NO BIAS/NOT APPLICABLE | FRIDAY | 124 | OAKLEY | 40 - PERSONAL WEAPONS (HANDS, FEET, TEETH, ETC.) | 01/01/2022 12:00:00 AM | 2350 | 8 | 30XX MADISON RD | -84.43082 | 39.15239 | 18-25 | WHITE | NOT OF HISPANIC ORIG | MALE | UNKNOWN | 3 | NA | PART 2 MINOR | 45209 | OAKLEY | OAKLEY | |||||||
| 2565E4A0-1C0B-4F80-AE4B-4654CE7EDC02 | 229000009 | 01/01/2022 12:17:00 AM | 01/01/2022 12:15:00 AM | 01/01/2022 12:17:00 AM | Z–EARLY CLOSED | 1521 | 3 | 2 | IMPROPERLY DISCHARGING FIREARM AT/INTO HABITATION/SCHOOL | 01-SINGLE FAMILY 2 STORY | N–NO BIAS/NOT APPLICABLE | SATURDAY | 262 | WEST PRICE HILL | 11 - FIREARM (TYPE NOT STATED) | 01/04/2022 12:00:00 AM | 15 | 17 | 49XX SHIRLEY PL | -84.60225 | 39.12635 | UNKNOWN | UNKNOWN | UNKNOWN | UNKNOWN | UNKNOWN | 1 | 1 | PART 2 MINOR | 45238 | WEST PRICE HILL | WEST PRICE HILL |
## [1] 15155 40## 'data.frame': 15155 obs. of 40 variables:
## $ INSTANCEID : chr "4B312B08-FE95-4DD4-8A62-20D1A1138E82" "4B312B08-FE95-4DD4-8A62-20D1A1138E82" "4B312B08-FE95-4DD4-8A62-20D1A1138E82" "4B312B08-FE95-4DD4-8A62-20D1A1138E82" ...
## $ INCIDENT_NO : chr "229000003" "229000003" "229000003" "229000003" ...
## $ DATE_REPORTED : chr "01/01/2022 12:09:00 AM" "01/01/2022 12:09:00 AM" "01/01/2022 12:09:00 AM" "01/01/2022 12:09:00 AM" ...
## $ DATE_FROM : chr "12/31/2021 11:50:00 PM" "12/31/2021 11:50:00 PM" "12/31/2021 11:50:00 PM" "12/31/2021 11:50:00 PM" ...
## $ DATE_TO : chr "01/01/2022 12:08:00 AM" "01/01/2022 12:08:00 AM" "01/01/2022 12:08:00 AM" "01/01/2022 12:08:00 AM" ...
## $ CLSD : chr "F--CLEARED BY ARREST - ADULT" "F--CLEARED BY ARREST - ADULT" "F--CLEARED BY ARREST - ADULT" "F--CLEARED BY ARREST - ADULT" ...
## $ UCR : int 803 803 803 1493 1493 1493 810 810 810 1521 ...
## $ DST : chr "2" "2" "2" "2" ...
## $ BEAT : chr "2" "2" "2" "2" ...
## $ OFFENSE : chr "MENACING" "MENACING" "MENACING" "CRIMINAL DAMAGING/ENDANGERING" ...
## $ LOCATION : chr "26-BAR" "26-BAR" "26-BAR" "26-BAR" ...
## $ THEFT_CODE : chr "" "" "" "" ...
## $ FLOOR : chr "" "" "" "" ...
## $ SIDE : chr "" "" "" "" ...
## $ OPENING : chr "" "" "" "" ...
## $ HATE_BIAS : chr "N--NO BIAS/NOT APPLICABLE" "N--NO BIAS/NOT APPLICABLE" "N--NO BIAS/NOT APPLICABLE" "N--NO BIAS/NOT APPLICABLE" ...
## $ DAYOFWEEK : chr "FRIDAY" "FRIDAY" "FRIDAY" "FRIDAY" ...
## $ RPT_AREA : chr "124" "124" "124" "124" ...
## $ CPD_NEIGHBORHOOD : chr "OAKLEY" "OAKLEY" "OAKLEY" "OAKLEY" ...
## $ WEAPONS : chr "99 - NONE" "99 - NONE" "99 - NONE" "80 - OTHER WEAPON" ...
## $ DATE_OF_CLEARANCE : chr "01/01/2022 12:00:00 AM" "01/01/2022 12:00:00 AM" "01/01/2022 12:00:00 AM" "01/01/2022 12:00:00 AM" ...
## $ HOUR_FROM : int 2350 2350 2350 2350 2350 2350 2350 2350 2350 15 ...
## $ HOUR_TO : int 8 8 8 8 8 8 8 8 8 17 ...
## $ ADDRESS_X : chr "30XX MADISON RD" "30XX MADISON RD" "30XX MADISON RD" "30XX MADISON RD" ...
## $ LONGITUDE_X : num -84.4 -84.4 -84.4 -84.4 -84.4 ...
## $ LATITUDE_X : num 39.2 39.2 39.2 39.2 39.2 ...
## $ VICTIM_AGE : chr "18-25" "UNKNOWN" "31-40" "18-25" ...
## $ VICTIM_RACE : chr "WHITE" "" "WHITE" "WHITE" ...
## $ VICTIM_ETHNICITY : chr "NOT OF HISPANIC ORIG" "" "NOT OF HISPANIC ORIG" "NOT OF HISPANIC ORIG" ...
## $ VICTIM_GENDER : chr "MALE" "" "FEMALE" "MALE" ...
## $ SUSPECT_AGE : chr "UNKNOWN" "UNKNOWN" "UNKNOWN" "UNKNOWN" ...
## $ SUSPECT_RACE : chr "" "" "" "" ...
## $ SUSPECT_ETHNICITY : chr "" "" "" "" ...
## $ SUSPECT_GENDER : chr "" "" "" "" ...
## $ TOTALNUMBERVICTIMS : int 3 3 3 3 3 3 3 3 3 1 ...
## $ TOTALSUSPECTS : int NA NA NA NA NA NA NA NA NA 1 ...
## $ UCR_GROUP : chr "PART 2 MINOR" "PART 2 MINOR" "PART 2 MINOR" "PART 2 MINOR" ...
## $ ZIP : int 45209 45209 45209 45209 45209 45209 45209 45209 45209 45238 ...
## $ COMMUNITY_COUNCIL_NEIGHBORHOOD: chr "OAKLEY" "OAKLEY" "OAKLEY" "OAKLEY" ...
## $ SNA_NEIGHBORHOOD : chr "OAKLEY" "OAKLEY" "OAKLEY" "OAKLEY" ...## INSTANCEID INCIDENT_NO
## 0 0
## DATE_REPORTED DATE_FROM
## 0 0
## DATE_TO CLSD
## 0 0
## UCR DST
## 10 0
## BEAT OFFENSE
## 0 0
## LOCATION THEFT_CODE
## 0 0
## FLOOR SIDE
## 0 0
## OPENING HATE_BIAS
## 0 0
## DAYOFWEEK RPT_AREA
## 0 0
## CPD_NEIGHBORHOOD WEAPONS
## 0 0
## DATE_OF_CLEARANCE HOUR_FROM
## 0 2
## HOUR_TO ADDRESS_X
## 9 0
## LONGITUDE_X LATITUDE_X
## 1714 1714
## VICTIM_AGE VICTIM_RACE
## 0 0
## VICTIM_ETHNICITY VICTIM_GENDER
## 0 0
## SUSPECT_AGE SUSPECT_RACE
## 0 0
## SUSPECT_ETHNICITY SUSPECT_GENDER
## 0 0
## TOTALNUMBERVICTIMS TOTALSUSPECTS
## 33 7082
## UCR_GROUP ZIP
## 0 1
## COMMUNITY_COUNCIL_NEIGHBORHOOD SNA_NEIGHBORHOOD
## 0 0## Warning: NAs introduced by coercion## [1] NA## Warning in safe_boxplot("VICTIM_AGE", crime_data): NAs introduced by coercion## No valid data to plot for VICTIM_AGE## No valid data to plot for SUSPECT_AGE