Skip to content

Instantly share code, notes, and snippets.

View zhengyunhan's full-sized avatar

yunhan zhengyunhan

15 followers · 0 following
View GitHub Profile
@zhengyunhan
zhengyunhan / xBeijing_new.csv
Created March 25, 2020 00:14
Place count freq new_freq Province province
1 冀F 607 2.276 11.014 冀 Hebei
2 冀R 448 1.68 8.129 冀 Hebei
3 冀A 273 1.024 4.954 冀 Hebei
4 冀D 254 0.952 4.609 冀 Hebei
5 冀G 254 0.952 4.609 冀 Hebei
6 冀H 203 0.761 3.684 冀 Hebei
7 冀B 198 0.742 3.593 冀 Hebei
8 蒙A 151 0.566 2.74 蒙 Inner_Mongolia
9 冀J 127 0.476 2.304 冀 Hebei
@zhengyunhan
zhengyunhan / license_counts.csv
Created March 25, 2020 00:11
Place count
1 京N 5014
2 京Q 4936
3 无 3404
4 京P 1624
5 京B 1612
6 京A 1028
7 京E 646
8 冀F 607
9 京G 540
@zhengyunhan
zhengyunhan / institution_inoutflow.csv
Created May 12, 2019 00:14
We can't make this file beautiful and searchable because it's too large.
sid,year,x_id,formatted_address,org_id,name,lat,lng,country,des_lat,des_lng,des_org_id,des_schoolname,des_country,MIT,HARVARD,STANFORD,BERKELEY,CMU,CHICAGO,OXFORD,CAMBRIDGE,SACLAY,COPENHAGEN,MCGILL,TORONTO,TOKYO,KYOTO,TSINGHUA,PEKING,NUS,WEIZMANN,CAPE,SIDNEY,PAULO,outflow,inflow
53f31921dabfae9a84429c6f,1995,5b869f6fe1cd8e14a3b0c1cc,"32 Vassar St, Cambridge, MA 02139, USA",5b865691e1cd8e6153583b93,"MASSACHUSETTS INSTITUTE OF TECHNOLOGY, ARTIFICIAL",42.361866,-71.090561,USA,42.3374302,-71.105438,5b865691e1cd8e6153583b93,"HARVARD MEDICAL SCHOOL, DEPARTMENT OF RADIOLOGY, BOSTON, MA, USA. SW@AI.MIT.EDU",USA,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0
53f31921dabfae9a84429c6f,1996,5b86a34ae1cd8e14a3c9b0db,"300 Longwood Ave, Boston, MA 02115, USA",5b865691e1cd8e6153583b93,"HARVARD MEDICAL SCHOOL, DEPARTMENT OF RADIOLOGY, BOSTON, MA, USA. SW@AI.MIT.EDU",42.337429,-71.105438,USA,42.360091,-71.09416,5b865691e1cd8e6153583b93,MASSACHUSETTS INSTITUTE OF TECHNOLOGY,USA,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0
53f31
@zhengyunhan
zhengyunhan / inoutflow_5years_2.csv
Created May 8, 2019 02:39
We can't make this file beautiful and searchable because it's too large.
sid,formatted_address,org_id,name,lat,lng,country,des_address,des_org_id,des_schoolname,des_lat,des_lng,des_country,year,MIT,HARVARD,STANFORD,BERKELEY,CMU,CHICAGO,OXFORD,CAMBRIDGE,SACLAY,COPENHAGEN,MCGILL,TORONTO,TOKYO,KYOTO,TSINGHUA,PEKING,SIDNEY,NUS,WEIZMANN,CAPE,PAULO,outflow,inflow
53f35b6bdabfae4b349708a0,"52 Oxford St, Cambridge, MA 02138, USA",5b865622e1cd8e6153542db1,BIOLOGICAL LABORATORIES|HARVARD UNIVERSITY,42.380032,-71.115334,USA,"52 Oxford St, Cambridge, MA 02138, USA",5b865507e1cd8e615349a6eb,"DEPARTMENT OF BIOCHEMISTRY AND MOLECULAR BIOLOGY HARVARD UNIVERSITY CAMBRIDGE, MASS. 02138, USA",42.380032,-71.115334,USA,1985,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0
53f37355dabfae4b349c8c57,"225 E Chicago Ave, Chicago, IL 60611, USA",5b865798e1cd8e615362401d,"DEPARTMENT OF PEDIATRICS, CHILDREN'S MEMORIAL HOSPITAL, CHICAGO, ILLINOIS USA.",41.896225,-87.621834,USA,"333 Cedar St, New Haven, CT 06510, USA",5b865638e1cd8e615355057a,YALE UNIVERSITY|SCHOOL OF MEDICINE|DEPARTMENT OF HUMAN GENETICS,41.30323
@zhengyunhan
zhengyunhan / inoutflow_5years.csv
Created May 1, 2019 21:35
We can't make this file beautiful and searchable because it's too large.
sid,formatted_address,org_id,name,lat,lng,country,des_address,des_org_id,des_schoolname,des_lat,des_lng,des_country,year,mit,harvard,stanford,berkeley,cmu,chicago,oxford,cambridge,saclay,copenhagen,mcgill,toronto,tokyo,kyoto,tsinghua,peking,sidney,nus,weizmann,cape,paulo,outflow,inflow
53f35b6bdabfae4b349708a0,"52 Oxford St, Cambridge, MA 02138, USA",5b865622e1cd8e6153542db1,BIOLOGICAL LABORATORIES|HARVARD UNIVERSITY,42.380032,-71.115334,USA,"52 Oxford St, Cambridge, MA 02138, USA",5b865507e1cd8e615349a6eb,"DEPARTMENT OF BIOCHEMISTRY AND MOLECULAR BIOLOGY HARVARD UNIVERSITY CAMBRIDGE, MASS. 02138, USA",42.380032,-71.115334,USA,1985,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0
53f37355dabfae4b349c8c57,"225 E Chicago Ave, Chicago, IL 60611, USA",5b865798e1cd8e615362401d,"DEPARTMENT OF PEDIATRICS, CHILDREN'S MEMORIAL HOSPITAL, CHICAGO, ILLINOIS USA.",41.896225,-87.621834,USA,"333 Cedar St, New Haven, CT 06510, USA",5b865638e1cd8e615355057a,YALE UNIVERSITY|SCHOOL OF MEDICINE|DEPARTMENT OF HUMAN GENETICS,41.30323
@zhengyunhan
zhengyunhan / outflow_5year.csv
Created May 1, 2019 20:36
We can't make this file beautiful and searchable because it's too large.
sid,formatted_address,org_id,name,lat,lng,country,des_address,des_org_id,des_schoolname,des_lat,des_lng,des_country,year,MIT,HARVARD,STANFORD,BERKELEY,CMU,CHICAGO,OXFORD,CAMBRIDGE,SACLAY,COPENHAGEN,MCGILL,TORONTO,TOKYO,KYOTO,TSINGHUA,PEKING,SIDNEY,NUS,WEIZMANN,CAPE,PAULO
53f35b6bdabfae4b349708a0,"52 Oxford St, Cambridge, MA 02138, USA",5b865622e1cd8e6153542db1,BIOLOGICAL LABORATORIES|HARVARD UNIVERSITY,42.380032,-71.115334,USA,"52 Oxford St, Cambridge, MA 02138, USA",5b865507e1cd8e615349a6eb,"DEPARTMENT OF BIOCHEMISTRY AND MOLECULAR BIOLOGY HARVARD UNIVERSITY CAMBRIDGE, MASS. 02138, USA",42.380032,-71.115334,USA,1985,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f37355dabfae4b349c8c57,"225 E Chicago Ave, Chicago, IL 60611, USA",5b865798e1cd8e615362401d,"DEPARTMENT OF PEDIATRICS, CHILDREN'S MEMORIAL HOSPITAL, CHICAGO, ILLINOIS USA.",41.896225,-87.621834,USA,"333 Cedar St, New Haven, CT 06510, USA",5b865638e1cd8e615355057a,YALE UNIVERSITY|SCHOOL OF MEDICINE|DEPARTMENT OF HUMAN GENETICS,41.30323,-72.933823,USA,198
@zhengyunhan
zhengyunhan / inflow_5year.csv
Created May 1, 2019 20:33
We can't make this file beautiful and searchable because it's too large.
sid,formatted_address,org_id,name,lat,lng,country,des_address,des_org_id,des_schoolname,des_lat,des_lng,des_country,year,MIT,HARVARD,STANFORD,BERKELEY,CMU,CHICAGO,OXFORD,CAMBRIDGE,SACLAY,COPENHAGEN,MCGILL,TORONTO,TOKYO,KYOTO,TSINGHUA,PEKING,SIDNEY,NUS,WEIZMANN,CAPE,PAULO
53f35b6bdabfae4b349708a0,"52 Oxford St, Cambridge, MA 02138, USA",5b865622e1cd8e6153542db1,BIOLOGICAL LABORATORIES|HARVARD UNIVERSITY,42.380032,-71.115334,USA,"52 Oxford St, Cambridge, MA 02138, USA",5b865507e1cd8e615349a6eb,"DEPARTMENT OF BIOCHEMISTRY AND MOLECULAR BIOLOGY HARVARD UNIVERSITY CAMBRIDGE, MASS. 02138, USA",42.380032,-71.115334,USA,1985,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f3a011dabfae4b34ab455b,"1200 E California Blvd, Pasadena, CA 91125, USA",5b865691e1cd8e6153583b93,"DIVISION OF ENGINEERING AND APPLIED SCIENCE, CALIFORNIA INSTITUTE OF TECHNOLOGY, PASADENA, CA 91125, USA",34.137657,-118.12527,USA,"450 Serra Mall, Stanford, CA 94305, USA",5b865583e1cd8e61534e3374,"DIVISION OF APPLIED MECHANICS, STANFORD UNIVERSITY, STANF
@zhengyunhan
zhengyunhan / select_outflow2.csv
Created April 24, 2019 14:25
We can't make this file beautiful and searchable because it's too large.
sid,year,x_id,formatted_address,org_id,name,lat,lng,country,des_lat,des_lng,des_org_id,des_schoolname,des_country,MIT,HARVARD,STANFORD,BERKELEY,CMU,CHICAGO,OXFORD,CAMBRIDGE,SACLAY,COPENHAGEN,MCGILL,TORONTO,TOKYO,KYOTO,TSINGHUA,PEKING,NUS,WEIZMANN,CAPE,SIDNEY,PAULO
53f31921dabfae9a84429c6f,1995,5b869f6fe1cd8e14a3b0c1cc,"32 Vassar St, Cambridge, MA 02139, USA",5b865691e1cd8e6153583b93,"MASSACHUSETTS INSTITUTE OF TECHNOLOGY, ARTIFICIAL",42.361866,-71.090561,USA,42.3374302,-71.105438,5b865691e1cd8e6153583b93,"HARVARD MEDICAL SCHOOL, DEPARTMENT OF RADIOLOGY, BOSTON, MA, USA. SW@AI.MIT.EDU",USA,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f31921dabfae9a84429c6f,1996,5b86a34ae1cd8e14a3c9b0db,"300 Longwood Ave, Boston, MA 02115, USA",5b865691e1cd8e6153583b93,"HARVARD MEDICAL SCHOOL, DEPARTMENT OF RADIOLOGY, BOSTON, MA, USA. SW@AI.MIT.EDU",42.337429,-71.105438,USA,42.360091,-71.09416,5b865691e1cd8e6153583b93,MASSACHUSETTS INSTITUTE OF TECHNOLOGY,USA,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f31921dabfae9a84429c6f,199
@zhengyunhan
zhengyunhan / select_inflow2.csv
Created April 24, 2019 14:24
We can't make this file beautiful and searchable because it's too large.
sid,year,x_id,formatted_address,org_id,name,lat,lng,country,des_lat,des_lng,des_org_id,des_schoolname,des_country,MIT,HARVARD,STANFORD,BERKELEY,CMU,CHICAGO,OXFORD,CAMBRIDGE,SACLAY,COPENHAGEN,MCGILL,TORONTO,TOKYO,KYOTO,TSINGHUA,PEKING,SIDNEY,NUS,WEIZMANN,CAPE,PAULO
53f31921dabfae9a84429c6f,1994,5b868d10e1cd8e14a3368e88,"45 Francis St, Boston, MA 02115, USA",5b86568de1cd8e6153581b85,BRIGHAM AND WOMEN S HOSPITAL,42.336014,-71.106987,USA,42.3618641,-71.0905626,5b865691e1cd8e6153583b93,"MASSACHUSETTS INSTITUTE OF TECHNOLOGY, ARTIFICIAL",USA,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f31921dabfae9a84429c6f,1995,5b869f6fe1cd8e14a3b0c1cc,"32 Vassar St, Cambridge, MA 02139, USA",5b865691e1cd8e6153583b93,"MASSACHUSETTS INSTITUTE OF TECHNOLOGY, ARTIFICIAL",42.361866,-71.090561,USA,42.3374302,-71.105438,5b865691e1cd8e6153583b93,"HARVARD MEDICAL SCHOOL, DEPARTMENT OF RADIOLOGY, BOSTON, MA, USA. SW@AI.MIT.EDU",USA,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f31921dabfae9a84429c6f,1996,5b86a34ae1cd8e14a3c9b0db,"300 Longwoo
@zhengyunhan
zhengyunhan / select_outflow.csv
Created April 23, 2019 23:12
We can't make this file beautiful and searchable because it's too large.
sid,year,x_id,formatted_address,org_id,name,lat,lng,country,des_lat,des_lng,des_org_id,des_schoolname,des_country,MIT,HARVARD,STANFORD,BERKELEY,CMU,CHICAGO,OXFORD,CAMBRIDGE,SACLAY,COPENHAGEN,MCGILL,TORONTO,TOKYO,KYOTO,TSINGHUA,PEKING,NUS,WEIZMANN,CAPE,SIDNEY,PAULO
53f31921dabfae9a84429c6f,1995,5b869f6fe1cd8e14a3b0c1cc,"32 Vassar St, Cambridge, MA 02139, USA",5b865691e1cd8e6153583b93,"MASSACHUSETTS INSTITUTE OF TECHNOLOGY, ARTIFICIAL",42.361866,-71.090561,USA,42.3374302,-71.105438,5b865691e1cd8e6153583b93,"HARVARD MEDICAL SCHOOL, DEPARTMENT OF RADIOLOGY, BOSTON, MA, USA. SW@AI.MIT.EDU",USA,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f31921dabfae9a84429c6f,1996,5b86a34ae1cd8e14a3c9b0db,"300 Longwood Ave, Boston, MA 02115, USA",5b865691e1cd8e6153583b93,"HARVARD MEDICAL SCHOOL, DEPARTMENT OF RADIOLOGY, BOSTON, MA, USA. SW@AI.MIT.EDU",42.337429,-71.105438,USA,42.360091,-71.09416,5b865691e1cd8e6153583b93,MASSACHUSETTS INSTITUTE OF TECHNOLOGY,USA,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
53f31921dabfae9a84429c6f,199