does time of da y affect arrest rate
play

Does time of da y affect arrest rate ? AN ALYZIN G P OL IC E AC - PowerPoint PPT Presentation

Jan 03, 2023 •40 likes •350 views

Does time of da y affect arrest rate ? AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS Ke v in Markham Fo u nder , Data School Anal yz ing datetime data apple price volume date_and_time 0 174.35 20567800 2018-01-08 16:00:00 1

  1. Does time of da y affect arrest rate ? AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS Ke v in Markham Fo u nder , Data School

  2. Anal yz ing datetime data apple price volume date_and_time 0 174.35 20567800 2018-01-08 16:00:00 1 174.33 21584000 2018-01-09 16:00:00 2 155.15 54390500 2018-02-08 16:00:00 3 156.41 70672600 2018-02-09 16:00:00 4 176.94 23774100 2018-03-08 16:00:00 5 179.98 32185200 2018-03-09 16:00:00 ANALYZING POLICE ACTIVITY WITH PANDAS

  3. Accessing datetime attrib u tes (1) apple.dtypes price float64 volume int64 date_and_time datetime64[ns] apple.date_and_time.dt.month 0 1 1 1 2 2 3 2 ... ANALYZING POLICE ACTIVITY WITH PANDAS

  4. Accessing datetime attrib u tes (2) apple.set_index('date_and_time', inplace=True) apple.index DatetimeIndex(['2018-01-08 16:00:00', '2018-01-09 16:00:00', '2018-02-08 16:00:00', '2018-02-09 16:00:00', '2018-03-08 16:00:00', '2018-03-09 16:00:00'], dtype='datetime64[ns]', name='date_and_time', freq=Non apple.index.month Int64Index([1, 1, 2, 2, 3, 3], dtype='int64', name='date_and_time') dt accessor is not u sed w ith a DatetimeInde x ANALYZING POLICE ACTIVITY WITH PANDAS

  5. Calc u lating the monthl y mean price apple.price.mean() 169.52666666666667 apple.groupby(apple.index.month).price.mean() date_and_time 1 174.34 2 155.78 3 178.46 Name: price, dtype: float64 monthly_price = apple.groupby(apple.index.month).price.mean() ANALYZING POLICE ACTIVITY WITH PANDAS

  6. Plotting the monthl y mean price import matplotlib.pyplot as plt monthly_price.plot() Line plot : Series inde x on x- a x is , Series v al u es on y- a x is plt.xlabel('Month') plt.ylabel('Price') plt.title('Monthly mean stock price for Apple') plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  7. ANALYZING POLICE ACTIVITY WITH PANDAS

  8. Let ' s practice ! AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS

  9. Are dr u g - related stops on the rise ? AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS Ke v in Markham Fo u nder , Data School

  10. Resampling the price apple.groupby(apple.index.month).price.mean() date_and_time 1 174.34 2 155.78 3 178.46 apple.price.resample('M').mean() date_and_time 2018-01-31 174.34 2018-02-28 155.78 2018-03-31 178.46 ANALYZING POLICE ACTIVITY WITH PANDAS

  11. Resampling the v ol u me apple date_and_time price volume 2018-01-08 16:00:00 174.35 20567800 2018-01-09 16:00:00 174.33 21584000 2018-02-08 16:00:00 155.15 54390500 ... ... ... apple.volume.resample('M').mean() date_and_time 2018-01-31 21075900 2018-02-28 62531550 2018-03-31 27979650 ANALYZING POLICE ACTIVITY WITH PANDAS

  12. Concatenating price and v ol u me monthly_price = apple.price.resample('M').mean() monthly_volume = apple.volume.resample('M').mean() pd.concat([monthly_price, monthly_volume], axis='columns') date_and_time price volume 2018-01-31 174.34 21075900 2018-02-28 155.78 62531550 2018-03-31 178.46 27979650 monthly = pd.concat([monthly_price, monthly_volume], axis='columns') ANALYZING POLICE ACTIVITY WITH PANDAS

  13. Plotting price and v ol u me (1) monthly.plot() plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  14. Plotting price and v ol u me (2) monthly.plot(subplots=True) plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  15. Let ' s practice ! AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS

  16. What v iolations are ca u ght in each district ? AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS Ke v in Markham Fo u nder , Data School

  17. Comp u ting a freq u enc y table pd.crosstab(ri.driver_race, ri[(ri.driver_race == 'Asian') & ri.driver_gender) (ri.driver_gender == 'F') ].shape driver_gender F M driver_race (551, 14) Asian 551 1838 Black 2681 9604 driver_race is along the Hispanic 1953 7774 inde x, driver_gender is Other 53 212 White 18536 43334 along the col u mns table = pd.crosstab( ri.driver_race, Freq u enc y table : Tall y of ri.driver_gender) ho w man y times each combination of v al u es occ u rs ANALYZING POLICE ACTIVITY WITH PANDAS

  18. Selecting a DataFrame slice .loc[] accessor : Select table.loc['Asian':'Hispanic'] from a DataFrame b y label driver_gender F M table driver_race Asian 551 1838 driver_gender F M Black 2681 9604 driver_race Hispanic 1953 7774 Asian 551 1838 Black 2681 9604 table = Hispanic 1953 7774 table.loc['Asian':'Hispanic'] Other 53 212 White 18536 43334 ANALYZING POLICE ACTIVITY WITH PANDAS

  19. Creating a line plot table.plot() plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  20. Creating a bar plot table.plot(kind='bar') plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  21. Stacking the bars table.plot(kind='bar', stacked=True) plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  22. Let ' s practice ! AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS

  23. Ho w long might y o u be stopped for a v iolation ? AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS Ke v in Markham Fo u nder , Data School

  24. Anal yz ing an object col u mn apple date_and_time price volume change 2018-01-08 16:00:00 174.35 20567800 down ... ... ... ... 2018-03-09 16:00:00 179.98 32185200 up apple.change.dtype Create a Boolean col u mn : True if the price w ent u p , and False other w ise dtype('O') Calc u late ho w o � en the .astype() can ' t be u sed in price w ent u p b y taking the this case col u mn mean ANALYZING POLICE ACTIVITY WITH PANDAS

  25. Mapping one set of v al u es to another Dictionar y maps the v al u es y o u ha v e to the v al u es y o u w ant mapping = {'up':True, 'down':False} apple['is_up'] = apple.change.map(mapping) apple date_and_time price volume change is_up 2018-01-08 16:00:00 174.35 20567800 down False ... ... ... ... ... 2018-03-09 16:00:00 179.98 32185200 up True apple.is_up.mean() 0.5 ANALYZING POLICE ACTIVITY WITH PANDAS

  26. Calc u lating the search rate Vis u ali z e ho w o � en searches w ere done a � er each v iolation t y pe ri.groupby('violation').search_conducted.mean() violation Equipment 0.064280 Moving violation 0.057014 Other 0.045362 Registration/plates 0.093438 Seat belt 0.031513 Speeding 0.021560 search_rate = ri.groupby('violation').search_conducted.mean ANALYZING POLICE ACTIVITY WITH PANDAS

  27. Creating a bar plot search_rate.plot(kind='bar') plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  28. Ordering the bars (1) Order the bars from le � to right b y si z e search_rate.sort_values() violation Speeding 0.021560 Seat belt 0.031513 Other 0.045362 Moving violation 0.057014 Equipment 0.064280 Registration/plates 0.093438 Name: search_conducted, dtype: float64 ANALYZING POLICE ACTIVITY WITH PANDAS

  29. Ordering the bars (2) search_rate.sort_values().plot(kind='bar') plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  30. Rotating the bars search_rate.sort_values().plot(kind='barh') plt.show() ANALYZING POLICE ACTIVITY WITH PANDAS

  31. Let ' s practice ! AN ALYZIN G P OL IC E AC TIVITY W ITH PAN DAS

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

History of Arrest in Intimate Partner Violence 1970s/1980s 7% to 15% arrest rate in IPV

History of Arrest in Intimate Partner Violence 1970s/1980s 7% to 15% arrest rate in IPV

The Results of a 10-Year Study of the Impact of Intimate Partner Violence Primary Aggressor Laws on Single and Dual Arrest David Hirschel, PhD , Professor Emeritus of Criminal Justice at the University of Massachusetts Lowell and at the

419 views • 6 slides
7 Chapter 2 Factors: How Time and Interest Affect Money Progressive Example-The Cement Factory

7 Chapter 2 Factors: How Time and Interest Affect Money Progressive Example-The Cement Factory

Chapter 1 Foundations of Engineering Economy 1.1 Engineering Economics: Description and Role in Decision Making 1.2 Performing an Engineering Economy Study 1.3 Professional Ethics and Economic Decisions 1.4 Interest Rate and Rate of Return

1.21k views • 80 slides
Personal Fall Arrest st Syst ystems Personal fall arrest system means a system used to

Personal Fall Arrest st Syst ystems Personal fall arrest system means a system used to

Personal Fall Arrest st Syst ystems Personal fall arrest system means a system used to arrest an employee in a fall from a working level. It consists of an anchorage, connectors, a body belt or body harness and may include a

1.27k views • 94 slides
Affect/Emotion in Design What are we trying to do with designs? What is Affect? Affect:

Affect/Emotion in Design What are we trying to do with designs? What is Affect? Affect:

Affect/Emotion in Design What are we trying to do with designs? What is Affect? Affect: General emotional response Essentially, the desire of designers to: Create positive responses in users At ease, comfortable, enjoy using,

1.25k views • 38 slides
in Cardiac Arrest in Cardiac Arrest Management Management Sean Kivlehan, MD, MPH May 2014

in Cardiac Arrest in Cardiac Arrest Management Management Sean Kivlehan, MD, MPH May 2014

in Cardiac Arrest in Cardiac Arrest Management Management Sean Kivlehan, MD, MPH May 2014 Outline 1. Capnography 2. Compressions 3. CPR Devices 4. Hypothermia 5. Access 6. Medications Capnography & Termination Significantly

457 views • 19 slides
Does exporting affect financial leverages: Evidence from Chinese firms under exchange rate

Does exporting affect financial leverages: Evidence from Chinese firms under exchange rate

Does exporting affect financial leverages: Evidence from Chinese firms under exchange rate fluctuations Zhihong Yu GEP, School of Economics, University of Nottingham Festschrift Conference for Professor Sir David Greenaway, June 25, Nottingham

687 views • 42 slides
Does Foreign Bank Presence Affect Interest Rate Pass-Through in Emerging and Developing

Does Foreign Bank Presence Affect Interest Rate Pass-Through in Emerging and Developing

Does Foreign Bank Presence Affect Interest Rate Pass-Through in Emerging and Developing Economies? Sasidaran Gopalan* Post-Doctoral Research Fellow Institute for Emerging Market Studies (IEMS) and Institute for Advanced Study (IAS) The Hong

907 views • 47 slides
Arrest of Ships in India Foreign Arbitration & India Indian Law & Practice Zarir P

Arrest of Ships in India Foreign Arbitration & India Indian Law & Practice Zarir P

Arrest of Ships in India Foreign Arbitration & India Indian Law & Practice Zarir P Bharucha Part I Arrest of ships in Arrest of ships in India India Introduction Federal type legal system with no intermediate courts of

701 views • 35 slides
How Do Mortgage Rate Resets Affect Consumer Spending and Debt Repayment? Evidence from Canadian

How Do Mortgage Rate Resets Affect Consumer Spending and Debt Repayment? Evidence from Canadian

How Do Mortgage Rate Resets Affect Consumer Spending and Debt Repayment? Evidence from Canadian Consumers Katya Kartashova Xiaoqing Zhou Bank of Canada Federal Reserve Bank of Dallas The views in this presentation are solely the responsibility

505 views • 23 slides
Labor Classification Yrs Rate 1 Rate 2 Rate 3 Rate 4 Rate 5 Rate 6 Rate 7 Rate 8 Rate 9

Labor Classification Yrs Rate 1 Rate 2 Rate 3 Rate 4 Rate 5 Rate 6 Rate 7 Rate 8 Rate 9

Labor Classification Yrs Rate 1 Rate 2 Rate 3 Rate 4 Rate 5 Rate 6 Rate 7 Rate 8 Rate 9 Rate 10 Oz 30+ $ 72.50 Wicked Witches 20+ $ 61.00 $ 60.00 $ 58.00 $ 53.00 $ 52.00 $ 49.00 Scare Crows 15+ $ 48.00 $ 45.00 $

278 views • 7 slides
Classical metapopulation model Area effects How does island area affect the number species on

Classical metapopulation model Area effects How does island area affect the number species on

Classical metapopulation model Area effects How does island area affect the number species on the island? How does size affect colonization rate? Colonization Rate Extinction S small < S large Equilibrium S s E s metapopulation C l size

281 views • 6 slides
Sudden Cardiac Arrest HEART SMART COMMUNITIES Current Local Statistics If someone in our

Sudden Cardiac Arrest HEART SMART COMMUNITIES Current Local Statistics If someone in our

Sudden Cardiac Arrest HEART SMART COMMUNITIES Current Local Statistics If someone in our community suffers a sudden cardiac arrest outside of the hospital, how likely is he or she to survive? Less than 10% of sudden cardiac arrest victims

403 views • 11 slides
Cardiac Arrest, Cardiogenic Shock, Therapeutic Hypothermia Timothy D. Henry, MD Director of

Cardiac Arrest, Cardiogenic Shock, Therapeutic Hypothermia Timothy D. Henry, MD Director of

Cardiac Arrest, Cardiogenic Shock, Therapeutic Hypothermia Timothy D. Henry, MD Director of Cardiology Cedars-Sinai Heart Institute Disclosures: Nothing to disclose 3 Out-of-Hospital Cardiac Arrest 48 year old male presents to ER as

501 views • 35 slides
Disclosures Research support from UCOP CHQI In-Hospital Cardiac Arrest: award Measuring

Disclosures Research support from UCOP CHQI In-Hospital Cardiac Arrest: award Measuring

5/29/2014 Disclosures Research support from UCOP CHQI In-Hospital Cardiac Arrest: award Measuring Effectiveness and Improving Outcomes J. Matthew Aldrich, MD Anesthesia & Critical Care UCSF Overview Cardiopulmonary Arrest: Quality

283 views • 12 slides
33C versus 36C after Cardiac Arrest TTM-trial investigators Niklas Nielsen, MD, PhD, EDIC,

33C versus 36C after Cardiac Arrest TTM-trial investigators Niklas Nielsen, MD, PhD, EDIC,

Targeted Temperature Management 33C versus 36C after Cardiac Arrest TTM-trial investigators Niklas Nielsen, MD, PhD, EDIC, DEAA Helsingborg Hospital Lund University Sweden Hypothermia to 32-34C after out-of- hospital cardiac arrest

494 views • 16 slides
Mass Storage & IO Positioning time ( random-access time ) is time to move disk arm to

Mass Storage & IO Positioning time ( random-access time ) is time to move disk arm to

CSC 4103 - Operating Systems Overview of Mass Storage Structure Spring 2008 Magnetic disks provide bulk of secondary storage of modern computers Drives rotate at 60 to 200 times per second Lecture - XVIII Transfer rate is rate at

254 views • 3 slides
Real World Example Buzzer Feature for a Car Should Buzz when 1. the engine is

Real World Example Buzzer Feature for a Car Should Buzz when 1. the engine is

ADMIN READING Appendix: Read B.7-B.10, and B.12 (skip the Verilog details). IC220 Course Paper description due by Mon Feb 24 for approval (email) Current computer architectural topic/issue Slide Set #8: Digital Logic Finale

373 views • 8 slides
Real World Example Buzzer Feature for a Car Should Buzz when IC220 1. the

Real World Example Buzzer Feature for a Car Should Buzz when IC220 1. the

Real World Example Buzzer Feature for a Car Should Buzz when IC220 1. the engine is on, the door is closed, and the seat belt is unbuckled Slide Set #A2: Combinational and 2. the engine is on, the door is open What are

221 views • 6 slides
Oregon Task Force on Autonomous Vehicles Kick-Off Meeting April 18, 2018 4/18/2018 1 Welcome

Oregon Task Force on Autonomous Vehicles Kick-Off Meeting April 18, 2018 4/18/2018 1 Welcome

Oregon Task Force on Autonomous Vehicles Kick-Off Meeting April 18, 2018 4/18/2018 1 Welcome to the Task Force on Autonomous Vehicles 4/18/2018 2 Purpose of the Task Force Framing the Future for Autonomous Vehicles in Oregon Problem:

697 views • 56 slides
Teen een Dr Driver Safety ty Topic Call #3 December 19, 2017 Strategy Team Updates Call (866)

Teen een Dr Driver Safety ty Topic Call #3 December 19, 2017 Strategy Team Updates Call (866)

Teen een Dr Driver Safety ty Topic Call #3 December 19, 2017 Strategy Team Updates Call (866) 835-7973 to join Tips ps Download Call (866) 835-7973 resources from File for audio Share pod Mute yourself when This webinar is youre

640 views • 40 slides
Noise Sensitivity of Boolean Functions and Critical Percolation Jeffrey Steif Pictures

Noise Sensitivity of Boolean Functions and Critical Percolation Jeffrey Steif Pictures

Noise Sensitivity of Boolean Functions and Critical Percolation Jeffrey Steif Pictures borrowed from C. Garban and others Jeff Steif October 21, 2019 1 / 35 Outline of talk Jeff Steif October 21, 2019 2 / 35 Outline of talk 1.

1.56k views • 107 slides
Simul-Climber All The Climb, All The Time Emma Steinhardt, James Tsao, Tobi Rudoltz Sketch Model

Simul-Climber All The Climb, All The Time Emma Steinhardt, James Tsao, Tobi Rudoltz Sketch Model

Simul-Climber All The Climb, All The Time Emma Steinhardt, James Tsao, Tobi Rudoltz Sketch Model Review Yellow B Motivation Simultaneous climbing saves time, a risky practice with little protection 75% of injuries caused by falls

429 views • 9 slides
Using Uncertain Knowledge Agents dont have complete knowledge about the world. Agents

Using Uncertain Knowledge Agents dont have complete knowledge about the world. Agents

Using Uncertain Knowledge Agents dont have complete knowledge about the world. Agents need to make decisions based on their uncertainty. It isnt enough to assume what the world is like. Example: wearing a seat belt. An agent

466 views • 14 slides
Solvers Principles and Architecture (SPA) General Introduction Master Sciences Informatique

Solvers Principles and Architecture (SPA) General Introduction Master Sciences Informatique

Solvers Principles and Architecture (SPA) General Introduction Master Sciences Informatique (Sif) September 18th, 2019 Rennes Khalil Ghorbal k halil.ghorbal@inria.fr K. Ghorbal (INRIA) 1 SIF M2 1 / 15 What makes a problem important ?

688 views • 49 slides

More recommend