Skip to content

Instantly share code, notes, and snippets.

@leebrian

leebrian/..ph_language_query.ipynb

Forked from jakevdp/ADS_Language_Query.ipynb
Last active April 1, 2021 20:28
Show Gist options
  • Save leebrian/faa8df84689be45eb2ad8d10c39875d0 to your computer and use it in GitHub Desktop.
Save leebrian/faa8df84689be45eb2ad8d10c39875d0 to your computer and use it in GitHub Desktop.
Download ZIP
data processing languages used in public health publications
Display the source blob
Display the rendered blob
Raw
..ph_language_query.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Raw
.gitignore
*.ipynb
*.bak
Raw
cdc_results.csv
name year count total_count
Python 2000 0 933
Python 2001 0 1048
Python 2002 0 962
Python 2003 0 1145
Python 2004 0 1224
Python 2005 0 1320
Python 2006 0 1438
Python 2007 0 1450
Python 2008 1 1518
Python 2009 1 1551
Python 2010 0 1647
Python 2011 0 1936
Python 2012 1 1930
Python 2013 0 2052
Python 2014 1 2928
Python 2015 0 3367
Python 2016 1 3537
Python 2017 0 3587
Python 2018 0 3508
Python 2019 1 3345
Python 2020 0 3526
R 2000 0 933
R 2001 0 1048
R 2002 0 962
R 2003 0 1145
R 2004 0 1224
R 2005 0 1320
R 2006 0 1438
R 2007 0 1450
R 2008 0 1518
R 2009 0 1551
R 2010 0 1647
R 2011 0 1936
R 2012 0 1930
R 2013 0 2052
R 2014 1 2928
R 2015 0 3367
R 2016 0 3537
R 2017 0 3587
R 2018 0 3508
R 2019 0 3345
R 2020 0 3526
R 2000 0 933
R 2001 0 1048
R 2002 0 962
R 2003 1 1145
R 2004 0 1224
R 2005 0 1320
R 2006 0 1438
R 2007 0 1450
R 2008 0 1518
R 2009 0 1551
R 2010 0 1647
R 2011 1 1936
R 2012 0 1930
R 2013 1 2052
R 2014 3 2928
R 2015 2 3367
R 2016 2 3537
R 2017 2 3587
R 2018 3 3508
R 2019 3 3345
R 2020 0 3526
R 2000 0 933
R 2001 0 1048
R 2002 0 962
R 2003 0 1145
R 2004 0 1224
R 2005 0 1320
R 2006 0 1438
R 2007 0 1450
R 2008 0 1518
R 2009 0 1551
R 2010 1 1647
R 2011 1 1936
R 2012 3 1930
R 2013 3 2052
R 2014 2 2928
R 2015 1 3367
R 2016 1 3537
R 2017 1 3587
R 2018 5 3508
R 2019 4 3345
R 2020 7 3526
R 2000 0 933
R 2001 0 1048
R 2002 0 962
R 2003 1 1145
R 2004 0 1224
R 2005 0 1320
R 2006 0 1438
R 2007 0 1450
R 2008 0 1518
R 2009 0 1551
R 2010 0 1647
R 2011 0 1936
R 2012 1 1930
R 2013 0 2052
R 2014 2 2928
R 2015 1 3367
R 2016 2 3537
R 2017 0 3587
R 2018 4 3508
R 2019 6 3345
R 2020 2 3526
R 2000 0 933
R 2001 0 1048
R 2002 0 962
R 2003 0 1145
R 2004 0 1224
R 2005 0 1320
R 2006 0 1438
R 2007 0 1450
R 2008 0 1518
R 2009 0 1551
R 2010 0 1647
R 2011 0 1936
R 2012 2 1930
R 2013 0 2052
R 2014 0 2928
R 2015 1 3367
R 2016 0 3537
R 2017 1 3587
R 2018 1 3508
R 2019 0 3345
R 2020 0 3526
R 2000 0 933
R 2001 0 1048
R 2002 0 962
R 2003 0 1145
R 2004 0 1224
R 2005 0 1320
R 2006 0 1438
R 2007 0 1450
R 2008 1 1518
R 2009 0 1551
R 2010 0 1647
R 2011 0 1936
R 2012 1 1930
R 2013 1 2052
R 2014 5 2928
R 2015 9 3367
R 2016 8 3537
R 2017 7 3587
R 2018 14 3508
R 2019 17 3345
R 2020 14 3526
R 2000 0 933
R 2001 0 1048
R 2002 0 962
R 2003 0 1145
R 2004 0 1224
R 2005 0 1320
R 2006 0 1438
R 2007 0 1450
R 2008 0 1518
R 2009 0 1551
R 2010 0 1647
R 2011 0 1936
R 2012 0 1930
R 2013 0 2052
R 2014 0 2928
R 2015 0 3367
R 2016 1 3537
R 2017 1 3587
R 2018 1 3508
R 2019 0 3345
R 2020 0 3526
SAS 2000 0 933
SAS 2001 0 1048
SAS 2002 0 962
SAS 2003 1 1145
SAS 2004 1 1224
SAS 2005 2 1320
SAS 2006 2 1438
SAS 2007 4 1450
SAS 2008 4 1518
SAS 2009 1 1551
SAS 2010 7 1647
SAS 2011 4 1936
SAS 2012 7 1930
SAS 2013 3 2052
SAS 2014 9 2928
SAS 2015 16 3367
SAS 2016 9 3537
SAS 2017 12 3587
SAS 2018 6 3508
SAS 2019 8 3345
SAS 2020 10 3526
SPSS 2000 0 933
SPSS 2001 0 1048
SPSS 2002 0 962
SPSS 2003 1 1145
SPSS 2004 0 1224
SPSS 2005 0 1320
SPSS 2006 0 1438
SPSS 2007 0 1450
SPSS 2008 0 1518
SPSS 2009 0 1551
SPSS 2010 1 1647
SPSS 2011 1 1936
SPSS 2012 0 1930
SPSS 2013 4 2052
SPSS 2014 8 2928
SPSS 2015 7 3367
SPSS 2016 4 3537
SPSS 2017 2 3587
SPSS 2018 6 3508
SPSS 2019 10 3345
SPSS 2020 5 3526
JavaScript 2000 0 933
JavaScript 2001 0 1048
JavaScript 2002 0 962
JavaScript 2003 0 1145
JavaScript 2004 0 1224
JavaScript 2005 0 1320
JavaScript 2006 0 1438
JavaScript 2007 0 1450
JavaScript 2008 0 1518
JavaScript 2009 0 1551
JavaScript 2010 1 1647
JavaScript 2011 0 1936
JavaScript 2012 0 1930
JavaScript 2013 0 2052
JavaScript 2014 0 2928
JavaScript 2015 0 3367
JavaScript 2016 0 3537
JavaScript 2017 0 3587
JavaScript 2018 0 3508
JavaScript 2019 0 3345
JavaScript 2020 0 3526
Raw
ignore_ph_results_c.csv
count name total_count year
3.0 C 476274.0 2000
4.0 C 490580.0 2001
9.0 C 506972.0 2002
12.0 C 533266.0 2003
18.0 C 576467.0 2004
17.0 C 634291.0 2005
20.0 C 682781.0 2006
23.0 C 720057.0 2007
32.0 C 770407.0 2008
25.0 C 811851.0 2009
28.0 C 877056.0 2010
26.0 C 956228.0 2011
40.0 C 1026315.0 2012
44.0 C 1088911.0 2013
38.0 C 1144012.0 2014
46.0 C 1199014.0 2015
64.0 C 1223469.0 2016
32.0 C 1247026.0 2017
41.885245901639344 C 1310826.2950819673 2018
202.0 C 476274.0 2000
221.0 C 490580.0 2001
246.0 C 506972.0 2002
261.0 C 533266.0 2003
257.0 C 576467.0 2004
352.0 C 634291.0 2005
402.0 C 682781.0 2006
448.0 C 720057.0 2007
500.0 C 770407.0 2008
465.0 C 811851.0 2009
540.0 C 877056.0 2010
581.0 C 956228.0 2011
636.0 C 1026315.0 2012
683.0 C 1088911.0 2013
755.0 C 1144012.0 2014
1127.0 C 1199014.0 2015
1659.0 C 1223469.0 2016
1641.0 C 1247026.0 2017
1409.7377049180327 C 1310826.2950819673 2018
205.0 C 476274.0 2000
240.0 C 490580.0 2001
196.0 C 506972.0 2002
243.0 C 533266.0 2003
277.0 C 576467.0 2004
272.0 C 634291.0 2005
343.0 C 682781.0 2006
349.0 C 720057.0 2007
388.0 C 770407.0 2008
396.0 C 811851.0 2009
437.0 C 877056.0 2010
528.0 C 956228.0 2011
556.0 C 1026315.0 2012
609.0 C 1088911.0 2013
754.0 C 1144012.0 2014
904.0 C 1199014.0 2015
1071.0 C 1223469.0 2016
1111.0 C 1247026.0 2017
1072.2622950819673 C 1310826.2950819673 2018
789.0 C 476274.0 2000
746.0 C 490580.0 2001
760.0 C 506972.0 2002
728.0 C 533266.0 2003
774.0 C 576467.0 2004
772.0 C 634291.0 2005
902.0 C 682781.0 2006
837.0 C 720057.0 2007
826.0 C 770407.0 2008
894.0 C 811851.0 2009
986.0 C 877056.0 2010
1089.0 C 956228.0 2011
1105.0 C 1026315.0 2012
1165.0 C 1088911.0 2013
1329.0 C 1144012.0 2014
1485.0 C 1199014.0 2015
1686.0 C 1223469.0 2016
1635.0 C 1247026.0 2017
1603.6065573770493 C 1310826.2950819673 2018
147.0 C 476274.0 2000
162.0 C 490580.0 2001
147.0 C 506972.0 2002
188.0 C 533266.0 2003
206.0 C 576467.0 2004
229.0 C 634291.0 2005
226.0 C 682781.0 2006
230.0 C 720057.0 2007
243.0 C 770407.0 2008
274.0 C 811851.0 2009
275.0 C 877056.0 2010
298.0 C 956228.0 2011
288.0 C 1026315.0 2012
331.0 C 1088911.0 2013
327.0 C 1144012.0 2014
411.0 C 1199014.0 2015
447.0 C 1223469.0 2016
474.0 C 1247026.0 2017
446.37704918032784 C 1310826.2950819673 2018
Raw
ph_results.csv
name year count total_count
Python 2000 19 477012
Python 2001 28 491223
Python 2002 37 507713
Python 2003 32 534101
Python 2004 32 577408
Python 2005 42 635161
Python 2006 44 684182
Python 2007 58 721303
Python 2008 77 771782
Python 2009 97 813234
Python 2010 117 878245
Python 2011 140 957784
Python 2012 157 1029173
Python 2013 210 1091716
Python 2014 284 1147306
Python 2015 311 1200352
Python 2016 339 1233415
Python 2017 397 1261206
Python 2018 579 1306339
Python 2019 713 1368155
Python 2020 947 1590969
R 2000 2 477012
R 2001 1 491223
R 2002 3 507713
R 2003 5 534101
R 2004 8 577408
R 2005 14 635161
R 2006 24 684182
R 2007 29 721303
R 2008 34 771782
R 2009 30 813234
R 2010 28 878245
R 2011 29 957784
R 2012 49 1029173
R 2013 31 1091716
R 2014 60 1147306
R 2015 64 1200352
R 2016 66 1233415
R 2017 58 1261206
R 2018 81 1306339
R 2019 102 1368155
R 2020 98 1590969
R 2000 186 477012
R 2001 171 491223
R 2002 190 507713
R 2003 227 534101
R 2004 267 577408
R 2005 351 635161
R 2006 395 684182
R 2007 403 721303
R 2008 441 771782
R 2009 497 813234
R 2010 501 878245
R 2011 573 957784
R 2012 656 1029173
R 2013 735 1091716
R 2014 903 1147306
R 2015 948 1200352
R 2016 1023 1233415
R 2017 1079 1261206
R 2018 1155 1306339
R 2019 1243 1368155
R 2020 1315 1590969
R 2000 61 477012
R 2001 68 491223
R 2002 64 507713
R 2003 72 534101
R 2004 84 577408
R 2005 126 635161
R 2006 135 684182
R 2007 137 721303
R 2008 156 771782
R 2009 152 813234
R 2010 193 878245
R 2011 252 957784
R 2012 251 1029173
R 2013 307 1091716
R 2014 399 1147306
R 2015 508 1200352
R 2016 613 1233415
R 2017 645 1261206
R 2018 722 1306339
R 2019 861 1368155
R 2020 1039 1590969
R 2000 158 477012
R 2001 138 491223
R 2002 145 507713
R 2003 164 534101
R 2004 172 577408
R 2005 159 635161
R 2006 323 684182
R 2007 212 721303
R 2008 224 771782
R 2009 228 813234
R 2010 256 878245
R 2011 330 957784
R 2012 387 1029173
R 2013 492 1091716
R 2014 603 1147306
R 2015 715 1200352
R 2016 771 1233415
R 2017 812 1261206
R 2018 888 1306339
R 2019 1044 1368155
R 2020 1291 1590969
R 2000 23 477012
R 2001 36 491223
R 2002 36 507713
R 2003 34 534101
R 2004 52 577408
R 2005 43 635161
R 2006 42 684182
R 2007 57 721303
R 2008 68 771782
R 2009 81 813234
R 2010 92 878245
R 2011 105 957784
R 2012 94 1029173
R 2013 140 1091716
R 2014 174 1147306
R 2015 205 1200352
R 2016 228 1233415
R 2017 293 1261206
R 2018 326 1306339
R 2019 421 1368155
R 2020 492 1590969
R 2000 192 477012
R 2001 205 491223
R 2002 154 507713
R 2003 153 534101
R 2004 143 577408
R 2005 189 635161
R 2006 209 684182
R 2007 250 721303
R 2008 361 771782
R 2009 389 813234
R 2010 478 878245
R 2011 529 957784
R 2012 714 1029173
R 2013 974 1091716
R 2014 1633 1147306
R 2015 2131 1200352
R 2016 2516 1233415
R 2017 2884 1261206
R 2018 5638 1306339
R 2019 9097 1368155
R 2020 11389 1590969
R 2000 0 477012
R 2001 1 491223
R 2002 0 507713
R 2003 1 534101
R 2004 4 577408
R 2005 0 635161
R 2006 5 684182
R 2007 6 721303
R 2008 6 771782
R 2009 4 813234
R 2010 7 878245
R 2011 12 957784
R 2012 8 1029173
R 2013 6 1091716
R 2014 12 1147306
R 2015 31 1200352
R 2016 36 1233415
R 2017 29 1261206
R 2018 41 1306339
R 2019 51 1368155
R 2020 62 1590969
SAS 2000 182 477012
SAS 2001 211 491223
SAS 2002 257 507713
SAS 2003 273 534101
SAS 2004 312 577408
SAS 2005 357 635161
SAS 2006 402 684182
SAS 2007 470 721303
SAS 2008 542 771782
SAS 2009 539 813234
SAS 2010 638 878245
SAS 2011 736 957784
SAS 2012 822 1029173
SAS 2013 843 1091716
SAS 2014 1043 1147306
SAS 2015 1244 1200352
SAS 2016 1346 1233415
SAS 2017 1454 1261206
SAS 2018 1565 1306339
SAS 2019 1755 1368155
SAS 2020 2280 1590969
SPSS 2000 90 477012
SPSS 2001 117 491223
SPSS 2002 121 507713
SPSS 2003 177 534101
SPSS 2004 209 577408
SPSS 2005 297 635161
SPSS 2006 369 684182
SPSS 2007 433 721303
SPSS 2008 589 771782
SPSS 2009 770 813234
SPSS 2010 1010 878245
SPSS 2011 1279 957784
SPSS 2012 1764 1029173
SPSS 2013 2257 1091716
SPSS 2014 2892 1147306
SPSS 2015 3210 1200352
SPSS 2016 3345 1233415
SPSS 2017 3628 1261206
SPSS 2018 3890 1306339
SPSS 2019 4491 1368155
SPSS 2020 5805 1590969
JavaScript 2000 6 477012
JavaScript 2001 10 491223
JavaScript 2002 12 507713
JavaScript 2003 2 534101
JavaScript 2004 8 577408
JavaScript 2005 11 635161
JavaScript 2006 4 684182
JavaScript 2007 14 721303
JavaScript 2008 15 771782
JavaScript 2009 15 813234
JavaScript 2010 14 878245
JavaScript 2011 15 957784
JavaScript 2012 18 1029173
JavaScript 2013 36 1091716
JavaScript 2014 47 1147306
JavaScript 2015 64 1200352
JavaScript 2016 76 1233415
JavaScript 2017 73 1261206
JavaScript 2018 76 1306339
JavaScript 2019 64 1368155
JavaScript 2020 53 1590969
Raw
ph_results_js.csv
count name total_count year
6.0 JavaScript 476274.0 2000
10.0 JavaScript 490580.0 2001
12.0 JavaScript 506972.0 2002
2.0 JavaScript 533266.0 2003
8.0 JavaScript 576467.0 2004
11.0 JavaScript 634291.0 2005
4.0 JavaScript 682781.0 2006
14.0 JavaScript 720057.0 2007
15.0 JavaScript 770407.0 2008
15.0 JavaScript 811851.0 2009
14.0 JavaScript 877056.0 2010
15.0 JavaScript 956228.0 2011
18.0 JavaScript 1026315.0 2012
36.0 JavaScript 1088911.0 2013
47.0 JavaScript 1144012.0 2014
64.0 JavaScript 1199014.0 2015
76.0 JavaScript 1223469.0 2016
72.0 JavaScript 1247026.0 2017
84.9672131147541 JavaScript 1310826.2950819673 2018
Raw
ph_results_py.csv
count name total_count year
19.0 Python 476273.0 2000
28.0 Python 490580.0 2001
37.0 Python 506972.0 2002
32.0 Python 533266.0 2003
32.0 Python 576467.0 2004
42.0 Python 634291.0 2005
44.0 Python 682781.0 2006
58.0 Python 720057.0 2007
76.0 Python 770407.0 2008
97.0 Python 811851.0 2009
117.0 Python 877056.0 2010
140.0 Python 956228.0 2011
157.0 Python 1026315.0 2012
210.0 Python 1088911.0 2013
284.0 Python 1144012.0 2014
311.0 Python 1199014.0 2015
336.0 Python 1223469.0 2016
384.0 Python 1247026.0 2017
582.8032786885246 Python 1310826.2950819673 2018
Raw
ph_results_r.csv
count name total_count year
2.0 R 476274.0 2000
1.0 R 490580.0 2001
3.0 R 506972.0 2002
5.0 R 533266.0 2003
8.0 R 576467.0 2004
14.0 R 634291.0 2005
24.0 R 682781.0 2006
29.0 R 720057.0 2007
34.0 R 770407.0 2008
30.0 R 811851.0 2009
28.0 R 877056.0 2010
29.0 R 956228.0 2011
49.0 R 1026315.0 2012
31.0 R 1088911.0 2013
60.0 R 1144012.0 2014
63.0 R 1199014.0 2015
66.0 R 1223469.0 2016
56.0 R 1247026.0 2017
64.62295081967213 R 1310826.2950819673 2018
185.0 R 476274.0 2000
170.0 R 490580.0 2001
190.0 R 506972.0 2002
226.0 R 533266.0 2003
267.0 R 576467.0 2004
350.0 R 634291.0 2005
394.0 R 682781.0 2006
401.0 R 720057.0 2007
439.0 R 770407.0 2008
497.0 R 811851.0 2009
498.0 R 877056.0 2010
574.0 R 956228.0 2011
658.0 R 1026315.0 2012
739.0 R 1088911.0 2013
901.0 R 1144012.0 2014
948.0 R 1199014.0 2015
1018.0 R 1223469.0 2016
1005.0 R 1247026.0 2017
921.4754098360655 R 1310826.2950819673 2018
62.0 R 476274.0 2000
68.0 R 490580.0 2001
64.0 R 506972.0 2002
72.0 R 533266.0 2003
84.0 R 576467.0 2004
126.0 R 634291.0 2005
136.0 R 682781.0 2006
139.0 R 720057.0 2007
156.0 R 770407.0 2008
151.0 R 811851.0 2009
192.0 R 877056.0 2010
251.0 R 956228.0 2011
251.0 R 1026315.0 2012
309.0 R 1088911.0 2013
398.0 R 1144012.0 2014
509.0 R 1199014.0 2015
605.0 R 1223469.0 2016
628.0 R 1247026.0 2017
677.344262295082 R 1310826.2950819673 2018
157.0 R 476274.0 2000
136.0 R 490580.0 2001
146.0 R 506972.0 2002
161.0 R 533266.0 2003
172.0 R 576467.0 2004
159.0 R 634291.0 2005
311.0 R 682781.0 2006
211.0 R 720057.0 2007
221.0 R 770407.0 2008
224.0 R 811851.0 2009
256.0 R 877056.0 2010
327.0 R 956228.0 2011
388.0 R 1026315.0 2012
490.0 R 1088911.0 2013
601.0 R 1144012.0 2014
713.0 R 1199014.0 2015
769.0 R 1223469.0 2016
790.0 R 1247026.0 2017
852.0655737704918 R 1310826.2950819673 2018
23.0 R 476274.0 2000
36.0 R 490580.0 2001
36.0 R 506972.0 2002
34.0 R 533266.0 2003
52.0 R 576467.0 2004
43.0 R 634291.0 2005
42.0 R 682781.0 2006
57.0 R 720057.0 2007
68.0 R 770407.0 2008
81.0 R 811851.0 2009
92.0 R 877056.0 2010
106.0 R 956228.0 2011
93.0 R 1026315.0 2012
140.0 R 1088911.0 2013
173.0 R 1144012.0 2014
205.0 R 1199014.0 2015
227.0 R 1223469.0 2016
291.0 R 1247026.0 2017
330.2950819672131 R 1310826.2950819673 2018
Raw
ph_results_sas.csv
count name total_count year
182.0 SAS 476274.0 2000
209.0 SAS 490580.0 2001
257.0 SAS 506972.0 2002
273.0 SAS 533266.0 2003
313.0 SAS 576467.0 2004
357.0 SAS 634291.0 2005
401.0 SAS 682781.0 2006
467.0 SAS 720057.0 2007
539.0 SAS 770407.0 2008
537.0 SAS 811851.0 2009
637.0 SAS 877056.0 2010
732.0 SAS 956228.0 2011
820.0 SAS 1026315.0 2012
842.0 SAS 1088911.0 2013
1040.0 SAS 1144012.0 2014
1259.0 SAS 1199014.0 2015
1345.0 SAS 1223469.0 2016
1437.0 SAS 1247026.0 2017
1540.1803278688524 SAS 1310826.2950819673 2018
Raw
ph_results_spss.csv
count name total_count year
90.0 SPSS 476274.0 2000
117.0 SPSS 490580.0 2001
121.0 SPSS 506972.0 2002
177.0 SPSS 533266.0 2003
209.0 SPSS 576467.0 2004
297.0 SPSS 634291.0 2005
369.0 SPSS 682781.0 2006
433.0 SPSS 720057.0 2007
588.0 SPSS 770407.0 2008
767.0 SPSS 811851.0 2009
1009.0 SPSS 877056.0 2010
1279.0 SPSS 956228.0 2011
1764.0 SPSS 1026315.0 2012
2256.0 SPSS 1088911.0 2013
2890.0 SPSS 1144012.0 2014
3207.0 SPSS 1199014.0 2015
3335.0 SPSS 1223469.0 2016
3567.0 SPSS 1247026.0 2017
3560.245901639344 SPSS 1310826.2950819673 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment