Created
May 20, 2016 05:03
-
-
Save ChillarAnand/922e15eb1c99a14559e42a921f1a983e to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| year questions answers | |
| ---- --------- ------- | |
| 2008 58903 221891 | |
| 2009 345934 957882 | |
| 2010 703073 1482175 | |
| 2011 1213325 2295104 | |
| 2012 1664439 2856400 | |
| 2013 2076711 3357122 | |
| 2014 2179821 3238804 | |
| 2015 2409834 3196377 | |
| 2016 1017110 1247044 | |
| (9 row(s) returned) | |
| year total_questions total_answers | |
| ---- --------------- ------------- | |
| 2008 70372 332383 | |
| 2009 394567 1188382 | |
| 2010 820161 1763772 | |
| 2011 1445142 2657936 | |
| 2012 2065664 3328785 | |
| 2013 2759442 3969998 | |
| 2014 3040440 3801302 | |
| 2015 3105720 3704174 | |
| 2016 1238114 1438269 | |
| (9 row(s) returned) | |
| year Edits | |
| ---- ------- | |
| 2008 69917 | |
| 2009 427154 | |
| 2010 757950 | |
| 2011 1461840 | |
| 2012 2230815 | |
| 2013 2822375 | |
| 2014 2942708 | |
| 2015 3333602 | |
| 2016 1356988 | |
| (9 row(s) returned) | |
| year comments | |
| ---- -------- | |
| 2008 141329 | |
| 2009 1259320 | |
| 2010 2552973 | |
| 2011 4802768 | |
| 2012 7028446 | |
| 2013 9179700 | |
| 2014 9476544 | |
| 2015 9853160 | |
| 2016 3974448 | |
| (9 row(s) returned) | |
| year accepts upvotes downvotes | |
| ---- ------- -------- --------- | |
| 2008 31537 779067 75803 | |
| 2009 227738 2899631 222929 | |
| 2010 467459 4198940 256806 | |
| 2011 798308 6630761 460376 | |
| 2012 1069568 9908135 949267 | |
| 2013 1168478 12969507 1613021 | |
| 2014 1173153 13434907 1986380 | |
| 2015 1125384 15604647 2252340 | |
| 2016 435253 6425720 927205 | |
| (9 row(s) returned) | |
| Post Link ViewCount | |
| ---------------------------------------------------------------------------------------------------------------------------- --------- | |
| iOS9 Untrusted Enterprise Developer with no option to trust 303844 | |
| How do I install a Python package with a .whl file? 250233 | |
| Xcode error "Could not find Developer Disk Image" 246377 | |
| Transport Security has Blocked a cleartext HTTP 232249 | |
| PHP7 : Missing VCRUNTIME140.dll 205256 | |
| Error retrieving parent for item: No resource found that matches the given name after upgrading to AppCompat v23 203142 | |
| HttpClient won't import in Android Studio 159437 | |
| How to add an image to the "drawable" folder in Android Studio? 143339 | |
| InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately 132482 | |
| New warnings in iOS 9 131327 | |
| (10 row(s) returned) | |
| Post Link Score | |
| ---------------------------------------------------------------------------------------------------------------- ----- | |
| New warnings in iOS 9 939 | |
| Transport Security has Blocked a cleartext HTTP 671 | |
| Android Studio Rename Package 652 | |
| Why does "not(True) in [False, True]" return False? 650 | |
| Error retrieving parent for item: No resource found that matches the given name after upgrading to AppCompat v23 640 | |
| Why is 1000000000000000 in range(1000000000000001) so fast in Python 3? 633 | |
| How do I test for an empty JavaScript object? 633 | |
| Complex Git branch name broke all Git commands 605 | |
| Why is executing Java code in comments with certain Unicode characters allowed? 588 | |
| iOS9 Untrusted Enterprise Developer with no option to trust 586 | |
| (10 row(s) returned) | |
| Post Link anon_up anon_down anon_score | |
| ----------------------------------------------------------------------------------- ------- --------- ---------- | |
| Multiple Errors Installing Visual Studio 2015 Community Edition 289 1 288 | |
| Error:Unable to run mksdcard SDK tool in ubuntu 253 17 236 | |
| iOS9 Untrusted Enterprise Developer with no option to trust 418 188 230 | |
| New warnings in iOS 9 209 5 204 | |
| Unable to install Android Studio in Ubuntu 255 57 198 | |
| The Android emulator is out of view, how can I move it? 185 9 176 | |
| XAMPP : Couldn't start Apache (Windows 10) 199 27 172 | |
| Netbeans IDE 8.0.2 C++ Input/Output Error 194 31 163 | |
| Xcode 6 crashes on submitting Archive 158 2 156 | |
| android.support.v7.internal.widget.ActionBarOverlayLayout could not be instantiated 180 26 154 | |
| (10 row(s) returned) | |
| year new_users | |
| ---- --------- | |
| 2008 21721 | |
| 2009 78410 | |
| 2010 201260 | |
| 2011 362061 | |
| 2012 727722 | |
| 2013 1130602 | |
| 2014 1185788 | |
| 2015 1271272 | |
| 2016 589196 | |
| (9 row(s) returned) | |
| month new_users | |
| ----- --------- | |
| 1 100126 | |
| 2 97952 | |
| 3 111350 | |
| 4 111648 | |
| 5 102521 | |
| 6 103323 | |
| 7 107820 | |
| 8 102165 | |
| 9 105033 | |
| 10 111985 | |
| 11 109091 | |
| 12 108258 | |
| (12 row(s) returned) | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import matplotlib.pyplot as plt | |
| import numpy as np | |
| users = [ | |
| '2008 21721', | |
| '2009 78410', | |
| '2010 201260', | |
| '2011 362061', | |
| '2012 727722', | |
| '2013 1130602', | |
| '2014 1185788', | |
| '2015 1271272', | |
| '2016 589196', | |
| ] | |
| users = [i.split() for i in users[:-1]] | |
| user_data = [int(i[1]) for i in users] | |
| years = [int(i[0]) for i in users] | |
| plt.xticks(years, years) | |
| plt.plot(years, user_data) | |
| plt.legend(['New Users'], loc='upper left') | |
| plt.show() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment