Skip to content

Instantly share code, notes, and snippets.

@n0vad3v n0vad3v/996.ipynb Secret
Last active Apr 9, 2019

Embed
What would you like to do?
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "996.ipynb",
"version": "0.3.2",
"provenance": [],
"collapsed_sections": [],
"toc_visible": true
},
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
}
},
"cells": [
{
"metadata": {
"colab_type": "code",
"id": "opRBUs6iAbLB",
"colab": {}
},
"cell_type": "code",
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"import datetime"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"colab_type": "code",
"id": "180i_TcAApNM",
"colab": {}
},
"cell_type": "code",
"source": [
"df = pd.read_csv('996-stargazers-180000.csv')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "1Fb5-_6swMVr",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"数据预览如下:"
]
},
{
"metadata": {
"colab_type": "code",
"id": "m4mAErhfBEzE",
"outputId": "baf70914-ab20-4c19-fc9c-624df6c3f5c9",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 309
}
},
"cell_type": "code",
"source": [
"df.head()"
],
"execution_count": 3,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>username</th>\n",
" <th>name</th>\n",
" <th>blog</th>\n",
" <th>company</th>\n",
" <th>bio</th>\n",
" <th>avatar_url</th>\n",
" <th>hireable</th>\n",
" <th>num_followers</th>\n",
" <th>num_following</th>\n",
" <th>created_at</th>\n",
" <th>star_time</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>weaming</td>\n",
" <td>garden.yuen</td>\n",
" <td>https://bitsflow.org</td>\n",
" <td>NaN</td>\n",
" <td>Python/Go/Rust/Crystal/Haskell/Vue</td>\n",
" <td>https://avatars0.githubusercontent.com/u/10275...</td>\n",
" <td>False</td>\n",
" <td>61</td>\n",
" <td>295</td>\n",
" <td>2014-12-22 21:06:21</td>\n",
" <td>2019-03-26 02:41:28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>LaoJJ</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/26458...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2017-03-16 06:10:57</td>\n",
" <td>2019-03-26 02:42:14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>134355</td>\n",
" <td>ljw</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/38032...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2018-04-03 03:21:19</td>\n",
" <td>2019-03-26 02:42:26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Shaman05</td>\n",
" <td>shaman</td>\n",
" <td>http://shaman05.github.io/</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/95175...</td>\n",
" <td>False</td>\n",
" <td>28</td>\n",
" <td>0</td>\n",
" <td>2011-08-01 08:32:32</td>\n",
" <td>2019-03-26 02:42:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>xyz0z0</td>\n",
" <td>xyz0z0</td>\n",
" <td>https://xyz0z0.xyz/</td>\n",
" <td>NaN</td>\n",
" <td>Just do it.</td>\n",
" <td>https://avatars0.githubusercontent.com/u/54773...</td>\n",
" <td>False</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>2013-09-17 06:06:25</td>\n",
" <td>2019-03-26 02:43:34</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" username name blog company \\\n",
"0 weaming garden.yuen https://bitsflow.org NaN \n",
"1 LaoJJ NaN NaN NaN \n",
"2 134355 ljw NaN NaN \n",
"3 Shaman05 shaman http://shaman05.github.io/ NaN \n",
"4 xyz0z0 xyz0z0 https://xyz0z0.xyz/ NaN \n",
"\n",
" bio \\\n",
"0 Python/Go/Rust/Crystal/Haskell/Vue \n",
"1 NaN \n",
"2 NaN \n",
"3 NaN \n",
"4 Just do it. \n",
"\n",
" avatar_url hireable num_followers \\\n",
"0 https://avatars0.githubusercontent.com/u/10275... False 61 \n",
"1 https://avatars0.githubusercontent.com/u/26458... False 0 \n",
"2 https://avatars1.githubusercontent.com/u/38032... False 0 \n",
"3 https://avatars1.githubusercontent.com/u/95175... False 28 \n",
"4 https://avatars0.githubusercontent.com/u/54773... False 1 \n",
"\n",
" num_following created_at star_time \n",
"0 295 2014-12-22 21:06:21 2019-03-26 02:41:28 \n",
"1 0 2017-03-16 06:10:57 2019-03-26 02:42:14 \n",
"2 1 2018-04-03 03:21:19 2019-03-26 02:42:26 \n",
"3 0 2011-08-01 08:32:32 2019-03-26 02:42:49 \n",
"4 12 2013-09-17 06:06:25 2019-03-26 02:43:34 "
]
},
"metadata": {
"tags": []
},
"execution_count": 3
}
]
},
{
"metadata": {
"id": "FrUhkUZ6wMV5",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"# 清洗数据\n",
"\n",
"由于通过脚本爬取下来的数据比较乱(时区也是错的,为 UTC-5),所以第一步是对数据有一个基本的清洗,从把时区转换为 UTC+8 开始~"
]
},
{
"metadata": {
"id": "8eXdO0RAwMV7",
"colab_type": "code",
"colab": {}
},
"cell_type": "code",
"source": [
"df['star_time'] = pd.to_datetime(df['star_time'])\n",
"df['created_at'] = pd.to_datetime(df['created_at'])\n",
"df['star_time'] = df['star_time'] + pd.to_timedelta('13hr')\n",
"df['created_at'] = df['created_at'] + pd.to_timedelta('13hr')"
],
"execution_count": 0,
"outputs": []
},
{
"metadata": {
"id": "olkN9ZvewMWA",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"按照给仓库点 Star 的时间排序(顺序)"
]
},
{
"metadata": {
"colab_type": "code",
"id": "jMA75JgCI-Rj",
"outputId": "743d2977-8f31-4569-bc42-3fcd8a29c508",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 3026
}
},
"cell_type": "code",
"source": [
"df.sort_values('star_time')"
],
"execution_count": 5,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>username</th>\n",
" <th>name</th>\n",
" <th>blog</th>\n",
" <th>company</th>\n",
" <th>bio</th>\n",
" <th>avatar_url</th>\n",
" <th>hireable</th>\n",
" <th>num_followers</th>\n",
" <th>num_following</th>\n",
" <th>created_at</th>\n",
" <th>star_time</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>weaming</td>\n",
" <td>garden.yuen</td>\n",
" <td>https://bitsflow.org</td>\n",
" <td>NaN</td>\n",
" <td>Python/Go/Rust/Crystal/Haskell/Vue</td>\n",
" <td>https://avatars0.githubusercontent.com/u/10275...</td>\n",
" <td>False</td>\n",
" <td>61</td>\n",
" <td>295</td>\n",
" <td>2014-12-23 10:06:21</td>\n",
" <td>2019-03-26 15:41:28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>LaoJJ</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/26458...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2017-03-16 19:10:57</td>\n",
" <td>2019-03-26 15:42:14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>134355</td>\n",
" <td>ljw</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/38032...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2018-04-03 16:21:19</td>\n",
" <td>2019-03-26 15:42:26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Shaman05</td>\n",
" <td>shaman</td>\n",
" <td>http://shaman05.github.io/</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/95175...</td>\n",
" <td>False</td>\n",
" <td>28</td>\n",
" <td>0</td>\n",
" <td>2011-08-01 21:32:32</td>\n",
" <td>2019-03-26 15:42:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>xyz0z0</td>\n",
" <td>xyz0z0</td>\n",
" <td>https://xyz0z0.xyz/</td>\n",
" <td>NaN</td>\n",
" <td>Just do it.</td>\n",
" <td>https://avatars0.githubusercontent.com/u/54773...</td>\n",
" <td>False</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>2013-09-17 19:06:25</td>\n",
" <td>2019-03-26 15:43:34</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>PeterCxy</td>\n",
" <td>Peter Cai</td>\n",
" <td>https://typeblog.net</td>\n",
" <td>NaN</td>\n",
" <td>Undergraduate student at Xi'an Jiaotong-Liverp...</td>\n",
" <td>https://avatars1.githubusercontent.com/u/45324...</td>\n",
" <td>False</td>\n",
" <td>708</td>\n",
" <td>31</td>\n",
" <td>2013-05-26 20:01:47</td>\n",
" <td>2019-03-26 15:43:36</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>lodgbore</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/35795...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-01-25 15:13:03</td>\n",
" <td>2019-03-26 15:43:39</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>zhengqingxin</td>\n",
" <td>郑庆鑫</td>\n",
" <td>https://www.zhengqingxin.com</td>\n",
" <td>@75team</td>\n",
" <td>Not just a coder.</td>\n",
" <td>https://avatars3.githubusercontent.com/u/18438...</td>\n",
" <td>False</td>\n",
" <td>20</td>\n",
" <td>70</td>\n",
" <td>2016-04-13 16:37:09</td>\n",
" <td>2019-03-26 15:43:43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>amendgit</td>\n",
" <td>辰申</td>\n",
" <td>NaN</td>\n",
" <td>USTC</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/17930...</td>\n",
" <td>False</td>\n",
" <td>20</td>\n",
" <td>10</td>\n",
" <td>2012-05-30 19:05:12</td>\n",
" <td>2019-03-26 15:43:56</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>ianthonywan</td>\n",
" <td>万千</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/12031...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2015-04-20 18:08:03</td>\n",
" <td>2019-03-26 15:44:00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>jinfa</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/38729...</td>\n",
" <td>False</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>2013-03-15 16:56:49</td>\n",
" <td>2019-03-26 15:44:15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>ddmy</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/19168...</td>\n",
" <td>False</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>2016-05-03 20:11:07</td>\n",
" <td>2019-03-26 15:45:11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>fighterleslie</td>\n",
" <td>张雪松</td>\n",
" <td>http://fighterleslie.com</td>\n",
" <td>Udesk</td>\n",
" <td>A passionate and pragmatic programmer</td>\n",
" <td>https://avatars2.githubusercontent.com/u/83189...</td>\n",
" <td>False</td>\n",
" <td>16</td>\n",
" <td>78</td>\n",
" <td>2014-07-31 17:35:57</td>\n",
" <td>2019-03-26 15:45:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>feng0403</td>\n",
" <td>feng0403</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/68834...</td>\n",
" <td>False</td>\n",
" <td>4</td>\n",
" <td>16</td>\n",
" <td>2014-03-07 20:52:03</td>\n",
" <td>2019-03-26 15:45:30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>zsn1224</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/35883...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-01-28 11:13:51</td>\n",
" <td>2019-03-26 15:46:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>chenhuiyangxin</td>\n",
" <td>陈鑫</td>\n",
" <td>NaN</td>\n",
" <td>同花顺</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/10590...</td>\n",
" <td>False</td>\n",
" <td>3</td>\n",
" <td>7</td>\n",
" <td>2015-01-19 11:17:40</td>\n",
" <td>2019-03-26 15:47:45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>yuname</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/16079...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>2015-11-30 16:53:10</td>\n",
" <td>2019-03-26 15:49:17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>panhainan</td>\n",
" <td>潘海南</td>\n",
" <td>https://sixteen.site</td>\n",
" <td>NaN</td>\n",
" <td>不破不立!</td>\n",
" <td>https://avatars1.githubusercontent.com/u/78844...</td>\n",
" <td>False</td>\n",
" <td>65</td>\n",
" <td>99</td>\n",
" <td>2014-06-14 06:37:41</td>\n",
" <td>2019-03-26 15:49:28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>hdwmp123</td>\n",
" <td>KingTiger</td>\n",
" <td>http://www.diandian.com/dianlog/goletiger</td>\n",
" <td>Carsmart</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/52183...</td>\n",
" <td>True</td>\n",
" <td>5</td>\n",
" <td>33</td>\n",
" <td>2013-08-13 11:02:51</td>\n",
" <td>2019-03-26 15:49:48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>tiny-yfj</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/31646...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2017-09-05 15:11:59</td>\n",
" <td>2019-03-26 15:50:00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>zgsdharry</td>\n",
" <td>Harry</td>\n",
" <td>http://haoshengzhide.com/</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/32243...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>2013-01-09 17:47:53</td>\n",
" <td>2019-03-26 15:50:19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>ddatsh</td>\n",
" <td>peter zhang</td>\n",
" <td>https://ddatsh.com</td>\n",
" <td>NaN</td>\n",
" <td>java &amp; go</td>\n",
" <td>https://avatars0.githubusercontent.com/u/18091...</td>\n",
" <td>True</td>\n",
" <td>13</td>\n",
" <td>3</td>\n",
" <td>2012-06-02 17:35:06</td>\n",
" <td>2019-03-26 15:52:03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>JaxWilliams</td>\n",
" <td>JaxWillliams</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>to be better</td>\n",
" <td>https://avatars1.githubusercontent.com/u/17276...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>2016-02-17 00:18:32</td>\n",
" <td>2019-03-26 15:52:14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>holmium</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Strange</td>\n",
" <td>https://avatars3.githubusercontent.com/u/22557...</td>\n",
" <td>True</td>\n",
" <td>53</td>\n",
" <td>0</td>\n",
" <td>2012-08-31 23:14:17</td>\n",
" <td>2019-03-26 15:52:55</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>BroncoTc</td>\n",
" <td>BroncoTc</td>\n",
" <td>https://broncotc.net</td>\n",
" <td>NaN</td>\n",
" <td>Student Developer @ UC Irvine</td>\n",
" <td>https://avatars1.githubusercontent.com/u/70974...</td>\n",
" <td>False</td>\n",
" <td>72</td>\n",
" <td>77</td>\n",
" <td>2014-03-29 08:56:28</td>\n",
" <td>2019-03-26 15:52:58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>buaaljy</td>\n",
" <td>buaaljy</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/80119...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>2014-06-28 17:34:32</td>\n",
" <td>2019-03-26 15:53:35</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>longlongh4</td>\n",
" <td>hailong</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/77854...</td>\n",
" <td>False</td>\n",
" <td>8</td>\n",
" <td>6</td>\n",
" <td>2011-05-10 15:40:30</td>\n",
" <td>2019-03-26 15:54:10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>silence-ice</td>\n",
" <td>BinHuang</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/14326...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2015-09-17 15:49:14</td>\n",
" <td>2019-03-26 15:55:05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>zouyifeng</td>\n",
" <td>大头</td>\n",
" <td>https://zouyifeng.xyz</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/22537...</td>\n",
" <td>False</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>2016-09-30 14:04:54</td>\n",
" <td>2019-03-26 15:55:26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>xpflying</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/17597...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2016-03-03 00:13:47</td>\n",
" <td>2019-03-26 15:55:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176822</th>\n",
" <td>lvi166</td>\n",
" <td>lvi</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/18674...</td>\n",
" <td>False</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>2016-04-26 14:28:36</td>\n",
" <td>2019-04-05 16:00:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176823</th>\n",
" <td>TAGHAN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/43736...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-10-01 10:52:10</td>\n",
" <td>2019-04-05 16:01:00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176824</th>\n",
" <td>fan1997</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/22073...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>2016-09-08 17:18:21</td>\n",
" <td>2019-04-05 16:01:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176825</th>\n",
" <td>LJM-GitHub</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/35515...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-01-17 11:38:18</td>\n",
" <td>2019-04-05 16:01:04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176826</th>\n",
" <td>sdzer</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/34713...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2017-12-20 20:59:56</td>\n",
" <td>2019-04-05 16:01:09</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176827</th>\n",
" <td>Janewhite</td>\n",
" <td>White easily</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/22785...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2016-10-12 14:06:32</td>\n",
" <td>2019-04-05 16:01:13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176828</th>\n",
" <td>liu7654</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/45345...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2018-11-26 10:51:10</td>\n",
" <td>2019-04-05 16:01:31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176829</th>\n",
" <td>linf233</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/37804...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-03-26 21:33:48</td>\n",
" <td>2019-04-05 16:01:45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176830</th>\n",
" <td>BenjaminBao</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/49303...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2019-04-05 16:00:39</td>\n",
" <td>2019-04-05 16:02:32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176831</th>\n",
" <td>Melonl</td>\n",
" <td>Melonl</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Chinese developer</td>\n",
" <td>https://avatars0.githubusercontent.com/u/12196...</td>\n",
" <td>False</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>2015-05-01 16:26:42</td>\n",
" <td>2019-04-05 16:02:32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176832</th>\n",
" <td>dengachao</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/40375...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2018-06-19 09:26:40</td>\n",
" <td>2019-04-05 16:02:53</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176833</th>\n",
" <td>sweshixing</td>\n",
" <td>ShiX</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/24455...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>5</td>\n",
" <td>2016-12-08 20:42:13</td>\n",
" <td>2019-04-05 16:03:25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176834</th>\n",
" <td>Keatooon</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/76650...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>2014-05-22 14:08:49</td>\n",
" <td>2019-04-05 16:03:33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176835</th>\n",
" <td>iberlins</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/33252...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2017-10-31 18:47:26</td>\n",
" <td>2019-04-05 16:03:48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176836</th>\n",
" <td>pjr2020</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/29218...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2017-06-06 09:49:48</td>\n",
" <td>2019-04-05 16:03:59</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176837</th>\n",
" <td>jtaylor351</td>\n",
" <td>Jordan</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>A math nerd that moonlights as a web developer</td>\n",
" <td>https://avatars1.githubusercontent.com/u/28931...</td>\n",
" <td>False</td>\n",
" <td>6</td>\n",
" <td>34</td>\n",
" <td>2017-05-25 01:57:17</td>\n",
" <td>2019-04-05 16:04:08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176838</th>\n",
" <td>uPeak</td>\n",
" <td>Special-iFeng</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>植根于内心的修养,\\r\\n无需提醒的自觉,\\r\\n以约束为前提的自由,\\r\\n为别人着想的善良</td>\n",
" <td>https://avatars0.githubusercontent.com/u/25560...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2017-02-05 14:39:14</td>\n",
" <td>2019-04-05 16:04:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176839</th>\n",
" <td>mrzhang638993</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/33189...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2017-10-29 09:41:07</td>\n",
" <td>2019-04-05 16:05:01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176840</th>\n",
" <td>a0919610611</td>\n",
" <td>Yu-Fu,Fu</td>\n",
" <td>https://twleo.com</td>\n",
" <td>NaN</td>\n",
" <td>commonly used ID: a0919610611 / fuyu0425 / twleo</td>\n",
" <td>https://avatars3.githubusercontent.com/u/15128...</td>\n",
" <td>False</td>\n",
" <td>55</td>\n",
" <td>132</td>\n",
" <td>2015-10-15 00:17:02</td>\n",
" <td>2019-04-05 16:05:07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176841</th>\n",
" <td>TulDuRu</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/40054...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-06-08 15:20:58</td>\n",
" <td>2019-04-05 16:05:12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176842</th>\n",
" <td>LegendStatus</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars3.githubusercontent.com/u/47369...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2019-02-06 05:37:24</td>\n",
" <td>2019-04-05 16:05:18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176843</th>\n",
" <td>HangyuTian</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/22817...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2016-10-13 22:09:33</td>\n",
" <td>2019-04-05 16:05:28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176844</th>\n",
" <td>iceman1212</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/61219...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2013-12-06 18:21:39</td>\n",
" <td>2019-04-05 16:05:30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176845</th>\n",
" <td>LilyLee1996</td>\n",
" <td>鹿鹿</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars3.githubusercontent.com/u/20370...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2016-07-09 21:46:26</td>\n",
" <td>2019-04-05 16:05:56</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176846</th>\n",
" <td>zhuoqiang</td>\n",
" <td>ZHUO Qiang</td>\n",
" <td>http://zhuoqiang.me</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars3.githubusercontent.com/u/63909...</td>\n",
" <td>False</td>\n",
" <td>16</td>\n",
" <td>1</td>\n",
" <td>2011-02-26 11:07:13</td>\n",
" <td>2019-04-05 16:06:12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176847</th>\n",
" <td>ZGMFX25A</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/45308...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-11-24 17:38:11</td>\n",
" <td>2019-04-05 16:06:14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176848</th>\n",
" <td>IIvguan</td>\n",
" <td>Timothy</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/26371...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>2017-03-13 10:36:41</td>\n",
" <td>2019-04-05 16:06:51</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176849</th>\n",
" <td>Pash237</td>\n",
" <td>Pavel Alexeev</td>\n",
" <td>00b.in</td>\n",
" <td>NaN</td>\n",
" <td>iOS Developer, St. Petersburg, Russia</td>\n",
" <td>https://avatars3.githubusercontent.com/u/27762...</td>\n",
" <td>False</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>2010-05-15 18:00:45</td>\n",
" <td>2019-04-05 16:06:58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176850</th>\n",
" <td>xiaobu8806</td>\n",
" <td>Jin Zhang</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/37540...</td>\n",
" <td>True</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-03-19 19:55:04</td>\n",
" <td>2019-04-05 16:07:00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>176851</th>\n",
" <td>nautybit</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/24488...</td>\n",
" <td>False</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>2016-12-10 13:57:56</td>\n",
" <td>2019-04-05 16:07:31</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>176852 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
" username name \\\n",
"0 weaming garden.yuen \n",
"1 LaoJJ NaN \n",
"2 134355 ljw \n",
"3 Shaman05 shaman \n",
"4 xyz0z0 xyz0z0 \n",
"5 PeterCxy Peter Cai \n",
"6 lodgbore NaN \n",
"7 zhengqingxin 郑庆鑫 \n",
"8 amendgit 辰申 \n",
"9 ianthonywan 万千 \n",
"10 jinfa NaN \n",
"11 ddmy NaN \n",
"12 fighterleslie 张雪松 \n",
"13 feng0403 feng0403 \n",
"14 zsn1224 NaN \n",
"15 chenhuiyangxin 陈鑫 \n",
"16 yuname NaN \n",
"17 panhainan 潘海南 \n",
"18 hdwmp123 KingTiger \n",
"19 tiny-yfj NaN \n",
"20 zgsdharry Harry \n",
"21 ddatsh peter zhang \n",
"22 JaxWilliams JaxWillliams \n",
"23 holmium NaN \n",
"24 BroncoTc BroncoTc \n",
"25 buaaljy buaaljy \n",
"26 longlongh4 hailong \n",
"27 silence-ice BinHuang \n",
"28 zouyifeng 大头 \n",
"29 xpflying NaN \n",
"... ... ... \n",
"176822 lvi166 lvi \n",
"176823 TAGHAN NaN \n",
"176824 fan1997 NaN \n",
"176825 LJM-GitHub NaN \n",
"176826 sdzer NaN \n",
"176827 Janewhite White easily \n",
"176828 liu7654 NaN \n",
"176829 linf233 NaN \n",
"176830 BenjaminBao NaN \n",
"176831 Melonl Melonl \n",
"176832 dengachao NaN \n",
"176833 sweshixing ShiX \n",
"176834 Keatooon NaN \n",
"176835 iberlins NaN \n",
"176836 pjr2020 NaN \n",
"176837 jtaylor351 Jordan \n",
"176838 uPeak Special-iFeng \n",
"176839 mrzhang638993 NaN \n",
"176840 a0919610611 Yu-Fu,Fu \n",
"176841 TulDuRu NaN \n",
"176842 LegendStatus NaN \n",
"176843 HangyuTian NaN \n",
"176844 iceman1212 NaN \n",
"176845 LilyLee1996 鹿鹿 \n",
"176846 zhuoqiang ZHUO Qiang \n",
"176847 ZGMFX25A NaN \n",
"176848 IIvguan Timothy \n",
"176849 Pash237 Pavel Alexeev \n",
"176850 xiaobu8806 Jin Zhang \n",
"176851 nautybit NaN \n",
"\n",
" blog company \\\n",
"0 https://bitsflow.org NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 http://shaman05.github.io/ NaN \n",
"4 https://xyz0z0.xyz/ NaN \n",
"5 https://typeblog.net NaN \n",
"6 NaN NaN \n",
"7 https://www.zhengqingxin.com @75team \n",
"8 NaN USTC \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 http://fighterleslie.com Udesk \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 NaN 同花顺 \n",
"16 NaN NaN \n",
"17 https://sixteen.site NaN \n",
"18 http://www.diandian.com/dianlog/goletiger Carsmart \n",
"19 NaN NaN \n",
"20 http://haoshengzhide.com/ NaN \n",
"21 https://ddatsh.com NaN \n",
"22 NaN NaN \n",
"23 NaN NaN \n",
"24 https://broncotc.net NaN \n",
"25 NaN NaN \n",
"26 NaN NaN \n",
"27 NaN NaN \n",
"28 https://zouyifeng.xyz NaN \n",
"29 NaN NaN \n",
"... ... ... \n",
"176822 NaN NaN \n",
"176823 NaN NaN \n",
"176824 NaN NaN \n",
"176825 NaN NaN \n",
"176826 NaN NaN \n",
"176827 NaN NaN \n",
"176828 NaN NaN \n",
"176829 NaN NaN \n",
"176830 NaN NaN \n",
"176831 NaN NaN \n",
"176832 NaN NaN \n",
"176833 NaN NaN \n",
"176834 NaN NaN \n",
"176835 NaN NaN \n",
"176836 NaN NaN \n",
"176837 NaN NaN \n",
"176838 NaN NaN \n",
"176839 NaN NaN \n",
"176840 https://twleo.com NaN \n",
"176841 NaN NaN \n",
"176842 NaN NaN \n",
"176843 NaN NaN \n",
"176844 NaN NaN \n",
"176845 NaN NaN \n",
"176846 http://zhuoqiang.me NaN \n",
"176847 NaN NaN \n",
"176848 NaN NaN \n",
"176849 00b.in NaN \n",
"176850 NaN NaN \n",
"176851 NaN NaN \n",
"\n",
" bio \\\n",
"0 Python/Go/Rust/Crystal/Haskell/Vue \n",
"1 NaN \n",
"2 NaN \n",
"3 NaN \n",
"4 Just do it. \n",
"5 Undergraduate student at Xi'an Jiaotong-Liverp... \n",
"6 NaN \n",
"7 Not just a coder. \n",
"8 NaN \n",
"9 NaN \n",
"10 NaN \n",
"11 NaN \n",
"12 A passionate and pragmatic programmer \n",
"13 NaN \n",
"14 NaN \n",
"15 NaN \n",
"16 NaN \n",
"17 不破不立! \n",
"18 NaN \n",
"19 NaN \n",
"20 NaN \n",
"21 java & go \n",
"22 to be better \n",
"23 Strange \n",
"24 Student Developer @ UC Irvine \n",
"25 NaN \n",
"26 NaN \n",
"27 NaN \n",
"28 NaN \n",
"29 NaN \n",
"... ... \n",
"176822 NaN \n",
"176823 NaN \n",
"176824 NaN \n",
"176825 NaN \n",
"176826 NaN \n",
"176827 NaN \n",
"176828 NaN \n",
"176829 NaN \n",
"176830 NaN \n",
"176831 Chinese developer \n",
"176832 NaN \n",
"176833 NaN \n",
"176834 NaN \n",
"176835 NaN \n",
"176836 NaN \n",
"176837 A math nerd that moonlights as a web developer \n",
"176838 植根于内心的修养,\\r\\n无需提醒的自觉,\\r\\n以约束为前提的自由,\\r\\n为别人着想的善良 \n",
"176839 NaN \n",
"176840 commonly used ID: a0919610611 / fuyu0425 / twleo \n",
"176841 NaN \n",
"176842 NaN \n",
"176843 NaN \n",
"176844 NaN \n",
"176845 NaN \n",
"176846 NaN \n",
"176847 NaN \n",
"176848 NaN \n",
"176849 iOS Developer, St. Petersburg, Russia \n",
"176850 NaN \n",
"176851 NaN \n",
"\n",
" avatar_url hireable \\\n",
"0 https://avatars0.githubusercontent.com/u/10275... False \n",
"1 https://avatars0.githubusercontent.com/u/26458... False \n",
"2 https://avatars1.githubusercontent.com/u/38032... False \n",
"3 https://avatars1.githubusercontent.com/u/95175... False \n",
"4 https://avatars0.githubusercontent.com/u/54773... False \n",
"5 https://avatars1.githubusercontent.com/u/45324... False \n",
"6 https://avatars1.githubusercontent.com/u/35795... False \n",
"7 https://avatars3.githubusercontent.com/u/18438... False \n",
"8 https://avatars1.githubusercontent.com/u/17930... False \n",
"9 https://avatars1.githubusercontent.com/u/12031... False \n",
"10 https://avatars2.githubusercontent.com/u/38729... False \n",
"11 https://avatars2.githubusercontent.com/u/19168... False \n",
"12 https://avatars2.githubusercontent.com/u/83189... False \n",
"13 https://avatars0.githubusercontent.com/u/68834... False \n",
"14 https://avatars1.githubusercontent.com/u/35883... False \n",
"15 https://avatars2.githubusercontent.com/u/10590... False \n",
"16 https://avatars0.githubusercontent.com/u/16079... False \n",
"17 https://avatars1.githubusercontent.com/u/78844... False \n",
"18 https://avatars1.githubusercontent.com/u/52183... True \n",
"19 https://avatars2.githubusercontent.com/u/31646... False \n",
"20 https://avatars2.githubusercontent.com/u/32243... False \n",
"21 https://avatars0.githubusercontent.com/u/18091... True \n",
"22 https://avatars1.githubusercontent.com/u/17276... False \n",
"23 https://avatars3.githubusercontent.com/u/22557... True \n",
"24 https://avatars1.githubusercontent.com/u/70974... False \n",
"25 https://avatars1.githubusercontent.com/u/80119... False \n",
"26 https://avatars2.githubusercontent.com/u/77854... False \n",
"27 https://avatars1.githubusercontent.com/u/14326... False \n",
"28 https://avatars1.githubusercontent.com/u/22537... False \n",
"29 https://avatars0.githubusercontent.com/u/17597... False \n",
"... ... ... \n",
"176822 https://avatars0.githubusercontent.com/u/18674... False \n",
"176823 https://avatars2.githubusercontent.com/u/43736... False \n",
"176824 https://avatars2.githubusercontent.com/u/22073... False \n",
"176825 https://avatars1.githubusercontent.com/u/35515... False \n",
"176826 https://avatars2.githubusercontent.com/u/34713... False \n",
"176827 https://avatars0.githubusercontent.com/u/22785... False \n",
"176828 https://avatars0.githubusercontent.com/u/45345... False \n",
"176829 https://avatars0.githubusercontent.com/u/37804... False \n",
"176830 https://avatars0.githubusercontent.com/u/49303... False \n",
"176831 https://avatars0.githubusercontent.com/u/12196... False \n",
"176832 https://avatars2.githubusercontent.com/u/40375... False \n",
"176833 https://avatars2.githubusercontent.com/u/24455... False \n",
"176834 https://avatars2.githubusercontent.com/u/76650... False \n",
"176835 https://avatars1.githubusercontent.com/u/33252... False \n",
"176836 https://avatars1.githubusercontent.com/u/29218... False \n",
"176837 https://avatars1.githubusercontent.com/u/28931... False \n",
"176838 https://avatars0.githubusercontent.com/u/25560... False \n",
"176839 https://avatars2.githubusercontent.com/u/33189... False \n",
"176840 https://avatars3.githubusercontent.com/u/15128... False \n",
"176841 https://avatars1.githubusercontent.com/u/40054... False \n",
"176842 https://avatars3.githubusercontent.com/u/47369... False \n",
"176843 https://avatars2.githubusercontent.com/u/22817... False \n",
"176844 https://avatars2.githubusercontent.com/u/61219... False \n",
"176845 https://avatars3.githubusercontent.com/u/20370... False \n",
"176846 https://avatars3.githubusercontent.com/u/63909... False \n",
"176847 https://avatars0.githubusercontent.com/u/45308... False \n",
"176848 https://avatars0.githubusercontent.com/u/26371... False \n",
"176849 https://avatars3.githubusercontent.com/u/27762... False \n",
"176850 https://avatars1.githubusercontent.com/u/37540... True \n",
"176851 https://avatars0.githubusercontent.com/u/24488... False \n",
"\n",
" num_followers num_following created_at star_time \n",
"0 61 295 2014-12-23 10:06:21 2019-03-26 15:41:28 \n",
"1 0 0 2017-03-16 19:10:57 2019-03-26 15:42:14 \n",
"2 0 1 2018-04-03 16:21:19 2019-03-26 15:42:26 \n",
"3 28 0 2011-08-01 21:32:32 2019-03-26 15:42:49 \n",
"4 1 12 2013-09-17 19:06:25 2019-03-26 15:43:34 \n",
"5 708 31 2013-05-26 20:01:47 2019-03-26 15:43:36 \n",
"6 0 0 2018-01-25 15:13:03 2019-03-26 15:43:39 \n",
"7 20 70 2016-04-13 16:37:09 2019-03-26 15:43:43 \n",
"8 20 10 2012-05-30 19:05:12 2019-03-26 15:43:56 \n",
"9 0 1 2015-04-20 18:08:03 2019-03-26 15:44:00 \n",
"10 1 0 2013-03-15 16:56:49 2019-03-26 15:44:15 \n",
"11 4 1 2016-05-03 20:11:07 2019-03-26 15:45:11 \n",
"12 16 78 2014-07-31 17:35:57 2019-03-26 15:45:21 \n",
"13 4 16 2014-03-07 20:52:03 2019-03-26 15:45:30 \n",
"14 0 0 2018-01-28 11:13:51 2019-03-26 15:46:29 \n",
"15 3 7 2015-01-19 11:17:40 2019-03-26 15:47:45 \n",
"16 2 0 2015-11-30 16:53:10 2019-03-26 15:49:17 \n",
"17 65 99 2014-06-14 06:37:41 2019-03-26 15:49:28 \n",
"18 5 33 2013-08-13 11:02:51 2019-03-26 15:49:48 \n",
"19 0 0 2017-09-05 15:11:59 2019-03-26 15:50:00 \n",
"20 2 10 2013-01-09 17:47:53 2019-03-26 15:50:19 \n",
"21 13 3 2012-06-02 17:35:06 2019-03-26 15:52:03 \n",
"22 2 8 2016-02-17 00:18:32 2019-03-26 15:52:14 \n",
"23 53 0 2012-08-31 23:14:17 2019-03-26 15:52:55 \n",
"24 72 77 2014-03-29 08:56:28 2019-03-26 15:52:58 \n",
"25 2 4 2014-06-28 17:34:32 2019-03-26 15:53:35 \n",
"26 8 6 2011-05-10 15:40:30 2019-03-26 15:54:10 \n",
"27 0 0 2015-09-17 15:49:14 2019-03-26 15:55:05 \n",
"28 3 1 2016-09-30 14:04:54 2019-03-26 15:55:26 \n",
"29 0 0 2016-03-03 00:13:47 2019-03-26 15:55:49 \n",
"... ... ... ... ... \n",
"176822 1 2 2016-04-26 14:28:36 2019-04-05 16:00:49 \n",
"176823 0 0 2018-10-01 10:52:10 2019-04-05 16:01:00 \n",
"176824 0 2 2016-09-08 17:18:21 2019-04-05 16:01:02 \n",
"176825 0 0 2018-01-17 11:38:18 2019-04-05 16:01:04 \n",
"176826 0 0 2017-12-20 20:59:56 2019-04-05 16:01:09 \n",
"176827 0 0 2016-10-12 14:06:32 2019-04-05 16:01:13 \n",
"176828 0 1 2018-11-26 10:51:10 2019-04-05 16:01:31 \n",
"176829 0 0 2018-03-26 21:33:48 2019-04-05 16:01:45 \n",
"176830 0 0 2019-04-05 16:00:39 2019-04-05 16:02:32 \n",
"176831 1 0 2015-05-01 16:26:42 2019-04-05 16:02:32 \n",
"176832 0 1 2018-06-19 09:26:40 2019-04-05 16:02:53 \n",
"176833 2 5 2016-12-08 20:42:13 2019-04-05 16:03:25 \n",
"176834 0 2 2014-05-22 14:08:49 2019-04-05 16:03:33 \n",
"176835 0 0 2017-10-31 18:47:26 2019-04-05 16:03:48 \n",
"176836 0 1 2017-06-06 09:49:48 2019-04-05 16:03:59 \n",
"176837 6 34 2017-05-25 01:57:17 2019-04-05 16:04:08 \n",
"176838 0 0 2017-02-05 14:39:14 2019-04-05 16:04:29 \n",
"176839 0 1 2017-10-29 09:41:07 2019-04-05 16:05:01 \n",
"176840 55 132 2015-10-15 00:17:02 2019-04-05 16:05:07 \n",
"176841 0 0 2018-06-08 15:20:58 2019-04-05 16:05:12 \n",
"176842 0 0 2019-02-06 05:37:24 2019-04-05 16:05:18 \n",
"176843 0 1 2016-10-13 22:09:33 2019-04-05 16:05:28 \n",
"176844 0 0 2013-12-06 18:21:39 2019-04-05 16:05:30 \n",
"176845 0 0 2016-07-09 21:46:26 2019-04-05 16:05:56 \n",
"176846 16 1 2011-02-26 11:07:13 2019-04-05 16:06:12 \n",
"176847 0 0 2018-11-24 17:38:11 2019-04-05 16:06:14 \n",
"176848 0 6 2017-03-13 10:36:41 2019-04-05 16:06:51 \n",
"176849 4 1 2010-05-15 18:00:45 2019-04-05 16:06:58 \n",
"176850 0 0 2018-03-19 19:55:04 2019-04-05 16:07:00 \n",
"176851 1 0 2016-12-10 13:57:56 2019-04-05 16:07:31 \n",
"\n",
"[176852 rows x 11 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 5
}
]
},
{
"metadata": {
"id": "2WO0Mh2LwMWL",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"将排好序的数据中点 Star 日期转换为 `datetime` 并将日期设置为 index,方便后面统计。"
]
},
{
"metadata": {
"colab_type": "code",
"id": "mbDJdFliK-Ec",
"outputId": "fc36f519-a154-4da3-bd6c-9b99edbb669f",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 340
}
},
"cell_type": "code",
"source": [
"df['star_time'] = pd.to_datetime(df['star_time'])\n",
"df.index = df['star_time']\n",
"df.head()"
],
"execution_count": 6,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>username</th>\n",
" <th>name</th>\n",
" <th>blog</th>\n",
" <th>company</th>\n",
" <th>bio</th>\n",
" <th>avatar_url</th>\n",
" <th>hireable</th>\n",
" <th>num_followers</th>\n",
" <th>num_following</th>\n",
" <th>created_at</th>\n",
" <th>star_time</th>\n",
" </tr>\n",
" <tr>\n",
" <th>star_time</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2019-03-26 15:41:28</th>\n",
" <td>weaming</td>\n",
" <td>garden.yuen</td>\n",
" <td>https://bitsflow.org</td>\n",
" <td>NaN</td>\n",
" <td>Python/Go/Rust/Crystal/Haskell/Vue</td>\n",
" <td>https://avatars0.githubusercontent.com/u/10275...</td>\n",
" <td>False</td>\n",
" <td>61</td>\n",
" <td>295</td>\n",
" <td>2014-12-23 10:06:21</td>\n",
" <td>2019-03-26 15:41:28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-26 15:42:14</th>\n",
" <td>LaoJJ</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/26458...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2017-03-16 19:10:57</td>\n",
" <td>2019-03-26 15:42:14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-26 15:42:26</th>\n",
" <td>134355</td>\n",
" <td>ljw</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/38032...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2018-04-03 16:21:19</td>\n",
" <td>2019-03-26 15:42:26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-26 15:42:49</th>\n",
" <td>Shaman05</td>\n",
" <td>shaman</td>\n",
" <td>http://shaman05.github.io/</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/95175...</td>\n",
" <td>False</td>\n",
" <td>28</td>\n",
" <td>0</td>\n",
" <td>2011-08-01 21:32:32</td>\n",
" <td>2019-03-26 15:42:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-26 15:43:34</th>\n",
" <td>xyz0z0</td>\n",
" <td>xyz0z0</td>\n",
" <td>https://xyz0z0.xyz/</td>\n",
" <td>NaN</td>\n",
" <td>Just do it.</td>\n",
" <td>https://avatars0.githubusercontent.com/u/54773...</td>\n",
" <td>False</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>2013-09-17 19:06:25</td>\n",
" <td>2019-03-26 15:43:34</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" username name blog \\\n",
"star_time \n",
"2019-03-26 15:41:28 weaming garden.yuen https://bitsflow.org \n",
"2019-03-26 15:42:14 LaoJJ NaN NaN \n",
"2019-03-26 15:42:26 134355 ljw NaN \n",
"2019-03-26 15:42:49 Shaman05 shaman http://shaman05.github.io/ \n",
"2019-03-26 15:43:34 xyz0z0 xyz0z0 https://xyz0z0.xyz/ \n",
"\n",
" company bio \\\n",
"star_time \n",
"2019-03-26 15:41:28 NaN Python/Go/Rust/Crystal/Haskell/Vue \n",
"2019-03-26 15:42:14 NaN NaN \n",
"2019-03-26 15:42:26 NaN NaN \n",
"2019-03-26 15:42:49 NaN NaN \n",
"2019-03-26 15:43:34 NaN Just do it. \n",
"\n",
" avatar_url \\\n",
"star_time \n",
"2019-03-26 15:41:28 https://avatars0.githubusercontent.com/u/10275... \n",
"2019-03-26 15:42:14 https://avatars0.githubusercontent.com/u/26458... \n",
"2019-03-26 15:42:26 https://avatars1.githubusercontent.com/u/38032... \n",
"2019-03-26 15:42:49 https://avatars1.githubusercontent.com/u/95175... \n",
"2019-03-26 15:43:34 https://avatars0.githubusercontent.com/u/54773... \n",
"\n",
" hireable num_followers num_following \\\n",
"star_time \n",
"2019-03-26 15:41:28 False 61 295 \n",
"2019-03-26 15:42:14 False 0 0 \n",
"2019-03-26 15:42:26 False 0 1 \n",
"2019-03-26 15:42:49 False 28 0 \n",
"2019-03-26 15:43:34 False 1 12 \n",
"\n",
" created_at star_time \n",
"star_time \n",
"2019-03-26 15:41:28 2014-12-23 10:06:21 2019-03-26 15:41:28 \n",
"2019-03-26 15:42:14 2017-03-16 19:10:57 2019-03-26 15:42:14 \n",
"2019-03-26 15:42:26 2018-04-03 16:21:19 2019-03-26 15:42:26 \n",
"2019-03-26 15:42:49 2011-08-01 21:32:32 2019-03-26 15:42:49 \n",
"2019-03-26 15:43:34 2013-09-17 19:06:25 2019-03-26 15:43:34 "
]
},
"metadata": {
"tags": []
},
"execution_count": 6
}
]
},
{
"metadata": {
"id": "0i23wkD4wMWU",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"此时数据已经基本清洗完成,开始下面的统计。"
]
},
{
"metadata": {
"id": "xj_9e-G2wMWW",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"# 整体情况概览\n",
"\n",
"### Available For Hire?\n",
"\n",
"由于在 GitHub 上可以设置一个是否 Hireable(默认好像是没有勾选的),如图:\n",
"\n",
"![](https://i.loli.net/2019/04/01/5ca1b7266968b.png)\n",
"\n",
"而对于我们爬下来的信息中正好有这个项,所以从它开始咯,那么在这 176852 条数据中,有多少人勾选了这个呢?"
]
},
{
"metadata": {
"id": "mpgl0x5nwMWY",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 34
},
"outputId": "4b567c78-8cad-4c16-bbf3-c6950e1023fd"
},
"cell_type": "code",
"source": [
"checked_hireable_count = df['hireable'].sum()\n",
"checked_hireable_count"
],
"execution_count": 7,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"11468"
]
},
"metadata": {
"tags": []
},
"execution_count": 7
}
]
},
{
"metadata": {
"id": "JtuCnhc6wMWg",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"总共有 11468 (占有 6%)的人勾选了 \"Available for hire\""
]
},
{
"metadata": {
"id": "nYlnP-zawMWi",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"### Registered after creation"
]
},
{
"metadata": {
"id": "PG9K9FoJwMWj",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 328
},
"outputId": "84a78b61-fdac-4ecc-ef4b-67aba33a61fc"
},
"cell_type": "code",
"source": [
"registerd_after_creation = df\n",
"registerd_after_creation.index = registerd_after_creation['created_at']\n",
"zero_fo_registerd_after_creation = registerd_after_creation[registerd_after_creation['num_followers'] == 0]\n",
"# 丢掉不需要的列,分开处理\n",
"registerd_after_creation = registerd_after_creation[['created_at']]\n",
"zero_fo_registerd_after_creation = zero_fo_registerd_after_creation[['created_at']]\n",
"\n",
"registerd_after_creation = registerd_after_creation.resample('D').count()\n",
"zero_fo_registerd_after_creation = zero_fo_registerd_after_creation.resample('D').count()\n",
"registerd_after_creation.tail(8)"
],
"execution_count": 8,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>created_at</th>\n",
" </tr>\n",
" <tr>\n",
" <th>created_at</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2019-03-29</th>\n",
" <td>735</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-30</th>\n",
" <td>245</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-31</th>\n",
" <td>185</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-01</th>\n",
" <td>281</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-02</th>\n",
" <td>327</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-03</th>\n",
" <td>377</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-04</th>\n",
" <td>292</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-05</th>\n",
" <td>62</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" created_at\n",
"created_at \n",
"2019-03-29 735\n",
"2019-03-30 245\n",
"2019-03-31 185\n",
"2019-04-01 281\n",
"2019-04-02 327\n",
"2019-04-03 377\n",
"2019-04-04 292\n",
"2019-04-05 62"
]
},
"metadata": {
"tags": []
},
"execution_count": 8
}
]
},
{
"metadata": {
"id": "oyWM8WfVwMWs",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 328
},
"outputId": "21304a8a-7876-4e94-9731-2fee384f6bf5"
},
"cell_type": "code",
"source": [
"zero_fo_registerd_after_creation.tail(8)"
],
"execution_count": 9,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>created_at</th>\n",
" </tr>\n",
" <tr>\n",
" <th>created_at</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2019-03-29</th>\n",
" <td>726</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-30</th>\n",
" <td>242</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-03-31</th>\n",
" <td>182</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-01</th>\n",
" <td>272</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-02</th>\n",
" <td>319</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-03</th>\n",
" <td>365</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-04</th>\n",
" <td>290</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2019-04-05</th>\n",
" <td>61</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" created_at\n",
"created_at \n",
"2019-03-29 726\n",
"2019-03-30 242\n",
"2019-03-31 182\n",
"2019-04-01 272\n",
"2019-04-02 319\n",
"2019-04-03 365\n",
"2019-04-04 290\n",
"2019-04-05 61"
]
},
"metadata": {
"tags": []
},
"execution_count": 9
}
]
},
{
"metadata": {
"id": "_QtrupDNwMWz",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"对比项目的创建时间,可以看出从 **项目上线之后(2019/03/26)注册的,且给这个项目点了 Star** 的用户数量情况,共计 2423 个用户,其中,**没有任何 Followers 的**,有 2378 个用户。"
]
},
{
"metadata": {
"id": "Bxy2CUNCwMW2",
"colab_type": "text"
},
"cell_type": "markdown",
"source": [
"### Companys?\n",
"\n",
"对于各个比较主流的公司进行一些搜索(基于 GitHub 上在自己 Company 一栏中填写的信息进行模糊匹配),先试一下看看效果如何:"
]
},
{
"metadata": {
"id": "veMqCQKIwMW4",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 3108
},
"outputId": "125d24f4-434a-493b-8227-e83119a42fc3"
},
"cell_type": "code",
"source": [
"# 先试一下看看效果如何\n",
"df[df['company'].str.contains(\"Google\", na=False,regex=True,case=False)]"
],
"execution_count": 10,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>username</th>\n",
" <th>name</th>\n",
" <th>blog</th>\n",
" <th>company</th>\n",
" <th>bio</th>\n",
" <th>avatar_url</th>\n",
" <th>hireable</th>\n",
" <th>num_followers</th>\n",
" <th>num_following</th>\n",
" <th>created_at</th>\n",
" <th>star_time</th>\n",
" </tr>\n",
" <tr>\n",
" <th>created_at</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2013-01-24 22:11:05</th>\n",
" <td>roceys</td>\n",
" <td>roceys</td>\n",
" <td>https://roceys.org</td>\n",
" <td>@google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/33702...</td>\n",
" <td>False</td>\n",
" <td>19</td>\n",
" <td>168</td>\n",
" <td>2013-01-24 22:11:05</td>\n",
" <td>2019-03-27 19:14:54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2015-03-31 14:26:44</th>\n",
" <td>JesseHu1520</td>\n",
" <td>Skywalker</td>\n",
" <td>https://skywa1ker.cn</td>\n",
" <td>Google</td>\n",
" <td>Write a code,change the world.</td>\n",
" <td>https://avatars2.githubusercontent.com/u/11732...</td>\n",
" <td>False</td>\n",
" <td>8</td>\n",
" <td>4</td>\n",
" <td>2015-03-31 14:26:44</td>\n",
" <td>2019-03-27 19:20:23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-08-19 13:04:31</th>\n",
" <td>GeorgyZhou</td>\n",
" <td>Michael Zhou</td>\n",
" <td>http://zhouqj.com</td>\n",
" <td>Google | WeRide.ai | ZJU | USC</td>\n",
" <td>Researcher and student at USC.\\r\\nGoogler &amp; Tr...</td>\n",
" <td>https://avatars2.githubusercontent.com/u/21117...</td>\n",
" <td>False</td>\n",
" <td>11</td>\n",
" <td>8</td>\n",
" <td>2016-08-19 13:04:31</td>\n",
" <td>2019-03-27 23:09:15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-11-11 04:46:13</th>\n",
" <td>kangyizhang</td>\n",
" <td>Kangyi Zhang</td>\n",
" <td>NaN</td>\n",
" <td>@google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/59041...</td>\n",
" <td>False</td>\n",
" <td>5</td>\n",
" <td>4</td>\n",
" <td>2013-11-11 04:46:13</td>\n",
" <td>2019-03-28 01:52:16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2017-09-05 13:05:45</th>\n",
" <td>LacticAcidCYC</td>\n",
" <td>Yuchuan Chen</td>\n",
" <td>NaN</td>\n",
" <td>@Google</td>\n",
" <td>Hope never dies.</td>\n",
" <td>https://avatars0.githubusercontent.com/u/31643...</td>\n",
" <td>False</td>\n",
" <td>12</td>\n",
" <td>48</td>\n",
" <td>2017-09-05 13:05:45</td>\n",
" <td>2019-03-28 02:11:37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2017-07-06 06:06:27</th>\n",
" <td>yixinshi</td>\n",
" <td>Sam Shi</td>\n",
" <td>NaN</td>\n",
" <td>Google Cloud Machine Learning</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/29932...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>2017-07-06 06:06:27</td>\n",
" <td>2019-03-28 04:36:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2017-12-16 18:35:24</th>\n",
" <td>luolongfei</td>\n",
" <td>NaN</td>\n",
" <td>https://luolongfei.com</td>\n",
" <td>GOOGLE</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/34597...</td>\n",
" <td>False</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>2017-12-16 18:35:24</td>\n",
" <td>2019-03-28 06:53:17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-07-25 12:51:43</th>\n",
" <td>zhenghuiwang</td>\n",
" <td>Zhenghui Wang</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/82639...</td>\n",
" <td>False</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>2014-07-25 12:51:43</td>\n",
" <td>2019-03-28 07:37:35</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-04-19 19:15:22</th>\n",
" <td>0x333333</td>\n",
" <td>ZP Jiang</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>SWE @ Google</td>\n",
" <td>https://avatars0.githubusercontent.com/u/16589...</td>\n",
" <td>True</td>\n",
" <td>110</td>\n",
" <td>195</td>\n",
" <td>2012-04-19 19:15:22</td>\n",
" <td>2019-03-28 08:27:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2008-06-14 00:28:58</th>\n",
" <td>EmmanuelOga</td>\n",
" <td>Emmanuel Oga</td>\n",
" <td>http://EmmanuelOga.com</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/13634...</td>\n",
" <td>False</td>\n",
" <td>139</td>\n",
" <td>1054</td>\n",
" <td>2008-06-14 00:28:58</td>\n",
" <td>2019-03-28 09:45:59</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-11-24 18:02:33</th>\n",
" <td>tengyifei</td>\n",
" <td>Yifei Teng</td>\n",
" <td>https://thinkingandcomputing.com/</td>\n",
" <td>Google</td>\n",
" <td>Compumusician</td>\n",
" <td>https://avatars3.githubusercontent.com/u/28775...</td>\n",
" <td>True</td>\n",
" <td>97</td>\n",
" <td>399</td>\n",
" <td>2012-11-24 18:02:33</td>\n",
" <td>2019-03-28 12:58:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2015-01-23 10:26:55</th>\n",
" <td>BichengLUO</td>\n",
" <td>Bicheng Luo</td>\n",
" <td>http://bichengluo.me/</td>\n",
" <td>Google</td>\n",
" <td>iOS/C/C++ dev, using Python, working in Google...</td>\n",
" <td>https://avatars0.githubusercontent.com/u/10663...</td>\n",
" <td>True</td>\n",
" <td>60</td>\n",
" <td>81</td>\n",
" <td>2015-01-23 10:26:55</td>\n",
" <td>2019-03-28 13:16:45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-04-08 04:05:16</th>\n",
" <td>liubonan</td>\n",
" <td>Bonan Liu</td>\n",
" <td>http://www.liubonan.com/info</td>\n",
" <td>@google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/16218...</td>\n",
" <td>False</td>\n",
" <td>9</td>\n",
" <td>9</td>\n",
" <td>2012-04-08 04:05:16</td>\n",
" <td>2019-03-28 13:31:11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2017-12-18 15:10:32</th>\n",
" <td>Moocliu</td>\n",
" <td>南梦</td>\n",
" <td>NaN</td>\n",
" <td>google</td>\n",
" <td>Dreams always have to be fulfilled. Should one...</td>\n",
" <td>https://avatars1.githubusercontent.com/u/34642...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>2017-12-18 15:10:32</td>\n",
" <td>2019-03-28 14:04:16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2018-03-28 11:23:23</th>\n",
" <td>jojoCry</td>\n",
" <td>nevercry</td>\n",
" <td>NaN</td>\n",
" <td>google</td>\n",
" <td>nullpointerexception</td>\n",
" <td>https://avatars0.githubusercontent.com/u/37857...</td>\n",
" <td>False</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2018-03-28 11:23:23</td>\n",
" <td>2019-03-28 14:11:13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-03-10 15:23:32</th>\n",
" <td>VolkGithub</td>\n",
" <td>Volk</td>\n",
" <td>NaN</td>\n",
" <td>@google</td>\n",
" <td>本人学识渊博、经验丰富、代码风骚、效率恐怖!</td>\n",
" <td>https://avatars2.githubusercontent.com/u/17759...</td>\n",
" <td>False</td>\n",
" <td>2</td>\n",
" <td>20</td>\n",
" <td>2016-03-10 15:23:32</td>\n",
" <td>2019-03-28 14:33:45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-10-10 22:19:45</th>\n",
" <td>crazytan</td>\n",
" <td>Jia Tan</td>\n",
" <td>NaN</td>\n",
" <td>@Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/91361...</td>\n",
" <td>False</td>\n",
" <td>25</td>\n",
" <td>35</td>\n",
" <td>2014-10-10 22:19:45</td>\n",
" <td>2019-03-28 15:27:25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-03-12 12:30:50</th>\n",
" <td>kaoet</td>\n",
" <td>Kaoet</td>\n",
" <td>NaN</td>\n",
" <td>@Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/15274...</td>\n",
" <td>False</td>\n",
" <td>8</td>\n",
" <td>0</td>\n",
" <td>2012-03-12 12:30:50</td>\n",
" <td>2019-03-28 16:54:04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-02-19 10:03:13</th>\n",
" <td>moz1q1</td>\n",
" <td>mo</td>\n",
" <td>https://my.oschina.net/moziqi</td>\n",
" <td>Google Android dev</td>\n",
" <td>这个人比较懒,没留下什么东西</td>\n",
" <td>https://avatars1.githubusercontent.com/u/36322...</td>\n",
" <td>True</td>\n",
" <td>24</td>\n",
" <td>231</td>\n",
" <td>2013-02-19 10:03:13</td>\n",
" <td>2019-03-28 17:40:11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-06-09 16:05:18</th>\n",
" <td>yudequan</td>\n",
" <td>MacPrince</td>\n",
" <td>NaN</td>\n",
" <td>@Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/78360...</td>\n",
" <td>False</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>2014-06-09 16:05:18</td>\n",
" <td>2019-03-28 19:52:58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-09-15 01:25:05</th>\n",
" <td>charnugagoo</td>\n",
" <td>charnugagoo</td>\n",
" <td>http://yuzhuoran.wordpress.com</td>\n",
" <td>Google Research</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/23482...</td>\n",
" <td>True</td>\n",
" <td>66</td>\n",
" <td>134</td>\n",
" <td>2012-09-15 01:25:05</td>\n",
" <td>2019-03-28 22:11:13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-09-24 08:04:19</th>\n",
" <td>chaconnewu</td>\n",
" <td>Yu Wu</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>I care about devising methods and creating too...</td>\n",
" <td>https://avatars2.githubusercontent.com/u/24074...</td>\n",
" <td>True</td>\n",
" <td>180</td>\n",
" <td>26</td>\n",
" <td>2012-09-24 08:04:19</td>\n",
" <td>2019-03-28 23:17:43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-08-20 11:52:37</th>\n",
" <td>Liujingfang1</td>\n",
" <td>Jingfang Liu</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/84986...</td>\n",
" <td>False</td>\n",
" <td>28</td>\n",
" <td>2</td>\n",
" <td>2014-08-20 11:52:37</td>\n",
" <td>2019-03-29 01:31:52</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-10-08 23:28:42</th>\n",
" <td>xiaoyifan</td>\n",
" <td>Yifan Xiao</td>\n",
" <td>http://xiaoyifan.github.io</td>\n",
" <td>Google Cloud AI</td>\n",
" <td>Nothing can be better than building something.</td>\n",
" <td>https://avatars0.githubusercontent.com/u/90855...</td>\n",
" <td>True</td>\n",
" <td>19</td>\n",
" <td>58</td>\n",
" <td>2014-10-08 23:28:42</td>\n",
" <td>2019-03-29 01:33:37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-05-12 13:31:52</th>\n",
" <td>QawsQAER</td>\n",
" <td>Edward</td>\n",
" <td>NaN</td>\n",
" <td>Google Inc.</td>\n",
" <td>Learn, Code and Play</td>\n",
" <td>https://avatars1.githubusercontent.com/u/44077...</td>\n",
" <td>False</td>\n",
" <td>19</td>\n",
" <td>17</td>\n",
" <td>2013-05-12 13:31:52</td>\n",
" <td>2019-03-29 04:15:03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-09-21 08:09:06</th>\n",
" <td>TerryC78</td>\n",
" <td>Tianyu (Terry) Chen</td>\n",
" <td>https://www.linkedin.com/in/tianyuc</td>\n",
" <td>Google</td>\n",
" <td>@Google/@CMU/@SJTU</td>\n",
" <td>https://avatars2.githubusercontent.com/u/88467...</td>\n",
" <td>True</td>\n",
" <td>28</td>\n",
" <td>21</td>\n",
" <td>2014-09-21 08:09:06</td>\n",
" <td>2019-03-29 05:22:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-05-31 11:17:31</th>\n",
" <td>NeilLi1992</td>\n",
" <td>Yong Li</td>\n",
" <td>http://blog.yongli1992.com</td>\n",
" <td>Google</td>\n",
" <td>Hi, I'm a developer originally from China, cur...</td>\n",
" <td>https://avatars1.githubusercontent.com/u/45763...</td>\n",
" <td>False</td>\n",
" <td>22</td>\n",
" <td>25</td>\n",
" <td>2013-05-31 11:17:31</td>\n",
" <td>2019-03-29 05:59:37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2015-12-23 08:49:00</th>\n",
" <td>qinyeli</td>\n",
" <td>Qinye Sindy Li</td>\n",
" <td>qinyeli.github.io</td>\n",
" <td>@google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars1.githubusercontent.com/u/16407...</td>\n",
" <td>False</td>\n",
" <td>32</td>\n",
" <td>75</td>\n",
" <td>2015-12-23 08:49:00</td>\n",
" <td>2019-03-29 06:55:31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2011-05-06 21:20:30</th>\n",
" <td>palcu</td>\n",
" <td>Alex Palcuie</td>\n",
" <td>https://blog.palcu.ro/</td>\n",
" <td>@Google</td>\n",
" <td>SRE @google Cloud. Ex @palantir, @rosedu, @gov...</td>\n",
" <td>https://avatars0.githubusercontent.com/u/77222...</td>\n",
" <td>True</td>\n",
" <td>220</td>\n",
" <td>201</td>\n",
" <td>2011-05-06 21:20:30</td>\n",
" <td>2019-03-29 07:31:26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2015-01-16 00:09:53</th>\n",
" <td>axeisghost</td>\n",
" <td>Junxian Wu</td>\n",
" <td>http://weibo.com/ruphatwu</td>\n",
" <td>Google</td>\n",
" <td>Beers - The Front Bottoms</td>\n",
" <td>https://avatars0.githubusercontent.com/u/10549...</td>\n",
" <td>False</td>\n",
" <td>15</td>\n",
" <td>15</td>\n",
" <td>2015-01-16 00:09:53</td>\n",
" <td>2019-03-29 07:40:57</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2015-07-28 20:00:39</th>\n",
" <td>ZhangShiqiu1993</td>\n",
" <td>Shiqiu Zhang</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/13538...</td>\n",
" <td>True</td>\n",
" <td>8</td>\n",
" <td>6</td>\n",
" <td>2015-07-28 20:00:39</td>\n",
" <td>2019-03-31 07:18:19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-04-06 22:23:55</th>\n",
" <td>ruofeidu</td>\n",
" <td>Ruofei Du</td>\n",
" <td>http://www.duruofei.com</td>\n",
" <td>@google</td>\n",
" <td>Research Scientist at Google</td>\n",
" <td>https://avatars0.githubusercontent.com/u/16188...</td>\n",
" <td>False</td>\n",
" <td>65</td>\n",
" <td>83</td>\n",
" <td>2012-04-06 22:23:55</td>\n",
" <td>2019-03-31 07:28:04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012-04-16 19:30:23</th>\n",
" <td>yuefengz</td>\n",
" <td>Yuefeng Zhou</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/16478...</td>\n",
" <td>True</td>\n",
" <td>167</td>\n",
" <td>23</td>\n",
" <td>2012-04-16 19:30:23</td>\n",
" <td>2019-03-31 09:49:54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-03-10 09:25:52</th>\n",
" <td>congliu01</td>\n",
" <td>Cong Liu</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars3.githubusercontent.com/u/69022...</td>\n",
" <td>False</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>2014-03-10 09:25:52</td>\n",
" <td>2019-03-31 10:13:10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016-01-22 03:40:26</th>\n",
" <td>caisq</td>\n",
" <td>Shanqing Cai</td>\n",
" <td>http://scai.io/</td>\n",
" <td>Google</td>\n",
" <td>{TensorFlow.js, TensorFlow} @ Google\\r\\n</td>\n",
" <td>https://avatars2.githubusercontent.com/u/16824...</td>\n",
" <td>False</td>\n",
" <td>246</td>\n",
" <td>44</td>\n",
" <td>2016-01-22 03:40:26</td>\n",
" <td>2019-03-31 11:18:47</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2011-12-23 11:38:31</th>\n",
" <td>Jacksunwei</td>\n",
" <td>Jack Sun</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/12813...</td>\n",
" <td>False</td>\n",
" <td>6</td>\n",
" <td>13</td>\n",
" <td>2011-12-23 11:38:31</td>\n",
" <td>2019-03-31 12:40:56</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2015-01-29 15:12:14</th>\n",
" <td>shuangly</td>\n",
" <td>Shuangling Yin</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars2.githubusercontent.com/u/10753...</td>\n",
" <td>True</td>\n",
" <td>6</td>\n",
" <td>5</td>\n",
" <td>2015-01-29 15:12:14</td>\n",
" <td>2019-03-31 13:04:56</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-11-20 16:22:35</th>\n",
" <td>lk-chen</td>\n",
" <td>lkchen</td>\n",
" <td>NaN</td>\n",
" <td>Google</td>\n",
" <td>Google software engineer, working on Google Ne...</td>\n",
" <td>https://avatars0.githubusercontent.com/u/59887...</td>\n",
" <td>True</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>2013-11-20 16:22:35</td>\n",
" <td>2019-03-31 18:05:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-05-27 05:20:21</th>\n",
" <td>yangyi02</td>\n",
" <td>Yi Yang</td>\n",
" <td>https://yangyi02.github.io</td>\n",
" <td>Google DeepMind</td>\n",
" <td>Research Scientist at Google DeepMind</td>\n",
" <td>https://avatars0.githubusercontent.com/u/45349...</td>\n",
" <td>True</td>\n",
" <td>62</td>\n",
" <td>106</td>\n",
" <td>2013-05-27 05:20:21</td>\n",
" <td>2019-04-01 06:01:32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-07-31 13:14:24</th>\n",
" <td>BSBandme</td>\n",
" <td>Yilun Chong</td>\n",
" <td>NaN</td>\n",
" <td>Google LLC</td>\n",
" <td>NaN</td>\n",
" <td>https://avatars0.githubusercontent.com/u/51264...</td>\n",
" <td>True</td>\n",
" <td>30</td>\n",
" <td>7</td>\n",
" <td>2013-07-31 13:14:24</td>\n",
" <td>2019-04-01 10:20:49</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014-12-15 14:29:12</th>\n",
" <td>youhusky</td>\n",
" <td>Bozhao(Joshua) Li</td>\n",
" <td>http://joshuablog.herokuapp.com/</td>\n",
" <td>@Google</td>\n",
" <td>Software Engineer at Google</td>\n",
" <td>https://avatars3.githubusercontent.com/u/10191...</td>\n",
" <td>True</td>\n",
" <td>60</td>\n",
" <td>14</td>\n",
" <td>2014-12-15 14:29:12</td>\n",
" <td>2019-04-01 13:03:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013-08-21 14:49:17</th>\n",