Skip to content

Instantly share code, notes, and snippets.

View joannalok's full-sized avatar

joannalok

View GitHub Profile
@joannalok
joannalok / Australia_Data.csv
Created November 17, 2015 06:41
States 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
New South Wales 6650735 6693206 6742690 6834156 6943461 7053755 7144292 7218529 7307183 7409337 7518472
Victoria 4927149 4989246 5061266 5153522 5256375 5371934 5461101 5537817 5632521 5735007 5841667
Queensland 3829970 3918494 4007992 4111018 4219505 4328771 4404744 4476778 4568205 4651912 4722447
South Australia 1528189 1538804 1552529 1570619 1588665 1608902 1627322 1639614 1656035 1670498 1685714
Western Australia 1979542 2011207 2050581 2106139 2171700 2240250 2290845 2353409 2437994 2519007 2573389
Tasmania 483178 486202 489302 493262 498568 504353 508847 511483 512106 513100 514762
Northern Territory 202663 205905 209057 213748 219874 226027 229778 231292 235881 242541 245079
Australian Capital Territory 328940 331399 335170 342644 348368 354785 361766 367985 375183 381291 385996
@joannalok
joannalok / Australia_Data.csv
Created November 17, 2015 03:24
Intermediate (Module 4: Australia population & unemployment)
New South Wales 6650735 6693206 6742690 6834156 6943461 7053755 7144292 7218529 7307183 7409337 7518472
Victoria 4927149 4989246 5061266 5153522 5256375 5371934 5461101 5537817 5632521 5735007 5841667
Queensland 3829970 3918494 4007992 4111018 4219505 4328771 4404744 4476778 4568205 4651912 4722447
South Australia 1528189 1538804 1552529 1570619 1588665 1608902 1627322 1639614 1656035 1670498 1685714
Western Australia 1979542 2011207 2050581 2106139 2171700 2240250 2290845 2353409 2437994 2519007 2573389
Tasmania 483178 486202 489302 493262 498568 504353 508847 511483 512106 513100 514762
Northern Territory 202663 205905 209057 213748 219874 226027 229778 231292 235881 242541 245079
Australian Capital Territory 328940 331399 335170 342644 348368 354785 361766 367985 375183 381291 385996
@joannalok
joannalok / australia_map.json
Created November 13, 2015 08:27
Intermediate Module 3: Map of Australia
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@joannalok
joannalok / AverageSalary.csv
Created November 7, 2015 12:13
AverageSalary(Week2 Intermediate)
Country 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
Australia 45130 44734 45098 45588 46987 47598 47880 49236 49616 49147 50706 52175 52229 51374 51148
Austria 42298 42193 42876 42994 43673 43904 44601 44863 45550 46230 45978 45444 45733 45660 45988
Belgium 45844 46107 46973 47218 47106 46809 47065 46840 46922 47439 47154 47319 47682 48102 48093
Canada 39207 39078 38669 38682 39703 41384 42683 43712 44514 44968 45165 45858 46902 47794 48164
Czech Republic 14913 15392 16567 17817 18695 19245 20005 20595 20602 20550 21028 21218 21031 20660 21185
Denmark 41736 42050 43016 44089 45101 45886 46695 47248 47897 49055 49576 49174 48901 48761 49589
Estonia 11850 12242 12808 14038 15065 16030 17214 19921 20024 19397 19218 18413 18871 19453 21020
Finland 34725 35108 35307 35987 37175 38047 38932 39525 39908 40230 40862 41002 40968 40736 40742
France 35091 35322 36274 36575 37171 37619 38036 38194 38098 39263 40049 39978 40258 40530 40828
@joannalok
joannalok / PropertyPriceIndex.csv
Created November 1, 2015 04:51
Intermediate Module 1 (Revised)
Rank Country Price_To_Income_Ratio Gross_Rental_Yield_City_Centre Gross_Rental_Yield_Outside_of_Centre Price_To_Rent_Ratio_City_Centre Price_To_Rent_Ratio_Outside_of_City_Centre Mortgage_as_a_percentage_of_income affordability_index
1 Papua New Guinea 93 5.96 17.74 16.77 5.64 1140.6 0.09
2 Cuba 77.62 25.63 13.74 3.9 7.28 564.42 0.18
3 Hong Kong 31.49 2.38 2.6 42.1 38.44 203.31 0.49
4 Ghana 29.8 10.87 14.37 9.2 6.96 745.59 0.13
5 Syria 29.14 4.1 3.06 24.37 32.64 271.14 0.37
6 Uganda 28.89 1.79 8.53 55.74 11.73 575.44 0.17
7 Taiwan 28.48 1.1 1.34 90.62 74.9 174.34 0.57
8 Vietnam 27.27 4.26 6.6 23.48 15.15 302.51 0.33
9 Macao 26.98 3.49 1.82 28.66 54.9 183.01 0.55
@joannalok
joannalok / PropertyPriceIndex.csv
Created October 28, 2015 07:32
Intermediate: Module1
1 Papua New Guinea 93 5.96 17.74 16.77 5.64 1140.6 0.09
2 Cuba 77.62 25.63 13.74 3.9 7.28 564.42 0.18
3 Hong Kong 31.49 2.38 2.6 42.1 38.44 203.31 0.49
4 Ghana 29.8 10.87 14.37 9.2 6.96 745.59 0.13
5 Syria 29.14 4.1 3.06 24.37 32.64 271.14 0.37
6 Uganda 28.89 1.79 8.53 55.74 11.73 575.44 0.17
7 Taiwan 28.48 1.1 1.34 90.62 74.9 174.34 0.57
8 Vietnam 27.27 4.26 6.6 23.48 15.15 302.51 0.33
9 Macao 26.98 3.49 1.82 28.66 54.9 183.01 0.55
@joannalok
joannalok / HKCCI.csv
Created September 25, 2015 10:39
Centra-City Index (Week 6)
YYYYMM CCI
2015-07 142.3
2015-06 140.35
2015-05 138.5
2015-04 137.47
2015-03 135.8
2015-02 135.28
2015-01 132.51
2014-12 130.16
2014-11 127.34
@joannalok
joannalok / PropertyPriceIndex.csv
Created September 25, 2015 09:14
PropertyPriceIndex (Week5 Updates)
1 Papua New Guinea 93 5.96 17.74 16.77 5.64 1140.6 0.09
2 Cuba 77.62 25.63 13.74 3.9 7.28 564.42 0.18
3 Hong Kong 31.49 2.38 2.6 42.1 38.44 203.31 0.49
4 Ghana 29.8 10.87 14.37 9.2 6.96 745.59 0.13
5 Syria 29.14 4.1 3.06 24.37 32.64 271.14 0.37
6 Uganda 28.89 1.79 8.53 55.74 11.73 575.44 0.17
7 Taiwan 28.48 1.1 1.34 90.62 74.9 174.34 0.57
8 Vietnam 27.27 4.26 6.6 23.48 15.15 302.51 0.33
9 Macao 26.98 3.49 1.82 28.66 54.9 183.01 0.55
@joannalok
joannalok / PropertyPriceIndex.csv
Created September 17, 2015 03:53
PropertyPriceIndex (Week 5)
1 Papua New Guinea 93 5.96 17.74 16.77 5.64 1140.6 0.09
2 Cuba 77.62 25.63 13.74 3.9 7.28 564.42 0.18
3 Hong Kong 31.49 2.38 2.6 42.1 38.44 203.31 0.49
4 Ghana 29.8 10.87 14.37 9.2 6.96 745.59 0.13
5 Syria 29.14 4.1 3.06 24.37 32.64 271.14 0.37
6 Uganda 28.89 1.79 8.53 55.74 11.73 575.44 0.17
7 Taiwan 28.48 1.1 1.34 90.62 74.9 174.34 0.57
8 Vietnam 27.27 4.26 6.6 23.48 15.15 302.51 0.33
9 Macao 26.98 3.49 1.82 28.66 54.9 183.01 0.55
@joannalok
joannalok / PropertyPriceIndex.csv
Created September 10, 2015 11:09
PropertyPriceIndex (Week4)
1 Papua New Guinea 93 5.96 17.74 16.77 5.64 1140.6 0.09
2 Cuba 77.62 25.63 13.74 3.9 7.28 564.42 0.18
3 Hong Kong 31.49 2.38 2.6 42.1 38.44 203.31 0.49
4 Ghana 29.8 10.87 14.37 9.2 6.96 745.59 0.13
5 Syria 29.14 4.1 3.06 24.37 32.64 271.14 0.37
6 Uganda 28.89 1.79 8.53 55.74 11.73 575.44 0.17
7 Taiwan 28.48 1.1 1.34 90.62 74.9 174.34 0.57
8 Vietnam 27.27 4.26 6.6 23.48 15.15 302.51 0.33
9 Macao 26.98 3.49 1.82 28.66 54.9 183.01 0.55