In [1]:
import pandas as pd
import numpy as np
import matplotlib
In [3]:
issues = pd.read_csv("opentoday.csv")
In [4]:
issues
Out[4]:
title
id
activity
creation
status
0
Class name hardcoded in TracebackException.fro...
24710
2015-07-24.22:57:05
2015-07-24.22:57:05
1
1
array.fromstring Use After Free
24613
2015-07-24.20:07:29
2015-07-12.00:32:50
1
2
Unix build uses '-Wno-unused-result', which ic...
24709
2015-07-24.19:43:54
2015-07-24.19:43:54
1
3
Assertion failed in pymonotonic_new
24707
2015-07-24.17:43:56
2015-07-24.15:53:37
1
4
collections.OrderedDict collaborative subclassing
24685
2015-07-24.17:40:09
2015-07-22.17:04:00
1
5
strop.replace Integer Overflow
24708
2015-07-24.16:26:38
2015-07-24.16:26:20
1
6
poplib maxline behaviour may be wrong
23906
2015-07-24.16:06:23
2015-04-10.15:26:33
1
7
TemporaryDirectory is cleaned up twice
24699
2015-07-24.15:42:42
2015-07-23.22:51:03
1
8
operator.subscript
24379
2015-07-24.15:36:50
2015-06-04.06:07:04
1
9
Error in Python 3 docs for PyMethodDef
15657
2015-07-24.15:32:16
2012-08-14.19:02:45
1
10
poplib: Line too long error causes knock-on fa...
24706
2015-07-24.15:24:32
2015-07-24.15:24:32
1
11
sysconfig._parse_makefile doesn't expand ${} v...
24705
2015-07-24.13:43:54
2015-07-24.12:13:00
1
12
Provide a rejected execution model and impleme...
22737
2015-07-24.12:43:45
2014-10-27.02:38:59
1
13
consider implementing __await__ on concurrent....
24383
2015-07-24.11:54:48
2015-06-04.15:38:14
1
14
Steps for Android Native Build of Python 3.4.2
23496
2015-07-24.10:41:57
2015-02-21.20:46:56
1
15
Add timespec optional flag to datetime isoform...
19475
2015-07-24.09:53:38
2013-11-01.17:05:21
1
16
Dead Code of Handler check in function faultha...
24302
2015-07-24.08:36:17
2015-05-27.16:30:45
1
17
Add CoroutineReturn and CoroutineExit builtin ...
24697
2015-07-24.08:35:13
2015-07-23.15:10:15
1
18
Put most likely test first in set_add_entry()
24681
2015-07-24.05:41:39
2015-07-22.04:01:49
1
19
dict() built-in fails on iterators with a "key...
24659
2015-07-24.05:35:16
2015-07-18.08:54:59
1
20
obsolete macpath module dangerously broken and...
9850
2015-07-24.03:47:04
2010-09-14.05:14:10
1
21
array compare is hideously slow
24700
2015-07-24.02:36:11
2015-07-23.23:01:14
1
22
cross type comparisons clarification
22000
2015-07-24.01:38:53
2014-07-17.18:38:32
1
23
get_externals.bat script fails
24698
2015-07-23.17:41:34
2015-07-23.17:19:38
1
24
IDLE debugger causes crash if not quitted prop...
24455
2015-07-23.16:33:09
2015-06-15.15:57:30
1
25
mock_open data is visible only once for the li...
21750
2015-07-23.15:49:29
2014-06-13.18:14:49
1
26
Mock.assert* API is in user namespace
24651
2015-07-23.15:34:40
2015-07-17.07:56:00
1
27
Add Base32 support for RFC4648 "Extended Hex" ...
16995
2015-07-23.15:26:24
2013-01-18.18:21:19
1
28
file accepts 'rU+' as a mode
2091
2015-07-23.15:21:05
2008-02-12.22:55:09
1
29
Don't use None as sentinel for traceback
24696
2015-07-23.14:52:20
2015-07-23.14:52:20
1
...
...
...
...
...
...
4882
TextIOWrapper Buffering Inconsistent Between _...
7955
2010-10-29.10:07:21
2010-02-18.06:41:15
1
4883
ctypes.xFUNCTYPE are decorators.
4260
2010-10-29.10:07:21
2008-11-05.05:51:02
1
4884
Popen() object stdout attribute reassignment b...
3687
2010-10-29.10:07:21
2008-08-26.15:57:45
1
4885
ftplib doesn't check close status after sendin...
10202
2010-10-28.14:14:32
2010-10-26.19:04:47
1
4886
ExpatError not property wrapped
10108
2010-10-27.10:23:29
2010-10-14.21:54:28
1
4887
Turtle speed() function has no effect under Ma...
3062
2010-10-19.21:17:08
2008-06-08.11:06:53
1
4888
xmlrpclib does not handle some non-printable c...
10066
2010-10-14.21:03:59
2010-10-11.16:16:39
1
4889
Format parser is too permissive
10021
2010-10-08.22:55:18
2010-10-04.16:24:04
1
4890
Update multiprocessing docs re: freeze_support
5501
2010-10-04.18:13:45
2009-03-17.18:01:43
1
4891
shutil.copyfile -- allow sparse copying
10016
2010-10-04.12:03:53
2010-10-02.14:16:54
1
4892
Inconsistent naming of custom command in setup...
6860
2010-09-30.01:01:57
2009-09-08.01:08:32
1
4893
zsh-style subpattern matching for fnmatch/glob
4573
2010-09-27.20:40:12
2008-12-07.08:17:56
1
4894
Export more libreadline API functions
1175004
2010-09-23.10:20:33
2005-04-01.19:30:23
1
4895
base64 "legacy" functions violate RFC 3548
1753718
2010-09-17.18:27:12
2007-07-13.18:13:54
1
4896
__call__.__call__ chain cause crash when long ...
9743
2010-09-13.06:46:28
2010-09-02.14:36:32
1
4897
include higher (../../) dirs fails
9261
2010-09-08.03:01:31
2010-07-14.16:20:36
1
4898
Recursive variable definition causes sysconfig...
919238
2010-09-07.13:31:53
2004-03-19.03:15:15
1
4899
allow multiple threads to efficiently send the...
3735
2010-08-31.10:51:47
2008-08-29.23:07:08
1
4900
sndhdr.what() does not recognize wav file
1611944
2010-08-25.14:36:32
2006-12-09.02:37:48
1
4901
tokenize.generate_tokens doesn't always return...
5028
2010-08-22.00:25:38
2009-01-22.01:39:01
1
4902
distutils extension library path bug on cygwin
1289136
2010-08-21.19:27:33
2005-09-12.22:04:55
1
4903
Encodings and aliases do not match runtime
1249749
2010-08-21.18:46:24
2005-08-01.18:23:30
1
4904
distutils relative path errors
9023
2010-08-21.17:42:46
2010-06-18.08:47:29
1
4905
Explain the default timeout in http-client-rel...
8595
2010-08-19.13:16:45
2010-05-02.02:54:42
1
4906
Improved doctest REPORT_*DIFFs with ELLIPSIS a...
9640
2010-08-19.11:06:03
2010-08-19.11:04:09
1
4907
Interrupt/kill threads w/exception
1509060
2010-08-09.03:40:42
2006-06-20.04:30:39
1
4908
make install change: Allow $DESTDIR to be rela...
1520879
2010-08-09.03:34:55
2006-07-11.23:56:10
1
4909
ftplib Persistent data connection
2628
2010-08-07.16:33:11
2008-04-13.23:50:10
1
4910
pulldom.SAX2DOM Doesn't support processing ins...
9453
2010-08-02.10:53:49
2010-08-02.10:49:16
1
4911
xml.sax.xmlreader.XMLReader.getProperty (xml.s...
6686
2010-07-20.07:11:34
2009-08-11.19:19:52
1
4912 rows × 5 columns
In [9]:
# open issues
len(issues)
Out[9]:
4912
In [13]:
#before 2011
i = issues
len(i[(i.activity <= '2011-01-01')])
Out[13]:
44
In [18]:
# 2011
i = issues
len(i[((i.activity <= '2012-01-01') & (i.activity > '2011-01-01'))])
Out[18]:
210
In [21]:
# 2012
i = issues
len(i[(i.activity <= '2013-01-01') & (i.activity > '2012-01-01')])
Out[21]:
419
In [22]:
# 2013
i = issues
len(i[(i.activity <= '2014-01-01') & (i.activity > '2013-01-01')])
Out[22]:
721
In [23]:
# 2014
i = issues
len(i[(i.activity <= '2015-01-01') & (i.activity > '2014-01-01')])
Out[23]:
1943
In [24]:
# 2015 so far
i = issues
len(i[(i.activity > '2015-01-01')])
Out[24]:
1575
In [26]:
# 2015 so far
i = issues
thisyear = i[(i.activity > '2015-01-01')]
len(thisyear)
Out[26]:
1575
In [27]:
thisyear
Out[27]:
title
id
activity
creation
status
0
Class name hardcoded in TracebackException.fro...
24710
2015-07-24.22:57:05
2015-07-24.22:57:05
1
1
array.fromstring Use After Free
24613
2015-07-24.20:07:29
2015-07-12.00:32:50
1
2
Unix build uses '-Wno-unused-result', which ic...
24709
2015-07-24.19:43:54
2015-07-24.19:43:54
1
3
Assertion failed in pymonotonic_new
24707
2015-07-24.17:43:56
2015-07-24.15:53:37
1
4
collections.OrderedDict collaborative subclassing
24685
2015-07-24.17:40:09
2015-07-22.17:04:00
1
5
strop.replace Integer Overflow
24708
2015-07-24.16:26:38
2015-07-24.16:26:20
1
6
poplib maxline behaviour may be wrong
23906
2015-07-24.16:06:23
2015-04-10.15:26:33
1
7
TemporaryDirectory is cleaned up twice
24699
2015-07-24.15:42:42
2015-07-23.22:51:03
1
8
operator.subscript
24379
2015-07-24.15:36:50
2015-06-04.06:07:04
1
9
Error in Python 3 docs for PyMethodDef
15657
2015-07-24.15:32:16
2012-08-14.19:02:45
1
10
poplib: Line too long error causes knock-on fa...
24706
2015-07-24.15:24:32
2015-07-24.15:24:32
1
11
sysconfig._parse_makefile doesn't expand ${} v...
24705
2015-07-24.13:43:54
2015-07-24.12:13:00
1
12
Provide a rejected execution model and impleme...
22737
2015-07-24.12:43:45
2014-10-27.02:38:59
1
13
consider implementing __await__ on concurrent....
24383
2015-07-24.11:54:48
2015-06-04.15:38:14
1
14
Steps for Android Native Build of Python 3.4.2
23496
2015-07-24.10:41:57
2015-02-21.20:46:56
1
15
Add timespec optional flag to datetime isoform...
19475
2015-07-24.09:53:38
2013-11-01.17:05:21
1
16
Dead Code of Handler check in function faultha...
24302
2015-07-24.08:36:17
2015-05-27.16:30:45
1
17
Add CoroutineReturn and CoroutineExit builtin ...
24697
2015-07-24.08:35:13
2015-07-23.15:10:15
1
18
Put most likely test first in set_add_entry()
24681
2015-07-24.05:41:39
2015-07-22.04:01:49
1
19
dict() built-in fails on iterators with a "key...
24659
2015-07-24.05:35:16
2015-07-18.08:54:59
1
20
obsolete macpath module dangerously broken and...
9850
2015-07-24.03:47:04
2010-09-14.05:14:10
1
21
array compare is hideously slow
24700
2015-07-24.02:36:11
2015-07-23.23:01:14
1
22
cross type comparisons clarification
22000
2015-07-24.01:38:53
2014-07-17.18:38:32
1
23
get_externals.bat script fails
24698
2015-07-23.17:41:34
2015-07-23.17:19:38
1
24
IDLE debugger causes crash if not quitted prop...
24455
2015-07-23.16:33:09
2015-06-15.15:57:30
1
25
mock_open data is visible only once for the li...
21750
2015-07-23.15:49:29
2014-06-13.18:14:49
1
26
Mock.assert* API is in user namespace
24651
2015-07-23.15:34:40
2015-07-17.07:56:00
1
27
Add Base32 support for RFC4648 "Extended Hex" ...
16995
2015-07-23.15:26:24
2013-01-18.18:21:19
1
28
file accepts 'rU+' as a mode
2091
2015-07-23.15:21:05
2008-02-12.22:55:09
1
29
Don't use None as sentinel for traceback
24696
2015-07-23.14:52:20
2015-07-23.14:52:20
1
...
...
...
...
...
...
1545
MozillaCookieJar does not handle session cookies
17164
2015-01-07.14:11:05
2013-02-08.21:23:23
1
1546
Update tix install information in tkinter tix ...
23156
2015-01-07.06:59:33
2015-01-03.21:55:24
1
1547
MSILIB truncates last character in summary inf...
22391
2015-01-06.12:35:21
2014-09-11.16:53:29
1
1548
"unclosed file" warning when defining unused l...
23010
2015-01-06.12:29:41
2014-12-08.13:46:54
1
1549
test_file.py depends on sys.stdin being unseek...
14853
2015-01-06.11:43:40
2012-05-18.18:50:06
1
1550
socket.recvfrom(0) waits for data
23176
2015-01-06.04:13:22
2015-01-06.02:58:37
1
1551
xmlrpc.client.ServerProxy needs timeout parameter
14134
2015-01-05.19:24:34
2012-02-26.22:19:00
1
1552
Migrate sqlite3 module to _v2 API to enhance p...
9303
2015-01-05.17:18:17
2010-07-19.12:08:04
1
1553
Add timeout parameter to Queue.join()
9634
2015-01-05.14:03:54
2010-08-18.17:46:20
1
1554
collections.abc sequences don't check identity...
23162
2015-01-05.06:20:56
2015-01-04.08:05:06
1
1555
unittest: object has no attribute '_removed_te...
23155
2015-01-04.20:11:15
2015-01-03.19:38:03
1
1556
Improved support for prepared SQL statements
22956
2015-01-04.14:28:44
2014-11-27.13:38:39
1
1557
"pydoc filter" documentation restrictive
23164
2015-01-04.13:19:32
2015-01-04.13:19:32
1
1558
pyvenv should display a progress indicator whi...
22256
2015-01-04.08:06:31
2014-08-23.09:12:01
1
1559
httplib: unicode url will cause an ascii codec...
22231
2015-01-04.06:46:17
2014-08-20.02:49:37
1
1560
Setup & Usage documentation for pydoc, idle & ...
14944
2015-01-04.02:29:37
2012-05-29.01:47:37
1
1561
IDLE HOWTO
17583
2015-01-04.02:17:21
2013-03-30.23:12:36
1
1562
urllib parse incorrect handing of params
23150
2015-01-03.20:48:25
2015-01-02.14:13:47
1
1563
Rename Scripts directory to bin and move pytho...
14302
2015-01-03.14:36:43
2012-03-14.16:29:34
1
1564
Python Tutorial 4.7.1: Improve ask_ok() to cov...
23116
2015-01-03.12:18:03
2014-12-26.19:42:14
1
1565
pip.exe breaks if python 2.7.9 is installed un...
23121
2015-01-03.10:51:01
2014-12-27.15:10:13
1
1566
flaky test in test_datetime
15933
2015-01-03.03:41:51
2012-09-12.16:20:15
1
1567
unittest expectedFailure could take a message ...
12681
2015-01-02.20:17:20
2011-08-02.11:41:56
1
1568
patch: steer people away from codecs.open
22128
2015-01-02.20:16:39
2014-08-03.13:17:18
1
1569
list(pathlib.Path().glob("")) fails with Index...
23076
2015-01-01.18:42:51
2014-12-17.23:59:40
1
1570
spwd returning different value depending on pr...
10388
2015-01-01.17:47:13
2010-11-11.14:03:10
1
1571
Misleading error from getspnam function of spw...
18787
2015-01-01.17:44:32
2013-08-20.04:13:01
1
1572
Integration of unittest.FunctionTestCase with ...
23142
2015-01-01.16:06:36
2015-01-01.07:58:44
1
1573
Change necessary in platform.py to support Iro...
17994
2015-01-01.02:49:39
2013-05-16.14:24:45
1
1574
Alternate RFC 3986 compliant URI parsing module
1500504
2015-01-01.01:25:35
2006-06-04.14:50:18
1
1575 rows × 5 columns
In [29]:
# 2014 created
t = thisyear
len(t[t.creation > '2015-01-01'])
Out[29]:
718
In [28]:
# 2014 created
t = thisyear
len(t[(t.creation <= '2015-01-01') & (t.creation > '2014-01-01')])
Out[28]:
316
In [30]:
# 2013 created
t = thisyear
len(t[(t.creation <= '2014-01-01') & (t.creation > '2013-01-01')])
Out[30]:
170
In [31]:
# 2012 created
t = thisyear
len(t[(t.creation <= '2013-01-01') & (t.creation > '2012-01-01')])
Out[31]:
100
In [32]:
# 2011 created
t = thisyear
len(t[(t.creation <= '2012-01-01') & (t.creation > '2011-01-01')])
Out[32]:
78
In [33]:
# 2010 created
t = thisyear
len(t[(t.creation <= '2011-01-01') & (t.creation > '2010-01-01')])
Out[33]:
74
In [34]:
# Pre-2010 created
t = thisyear
len(t[t.creation <= '2010-01-01'])
Out[34]:
119
In [35]:
119+74+78+100+170+316+718
Out[35]:
1575
In [ ]:
In [ ]:
Content source: willingc/bugriff
Similar notebooks: