Skip to content

Instantly share code, notes, and snippets.

View harkanwals's full-sized avatar
🎯
Focusing

Harkanwal harkanwals

🎯
Focusing
35 followers · 163 following
  • Auckland, New Zealand
View GitHub Profile
@harkanwals
harkanwals / test.csv
Created February 14, 2022 00:07
test font
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
‎‎​
@harkanwals
harkanwals / slope_chart.R
Created September 23, 2019 13:03
ethnicity_slope_chart_nz
require(tidyr)
require(dplyr)
require(ggrepel)
require(ggplot2)
require(kableExtra)
tibble::tribble(
~ethnicity_group, ~y2013, ~y2018,
"European", 74, 70.2,
@harkanwals
harkanwals / anzsic_code_for_level_4.csv
Last active September 7, 2022 23:38
anzsic codes with industry description upto level 3
code industry_description
A0111 Nursery Production (Under Cover)
A0112 Nursery Production (Outdoors)
A0113 Turf Growing
A0114 Floriculture Production (Under Cover)
A0115 Floriculture Production (Outdoors)
A0121 Mushroom Growing
A0122 Vegetable Growing (Under Cover)
A0123 Vegetable Growing (Outdoors)
A0131 Grape Growing
@harkanwals
harkanwals / mb_data.json
Created January 26, 2019 06:17
mbnz
This file has been truncated, but you can view the full file.
[{"mb":"0000100","population":3,"longitude":172.7677,"latitude":-34.4788},{"mb":"0000200","population":84,"longitude":172.9465,"latitude":-34.4567,"income":16700},{"mb":"0000300","population":57,"longitude":172.8798,"latitude":-34.5098,"income":15300},{"mb":"0000400","population":30,"longitude":172.8252,"latitude":-34.5603,"income":10800},{"mb":"0000502","population":36,"longitude":172.9096,"latitude":-34.5597,"income":20800},{"mb":"0000600","population":39,"longitude":172.9082,"latitude":-34.6357,"income":28800},{"mb":"0000700","population":63,"longitude":172.9521,"latitude":-34.6421,"income":20800},{"mb":"0000800","population":105,"longitude":172.9991,"latitude":-34.628,"income":16700},{"mb":"0000900","population":24,"longitude":172.9771,"latitude":-34.7078,"income":27500},{"mb":"0001000","population":81,"longitude":173.0097,"latitude":-34.7573,"income":16900},{"mb":"0001100","population":96,"longitude":173.0636,"latitude":-34.7718,"income":23300},{"mb":"0001201","population":93,"longitude":173.1008,"latitu
@harkanwals
harkanwals / quarterly.csv
Created June 14, 2018 14:44
region date median change
Queenstown-Lakes District 2017-12-31 938139.662027833 3.957
Queenstown-Lakes District 2017-09-30 935650.924376103 6.121
Queenstown-Lakes District 2018-03-31 902500 5.021
Queenstown-Lakes District 2016-12-31 902430.524733034 27.565
Queenstown-Lakes District 2017-06-30 900548.25 5.481
Queenstown-Lakes District 2016-09-30 881685.62927262 30.755
Auckland 2016-12-31 878054.307758913 10.331
Auckland 2017-06-30 874515 1.818
Auckland 2017-12-31 874324.055666004 -0.425
@harkanwals
harkanwals / quarterly_change.csv
Created June 14, 2018 13:48
region date change
Whangarei District 1994-03-31 0.836
Kaipara District 1994-03-31 -11.158
Thames-Coromandel District 1994-03-31 7.933
Hauraki District 1994-03-31 1.607
Waikato District 1994-03-31 4.696
Matamata-Piako District 1994-03-31 -5.987
Hamilton City 1994-03-31 5.893
Waipa District 1994-03-31 1.468
Otorohanga District 1994-03-31 27.04
@harkanwals
harkanwals / quarterly_change.csv
Created June 14, 2018 13:42
region date change
Whangarei District 1994-03-31 0.836433
Kaipara District 1994-03-31 -11.1578
Thames-Coromandel District 1994-03-31 7.93282
Hauraki District 1994-03-31 1.60744
Waikato District 1994-03-31 4.6962
Matamata-Piako District 1994-03-31 -5.98708
Hamilton City 1994-03-31 5.89273
Waipa District 1994-03-31 1.46836
Otorohanga District 1994-03-31 27.0401
@harkanwals
harkanwals / quarter_change.csv
Created June 14, 2018 13:40
region date change
Whangarei District 1994-03-31 0
Kaipara District 1994-03-31 -0
Thames-Coromandel District 1994-03-31 0
Hauraki District 1994-03-31 0
Waikato District 1994-03-31 0
Matamata-Piako District 1994-03-31 -0
Hamilton City 1994-03-31 0
Waipa District 1994-03-31 0
Otorohanga District 1994-03-31 0
@harkanwals
harkanwals / quarter_change.csv
Created June 14, 2018 13:39
region date change
Whangarei District 1994-03-31 0.8364333915328906
Kaipara District 1994-03-31 -11.1577950013541
Thames-Coromandel District 1994-03-31 7.932823081118211
Hauraki District 1994-03-31 1.607444008584863
Waikato District 1994-03-31 4.696201176854893
Matamata-Piako District 1994-03-31 -5.987084657518273
Hamilton City 1994-03-31 5.892729190304423
Waipa District 1994-03-31 1.4683581638272996
Otorohanga District 1994-03-31 27.040061254101015
@harkanwals
harkanwals / rents.csv
Created June 14, 2018 08:28
month region rent
1993-01-01 Auckland 196
1993-02-01 Auckland 196
1993-03-01 Auckland 193
1993-04-01 Auckland 195
1993-05-01 Auckland 200
1993-06-01 Auckland 194
1993-07-01 Auckland 203
1993-08-01 Auckland 200
1993-09-01 Auckland 201