Skip to content

Instantly share code, notes, and snippets.

View xianwu's full-sized avatar

xianwu

View GitHub Profile
@xianwu
xianwu / Data Imported from WDVP Datasets_xlsx2.csv
Created December 28, 2018 21:34
indicator region sub_region ISO_Country_code population surface_area__Km2_ y index
Afghanistan Asia Southern Asia AFG 36000000 652230 20.2 happy_planet_index
Albania Europe Southern Europe ALB 2900000 27398 36.8 happy_planet_index
Algeria Africa Northern Africa DZA 41000000 2381740 33.3 happy_planet_index
Andorra Europe Southern Europe AND 77000 468 happy_planet_index
Angola Africa Sub-Saharan Africa AGO 30000000 1246700 happy_planet_index
Antigua & Barbuda Americas Latin America and the Caribbean ATG 102000 442.6 happy_planet_index
Argentina Americas Latin America and the Caribbean ARG 44000000 2736690 35.2 happy_planet_index
Armenia Asia Western Asia ARM 3000000 28203 25.7 happy_planet_index
Australia Oceania Australia and New Zealand AUS 25000000 7682300 21.2 happy_planet_index
@xianwu
xianwu / whatMakesAGoodGovernment.csv
Last active December 28, 2018 14:50
what makes a 'good' government
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 36 columns, instead of 3 in line 2.
indicator,region,sub_region,ISO_Country_code,population,surface_area__Km2_,GINI_index,happy_planet_index,human_development_index,world_happiness_report_score,sustainable_economic_development,GDP___billions_PPP_,GDP_per_capita__PPP_,GDP_growth__annual___,health_expenditure____of_GDP,health_expenditure__per_person,education_expenditure___of_GDP,education_expenditure__per_perso,school_life_expectancy__YEARS_,unemployment____,government_spending_score,government_expenditure____of_GDP,political_rights_score,civil_liberties_score,political_stability___absence_of,government_effectiveness,regulatory_quality,rule_of_law,control_of_corruption,judicial_effectiveness_score,government_integrity_score,property_rights_score,tax_burden_score,overall_economic_freedom_score,financial_freedom_score,women_MPs____of_all_MPs_
Afghanistan,Asia,Southern Asia,AFG,36000000,652230,,20.2,0.498,2.66,,64.1,1919,1.5,10.3,184,3.8,24,11,8.5,79.3,26.3,5,6,-2.78,-1.3,-1.3,-1.57,-1.52,28.2,26.2,17.9,91.8,51.3,10,27.7
Albania,Europe,Southern Eur
@xianwu
xianwu / someHEDIdata.csv
Created December 12, 2018 16:44
two years data for 122 schools with teacher HEDI distribution
FiscalYear Field Support Center Name Superintendent SchoolDBN Switcher Highly Effective Effective Developing Ineffective
2018 FSC A SUPT A 11Z484 % of Total Distinct count of EmployeeID along MOTP_Rating 17.90% 60.70% 21.40%
2018 FSC A SUPT A 11Z484 Distinct count of EmployeeID 5 17 6
2018 FSC A SUPT A 11Z509 % of Total Distinct count of EmployeeID along MOTP_Rating 11.10% 86.10% 2.80%
2018 FSC A SUPT A 11Z509 Distinct count of EmployeeID 4 31 1
2018 FSC A SUPT A 11Z513 % of Total Distinct count of EmployeeID along MOTP_Rating 48.50% 39.40% 12.10%
2018 FSC A SUPT A 11Z513 Distinct count of EmployeeID 16 13 4
2018 FSC A SUPT A 11Z633 % of Total Distinct count of EmployeeID along MOTP_Rating 57.10% 28.60% 14.30%
2018 FSC A SUPT A 11Z633 Distinct count of EmployeeID 12 6 3
2018 FSC A SUPT A 11Z634 % of Total Distinct count of EmployeeID along MOTP_Rating 55.20% 41.40% 3.40%
@xianwu
xianwu / GIS.OFFICIAL_CLIM_DIVISIONS.json
Created December 11, 2018 22:04
United States map TopoJson file
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@xianwu
xianwu / barSample.csv
Created December 5, 2018 21:58
tiny sample data
DataName month DataValue
Data One January 20
Data One February 30
Data One March 5
Data Two January 10
Data Two February 30
Data Two March 18
Data Three January 15
Data Three February 40
Data Three March 27
@xianwu
xianwu / incomes.csv
Created November 14, 2018 21:30
income of multi countries, multi years, and different percentiles
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
val cutoff year country
6910 cop5 1981 Australia
6864 cop5 1985 Australia
6555 cop5 1989 Australia
6551 cop5 1995 Australia
7002 cop5 2001 Australia
7090 cop5 2003 Australia
8818 cop5 1987 Austria
8744 cop5 1994 Austria
5813 cop5 1995 Austria
@xianwu
xianwu / barley-extended.csv
Created November 14, 2018 21:27
barley csv file with 6 sites, 22 variety, and 10 years data
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
yield gen year site
47.5 Manchuria 1927 StPaul
45.4 Glabron 1927 StPaul
45 Svansota 1927 StPaul
43.4 Velvet 1927 StPaul
60.2 Trebi 1927 StPaul
45.2 ManxSA 1927 StPaul
50.3 SAxMan 1927 StPaul
49 Peatland 1927 StPaul
45.9 Colsess 1927 StPaul
@xianwu
xianwu / barley.txv
Created November 14, 2018 21:09
barley tsv file with 6 sites, 10 variety and 2 years data
yield variety year site
27 Manchuria 1931 University Farm
48.86667 Manchuria 1931 Waseca
27.43334 Manchuria 1931 Morris
39.93333 Manchuria 1931 Crookston
32.96667 Manchuria 1931 Grand Rapids
28.96667 Manchuria 1931 Duluth
43.06666 Glabron 1931 University Farm
55.2 Glabron 1931 Waseca
28.76667 Glabron 1931 Morris