Skip to main content

Pandas examples

rats.csv is downloaded here:
https://data.cityofchicago.org/Service-Requests/311-Service-Requests-Rodent-Baiting/97t6-zrhs

>>> import pandas
>>> rats = pandas.read_csv('rats.csv', skip_footer=1)

>>> rats['Current Activity'].unique()
array(['Dispatch Crew', nan, 'Request Sanitation Inspector',
       'Inspect for Violation', 'FVI - Outcome'], dtype=object)
>>> crew_dispatched = rats[rats['Current Activity'] == 'Dispatch Crew']
>>> len(crew_dispatched)
262417
>>> crew_dispatched['ZIP Code'].value_counts() 
>>> crew_dispatched.groupby("Completion Date")

>>> dates = crew_dispatched.groupby("Completion Date")
>>> len(dates)
1775
>>> date_counts = dates.size()
>>> date_counts [0:10]
Completion Date
01/01/2014      7
01/02/2013     20
01/02/2014     96
01/02/2015      5
01/02/2018     71
01/03/2011      4
01/03/2012    125
01/03/2013     46
01/03/2014     59
01/03/2017    212
dtype: int64

>>> date_counts.sort_values()[-10:]
Completion Date
11/28/2014    384
10/14/2011    391
10/11/2017    392
08/17/2017    392
11/12/2013    401
10/14/2016    412
10/07/2011    457
07/06/2016    461
11/01/2013    488
09/09/2016    492
dtype: int64
Labels:

Comments

Post a Comment

https://gengwg.blogspot.com/

Popular posts from this blog

CKA Simulator Kubernetes 1.22

  https://killer.sh Pre Setup Once you've gained access to your terminal it might be wise to spend ~1 minute to setup your environment. You could set these: alias k = kubectl                         # will already be pre-configured export do = "--dry-run=client -o yaml"     # k get pod x $do export now = "--force --grace-period 0"   # k delete pod x $now Vim To make vim use 2 spaces for a tab edit ~/.vimrc to contain: set tabstop=2 set expandtab set shiftwidth=2 More setup suggestions are in the tips section .     Question 1 | Contexts Task weight: 1%   You have access to multiple clusters from your main terminal through kubectl contexts. Write all those context names into /opt/course/1/contexts . Next write a command to display the current context into /opt/course/1/context_default_kubectl.sh , the command should use kubectl . Finally write a second command doing the same thing into ...
Post a Comment
Read more

OWASP Top 10 Threats and Mitigations Exam - Single Select

Last updated 4 Aug 11 Course Title: OWASP Top 10 Threats and Mitigation Exam Questions - Single Select 1) Which of the following consequences is most likely to occur due to an injection attack? Spoofing Cross-site request forgery Denial of service   Correct Insecure direct object references 2) Your application is created using a language that does not support a clear distinction between code and data. Which vulnerability is most likely to occur in your application? Injection   Correct Insecure direct object references Failure to restrict URL access Insufficient transport layer protection 3) Which of the following scenarios is most likely to cause an injection attack? Unvalidated input is embedded in an instruction stream.   Correct Unvalidated input can be distinguished from valid instructions. A Web application does not validate a client’s access to a resource. A Web action performs an operation on behalf of the user without checkin...
2 comments
Read more