Created
December 21, 2010 21:58
-
-
Save KristianLyng/750690 to your computer and use it in GitHub Desktop.
awk and population
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| kristian@luke:~$ cat stats | |
| Østfold 202751 221386 233301 238345 251032 268584 271662 3922 69 | |
| Akershus 234323 324390 369193 418114 471988 527625 536499 4620 116 | |
| Oslo 475663 481548 452023 461644 508726 575475 586860 427 1375 | |
| Hedmark 177324 179204 187223 187314 187999 190071 190709 26244 7 | |
| Oppland 166303 172479 180765 182593 183419 184288 185216 23878 8 | |
| Buskerud 168351 198852 214571 225261 238833 254634 257673 13870 19 | |
| Vestfold 174382 175402 186691 198354 215030 229134 231286 2157 107 | |
| Telemark 149943 156778 162050 162869 165595 167548 168231 13894 12 | |
| Aust-Agder 77066 80839 90629 97314 102714 107359 108499 8353 13 | |
| Vest-Agder 109083 124171 136718 145091 156878 168233 170377 6706 25 | |
| Rogaland 239052 268684 305490 337906 375225 420574 427947 8605 50 | |
| Hordaland 341303 373843 391463 411022 438312 469681 477175 14554 33 | |
| Sogn og Fjordane 99957 100933 105924 106614 107590 106457 107080 17709 6 | |
| Møre og Romsdal 213286 223709 236062 238278 243810 248727 251262 14614 17 | |
| Sør-Trøndelag 211819 234022 244760 251076 264865 286729 290547 17909 16 | |
| Nord-Trøndelag 116760 117998 125835 127226 127261 130708 131555 20881 6 | |
| Nordland 237530 240951 244493 239403 238295 235380 236271 36194 7 | |
| Troms Romsa 127771 136805 146818 146816 151777 155553 156494 24950 6 | |
| Finnmark Finnmárku 72104 76311 78331 74590 74087 72492 72856 45984 2 | |
| kristian@luke:~$ awk -F'\t' 'BEGIN { Serv="sort -t \"\t\" -n -k2"; }; { if (NR>1) { printf ("%-20s\t%s %%\n",$1,(($7-$2)/($7))*100) |& Serv };} END { close(Serv, "to"); while (Serv |& getline) print; close(Serv, "from")};' stats | |
| Nordland -0.913417 % | |
| Finnmark Finnmárku 0.535231 % | |
| Sogn og Fjordane 6.10575 % | |
| Hedmark 6.70644 % | |
| Oppland 9.75918 % | |
| Telemark 10.5074 % | |
| Nord-Trøndelag 10.6711 % | |
| Møre og Romsdal 14.249 % | |
| Oslo 17.3443 % | |
| Troms Romsa 17.8602 % | |
| Vestfold 23.8952 % | |
| Østfold 24.5111 % | |
| Sør-Trøndelag 26.1257 % | |
| Hordaland 27.333 % | |
| Aust-Agder 28.2165 % | |
| Buskerud 33.8851 % | |
| Vest-Agder 35.1596 % | |
| Rogaland 43.1605 % | |
| Akershus 55.5891 % |
Author
Author
(Unless I got it wrong!)
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Err, so for those who don't read Norwegian: It's population growth for each county in Norway from 1961 to 2010.