{ "cells": [ { "cell_type": "markdown", "id": "6bde7fc5", "metadata": {}, "source": [ "## How-to: Reshaping data\n", "\n", "You will often need to change the shape of a dataset. For example, in order to merge data or visualise it. In this lab, we will show how to quickly change the shape from long-to-wide format, with the pivot function, and from wide-to-long with the melt and stack functions. \n", "\n", "A full explanation of the reshaping capabilities in Pandas can be found in the [Pandas how-to](https://pandas.pydata.org/docs/user_guide/reshaping.html)\n", "\n", "We'll start by loading in a dataset from the [SSB API ready-made datasets](https://data.ssb.no/api/?lang=en) of population in Norwegian municipalities.\n", "\n", "See the [how-to on working with ssb data](https://nbviewer.org/url/jmaurit.github.io/anv_statistikk/SSB_data.ipynb)" ] }, { "cell_type": "code", "execution_count": 12, "id": "876caf9d", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import matplotlib as mpt\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "import statsmodels.formula.api as smf\n", "import statsmodels.api as sm" ] }, { "cell_type": "code", "execution_count": 17, "id": "87623597", "metadata": {}, "outputs": [], "source": [ "pop = pd.read_csv(\"https://data.ssb.no/api/v0/dataset/26975.csv?lang=en\", encoding = \"ISO-8859-1\")\n" ] }, { "cell_type": "markdown", "id": "2aea7572", "metadata": {}, "source": [ "A bit of cleaning" ] }, { "cell_type": "code", "execution_count": 18, "id": "51d0398e", "metadata": {}, "outputs": [], "source": [ "#pop[\"kommunenummer\"] = pop.region.str.slice(start=2, stop=6)\n", "pop = pop.loc[pop.kommunenummer!=\"Rest\",:]\n", "pop = pop.loc[pop.kommunenummer!=\"23 K\",:]\n", "pop = pop.loc[pop.kommunenummer!=\"21-2\",:]\n", "pop = pop.loc[pop.kommunenummer!=\"23 C\",:]\n", "pop = pop.rename(columns={'07459: Population, by region, year and contents':\"population\"})" ] }, { "cell_type": "markdown", "id": "5d2c266e", "metadata": {}, "source": [ "### From long to wide" ] }, { "cell_type": "code", "execution_count": 25, "id": "74d115ed", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
regionyearcontentspopulationkommunenummer
0K-3001 Halden1986Persons258443001
1K-3001 Halden1987Persons258073001
2K-3001 Halden1988Persons258483001
3K-3001 Halden1989Persons258413001
4K-3001 Halden1990Persons258163001
..................
13167K-5444 Sør-Varanger2018Persons101715444
13168K-5444 Sør-Varanger2019Persons101565444
13169K-5444 Sør-Varanger2020Persons101585444
13170K-5444 Sør-Varanger2021Persons101035444
13171K-5444 Sør-Varanger2022Persons99255444
\n", "

13172 rows × 5 columns

\n", "
" ], "text/plain": [ " region year contents population kommunenummer\n", "0 K-3001 Halden 1986 Persons 25844 3001\n", "1 K-3001 Halden 1987 Persons 25807 3001\n", "2 K-3001 Halden 1988 Persons 25848 3001\n", "3 K-3001 Halden 1989 Persons 25841 3001\n", "4 K-3001 Halden 1990 Persons 25816 3001\n", "... ... ... ... ... ...\n", "13167 K-5444 Sør-Varanger 2018 Persons 10171 5444\n", "13168 K-5444 Sør-Varanger 2019 Persons 10156 5444\n", "13169 K-5444 Sør-Varanger 2020 Persons 10158 5444\n", "13170 K-5444 Sør-Varanger 2021 Persons 10103 5444\n", "13171 K-5444 Sør-Varanger 2022 Persons 9925 5444\n", "\n", "[13172 rows x 5 columns]" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop" ] }, { "cell_type": "markdown", "id": "96c74aa0", "metadata": {}, "source": [ "Looking at the data above, we would say that this data is in **long** format. That means that we have one column with all the values of population, and then seperate columns saying which municipality and which year the population is for. \n", "\n", "Perhaps we would prefer to have a column for the population of each of the municipalities, where the rows would then indicate the years. This is what we call **wide** format. To do this, we use the function *pivot*" ] }, { "cell_type": "code", "execution_count": 26, "id": "8b2743d5", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
regionK-0301 OsloK-1101 EigersundK-1103 StavangerK-1106 HaugesundK-1108 SandnesK-1111 SokndalK-1112 LundK-1114 BjerkreimK-1119 HåK-1120 Klepp...K-5435 NordkappK-5436 Porsanger - Porsángu - PorsankiK-5437 Kárásjohka - KarasjokK-5438 LebesbyK-5439 GamvikK-5440 BerlevågK-5441 Deatnu - TanaK-5442 Unjárga - NessebyK-5443 BåtsfjordK-5444 Sør-Varanger
year
19864493951208710031126883418033483311022831271511358...4393438926941811152315333309100626439853
19874513451215910076126884428873487310923051280211565...421444042654179414791469328999925509745
19884537301220310173326947435253507311323201286811688...4127438626701736145814123215100824619564
19894561241233710230827229446133497313823091298811796...4061444326581761145013743201103024019579
19904583641239110290827600453393487310123401303411788...3975447526521754142413673195103723469641
19914616441239810353627788459833453308623731302211871...3986451426901695139813403232105623419693
19924674411249510519228106467473486305923731306711953...3994451127261652138813443268105623219758
19934734541264610679728436478483501308324321304112202...3962453527571630142313203299105923709819
19944777811272110807228670489563508307124371340912381...3970449327861598146112923274107224749930
19954834011279810912629064497633517307224581326812605...3914446127881578145513243272104825479913
19964886591286310999629229502733495306324491328012757...38524461278915681410133231981058262210010
19974947931290411132429385509743484309124491335612950...3771447128671576132612643142104125509843
19984996931304511262429699518633424308424371349813240...3606442228571538133712613137103525449790
19995028671310911389329888530923394309224541372313548...3554439728711483128312523056102124549646
20005074671328811479430362540163358309624561392113789...351744512901146312881236307496524709532
20015087261329111487030609548933354311424831401713884...350543582877152412691212304496324519498
20025125891332411578130742559843309313024671420314009...351343492852151112341210303996624079608
20035174011335011707431013568053294309724801441714135...349742942844150012051193306892924049547
20045218861338811852331361577373320310524611457014313...346843292865147311341158300492722909500
20055298461340812011331530587203309312924631478414536...341542992876143011141133303790121859463
20065384111341812129831738600393301309824751488314832...333042222889139110761104300689221719464
20075486171359412351332303616103266312025071507215271...327441412873135710461086297988421139490
20085604841377812605832956631533242311225391543815839...321940592866130410401077295485620909518
20095754751396912828833665645653246311125801594916350...318040002786133210251061295187820749623
20105868601417013070934049658203285313925831634216918...318539912789134210091044291288420709738
20115992301434613314234619674113265318626511682217397...32243980276813369911031289789320719826
20126132851447513484935099690043257318327391724417746...322839462763135610081015289690120899860
20136239661463613682535753712733286317327791763518227...320539682721133910631025290088221629968
20146344631481113856736099731423303322528201811518485...3213396326981341109810572883919220710090
20156476761491614004336538748323309324728611852818741...3278392527081343111610202909934223510221
20166583901494214072136951760583313324328251859118970...3276397826681318113910002922959221110227
20176667591489914085637166767423316325928261880019042...329139712696133011379912911951226710199
20186734691489814118637167775743331323728261876219217...323939642701134911539832922944226310171
20196810711483014203437250784393305321328071881419354...321839442673132811699812900941227010156
20206934941481114357437357795373280320227871899119588...316239982628129011329572918926222110158
20216970101478714414737323804503257317427911912019848...307539212641127110979282829880220010103
20226998271486014469937444813053281317827891929620163...29473904258412211057906282185421659925
\n", "

37 rows × 356 columns

\n", "
" ], "text/plain": [ "region K-0301 Oslo K-1101 Eigersund K-1103 Stavanger K-1106 Haugesund \\\n", "year \n", "1986 449395 12087 100311 26883 \n", "1987 451345 12159 100761 26884 \n", "1988 453730 12203 101733 26947 \n", "1989 456124 12337 102308 27229 \n", "1990 458364 12391 102908 27600 \n", "1991 461644 12398 103536 27788 \n", "1992 467441 12495 105192 28106 \n", "1993 473454 12646 106797 28436 \n", "1994 477781 12721 108072 28670 \n", "1995 483401 12798 109126 29064 \n", "1996 488659 12863 109996 29229 \n", "1997 494793 12904 111324 29385 \n", "1998 499693 13045 112624 29699 \n", "1999 502867 13109 113893 29888 \n", "2000 507467 13288 114794 30362 \n", "2001 508726 13291 114870 30609 \n", "2002 512589 13324 115781 30742 \n", "2003 517401 13350 117074 31013 \n", "2004 521886 13388 118523 31361 \n", "2005 529846 13408 120113 31530 \n", "2006 538411 13418 121298 31738 \n", "2007 548617 13594 123513 32303 \n", "2008 560484 13778 126058 32956 \n", "2009 575475 13969 128288 33665 \n", "2010 586860 14170 130709 34049 \n", "2011 599230 14346 133142 34619 \n", "2012 613285 14475 134849 35099 \n", "2013 623966 14636 136825 35753 \n", "2014 634463 14811 138567 36099 \n", "2015 647676 14916 140043 36538 \n", "2016 658390 14942 140721 36951 \n", "2017 666759 14899 140856 37166 \n", "2018 673469 14898 141186 37167 \n", "2019 681071 14830 142034 37250 \n", "2020 693494 14811 143574 37357 \n", "2021 697010 14787 144147 37323 \n", "2022 699827 14860 144699 37444 \n", "\n", "region K-1108 Sandnes K-1111 Sokndal K-1112 Lund K-1114 Bjerkreim \\\n", "year \n", "1986 41803 3483 3110 2283 \n", "1987 42887 3487 3109 2305 \n", "1988 43525 3507 3113 2320 \n", "1989 44613 3497 3138 2309 \n", "1990 45339 3487 3101 2340 \n", "1991 45983 3453 3086 2373 \n", "1992 46747 3486 3059 2373 \n", "1993 47848 3501 3083 2432 \n", "1994 48956 3508 3071 2437 \n", "1995 49763 3517 3072 2458 \n", "1996 50273 3495 3063 2449 \n", "1997 50974 3484 3091 2449 \n", "1998 51863 3424 3084 2437 \n", "1999 53092 3394 3092 2454 \n", "2000 54016 3358 3096 2456 \n", "2001 54893 3354 3114 2483 \n", "2002 55984 3309 3130 2467 \n", "2003 56805 3294 3097 2480 \n", "2004 57737 3320 3105 2461 \n", "2005 58720 3309 3129 2463 \n", "2006 60039 3301 3098 2475 \n", "2007 61610 3266 3120 2507 \n", "2008 63153 3242 3112 2539 \n", "2009 64565 3246 3111 2580 \n", "2010 65820 3285 3139 2583 \n", "2011 67411 3265 3186 2651 \n", "2012 69004 3257 3183 2739 \n", "2013 71273 3286 3173 2779 \n", "2014 73142 3303 3225 2820 \n", "2015 74832 3309 3247 2861 \n", "2016 76058 3313 3243 2825 \n", "2017 76742 3316 3259 2826 \n", "2018 77574 3331 3237 2826 \n", "2019 78439 3305 3213 2807 \n", "2020 79537 3280 3202 2787 \n", "2021 80450 3257 3174 2791 \n", "2022 81305 3281 3178 2789 \n", "\n", "region K-1119 Hå K-1120 Klepp ... K-5435 Nordkapp \\\n", "year ... \n", "1986 12715 11358 ... 4393 \n", "1987 12802 11565 ... 4214 \n", "1988 12868 11688 ... 4127 \n", "1989 12988 11796 ... 4061 \n", "1990 13034 11788 ... 3975 \n", "1991 13022 11871 ... 3986 \n", "1992 13067 11953 ... 3994 \n", "1993 13041 12202 ... 3962 \n", "1994 13409 12381 ... 3970 \n", "1995 13268 12605 ... 3914 \n", "1996 13280 12757 ... 3852 \n", "1997 13356 12950 ... 3771 \n", "1998 13498 13240 ... 3606 \n", "1999 13723 13548 ... 3554 \n", "2000 13921 13789 ... 3517 \n", "2001 14017 13884 ... 3505 \n", "2002 14203 14009 ... 3513 \n", "2003 14417 14135 ... 3497 \n", "2004 14570 14313 ... 3468 \n", "2005 14784 14536 ... 3415 \n", "2006 14883 14832 ... 3330 \n", "2007 15072 15271 ... 3274 \n", "2008 15438 15839 ... 3219 \n", "2009 15949 16350 ... 3180 \n", "2010 16342 16918 ... 3185 \n", "2011 16822 17397 ... 3224 \n", "2012 17244 17746 ... 3228 \n", "2013 17635 18227 ... 3205 \n", "2014 18115 18485 ... 3213 \n", "2015 18528 18741 ... 3278 \n", "2016 18591 18970 ... 3276 \n", "2017 18800 19042 ... 3291 \n", "2018 18762 19217 ... 3239 \n", "2019 18814 19354 ... 3218 \n", "2020 18991 19588 ... 3162 \n", "2021 19120 19848 ... 3075 \n", "2022 19296 20163 ... 2947 \n", "\n", "region K-5436 Porsanger - Porsángu - Porsanki  K-5437 Kárásjohka - Karasjok \\\n", "year \n", "1986 4389 2694 \n", "1987 4404 2654 \n", "1988 4386 2670 \n", "1989 4443 2658 \n", "1990 4475 2652 \n", "1991 4514 2690 \n", "1992 4511 2726 \n", "1993 4535 2757 \n", "1994 4493 2786 \n", "1995 4461 2788 \n", "1996 4461 2789 \n", "1997 4471 2867 \n", "1998 4422 2857 \n", "1999 4397 2871 \n", "2000 4451 2901 \n", "2001 4358 2877 \n", "2002 4349 2852 \n", "2003 4294 2844 \n", "2004 4329 2865 \n", "2005 4299 2876 \n", "2006 4222 2889 \n", "2007 4141 2873 \n", "2008 4059 2866 \n", "2009 4000 2786 \n", "2010 3991 2789 \n", "2011 3980 2768 \n", "2012 3946 2763 \n", "2013 3968 2721 \n", "2014 3963 2698 \n", "2015 3925 2708 \n", "2016 3978 2668 \n", "2017 3971 2696 \n", "2018 3964 2701 \n", "2019 3944 2673 \n", "2020 3998 2628 \n", "2021 3921 2641 \n", "2022 3904 2584 \n", "\n", "region K-5438 Lebesby K-5439 Gamvik K-5440 Berlevåg K-5441 Deatnu - Tana \\\n", "year \n", "1986 1811 1523 1533 3309 \n", "1987 1794 1479 1469 3289 \n", "1988 1736 1458 1412 3215 \n", "1989 1761 1450 1374 3201 \n", "1990 1754 1424 1367 3195 \n", "1991 1695 1398 1340 3232 \n", "1992 1652 1388 1344 3268 \n", "1993 1630 1423 1320 3299 \n", "1994 1598 1461 1292 3274 \n", "1995 1578 1455 1324 3272 \n", "1996 1568 1410 1332 3198 \n", "1997 1576 1326 1264 3142 \n", "1998 1538 1337 1261 3137 \n", "1999 1483 1283 1252 3056 \n", "2000 1463 1288 1236 3074 \n", "2001 1524 1269 1212 3044 \n", "2002 1511 1234 1210 3039 \n", "2003 1500 1205 1193 3068 \n", "2004 1473 1134 1158 3004 \n", "2005 1430 1114 1133 3037 \n", "2006 1391 1076 1104 3006 \n", "2007 1357 1046 1086 2979 \n", "2008 1304 1040 1077 2954 \n", "2009 1332 1025 1061 2951 \n", "2010 1342 1009 1044 2912 \n", "2011 1336 991 1031 2897 \n", "2012 1356 1008 1015 2896 \n", "2013 1339 1063 1025 2900 \n", "2014 1341 1098 1057 2883 \n", "2015 1343 1116 1020 2909 \n", "2016 1318 1139 1000 2922 \n", "2017 1330 1137 991 2911 \n", "2018 1349 1153 983 2922 \n", "2019 1328 1169 981 2900 \n", "2020 1290 1132 957 2918 \n", "2021 1271 1097 928 2829 \n", "2022 1221 1057 906 2821 \n", "\n", "region K-5442 Unjárga - Nesseby K-5443 Båtsfjord K-5444 Sør-Varanger \n", "year \n", "1986 1006 2643 9853 \n", "1987 999 2550 9745 \n", "1988 1008 2461 9564 \n", "1989 1030 2401 9579 \n", "1990 1037 2346 9641 \n", "1991 1056 2341 9693 \n", "1992 1056 2321 9758 \n", "1993 1059 2370 9819 \n", "1994 1072 2474 9930 \n", "1995 1048 2547 9913 \n", "1996 1058 2622 10010 \n", "1997 1041 2550 9843 \n", "1998 1035 2544 9790 \n", "1999 1021 2454 9646 \n", "2000 965 2470 9532 \n", "2001 963 2451 9498 \n", "2002 966 2407 9608 \n", "2003 929 2404 9547 \n", "2004 927 2290 9500 \n", "2005 901 2185 9463 \n", "2006 892 2171 9464 \n", "2007 884 2113 9490 \n", "2008 856 2090 9518 \n", "2009 878 2074 9623 \n", "2010 884 2070 9738 \n", "2011 893 2071 9826 \n", "2012 901 2089 9860 \n", "2013 882 2162 9968 \n", "2014 919 2207 10090 \n", "2015 934 2235 10221 \n", "2016 959 2211 10227 \n", "2017 951 2267 10199 \n", "2018 944 2263 10171 \n", "2019 941 2270 10156 \n", "2020 926 2221 10158 \n", "2021 880 2200 10103 \n", "2022 854 2165 9925 \n", "\n", "[37 rows x 356 columns]" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop_wide = pop.pivot(index=\"year\", columns=\"region\", values=\"population\")\n", "pop_wide" ] }, { "cell_type": "markdown", "id": "0002638a", "metadata": {}, "source": [ "Above we have the data in wide format, where we have a column for each category - in this case municipalities. In this format, we could relatively easily plot the development of population in Stavanger and Sandnes " ] }, { "cell_type": "code", "execution_count": 27, "id": "fe652607", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAEGCAYAAAB7DNKzAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAA5dklEQVR4nO3deXwV5fn//9eVhUASErIQIISQCGELmyQgm4qigBXBKgoVK1qrrW3dPl8tUm3Vaqv+uvixi7RY19YNsX5wQUVQilqQRfZ9C5AQyB4Ssp7k+v0xkxAghCXLyXI9H4/zOCf3zByuM0DeZ+a+5x5RVYwxxpjT8fF2AcYYY5o3CwpjjDF1sqAwxhhTJwsKY4wxdbKgMMYYUyc/bxfQ0CIjIzUuLs7bZRhjTIuydu3aLFXtXNuyVhcUcXFxrFmzxttlGGNMiyIi+0+3zE49GWOMqZMFhTHGmDpZUBhjjKlTq+ujqE15eTmpqamUlJR4uxTTBNq3b09MTAz+/v7eLsWYVqFNBEVqaiodO3YkLi4OEfF2OaYRqSrZ2dmkpqYSHx/v7XKMaRXaxKmnkpISIiIiLCTaABEhIiLCjh6NaUBtIigAC4k2xP6ujWlYbeLUkzHGtDaqSn5xOam5xRzMKSI1t5jAAF9mXtSzwf8sC4o24Fe/+hWXXHIJV1xxhbdLMcacg6Ml5RzMKeJgTjGpuU4YHH8uprDUc8L6F8Z2sqAwzrcIVcXH5+zPGv76179uxIqMMfW1/fBR1qTkcjC3iNScYg7kFHEwt4i8ovIT1gsO8CMmrAMxYYGMvCCi+nVMWAd6hAcS2qFxRvpZULQAKSkpXHXVVVx22WWsWLGCa6+9lg8//JDS0lK++93v8vjjjwPwxBNP8Prrr9OjRw8iIyNJSkrigQce4NZbb2Xy5MlMmzaNpUuX8sADD+DxeBg+fDhz584lICCAuLg4Zs2axQcffEB5eTnvvPMO/fr18/InN6b1OphTxPsbDrFwfRo7jxQC0M7Xx/nlHx7I4JhQYsMD6REeSI+wQHqEdyC0g79X+uAsKFqIHTt28PLLL3PttdeyYMECVq1ahaoyZcoUli9fTmBgIO+++y7r1q3D4/EwbNgwkpKSTniPkpISbr31VpYuXUqfPn245ZZbmDt3Lvfddx8AkZGRfPvttzz//PP8/ve/5x//+IcXPqkxrVdmQSkfbTzEwg2HWHcgD4DknmE8MTWRy/pFER3aAR+f5jcYw4KihejZsycjR47kgQceYPHixVx44YUAFBYWsmvXLgoKCpg6dSodOnQA4JprrjnlPXbs2EF8fDx9+vQBYNasWfz1r3+tDorrrrsOgKSkJP797383wacypnUrr6hkd0Yh6w/msWhTOl/vzqJSoX+3EGZP6sc1Q7oRExbo7TLPyIKihQgKCgKcPoo5c+bwox/96ITlzz777BnfQ1XrXB4QEACAr68vHo+nznWNMScqLqtg2+GjbDl0lK2H8tly6CjbDxdQ5qkEIDY8kJ9e1pspQ6JJ6NLRy9WemzMGhYi8BEwGMlR14EnLHgB+B3RW1Sy3bQ5wO1AB3KOqn7rtScArQAdgEXCvqqqIBACvAUlANjBdVVPcbWYBj7h/3JOq+mq9Pm0rMHHiRH75y18yc+ZMgoODSUtLw9/fn7Fjx/KjH/2IOXPm4PF4+Oijj7jjjjtO2LZfv36kpKSwe/duevfuzT//+U8uvfRSL30SY5onVaW8Qin1VFDqqaSkvIKjxR7yisrIKSojt6icvGPOc25RGblFZaTlFrMns5BK97tYaAd/EqNDmDWqJwO7h5IYHUKvzsEt9hqfszmieAX4C84v82oi0gO4EjhQo20AMANIBKKBJSLSR1UrgLnAncBKnKCYBHyMEyq5qtpbRGYAzwDTRSQceBRIBhRYKyLvq2ru+X/clm/ChAls27aNUaNGARAcHMy//vUvhg8fzpQpUxgyZAg9e/YkOTmZ0NDQE7Zt3749L7/8MjfccEN1Z/aPf/xjb3wMY5pcRaWSmlvE3sxj7MksZI/7fCivmFJPJaXlTjCUukcAZxLUzpdOge0IC/InNjyQqwZ2ZUC0EwoxYR1abCjURs50OgJAROKAD2seUYjIAuAJYCGQrKpZ7tEEqvqUu86nwGNACvCFqvZz278HjFPVH1Wto6orRMQPOAx0xgmccar6I3ebvwPLVPXNumpNTk7Wk29ctG3bNvr373/Gz9nSFRYWEhwcTFFREZdccgnz5s1j2LBh3i7LK9rK37k5vT2ZhXy8KZ3NaUfZm1VISlYRZRXHQyAs0J9enYOJCetAh3Z+BPj5EODvQ4Cfr/O6+uFLSAc/JxQC2xEW6E9ooD8Bfr5e/HQNT0TWqmpybcvOq49CRKYAaaq64aTU7I5zxFAl1W0rd1+f3F61zUEAVfWISD4QUbO9lm1OrudOnKMVYmNjz+cjtQp33nknW7dupaSkhFmzZrXZkDBt197MQhZtSufDjelsP1yACMRHBHFB52Au6xdFr8hgekUFcUFkMGFB7bxdbotxzkEhIoHAw8CE2hbX0qZ1tJ/vNic2qs4D5oFzRFHbOm3BG2+84e0SjGlyKVnH+MgNh23pRwEYHhfGo9cM4KqB3ega2t7LFbZ853NE0QuIB6qOJmKAb0VkBM63/h411o0BDrntMbW0U2ObVPfUUyiQ47aPO2mbZedRrzGmlckrKuO9dWksWJvKlkNOOCT1DONXkwdw1aCudAvt4OUKW5dzDgpV3QREVf0sIikc76N4H3hDRP6I05mdAKxS1QoRKRCRkcA3wC3An923eB+YBawApgGfu6OhPgV+KyJh7noTgDnn8yGNMS2fqvLNvhzeWnWARZsPU+apZHBMKI9c3Z/vDOpGdCcLh8ZyNsNj38T5Zh8pIqnAo6r6Ym3rquoWEZkPbAU8wE/dEU8Ad3F8eOzH7gPgReCfIrIb50hihvteOSLyBLDaXe/Xqppzzp/QGNOiZReW8u63qby1+iB7M4/Rsb0fM4b3YMbwWAZEh3i7vDbhjEGhqt87w/K4k37+DfCbWtZbAwyspb0EuOE07/0S8NKZajTGtC6qyoq92bz+zQEWbzlMeYWS3DOMn9zQm6sHdaNDu9Y14qi5azM3LvK24ODg6teLFi0iISGBAwcOnLDOww8/TI8ePU5YF2D58uUMGzYMPz8/FixYcMKyV199lYSEBBISEnj11ePXI95+++0MGTKEwYMHM23aNAoLC0+pqaioiJkzZzJo0CAGDhzI2LFjKSwsJC8vj+eff74hPrYx56TMU8l761K5+k9fcdML3/DVriy+PzKOxfdfwoK7RjMtKcZCwhuqpq1uLY+kpCQ92datW09pa2pBQUGqqrpkyRK94IILdPfu3aess2LFCj106FD1ulX27dunGzZs0O9///v6zjvvVLdnZ2drfHy8Zmdna05OjsbHx2tOTo6qqubn51evd//99+tTTz11yp/329/+Vu+///7qn7dv364lJSW6b98+TUxMrN8HbkIej+eUtubwd27OXl5RmT7/xW696DdLtOfsD3X8H5bpm9/s1+KyU/9uTeMA1uhpfq/aEUUT+vLLL7njjjv46KOP6NWr1ynLR44cSbdu3U5pj4uLY/Dgwafcg+LTTz/lyiuvJDw8nLCwMK688ko++eQTAEJCnHO3qkpxcXGtV4mmp6fTvfvxS1P69u1LQEAADz30EHv27GHo0KE8+OCDFBYWMn78eIYNG8agQYNYuHAhALNnzz7hyOOxxx7jD3/4w2nXT0lJoX///txxxx0kJiYyYcIEiouLAVi9ejWDBw9m1KhRPPjggwwc6JylrKio4MEHH2T48OEMHjyYv//97wAsW7aMyy67jJtuuolBgwad5d+AaW4O5hTx2PtbGPXUUp75ZDsXdA7i5VuHs/i+S5gxIpb2/nb00By0uUkBH/9gC1vd4XQNZUB0CI9ek1jnOqWlpUydOpVly5Y12H0e0tLS6NHj+GjkmJgY0tLSqn++7bbbWLRoEQMGDOAPf/jDKdv/4Ac/YMKECSxYsIDx48cza9YsEhISePrpp9m8eTPr168HwOPx8N577xESEkJWVhYjR45kypQpzJgxg/vuu4+f/OQnAMyfP59PPvmE9u3b17o+wK5du3jzzTd54YUXuPHGG3n33Xe5+eabue2225g3bx6jR4/moYceqq7xxRdfJDQ0lNWrV1NaWsqYMWOYMMG5hGfVqlVs3ryZ+Pj4BtmfpmlUVlb1P+znk82H8RHhmiHR3D42noHdQ8/8BqbJtbmg8BZ/f39Gjx7Niy++yHPPPdcg76m1TL9S88jh5ZdfpqKigrvvvpu3336b22677YR1hw4dyt69e1m8eDFLlixh+PDhrFixonqq8pp/zi9+8QuWL1+Oj48PaWlpHDlyhAsvvJCMjAwOHTpEZmYmYWFhxMbGUl5eXuv6APHx8QwdOhRwpjNPSUkhLy+PgoICRo8eDcBNN93Ehx9+CMDixYvZuHFjdd9Mfn4+u3btol27dowYMcJCogVJzy9mwZpU5q89yMGcYkLa+3HHJRdw6+g4u+6hmWtzQXGmb/6NxcfHh/nz53PFFVfw29/+ltmzZ1ffWGjKlCnndbvSmJgYli1bVv1zamoq48aNO2EdX19fpk+fzu9+97tTggKcTvbrrruO6667Dh8fHxYtWsT1119/wjqvv/46mZmZrF27Fn9/f+Li4igpKQFg2rRpLFiwgMOHDzNjxowzrl81lXlVbcXFxXVOf66q/PnPf2bixIkntC9btqx66nXTfJV5Kvl8+xHeXn2Q/+zMpFJh1AUR/L8r+zJpYFc7tdRCtLmg8KbAwEA+/PBDLr74Yrp06VJ9aud8TZw4kV/84hfk5joT6i5evJinnnoKVWXPnj307t0bVeWDDz6o9XTX119/zYABAwgLC6OsrIytW7cybtw4OnbsSEFBQfV6+fn5REVF4e/vzxdffMH+/furl82YMYM77riDrKws/vOf/5xx/dqEhYXRsWNHVq5cyciRI3nrrbdO+Ixz587l8ssvx9/fn507d57Qr2Kap/3Zx3j9mwO8uzaV7GNldAkJ4CfjenNDcgw9IyzgWxoLiiYWHh7OJ598wiWXXEJkZCRTp06tXvbzn/+cN954g6KiImJiYvjhD3/IY489xurVq/nud79Lbm4uH3zwAY8++ihbtmwhPDycX/7ylwwfPhyAX/3qV4SHh1NZWcmsWbM4evQoqsqQIUOYO3fuKbXs2bOHu+66C1WlsrKSq6++muuvvx4RYcyYMQwcOJCrrrqK2bNnc80115CcnMzQoUNPCJ3ExEQKCgro3r17dUf8zJkzT7v+6bz44ovccccdBAUFMW7cuOop0n/4wx+SkpLCsGHDUFU6d+7M//3f/9Xnr8A0opxjZfxp6S7+tdL5cjC+fxTTh/fgkoTO+Pna2JmW6qymGW9J2vI04y1Z1RTpAE8//TTp6en16suxv/OmVVJewSv/TeGvn+/mWJmHGSNiuW98AlEhNiFfS9Hg04wb09A++ugjnnrqKTweDz179uSVV17xdknmLFRWKu9vOMTvPt1BWl4x4/tF8dBV/VrcrT5N3SwoTLMwffp0pk+f7u0yzDlYsSeb3yzayua0oyRGh/C7aYMZ3TvS22WZRmBBYYw5J7szCnj64+0s2ZZBdGh7np0+hKlDuuPj03pu/WlOZEFhjDkrGQUlPPvZLt5efYCgdn7MntSP28bE2RDXNsCCwhhTp2OlHl74ci/zlu+lzFPJLaPiuPvy3kQEB5x5Y9MqWFAYY2rlqahk/ppUnl2yk8yCUr4zqCs/n9iPuEi7DqKtsYHNTaSppxlfunQpw4YNY+jQoYwdO5bdu3efUtPpphlvCCd/BtNyqCpLtx1h0nNf8ov3NhEbHsi7d43m+ZlJFhJtlB1RNLGlS5dy9913s3jxYmJjY09Yds011/Czn/2MhISEE9pjY2N55ZVX+P3vf39Ce05ODo8//jhr1qxBREhKSmLKlCmEhYVx1113sXDhQvr378/zzz/Pk08+ecqQ0+eee44uXbqwadMmAHbs2IG/v3/Df2jTYqzYk82zn+1kVUoO8ZFB/O3mJCYmdql19mHTdtgRRRNqymnGRYSjR51ZcvPz84mOjj7lfU83zTjAtddeS1JSEomJicybN696neDgYB5++GGGDBnCyJEjqyf727dvH6NGjWL48OH88pe/rF5/2bJljBs3jmnTptGvXz9mzpxZPbfT2rVrufTSS0lKSmLixImkp6cD8Kc//YkBAwYwePDg6vmjTONatS+HGfNW8L0XVrI/5xhPTE1k8f2XMGlgVwsJ0waPKD5+CA5vatj37DoIrnq6zlWaeprxf/zjH3znO9+hQ4cOhISEsHLlylO2P9004wAvvfQS4eHhFBcXM3z4cK6//noiIiI4duwYI0eO5De/+Q0///nPeeGFF3jkkUe49957ueuuu7jlllv461//esKfs27dOrZs2UJ0dDRjxozh66+/5qKLLuLuu+9m4cKFdO7cmbfffpuHH36Yl156iaeffpp9+/YREBBAXl5eg+wrU7u1+3N49rNdfLU7i84dA3j0mgF8z+4DYU5iRxRNpOY04w2lrmnGn332WRYtWkRqaiq33XYb//M//3PKulXTjD/44IPk5OQwfPhwtm3bBjjf6quOGg4ePMiuXbsAaNeuHZMnTwaOTxMOzgSD3/uec3v173//+yf8OSNGjCAmJgYfHx+GDh1KSkoKO3bsYPPmzVx55ZUMHTqUJ598ktTUVAAGDx7MzJkz+de//oWfX9v7LtMU1h3I5ZaXVnH93BVsP3yUR67uz/IHL+O2MfEWEuYUbe9/4Rm++TeWppxmPDMzkw0bNnDRRRcBzlXPkyZNqvU9aptm/MiRIyxZsoQVK1YQGBjIuHHjqqcJ9/f3rw4jX19fPB5P9Xud7hTFyVOLezweVJXExERWrFhxyvofffQRy5cv5/333+eJJ55gy5YtFhgNZHdGAU8t2s7S7RmEBfoz56p+fH9UTwLb2f41p2f/OppQU00zHhISQn5+Pjt37qRPnz589tlntU6Qd7ppxvPz8wkLCyMwMJDt27fXetrqZGPGjOGtt97i5ptv5vXXXz/j+n379iUzM5MVK1YwatQoysvL2blzJ/379+fgwYNcdtlljB07ljfeeIPCwkI6dep0zvvHHJdfVM7/Lt3Jayv2E9jOlwcn9mXW6DiCA+xXgDkz+1fSxJpimnGAF154geuvvx4fHx/CwsJ46aWXTqnldNOMl5WV8be//Y3BgwfTt29fRo4cecbP9dxzz3HTTTfx3HPPnXLjo9q0a9eOBQsWcM8995Cfn4/H4+G+++6jT58+3HzzzeTn56Oq3H///RYS9VBRqby1+gB/WLyT3KIyZgyP5YEJfexiOXNObJpx0yrZ37kz1PXxD7aw/XABI+LDefSaASRG2z2pTe1smnFj2pCDOUU89fE2Fm06TPdOHXh+5jCusmGuph4sKIxpJbILS5m3fC8v/zcFH4H/ubIPd15ygY1iMvXWZoJCVe0bVRvR2k6nnknOsTL+vnwPr/13P6WeCqYO7c6DE/sS3amDt0szrUSbCIr27duTnZ1NRESEhUUrp6pkZ2fTvn3rvwVn7rEy5n25l1f/m0JxeQVThkRz9+UJ9I6yebZMw2oTQRETE0NqaiqZmZneLsU0gfbt2xMTE+PtMhpNXlEZL3y5l1e+TqGovILJg6O5d3xvekfZ7UdN42gTQeHv7098fLy3yzDmvJV5Kll3IJel2zN445sDHCvzcPWgbtwzPoE+dn9q08jOGBQi8hIwGchQ1YFu2++Aa4AyYA9wm6rmucvmALcDFcA9qvqp254EvAJ0ABYB96qqikgA8BqQBGQD01U1xd1mFvCIW8qTqnp8Hm1jWjFVZVdGIV/tyuKr3Vms3JtNUVkFPgJXDXQCom9XCwjTNM7miOIV4C84v8yrfAbMUVWPiDwDzAFmi8gAYAaQCEQDS0Skj6pWAHOBO4GVOEExCfgYJ1RyVbW3iMwAngGmi0g48CiQDCiwVkTeV9Xc+n5oY5qj/KJyPt9xhC93ZfH17iyOHC0FID4yiOuHxTA2IZJRvSIIaW9TwZumdcagUNXlIhJ3UtviGj+uBKa5r6cCb6lqKbBPRHYDI0QkBQhR1RUAIvIacC1OUEwFHnO3XwD8RZwe54nAZ6qa427zGU64vHnOn9KYZqrUU8GyHZm8920an2/PoKyikrBAf0b3juTi3pGMTYgkJizQ22WaNq4h+ih+ALztvu6OExxVUt22cvf1ye1V2xwEcI9Q8oGImu21bHMCEbkT52jllJsBGdPcqCpr9+fy3ro0PtyYTn5xOZHB7Zg5MpYpQ6IZEtMJHx8bnWeaj3oFhYg8DHiAqlngavvXrXW0n+82JzaqzgPmgTOFRx0lG+M1ezILWbgujffWp3Ewp5j2/j5MTOzKtRd25+Lekfj52qz/pnk676BwO5onA+P1+BVOqUCPGqvFAIfc9pha2mtukyoifkAokOO2jztpm2XnW68x3rA7o4BFmw6zaFM62w8X4CMwpnck943vw8SBXW32VtMinNe/UhGZBMwGLlXVohqL3gfeEJE/4nRmJwCrVLVCRApEZCTwDXAL8Oca28wCVuD0dXzujob6FPitiIS5603A6TQ3ptlSVXYeKeSjTel8vCmdXRmFiEByzzB+NXkA3xnUja6hrf9iQNO6nM3w2DdxvtlHikgqzkikOUAA8Jl7pfNKVf2xqm4RkfnAVpxTUj91RzwB3MXx4bEfuw+AF4F/uh3fOTijplDVHBF5Aljtrvfrqo5tY5qTykplU1o+S7Yd4aNN6ezNPIYIjIgL5/EpiUwa2JUuIRYOpuVqE9OMG9PQCkrK+XJXFp9vz2DZjkyyCkvxERh5QQRXDerGxMQuRHW0cDAth00zbkw9qSp7s47xxfYMPt+ewap9OXgqlZD2flzaN4rL+3Xm0j5RhAe183apxjQ4CwpjanG0pJzNqflsSM1nY2oeGw7mcSjfuW94ny7B3H5xPOP7dWFYbCcbrWRaPQsK0+pVVCqFJR48lZV4KhVPpVJRoZRXVlJRqZRXVHKstIIth/LZmJrPhtQ89mYeq94+NjyQYT3DuCs+nHF9o+gRbhfAmbbFgsK0KpWVyv6cIjam5rExNZ9NqflsPpRPUVnFmTcGuoQEMDimE9dd2J3BMZ0Y1D2UMDudZNo4CwrTouUXlbNibxbrDzqniDal5VNQ4gGgvb8PidGh3Jjcgx7hgfj7Cn4+Pvj5CH6+gq+P+7OvEODnQ/9uITY6yZhaWFCYFkVV2ZZewBc7Mli2I4NvD+RRUan4+wr9u4VUT4ExKCaUhKhg6z8wpgFYUJhmr7DUw1e7sli2wxmKevio06k8sHsIPxnXi0v7dGZQTCgBfnZvaGMagwWFaZb2ZhbyuTsUdXVKDuUVSscAPy7uE8m4vlGM69OZKDtNZEyTsKAwzUKZp5LVKTks3ZbBFzsy2JfljDrq0yWYH4yN5/K+UQzrGYa/nUoypslZUBivySosrb6A7ctdWRSWemjn58PoXhHcNiaOy2woqjHNggWFaTJVt/f8bOsRlm47wrqDeag6Q1KvGRLN5f2iGNM7gsB29s/SmObE/keaRlXmqWTVvhyWbDvC0u1HOJhTDMCg7qHcOz6BK/p3ITE6BHdySWNMM2RBYRqMqpKWV8zmtHw2px1lU1o+3+7PpaDUQ4CfD2N7R3LXpb0Z3z/KrlcwpgWxoDDnRVVJzS1mo3vlsxMO+eQWlQPg6yMkRAUzeUg3Lu/XhbG9I+nQzoavGtMSWVCYs1JZ6fQvrErJYfW+HFbty6m+nsHfV+jTpSMTE7uS2D2UQd1D6de1I+39LRiMaQ0sKEytPBWVbD50lFX7slm1L5c1+3PIc48WuoQEMDwunBHx4VzYI4w+XYPtYjdjWjELClMtu7CU/+zM5IsdmSzfmUl+sRMM8ZFBTBjQhRHxEYyIC6dHeAfrfDamDbGgaMMqK5XNh/L5fHsGX+zIZGOqM1w1MjiACQO6cEmfzlx0Qbjdqc2YNs6Coo2prFRW7stm4bpDLN1+hKzCMkRgaI9O3H9FHy7rG0VidAg+PnbEYIxxWFC0EbszCvj3t2ksXH+ItLxiggP8uLxfFJf3i+KSPp3tFp7GmNOyoGjFsgtLeX/DId5bl8bG1Hx8fYSLEyKZfVU/ruzfxYarGmPOigVFK1PqqeDzbRksWJvKf3Zm4qlUEqNDeOTq/kwZGm39DcaYc2ZB0QqoKpvTjrJg7UEWbjhEXlE5XUICuP3ieK67MIa+XTt6u0RjTAtmQdGCZRaUsnB9GgvWprL9cAHt/HyYmNiVaUkxjO0dia91SBtjGoAFRQuhqmQVlpGSfYx9mcdYvPUwX+zIpKJSGdqjE09eO5BrBkcTGujv7VKNMa2MBUUzoqpkFpSyP6eIfVnH2J99jJSsIlKyj7E/u4jCUk/1ulEdA7jj4guYltSd3lF2askY03gsKJpYmaeStLxi9mcf40BOEfuziziQU8QB97m4vKJ6XT8foUd4ID0jAhkeF05cRCBxkUHERQTRIzzQTi0ZY5qEBUUDU1UyC0s5mFPEwZxiDuY4AXAw1/k5Pb+YSj2+fnt/H2LDA4kND2JsQiQ9IwKJDQ8kLiKI7mEd7Nafxhivs6Cop6zCUtYdyOPbA7msO5DLptR8jpVVnLBOVMcAeoQHMiI+nB5hHdyjhCB6RgQS1THA5k0yxjRrZwwKEXkJmAxkqOpAty0ceBuIA1KAG1U11102B7gdqADuUdVP3fYk4BWgA7AIuFdVVUQCgNeAJCAbmK6qKe42s4BH3FKeVNVX6/2J66GozMPujMIawZDHgZwiwDlNlBgdwrSkGHpFBdMjLJAe4R2ICQu06baNMS3a2RxRvAL8BeeXeZWHgKWq+rSIPOT+PFtEBgAzgEQgGlgiIn1UtQKYC9wJrMQJiknAxzihkquqvUVkBvAMMN0No0eBZECBtSLyflUgNbRSTwWb046ScbSEI0dLOFJQypH8Eo4UlHDkaClHjpZQUHJiZ/Kw2DBuHhnLsNgwBnYPtUAwxrRKZwwKVV0uInEnNU8FxrmvXwWWAbPd9rdUtRTYJyK7gREikgKEqOoKABF5DbgWJyimAo+577UA+Is452ImAp+pao67zWc44fLmuX/MMzta7OH6uf+t/tnfV4jq2J6okAASooIZ2zuSqJAAYsMDuTA2jOjQ9nbKyBjTJpxvH0UXVU0HUNV0EYly27vjHDFUSXXbyt3XJ7dXbXPQfS+PiOQDETXba9nmBCJyJ87RCrGxsef1gSKC2vHyrcPpEtKeLiEBhAW2sxlUjTGGhu/Mru03q9bRfr7bnNioOg+YB5CcnFzrOmfi4yNc1i/qzCsaY0wbc75jL4+ISDcA9znDbU8FetRYLwY45LbH1NJ+wjYi4geEAjl1vJcxxpgmdL5B8T4wy309C1hYo32GiASISDyQAKxyT1MViMhIt//hlpO2qXqvacDnqqrAp8AEEQkTkTBggttmjDGmCZ3N8Ng3cTquI0UkFWck0tPAfBG5HTgA3ACgqltEZD6wFfAAP3VHPAHcxfHhsR+7D4AXgX+6Hd85OKOmUNUcEXkCWO2u9+uqjm1jjDFNR5wv761HcnKyrlmzxttlGGNMiyIia1U1ubZlNj+EMcaYOllQGGOMqZMFhTHGmDpZUBhjjKmTBYUxxpg6WVAYY4ypkwWFMcaYOllQGGOMqZMFhTHGmDpZUBhjjKmTBYUxxpg6WVAYY4ypkwWFMcaYOllQGGOMqZMFhTHGmDpZUBhjjKmTBYUxxpg6WVAYY4ypkwWFMcaYOllQGGOMqZMFhTHGmDpZUBhjjKmTBYUxxpg6WVAYY4ypkwWFMcaYOllQGGOMqZMFhTHGmDpZUBhjjKmTBYUxxpg61SsoROR+EdkiIptF5E0RaS8i4SLymYjscp/Daqw/R0R2i8gOEZlYoz1JRDa5y/4kIuK2B4jI2277NyISV596jTGmVSnJh5SvYMVf4d93wsezG+WP8TvfDUWkO3APMEBVi0VkPjADGAAsVdWnReQh4CFgtogMcJcnAtHAEhHpo6oVwFzgTmAlsAiYBHwM3A7kqmpvEZkBPANMP9+ajTGmxTqWDenrIX2D8zi8EXL2Hl/esRv0vqJR/ujzDooa23cQkXIgEDgEzAHGuctfBZYBs4GpwFuqWgrsE5HdwAgRSQFCVHUFgIi8BlyLExRTgcfc91oA/EVERFW1nnUbY0zzVVoAh9ZD2lo49C2krYP8A8eXd+oJ3YbA0JnQbSh0GwzBUY1WznkHhaqmicjvgQNAMbBYVReLSBdVTXfXSReRquq74xwxVEl128rd1ye3V21z0H0vj4jkAxFA1vnWbYwxzUplBRzZDAe+cUPhW8jaCbjfhzv1hJgkGHEHRA+FroOgQ1hd79jg6nPqKQznG388kAe8IyI317VJLW1aR3td25xcy504p66IjY2towRjjPGyygo4vMnpW0j5Cvb/F0rznWVBUdA9CQZNg+hhEH0hBEV4t17qd+rpCmCfqmYCiMi/gdHAERHp5h5NdAMy3PVTgR41to/BOVWV6r4+ub3mNqki4geEAjknF6Kq84B5AMnJyXZayhjTfHhK4cgWJxBODobwXpB4LcRdDLEjITQGpLbvx95Vn6A4AIwUkUCcU0/jgTXAMWAW8LT7vNBd/33gDRH5I05ndgKwSlUrRKRAREYC3wC3AH+usc0sYAUwDfjc+ieMMc1WebETCunrnT6G9A2QsQ0qy53lEb1h4HedYOg5BkK6ebPas1afPopvRGQB8C3gAdbhfKsPBuaLyO04YXKDu/4Wd2TUVnf9n7ojngDuAl4BOuB0Yn/str8I/NPt+M7BGTVljDHeV5LvnEI6vAnSNzrhkLkDqn6tdQh3+hRG/8zpeO4xssUEw8mktX1BT05O1jVr1ni7DGNMa6EKR9NqhMIG5zlv//F1gqKcUOg2xB2FNKTZnkY6HRFZq6rJtS2r7/BYY4xpHSrKITcFsnY5o46qn3dCSd7x9cJ7QfdhkDQLug5xRiF17OKtqpuEBYUxpu1RdfoO9iyFAyudMMjZC5We4+sERUFkH6ezuctAJxC6JEJAR6+V7S0WFMaYtqEoB/Yuc8Jh9+dQ4A6uDO8FUf2h39VOMET2cTqdO3TyZrXNigWFMaZ1UnU6mHd84oRD2lrQSmgfCheMg17jofd4py/B1MmCwhjTuhzLgo3zYd2/IGMLIM5FbJc86MyFFD0MfO1X37mwvWWMafkqK2D3Ulj3T9jxsXPdQvdkmPy/MGAqBIZ7u8IWzYLCGNNyZe+B9a/D+jedPofACLjoR85keV0GeLu6VsOCwhjTslRWwM5PYdU82PsFiA/0vhKuegb6TAK/dt6usNWxoDDGtAxFOU6/w+p/OBe7dYyGyx6BC2dCSLS3q2vVLCiMMc3b4c2w6u+w8R3wFDtzJF35a2c4q6+/t6trEywojDHNjyps/8i5xeeB/4JfBxh8o3NPhq6DvF1dm2NBYYxpPlRh12fwxZPOnEqdYuHKJ+DCm23kkhdZUBhjmoe9/4HPn4TUVc5d3a6dC4NutGsemgH7GzDGeNeBb5wjiH3LnQ7qyc/C0Jtt9FIzYkFhjPGOQ+vhi9/ArsUQ1BkmPQ1Jt4F/e29XZk5iQWGMaTrHsmHzu7DxbUhbAx3C4IrHYMSd0C7I29WZ07CgMMY0rvJiZ1qNjfNh92fOVN5dBjqd1EmznEn6TLNmQWGMaXiVlbD/a9j4Fmx9H0qPQsduMPInMHg6dB3o7QrNObCgMMY0nIztTjhsfAeOpkK7YOg/BYZMh7iLwcfX2xWa82BBYYypn4IjsHkBbHgLDm8E8XXu83Dl49D3O9Au0NsVmnqyoDDGnLuyY7DtQ6dTeu8Xzg2Boi+ESc/AwOsgOMrbFZoGZEFhjDk7uSnOVdO7lzjXPJQXQWgsjP0fp9+hcx9vV2gaiQWFMaZ25SVOh/TuJU5AZO9y2sPinPs9JH4XYkeBj49XyzSNz4LCGHNcwRHY8ZFzn+l9y53ZWn0DIG4sDL/due9DRC8Q8XalpglZUBjT1uUdgG0fOI8DKwF1jhqGfd8Jhrix1iHdxllQGNMWZe6Ebe874ZC+3mnrMhDGPeQMZ43qb0cNppoFhTFtRc5e2PSuM5Q1c7vTFjPcvQnQZOeUkjG1sKAwpjUrOAxb3oNN70DaWqctdjRc9TvnDnGh3b1bn2kRLCiMaW2K85xTSpvegZQvnWscug525lYaeB2Exni7QtPCWFAY0xqUlzjTdW+aDzs/hYoyCIuHix+AQdOgc19vV2hasHoFhYh0Av4BDAQU+AGwA3gbiANSgBtVNdddfw5wO1AB3KOqn7rtScArQAdgEXCvqqqIBACvAUlANjBdVVPqU7MxrUb1xHtvuxPv5UNQFCTfDoNugO7DrEPaNIj6HlE8B3yiqtNEpB0QCPwCWKqqT4vIQ8BDwGwRGQDMABKBaGCJiPRR1QpgLnAnsBInKCYBH+OESq6q9haRGcAzwPR61mxMy3Z4sxMOm9+Fo2nOxHv9JsPgGyH+Urt1qGlw5/0vSkRCgEuAWwFUtQwoE5GpwDh3tVeBZcBsYCrwlqqWAvtEZDcwQkRSgBBVXeG+72vAtThBMRV4zH2vBcBfRERUVc+3bmNanMoKSF0DOz+BHYucEUs+ftBrvDNiySbeM42sPl89LgAygZdFZAiwFrgX6KKq6QCqmi4iVbODdcc5YqiS6raVu69Pbq/a5qD7Xh4RyQcigKyahYjInThHJMTGxtbjIxnTTJQchT2fO/0Nuz6FomxnVtaeo2H4DyHxOgiK8HaVpo2oT1D4AcOAu1X1GxF5Duc00+nUdrJU62iva5sTG1TnAfMAkpOT7WjDtDyVFc6Rwr4vnSOHlK+gshzad4KEK6HPJOh9BXTo5O1KTRtUn6BIBVJV9Rv35wU4QXFERLq5RxPdgIwa6/eosX0McMhtj6mlveY2qSLiB4QCOfWo2ZjmoTjPOZ2UugoOrnJelxU4yyISYOSPoc9V0OMi63MwXnfe/wJV9bCIHBSRvqq6AxgPbHUfs4Cn3eeF7ibvA2+IyB9xOrMTgFWqWiEiBSIyEvgGuAX4c41tZgErgGnA59Y/YVqcqqOFtLVuKKw+fmW0+EBUIgy+AWJGQOxFEH6Bd+s15iT1/apyN/C6O+JpL3Ab4APMF5HbgQPADQCqukVE5uMEiQf4qTviCeAujg+P/dh9ALwI/NPt+M7BGTVlTPOlCvmpkLbGCYa0b+HQeig/5izvEOYEwqBpznP3YRDQ0aslG3Mm0tq+oCcnJ+uaNWu8XYZpC1Qhbz8c3uQ80jc64XDMPdvq2865Irp7EsQkO8/hF9i1DaZZEpG1qppc2zI7+WnM2fCUQsa246FwZLPzXHrUWS4+ENHbuVd09yTn0WUg+LXzbt3GNAALCmNqU17i9CXs/9oZgZS6GjwlzjL/IOg60Ln6uesg56ghqr9dy2BaLQsKYwDKi50wSPkKUr52XleUAgLdBjvTYvQY7oRCWLzd/tO0KRYUpu3xlMKRLc4New6td56PbHWuWxAf6DYELroTeo6F2JF27YJp8ywoTOvmKXP6Ew6tOx4MGducUADngrbooTD6Z859GmJHQvsQ79VrTDNkQWFaj8pKyNnjDkt1H4c3OVNugzM0tdtQJxS6DYXoC6FTrI1CMuYMLChMy+Upg4MrYe8y58rmQ+uOj0LyD3KC4KIfOyOQLBSMOW8WFKZlydkLu5c6j5QvoazQmUm1S6JzEVvV0NTIPuDj6+1qjWkVLChM81aSD/tXwO4lsGepExQAnXrC4OnORHnxF9vVzcY0IgsK03yUFkD6BqfD+dA655Gzx1nmHwhxF8NFdzkXtdkVzsY0GQsK0/QqK+FoKmTudCbHS9/gjEjK2kX1LPIhMc5opKHfg5jhEDsK/AK8WLQxbZcFhWk85cWQux+ydkDWTicYsnY4gVBedHy9jtFOKAy6wel07jYUgjt7q2pjzEksKMz5K8xwgiD/oHPv5vzUEx9FWSeuH9rD6WROGgORCRDZFzr3haBI79RvjDkrFhTmzCrKnSOCw5vhyCb3eTMcyzxxvXYdITTGeUQPdZ479XRCISIBAoK9Ur4xpn4sKMyJVCF7jzP09OAq54K1zO3Hr2T2DYCofpAw0RmSGtHreDi0D/Vu7caYRmFB0dapOkNOU750J8T7CgrSnWVBUc6EeL0vhy6DnBlTIxLs1pzGtDH2P76tUYXcfcdDYd+XUODeojy4C8SNdYahxl3sHC3YEFRj2jwLitbu5GBI+crpeAYI6nxiMEQmWDAYY05hQdHalJc4Q1DTNzj3VUj5yrlmASAw0g2G+51g6NzXgsEYc0YWFC1VZQXk7IOMLc602Ufc55w9oJXOOtXBcJ8FgzHmvFlQNGeqUJQD2budAMje7YxIyt4D2buO35oTcaa0iOoPid+FLgMgKtFOJRljGoQFRXNQ4YHcFGcYauZ255qF7N3OoyT/+HriC2FxTifzBZdC1AAnFCL72v2ajTGNxoKiKalC3n6n/yBzhxsM7pQWFaXH1wuJgcjeMHAaRPR2giGit3M/BV9/79VvjGmTLCga0wkjjk7qWAbnF3/n/tDrcujcz7mQLbKPTZltjGlWLCgaUoXHuXjtwH+Ph0PVNQqBkRA3BnreCzHJTsdyuyDv1muMMWfBguJcVVY4k+Bl73FCIXuP29G8xzmtVOlx1guKckccjYGeY23EkTGmxbKgOJPiPDiwEva7RwhHNkNF2fHl/oEQ3suZ3mLAVKcvoccI59mCwRjTClhQnKwoB/b/F/a7fQqHNwEKvu2gezJc9OPjHczhvaBjVwsEY0yrZkFRJT8VXr/RuYANwK+9c2e1cQ9BzzFOv4J/B+/WaIwxXlDvoBARX2ANkKaqk0UkHHgbiANSgBtVNddddw5wO1AB3KOqn7rtScArQAdgEXCvqqqIBACvAUlANjBdVVPqW3OtgrtCpx7OBWtxY6B7kt160xhjAJ8GeI97gW01fn4IWKqqCcBS92dEZAAwA0gEJgHPuyEDMBe4E0hwH5Pc9tuBXFXtDTwLPNMA9dbO1w9uehsufRB6jraQMMYYV72CQkRigKuBf9Rongq86r5+Fbi2RvtbqlqqqvuA3cAIEekGhKjqClVVnCOIa2t5rwXAeBHrEDDGmKZU3yOK/wV+DlTWaOuiqukA7nOU294dOFhjvVS3rbv7+uT2E7ZRVQ+QD0ScXISI3Ckia0RkTWZm5smLjTHG1MN5B4WITAYyVHXt2W5SS5vW0V7XNic2qM5T1WRVTe7cufNZlmOMMeZs1KczewwwRUS+A7QHQkTkX8AREemmqunuaaUMd/1UoEeN7WOAQ257TC3tNbdJFRE/IBTIqUfNxhhjztF5H1Go6hxVjVHVOJxO6s9V9WbgfWCWu9osYKH7+n1ghogEiEg8Tqf1Kvf0VIGIjHT7H245aZuq95rm/hmnHFEYY4xpPI1xHcXTwHwRuR04ANwAoKpbRGQ+sBXwAD9V1Qp3m7s4Pjz2Y/cB8CLwTxHZjXMkMaMR6jXGGFMHaW1f0JOTk3XNmjXeLsMYY1oUEVmrqsm1LWuI6yiMMca0Yq3uiEJEMoH9p1kcCWQ1YTnnq6XUCS2nVquz4bWUWq3Os9NTVWsdNtrqgqIuIrLmdIdWzUlLqRNaTq1WZ8NrKbVanfVnp56MMcbUyYLCGGNMndpaUMzzdgFnqaXUCS2nVquz4bWUWq3OempTfRTGGGPOXVs7ojDGGHOOLCiMMcbUqcUHhYi8JCIZIrK5RtsQEVkhIptE5AMRCXHb/UXkVbd9m3vHvaptlonIDhFZ7z6iavvzmqjOdiLystu+QUTG1dgmyW3fLSJ/auj7czRgnY29P3uIyBfu3+MWEbnXbQ8Xkc9EZJf7HFZjmznuftshIhNrtDfaPm3gOpvVPhWRCHf9QhH5y0nv1Wz26RnqbLR9eh51Xikia939tlZELq/xXo36//6MVLVFP4BLgGHA5hptq4FL3dc/AJ5wX9+Ec/MkgECcW7XGuT8vA5KbSZ0/BV52X0cBawEf9+dVwCicKdg/Bq5qpnU29v7sBgxzX3cEdgIDgP8PeMhtfwh4xn09ANgABADxwB7At7H3aQPX2dz2aRAwFvgx8JeT3qs57dO66my0fXoedV4IRLuvB+LcXrrR9+fZPFr8EYWqLufUqcf7Asvd158B11etDgSJM2V5B6AMONoM6xyAcxtZVDUDyAOSpe67ATabOhuyntNR1XRV/dZ9XYBzO97uNOwdFptNnQ1VT0PWqqrHVPUroKTm+zS3fXq6OhvbedS5TlWrbrGwBWgvzmzbjf7//kxafFCcxmZgivv6Bo7fB2MBcAxIx5nZ9veqWvOX4svu4ecvm+jQ7nR1bgCmioifOFOyJ7nL6robYHOqs0qT7E8RicP5NvYNDXuHxeZUZ5XmtE9Pp7nt0zNp9H16HnVeD6xT1VK89/++WmsNih8APxWRtTiHfGVu+wigAojGOaz/fyJygbtspqoOAi52H9/3Yp0v4fxjWINzu9n/4kzNflZ3/GsE51onNNH+FJFg4F3gPlWt6+jwfO6w2GAaoE5ofvv0tG9RS5s392ldGn2fnmudIpIIPAP8qKqpltWa9LqGVhkUqrpdVSeoahLwJs55XnD6KD5R1XL3VMnXuKdKVDXNfS4A3qAJDvdPV6eqelT1flUdqqpTgU7ALuq+G2BzqrNJ9qeI+OP8B3xdVf/tNh9xD9WrToHU5w6LzanO5rhPT6e57dPTaux9eq51ikgM8B5wi6pW/d7yyv/7mlplUFSNXBARH+AR4G/uogPA5eIIAkYC291TJ5HuNv7AZJzTLV6pU0QC3foQkSsBj6pu1brvBths6myK/el+/heBbar6xxqLGvIOi82mzma6T2vVDPfp6d6nUffpudYpIp2Aj4A5qvp11cre+n9/gobqFffWA+cbbjpQjpO8twP34oww2Ilzx72qK9CDgXdwOoq2Ag/q8VERa4GN7rLncEeaeKnOOGAHTufXEpzpf6veJxnnH/Me4C9V2zSnOptof47FOfzeCKx3H98BInA62He5z+E1tnnY3W87qDFqpDH3aUPV2Yz3aQrO4IdC99/LgGa6T0+ps7H36bnWifMl7FiNddcDUU3x//5MD5vCwxhjTJ1a5aknY4wxDceCwhhjTJ0sKIwxxtTJgsIYY0ydLCiMMcbUyYLCGGNMnSwojGmGRMTX2zUYU8WCwph6EpEnxL3XgPvzb0TkHhF5UERWi8hGEXm8xvL/E+d+A1tE5M4a7YUi8msR+QZnSmljmgULCmPq70XcKRncaU5mAEdwpt8YAQwFkkTkEnf9H6gzb1YycI+IRLjtQTj3AblInWmxjWkW/LxdgDEtnaqmiEi2iFwIdAHWAcOBCe5rcKaPScC5r8c9IvJdt72H256NM7Pxu01ZuzFnw4LCmIbxD+BWoCvO9OvjgadU9e81VxLndrFXAKNUtUhElgHt3cUlqlrRRPUac9bs1JMxDeM9YBLOkcSn7uMH7r0IEJHu7iy8oUCuGxL9cGYwNqZZsyMKYxqAqpaJyBdAnntUsFhE+gMr3JumFQI3A58APxaRjTizw670Vs3GnC2bPdaYBuB2Yn8L3KCqu7xdjzENyU49GVNPIjIA2A0stZAwrZEdURhjjKmTHVEYY4ypkwWFMcaYOllQGGOMqZMFhTHGmDpZUBhjjKnT/w8SmONDe+1sbAAAAABJRU5ErkJggg==\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "pop_wide[[\"K-1103 Stavanger\", \"K-1108 Sandnes\"]].plot()" ] }, { "cell_type": "markdown", "id": "28884f7e", "metadata": {}, "source": [ "### From wide to long\n", "\n", "Now let's imagine that we have a wide dataset, like the one we made above, where we have one category per column. We may often wish to put this into long format. For example, if we want to merge the above dataset with another on both the year and municipality, then we would want the dataset in long format. \n", "\n", "To go from wide to long in pandas we have two options: Stack and melt. Both are covered in the Pandas [reshape userguide](https://pandas.pydata.org/docs/user_guide/reshaping.html). We quickly go through both below. \n", "\n", "We start with melt:" ] }, { "cell_type": "markdown", "id": "90d44f74", "metadata": {}, "source": [ "In the wide dataframe we have above, the year is set as the index. We run the command .reset_index() to make the year into a normal column" ] }, { "cell_type": "code", "execution_count": 43, "id": "9a0f4c42", "metadata": {}, "outputs": [], "source": [ "pop_wide = pop_wide.reset_index()" ] }, { "cell_type": "code", "execution_count": 33, "id": "762669a5", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
regionyearK-0301 OsloK-1101 EigersundK-1103 StavangerK-1106 HaugesundK-1108 SandnesK-1111 SokndalK-1112 LundK-1114 BjerkreimK-1119 Hå...K-5435 NordkappK-5436 Porsanger - Porsángu - PorsankiK-5437 Kárásjohka - KarasjokK-5438 LebesbyK-5439 GamvikK-5440 BerlevågK-5441 Deatnu - TanaK-5442 Unjárga - NessebyK-5443 BåtsfjordK-5444 Sør-Varanger
0198644939512087100311268834180334833110228312715...4393438926941811152315333309100626439853
1198745134512159100761268844288734873109230512802...421444042654179414791469328999925509745
2198845373012203101733269474352535073113232012868...4127438626701736145814123215100824619564
3198945612412337102308272294461334973138230912988...4061444326581761145013743201103024019579
4199045836412391102908276004533934873101234013034...3975447526521754142413673195103723469641
5199146164412398103536277884598334533086237313022...3986451426901695139813403232105623419693
6199246744112495105192281064674734863059237313067...3994451127261652138813443268105623219758
7199347345412646106797284364784835013083243213041...3962453527571630142313203299105923709819
8199447778112721108072286704895635083071243713409...3970449327861598146112923274107224749930
9199548340112798109126290644976335173072245813268...3914446127881578145513243272104825479913
10199648865912863109996292295027334953063244913280...38524461278915681410133231981058262210010
11199749479312904111324293855097434843091244913356...3771447128671576132612643142104125509843
12199849969313045112624296995186334243084243713498...3606442228571538133712613137103525449790
13199950286713109113893298885309233943092245413723...3554439728711483128312523056102124549646
14200050746713288114794303625401633583096245613921...351744512901146312881236307496524709532
15200150872613291114870306095489333543114248314017...350543582877152412691212304496324519498
16200251258913324115781307425598433093130246714203...351343492852151112341210303996624079608
17200351740113350117074310135680532943097248014417...349742942844150012051193306892924049547
18200452188613388118523313615773733203105246114570...346843292865147311341158300492722909500
19200552984613408120113315305872033093129246314784...341542992876143011141133303790121859463
20200653841113418121298317386003933013098247514883...333042222889139110761104300689221719464
21200754861713594123513323036161032663120250715072...327441412873135710461086297988421139490
22200856048413778126058329566315332423112253915438...321940592866130410401077295485620909518
23200957547513969128288336656456532463111258015949...318040002786133210251061295187820749623
24201058686014170130709340496582032853139258316342...318539912789134210091044291288420709738
25201159923014346133142346196741132653186265116822...32243980276813369911031289789320719826
26201261328514475134849350996900432573183273917244...322839462763135610081015289690120899860
27201362396614636136825357537127332863173277917635...320539682721133910631025290088221629968
28201463446314811138567360997314233033225282018115...3213396326981341109810572883919220710090
29201564767614916140043365387483233093247286118528...3278392527081343111610202909934223510221
30201665839014942140721369517605833133243282518591...3276397826681318113910002922959221110227
31201766675914899140856371667674233163259282618800...329139712696133011379912911951226710199
32201867346914898141186371677757433313237282618762...323939642701134911539832922944226310171
33201968107114830142034372507843933053213280718814...321839442673132811699812900941227010156
34202069349414811143574373577953732803202278718991...316239982628129011329572918926222110158
35202169701014787144147373238045032573174279119120...307539212641127110979282829880220010103
36202269982714860144699374448130532813178278919296...29473904258412211057906282185421659925
\n", "

37 rows × 357 columns

\n", "
" ], "text/plain": [ "region year K-0301 Oslo K-1101 Eigersund K-1103 Stavanger \\\n", "0 1986 449395 12087 100311 \n", "1 1987 451345 12159 100761 \n", "2 1988 453730 12203 101733 \n", "3 1989 456124 12337 102308 \n", "4 1990 458364 12391 102908 \n", "5 1991 461644 12398 103536 \n", "6 1992 467441 12495 105192 \n", "7 1993 473454 12646 106797 \n", "8 1994 477781 12721 108072 \n", "9 1995 483401 12798 109126 \n", "10 1996 488659 12863 109996 \n", "11 1997 494793 12904 111324 \n", "12 1998 499693 13045 112624 \n", "13 1999 502867 13109 113893 \n", "14 2000 507467 13288 114794 \n", "15 2001 508726 13291 114870 \n", "16 2002 512589 13324 115781 \n", "17 2003 517401 13350 117074 \n", "18 2004 521886 13388 118523 \n", "19 2005 529846 13408 120113 \n", "20 2006 538411 13418 121298 \n", "21 2007 548617 13594 123513 \n", "22 2008 560484 13778 126058 \n", "23 2009 575475 13969 128288 \n", "24 2010 586860 14170 130709 \n", "25 2011 599230 14346 133142 \n", "26 2012 613285 14475 134849 \n", "27 2013 623966 14636 136825 \n", "28 2014 634463 14811 138567 \n", "29 2015 647676 14916 140043 \n", "30 2016 658390 14942 140721 \n", "31 2017 666759 14899 140856 \n", "32 2018 673469 14898 141186 \n", "33 2019 681071 14830 142034 \n", "34 2020 693494 14811 143574 \n", "35 2021 697010 14787 144147 \n", "36 2022 699827 14860 144699 \n", "\n", "region K-1106 Haugesund K-1108 Sandnes K-1111 Sokndal K-1112 Lund \\\n", "0 26883 41803 3483 3110 \n", "1 26884 42887 3487 3109 \n", "2 26947 43525 3507 3113 \n", "3 27229 44613 3497 3138 \n", "4 27600 45339 3487 3101 \n", "5 27788 45983 3453 3086 \n", "6 28106 46747 3486 3059 \n", "7 28436 47848 3501 3083 \n", "8 28670 48956 3508 3071 \n", "9 29064 49763 3517 3072 \n", "10 29229 50273 3495 3063 \n", "11 29385 50974 3484 3091 \n", "12 29699 51863 3424 3084 \n", "13 29888 53092 3394 3092 \n", "14 30362 54016 3358 3096 \n", "15 30609 54893 3354 3114 \n", "16 30742 55984 3309 3130 \n", "17 31013 56805 3294 3097 \n", "18 31361 57737 3320 3105 \n", "19 31530 58720 3309 3129 \n", "20 31738 60039 3301 3098 \n", "21 32303 61610 3266 3120 \n", "22 32956 63153 3242 3112 \n", "23 33665 64565 3246 3111 \n", "24 34049 65820 3285 3139 \n", "25 34619 67411 3265 3186 \n", "26 35099 69004 3257 3183 \n", "27 35753 71273 3286 3173 \n", "28 36099 73142 3303 3225 \n", "29 36538 74832 3309 3247 \n", "30 36951 76058 3313 3243 \n", "31 37166 76742 3316 3259 \n", "32 37167 77574 3331 3237 \n", "33 37250 78439 3305 3213 \n", "34 37357 79537 3280 3202 \n", "35 37323 80450 3257 3174 \n", "36 37444 81305 3281 3178 \n", "\n", "region K-1114 Bjerkreim K-1119 Hå ... K-5435 Nordkapp \\\n", "0 2283 12715 ... 4393 \n", "1 2305 12802 ... 4214 \n", "2 2320 12868 ... 4127 \n", "3 2309 12988 ... 4061 \n", "4 2340 13034 ... 3975 \n", "5 2373 13022 ... 3986 \n", "6 2373 13067 ... 3994 \n", "7 2432 13041 ... 3962 \n", "8 2437 13409 ... 3970 \n", "9 2458 13268 ... 3914 \n", "10 2449 13280 ... 3852 \n", "11 2449 13356 ... 3771 \n", "12 2437 13498 ... 3606 \n", "13 2454 13723 ... 3554 \n", "14 2456 13921 ... 3517 \n", "15 2483 14017 ... 3505 \n", "16 2467 14203 ... 3513 \n", "17 2480 14417 ... 3497 \n", "18 2461 14570 ... 3468 \n", "19 2463 14784 ... 3415 \n", "20 2475 14883 ... 3330 \n", "21 2507 15072 ... 3274 \n", "22 2539 15438 ... 3219 \n", "23 2580 15949 ... 3180 \n", "24 2583 16342 ... 3185 \n", "25 2651 16822 ... 3224 \n", "26 2739 17244 ... 3228 \n", "27 2779 17635 ... 3205 \n", "28 2820 18115 ... 3213 \n", "29 2861 18528 ... 3278 \n", "30 2825 18591 ... 3276 \n", "31 2826 18800 ... 3291 \n", "32 2826 18762 ... 3239 \n", "33 2807 18814 ... 3218 \n", "34 2787 18991 ... 3162 \n", "35 2791 19120 ... 3075 \n", "36 2789 19296 ... 2947 \n", "\n", "region K-5436 Porsanger - Porsángu - Porsanki  K-5437 Kárásjohka - Karasjok \\\n", "0 4389 2694 \n", "1 4404 2654 \n", "2 4386 2670 \n", "3 4443 2658 \n", "4 4475 2652 \n", "5 4514 2690 \n", "6 4511 2726 \n", "7 4535 2757 \n", "8 4493 2786 \n", "9 4461 2788 \n", "10 4461 2789 \n", "11 4471 2867 \n", "12 4422 2857 \n", "13 4397 2871 \n", "14 4451 2901 \n", "15 4358 2877 \n", "16 4349 2852 \n", "17 4294 2844 \n", "18 4329 2865 \n", "19 4299 2876 \n", "20 4222 2889 \n", "21 4141 2873 \n", "22 4059 2866 \n", "23 4000 2786 \n", "24 3991 2789 \n", "25 3980 2768 \n", "26 3946 2763 \n", "27 3968 2721 \n", "28 3963 2698 \n", "29 3925 2708 \n", "30 3978 2668 \n", "31 3971 2696 \n", "32 3964 2701 \n", "33 3944 2673 \n", "34 3998 2628 \n", "35 3921 2641 \n", "36 3904 2584 \n", "\n", "region K-5438 Lebesby K-5439 Gamvik K-5440 Berlevåg K-5441 Deatnu - Tana \\\n", "0 1811 1523 1533 3309 \n", "1 1794 1479 1469 3289 \n", "2 1736 1458 1412 3215 \n", "3 1761 1450 1374 3201 \n", "4 1754 1424 1367 3195 \n", "5 1695 1398 1340 3232 \n", "6 1652 1388 1344 3268 \n", "7 1630 1423 1320 3299 \n", "8 1598 1461 1292 3274 \n", "9 1578 1455 1324 3272 \n", "10 1568 1410 1332 3198 \n", "11 1576 1326 1264 3142 \n", "12 1538 1337 1261 3137 \n", "13 1483 1283 1252 3056 \n", "14 1463 1288 1236 3074 \n", "15 1524 1269 1212 3044 \n", "16 1511 1234 1210 3039 \n", "17 1500 1205 1193 3068 \n", "18 1473 1134 1158 3004 \n", "19 1430 1114 1133 3037 \n", "20 1391 1076 1104 3006 \n", "21 1357 1046 1086 2979 \n", "22 1304 1040 1077 2954 \n", "23 1332 1025 1061 2951 \n", "24 1342 1009 1044 2912 \n", "25 1336 991 1031 2897 \n", "26 1356 1008 1015 2896 \n", "27 1339 1063 1025 2900 \n", "28 1341 1098 1057 2883 \n", "29 1343 1116 1020 2909 \n", "30 1318 1139 1000 2922 \n", "31 1330 1137 991 2911 \n", "32 1349 1153 983 2922 \n", "33 1328 1169 981 2900 \n", "34 1290 1132 957 2918 \n", "35 1271 1097 928 2829 \n", "36 1221 1057 906 2821 \n", "\n", "region K-5442 Unjárga - Nesseby K-5443 Båtsfjord K-5444 Sør-Varanger \n", "0 1006 2643 9853 \n", "1 999 2550 9745 \n", "2 1008 2461 9564 \n", "3 1030 2401 9579 \n", "4 1037 2346 9641 \n", "5 1056 2341 9693 \n", "6 1056 2321 9758 \n", "7 1059 2370 9819 \n", "8 1072 2474 9930 \n", "9 1048 2547 9913 \n", "10 1058 2622 10010 \n", "11 1041 2550 9843 \n", "12 1035 2544 9790 \n", "13 1021 2454 9646 \n", "14 965 2470 9532 \n", "15 963 2451 9498 \n", "16 966 2407 9608 \n", "17 929 2404 9547 \n", "18 927 2290 9500 \n", "19 901 2185 9463 \n", "20 892 2171 9464 \n", "21 884 2113 9490 \n", "22 856 2090 9518 \n", "23 878 2074 9623 \n", "24 884 2070 9738 \n", "25 893 2071 9826 \n", "26 901 2089 9860 \n", "27 882 2162 9968 \n", "28 919 2207 10090 \n", "29 934 2235 10221 \n", "30 959 2211 10227 \n", "31 951 2267 10199 \n", "32 944 2263 10171 \n", "33 941 2270 10156 \n", "34 926 2221 10158 \n", "35 880 2200 10103 \n", "36 854 2165 9925 \n", "\n", "[37 rows x 357 columns]" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop_wide" ] }, { "cell_type": "markdown", "id": "0f5e0e29", "metadata": {}, "source": [ "Then we simply use *year* as the id variable, and the melt function will combine all the values in the other columns into one column with a second columns indicating the category (municipality)" ] }, { "cell_type": "code", "execution_count": 34, "id": "c73607a6", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearregionvalue
01986K-0301 Oslo449395
11987K-0301 Oslo451345
21988K-0301 Oslo453730
31989K-0301 Oslo456124
41990K-0301 Oslo458364
............
131672018K-5444 Sør-Varanger10171
131682019K-5444 Sør-Varanger10156
131692020K-5444 Sør-Varanger10158
131702021K-5444 Sør-Varanger10103
131712022K-5444 Sør-Varanger9925
\n", "

13172 rows × 3 columns

\n", "
" ], "text/plain": [ " year region value\n", "0 1986 K-0301 Oslo 449395\n", "1 1987 K-0301 Oslo 451345\n", "2 1988 K-0301 Oslo 453730\n", "3 1989 K-0301 Oslo 456124\n", "4 1990 K-0301 Oslo 458364\n", "... ... ... ...\n", "13167 2018 K-5444 Sør-Varanger 10171\n", "13168 2019 K-5444 Sør-Varanger 10156\n", "13169 2020 K-5444 Sør-Varanger 10158\n", "13170 2021 K-5444 Sør-Varanger 10103\n", "13171 2022 K-5444 Sør-Varanger 9925\n", "\n", "[13172 rows x 3 columns]" ] }, "execution_count": 34, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop_long = pop_wide.melt(id_vars=[\"year\"])\n", "pop_long" ] }, { "cell_type": "code", "execution_count": 35, "id": "ed0980ea", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "id": "841bcd1a", "metadata": {}, "source": [ "We could also specify the name of the category and value columns" ] }, { "cell_type": "code", "execution_count": 36, "id": "682174e2", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearMunicipalitypopulation
01986K-0301 Oslo449395
11987K-0301 Oslo451345
21988K-0301 Oslo453730
31989K-0301 Oslo456124
41990K-0301 Oslo458364
............
131672018K-5444 Sør-Varanger10171
131682019K-5444 Sør-Varanger10156
131692020K-5444 Sør-Varanger10158
131702021K-5444 Sør-Varanger10103
131712022K-5444 Sør-Varanger9925
\n", "

13172 rows × 3 columns

\n", "
" ], "text/plain": [ " year Municipality population\n", "0 1986 K-0301 Oslo 449395\n", "1 1987 K-0301 Oslo 451345\n", "2 1988 K-0301 Oslo 453730\n", "3 1989 K-0301 Oslo 456124\n", "4 1990 K-0301 Oslo 458364\n", "... ... ... ...\n", "13167 2018 K-5444 Sør-Varanger 10171\n", "13168 2019 K-5444 Sør-Varanger 10156\n", "13169 2020 K-5444 Sør-Varanger 10158\n", "13170 2021 K-5444 Sør-Varanger 10103\n", "13171 2022 K-5444 Sør-Varanger 9925\n", "\n", "[13172 rows x 3 columns]" ] }, "execution_count": 36, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop_long = pop_wide.melt(id_vars=[\"year\"], var_name=\"Municipality\", value_name=\"population\")\n", "pop_long" ] }, { "cell_type": "markdown", "id": "43fd7916", "metadata": {}, "source": [ "We noticed the step we need to do above to change the index of *year* into a normal column in order to reshape using melt. We could instead have kept the year-index and then used the the *stack* function which works with indexes and multindexes. \n", "\n", "Starting by setting year to be the index of our initial wide data set" ] }, { "cell_type": "code", "execution_count": 44, "id": "3ef910d3", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
regionK-0301 OsloK-1101 EigersundK-1103 StavangerK-1106 HaugesundK-1108 SandnesK-1111 SokndalK-1112 LundK-1114 BjerkreimK-1119 HåK-1120 Klepp...K-5435 NordkappK-5436 Porsanger - Porsángu - PorsankiK-5437 Kárásjohka - KarasjokK-5438 LebesbyK-5439 GamvikK-5440 BerlevågK-5441 Deatnu - TanaK-5442 Unjárga - NessebyK-5443 BåtsfjordK-5444 Sør-Varanger
year
19864493951208710031126883418033483311022831271511358...4393438926941811152315333309100626439853
19874513451215910076126884428873487310923051280211565...421444042654179414791469328999925509745
19884537301220310173326947435253507311323201286811688...4127438626701736145814123215100824619564
19894561241233710230827229446133497313823091298811796...4061444326581761145013743201103024019579
19904583641239110290827600453393487310123401303411788...3975447526521754142413673195103723469641
19914616441239810353627788459833453308623731302211871...3986451426901695139813403232105623419693
19924674411249510519228106467473486305923731306711953...3994451127261652138813443268105623219758
19934734541264610679728436478483501308324321304112202...3962453527571630142313203299105923709819
19944777811272110807228670489563508307124371340912381...3970449327861598146112923274107224749930
19954834011279810912629064497633517307224581326812605...3914446127881578145513243272104825479913
19964886591286310999629229502733495306324491328012757...38524461278915681410133231981058262210010
19974947931290411132429385509743484309124491335612950...3771447128671576132612643142104125509843
19984996931304511262429699518633424308424371349813240...3606442228571538133712613137103525449790
19995028671310911389329888530923394309224541372313548...3554439728711483128312523056102124549646
20005074671328811479430362540163358309624561392113789...351744512901146312881236307496524709532
20015087261329111487030609548933354311424831401713884...350543582877152412691212304496324519498
20025125891332411578130742559843309313024671420314009...351343492852151112341210303996624079608
20035174011335011707431013568053294309724801441714135...349742942844150012051193306892924049547
20045218861338811852331361577373320310524611457014313...346843292865147311341158300492722909500
20055298461340812011331530587203309312924631478414536...341542992876143011141133303790121859463
20065384111341812129831738600393301309824751488314832...333042222889139110761104300689221719464
20075486171359412351332303616103266312025071507215271...327441412873135710461086297988421139490
20085604841377812605832956631533242311225391543815839...321940592866130410401077295485620909518
20095754751396912828833665645653246311125801594916350...318040002786133210251061295187820749623
20105868601417013070934049658203285313925831634216918...318539912789134210091044291288420709738
20115992301434613314234619674113265318626511682217397...32243980276813369911031289789320719826
20126132851447513484935099690043257318327391724417746...322839462763135610081015289690120899860
20136239661463613682535753712733286317327791763518227...320539682721133910631025290088221629968
20146344631481113856736099731423303322528201811518485...3213396326981341109810572883919220710090
20156476761491614004336538748323309324728611852818741...3278392527081343111610202909934223510221
20166583901494214072136951760583313324328251859118970...3276397826681318113910002922959221110227
20176667591489914085637166767423316325928261880019042...329139712696133011379912911951226710199
20186734691489814118637167775743331323728261876219217...323939642701134911539832922944226310171
20196810711483014203437250784393305321328071881419354...321839442673132811699812900941227010156
20206934941481114357437357795373280320227871899119588...316239982628129011329572918926222110158
20216970101478714414737323804503257317427911912019848...307539212641127110979282829880220010103
20226998271486014469937444813053281317827891929620163...29473904258412211057906282185421659925
\n", "

37 rows × 356 columns

\n", "
" ], "text/plain": [ "region K-0301 Oslo K-1101 Eigersund K-1103 Stavanger K-1106 Haugesund \\\n", "year \n", "1986 449395 12087 100311 26883 \n", "1987 451345 12159 100761 26884 \n", "1988 453730 12203 101733 26947 \n", "1989 456124 12337 102308 27229 \n", "1990 458364 12391 102908 27600 \n", "1991 461644 12398 103536 27788 \n", "1992 467441 12495 105192 28106 \n", "1993 473454 12646 106797 28436 \n", "1994 477781 12721 108072 28670 \n", "1995 483401 12798 109126 29064 \n", "1996 488659 12863 109996 29229 \n", "1997 494793 12904 111324 29385 \n", "1998 499693 13045 112624 29699 \n", "1999 502867 13109 113893 29888 \n", "2000 507467 13288 114794 30362 \n", "2001 508726 13291 114870 30609 \n", "2002 512589 13324 115781 30742 \n", "2003 517401 13350 117074 31013 \n", "2004 521886 13388 118523 31361 \n", "2005 529846 13408 120113 31530 \n", "2006 538411 13418 121298 31738 \n", "2007 548617 13594 123513 32303 \n", "2008 560484 13778 126058 32956 \n", "2009 575475 13969 128288 33665 \n", "2010 586860 14170 130709 34049 \n", "2011 599230 14346 133142 34619 \n", "2012 613285 14475 134849 35099 \n", "2013 623966 14636 136825 35753 \n", "2014 634463 14811 138567 36099 \n", "2015 647676 14916 140043 36538 \n", "2016 658390 14942 140721 36951 \n", "2017 666759 14899 140856 37166 \n", "2018 673469 14898 141186 37167 \n", "2019 681071 14830 142034 37250 \n", "2020 693494 14811 143574 37357 \n", "2021 697010 14787 144147 37323 \n", "2022 699827 14860 144699 37444 \n", "\n", "region K-1108 Sandnes K-1111 Sokndal K-1112 Lund K-1114 Bjerkreim \\\n", "year \n", "1986 41803 3483 3110 2283 \n", "1987 42887 3487 3109 2305 \n", "1988 43525 3507 3113 2320 \n", "1989 44613 3497 3138 2309 \n", "1990 45339 3487 3101 2340 \n", "1991 45983 3453 3086 2373 \n", "1992 46747 3486 3059 2373 \n", "1993 47848 3501 3083 2432 \n", "1994 48956 3508 3071 2437 \n", "1995 49763 3517 3072 2458 \n", "1996 50273 3495 3063 2449 \n", "1997 50974 3484 3091 2449 \n", "1998 51863 3424 3084 2437 \n", "1999 53092 3394 3092 2454 \n", "2000 54016 3358 3096 2456 \n", "2001 54893 3354 3114 2483 \n", "2002 55984 3309 3130 2467 \n", "2003 56805 3294 3097 2480 \n", "2004 57737 3320 3105 2461 \n", "2005 58720 3309 3129 2463 \n", "2006 60039 3301 3098 2475 \n", "2007 61610 3266 3120 2507 \n", "2008 63153 3242 3112 2539 \n", "2009 64565 3246 3111 2580 \n", "2010 65820 3285 3139 2583 \n", "2011 67411 3265 3186 2651 \n", "2012 69004 3257 3183 2739 \n", "2013 71273 3286 3173 2779 \n", "2014 73142 3303 3225 2820 \n", "2015 74832 3309 3247 2861 \n", "2016 76058 3313 3243 2825 \n", "2017 76742 3316 3259 2826 \n", "2018 77574 3331 3237 2826 \n", "2019 78439 3305 3213 2807 \n", "2020 79537 3280 3202 2787 \n", "2021 80450 3257 3174 2791 \n", "2022 81305 3281 3178 2789 \n", "\n", "region K-1119 Hå K-1120 Klepp ... K-5435 Nordkapp \\\n", "year ... \n", "1986 12715 11358 ... 4393 \n", "1987 12802 11565 ... 4214 \n", "1988 12868 11688 ... 4127 \n", "1989 12988 11796 ... 4061 \n", "1990 13034 11788 ... 3975 \n", "1991 13022 11871 ... 3986 \n", "1992 13067 11953 ... 3994 \n", "1993 13041 12202 ... 3962 \n", "1994 13409 12381 ... 3970 \n", "1995 13268 12605 ... 3914 \n", "1996 13280 12757 ... 3852 \n", "1997 13356 12950 ... 3771 \n", "1998 13498 13240 ... 3606 \n", "1999 13723 13548 ... 3554 \n", "2000 13921 13789 ... 3517 \n", "2001 14017 13884 ... 3505 \n", "2002 14203 14009 ... 3513 \n", "2003 14417 14135 ... 3497 \n", "2004 14570 14313 ... 3468 \n", "2005 14784 14536 ... 3415 \n", "2006 14883 14832 ... 3330 \n", "2007 15072 15271 ... 3274 \n", "2008 15438 15839 ... 3219 \n", "2009 15949 16350 ... 3180 \n", "2010 16342 16918 ... 3185 \n", "2011 16822 17397 ... 3224 \n", "2012 17244 17746 ... 3228 \n", "2013 17635 18227 ... 3205 \n", "2014 18115 18485 ... 3213 \n", "2015 18528 18741 ... 3278 \n", "2016 18591 18970 ... 3276 \n", "2017 18800 19042 ... 3291 \n", "2018 18762 19217 ... 3239 \n", "2019 18814 19354 ... 3218 \n", "2020 18991 19588 ... 3162 \n", "2021 19120 19848 ... 3075 \n", "2022 19296 20163 ... 2947 \n", "\n", "region K-5436 Porsanger - Porsángu - Porsanki  K-5437 Kárásjohka - Karasjok \\\n", "year \n", "1986 4389 2694 \n", "1987 4404 2654 \n", "1988 4386 2670 \n", "1989 4443 2658 \n", "1990 4475 2652 \n", "1991 4514 2690 \n", "1992 4511 2726 \n", "1993 4535 2757 \n", "1994 4493 2786 \n", "1995 4461 2788 \n", "1996 4461 2789 \n", "1997 4471 2867 \n", "1998 4422 2857 \n", "1999 4397 2871 \n", "2000 4451 2901 \n", "2001 4358 2877 \n", "2002 4349 2852 \n", "2003 4294 2844 \n", "2004 4329 2865 \n", "2005 4299 2876 \n", "2006 4222 2889 \n", "2007 4141 2873 \n", "2008 4059 2866 \n", "2009 4000 2786 \n", "2010 3991 2789 \n", "2011 3980 2768 \n", "2012 3946 2763 \n", "2013 3968 2721 \n", "2014 3963 2698 \n", "2015 3925 2708 \n", "2016 3978 2668 \n", "2017 3971 2696 \n", "2018 3964 2701 \n", "2019 3944 2673 \n", "2020 3998 2628 \n", "2021 3921 2641 \n", "2022 3904 2584 \n", "\n", "region K-5438 Lebesby K-5439 Gamvik K-5440 Berlevåg K-5441 Deatnu - Tana \\\n", "year \n", "1986 1811 1523 1533 3309 \n", "1987 1794 1479 1469 3289 \n", "1988 1736 1458 1412 3215 \n", "1989 1761 1450 1374 3201 \n", "1990 1754 1424 1367 3195 \n", "1991 1695 1398 1340 3232 \n", "1992 1652 1388 1344 3268 \n", "1993 1630 1423 1320 3299 \n", "1994 1598 1461 1292 3274 \n", "1995 1578 1455 1324 3272 \n", "1996 1568 1410 1332 3198 \n", "1997 1576 1326 1264 3142 \n", "1998 1538 1337 1261 3137 \n", "1999 1483 1283 1252 3056 \n", "2000 1463 1288 1236 3074 \n", "2001 1524 1269 1212 3044 \n", "2002 1511 1234 1210 3039 \n", "2003 1500 1205 1193 3068 \n", "2004 1473 1134 1158 3004 \n", "2005 1430 1114 1133 3037 \n", "2006 1391 1076 1104 3006 \n", "2007 1357 1046 1086 2979 \n", "2008 1304 1040 1077 2954 \n", "2009 1332 1025 1061 2951 \n", "2010 1342 1009 1044 2912 \n", "2011 1336 991 1031 2897 \n", "2012 1356 1008 1015 2896 \n", "2013 1339 1063 1025 2900 \n", "2014 1341 1098 1057 2883 \n", "2015 1343 1116 1020 2909 \n", "2016 1318 1139 1000 2922 \n", "2017 1330 1137 991 2911 \n", "2018 1349 1153 983 2922 \n", "2019 1328 1169 981 2900 \n", "2020 1290 1132 957 2918 \n", "2021 1271 1097 928 2829 \n", "2022 1221 1057 906 2821 \n", "\n", "region K-5442 Unjárga - Nesseby K-5443 Båtsfjord K-5444 Sør-Varanger \n", "year \n", "1986 1006 2643 9853 \n", "1987 999 2550 9745 \n", "1988 1008 2461 9564 \n", "1989 1030 2401 9579 \n", "1990 1037 2346 9641 \n", "1991 1056 2341 9693 \n", "1992 1056 2321 9758 \n", "1993 1059 2370 9819 \n", "1994 1072 2474 9930 \n", "1995 1048 2547 9913 \n", "1996 1058 2622 10010 \n", "1997 1041 2550 9843 \n", "1998 1035 2544 9790 \n", "1999 1021 2454 9646 \n", "2000 965 2470 9532 \n", "2001 963 2451 9498 \n", "2002 966 2407 9608 \n", "2003 929 2404 9547 \n", "2004 927 2290 9500 \n", "2005 901 2185 9463 \n", "2006 892 2171 9464 \n", "2007 884 2113 9490 \n", "2008 856 2090 9518 \n", "2009 878 2074 9623 \n", "2010 884 2070 9738 \n", "2011 893 2071 9826 \n", "2012 901 2089 9860 \n", "2013 882 2162 9968 \n", "2014 919 2207 10090 \n", "2015 934 2235 10221 \n", "2016 959 2211 10227 \n", "2017 951 2267 10199 \n", "2018 944 2263 10171 \n", "2019 941 2270 10156 \n", "2020 926 2221 10158 \n", "2021 880 2200 10103 \n", "2022 854 2165 9925 \n", "\n", "[37 rows x 356 columns]" ] }, "execution_count": 44, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop_wide = pop_wide.set_index(\"year\")\n", "pop_wide" ] }, { "cell_type": "code", "execution_count": 47, "id": "f11274e3", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "year region \n", "1986 K-0301 Oslo 449395\n", " K-1101 Eigersund 12087\n", " K-1103 Stavanger 100311\n", " K-1106 Haugesund 26883\n", " K-1108 Sandnes 41803\n", " ... \n", "2022 K-5440 Berlevåg 906\n", " K-5441 Deatnu - Tana 2821\n", " K-5442 Unjárga - Nesseby 854\n", " K-5443 Båtsfjord 2165\n", " K-5444 Sør-Varanger 9925\n", "Length: 13172, dtype: int64" ] }, "execution_count": 47, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop_long = pop_wide.stack()\n", "pop_long" ] }, { "cell_type": "markdown", "id": "ed555f58", "metadata": {}, "source": [ "Notice now that both year and region are set as indexes. We could convert them to be normal columns by using *.reset_index()*. We could also quickly convert back to wide format by using *.unstack()*" ] }, { "cell_type": "code", "execution_count": 50, "id": "03964470", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
regionK-0301 OsloK-1101 EigersundK-1103 StavangerK-1106 HaugesundK-1108 SandnesK-1111 SokndalK-1112 LundK-1114 BjerkreimK-1119 HåK-1120 Klepp...K-5435 NordkappK-5436 Porsanger - Porsángu - PorsankiK-5437 Kárásjohka - KarasjokK-5438 LebesbyK-5439 GamvikK-5440 BerlevågK-5441 Deatnu - TanaK-5442 Unjárga - NessebyK-5443 BåtsfjordK-5444 Sør-Varanger
year
19864493951208710031126883418033483311022831271511358...4393438926941811152315333309100626439853
19874513451215910076126884428873487310923051280211565...421444042654179414791469328999925509745
19884537301220310173326947435253507311323201286811688...4127438626701736145814123215100824619564
19894561241233710230827229446133497313823091298811796...4061444326581761145013743201103024019579
19904583641239110290827600453393487310123401303411788...3975447526521754142413673195103723469641
19914616441239810353627788459833453308623731302211871...3986451426901695139813403232105623419693
19924674411249510519228106467473486305923731306711953...3994451127261652138813443268105623219758
19934734541264610679728436478483501308324321304112202...3962453527571630142313203299105923709819
19944777811272110807228670489563508307124371340912381...3970449327861598146112923274107224749930
19954834011279810912629064497633517307224581326812605...3914446127881578145513243272104825479913
19964886591286310999629229502733495306324491328012757...38524461278915681410133231981058262210010
19974947931290411132429385509743484309124491335612950...3771447128671576132612643142104125509843
19984996931304511262429699518633424308424371349813240...3606442228571538133712613137103525449790
19995028671310911389329888530923394309224541372313548...3554439728711483128312523056102124549646
20005074671328811479430362540163358309624561392113789...351744512901146312881236307496524709532
20015087261329111487030609548933354311424831401713884...350543582877152412691212304496324519498
20025125891332411578130742559843309313024671420314009...351343492852151112341210303996624079608
20035174011335011707431013568053294309724801441714135...349742942844150012051193306892924049547
20045218861338811852331361577373320310524611457014313...346843292865147311341158300492722909500
20055298461340812011331530587203309312924631478414536...341542992876143011141133303790121859463
20065384111341812129831738600393301309824751488314832...333042222889139110761104300689221719464
20075486171359412351332303616103266312025071507215271...327441412873135710461086297988421139490
20085604841377812605832956631533242311225391543815839...321940592866130410401077295485620909518
20095754751396912828833665645653246311125801594916350...318040002786133210251061295187820749623
20105868601417013070934049658203285313925831634216918...318539912789134210091044291288420709738
20115992301434613314234619674113265318626511682217397...32243980276813369911031289789320719826
20126132851447513484935099690043257318327391724417746...322839462763135610081015289690120899860
20136239661463613682535753712733286317327791763518227...320539682721133910631025290088221629968
20146344631481113856736099731423303322528201811518485...3213396326981341109810572883919220710090
20156476761491614004336538748323309324728611852818741...3278392527081343111610202909934223510221
20166583901494214072136951760583313324328251859118970...3276397826681318113910002922959221110227
20176667591489914085637166767423316325928261880019042...329139712696133011379912911951226710199
20186734691489814118637167775743331323728261876219217...323939642701134911539832922944226310171
20196810711483014203437250784393305321328071881419354...321839442673132811699812900941227010156
20206934941481114357437357795373280320227871899119588...316239982628129011329572918926222110158
20216970101478714414737323804503257317427911912019848...307539212641127110979282829880220010103
20226998271486014469937444813053281317827891929620163...29473904258412211057906282185421659925
\n", "

37 rows × 356 columns

\n", "
" ], "text/plain": [ "region K-0301 Oslo K-1101 Eigersund K-1103 Stavanger K-1106 Haugesund \\\n", "year \n", "1986 449395 12087 100311 26883 \n", "1987 451345 12159 100761 26884 \n", "1988 453730 12203 101733 26947 \n", "1989 456124 12337 102308 27229 \n", "1990 458364 12391 102908 27600 \n", "1991 461644 12398 103536 27788 \n", "1992 467441 12495 105192 28106 \n", "1993 473454 12646 106797 28436 \n", "1994 477781 12721 108072 28670 \n", "1995 483401 12798 109126 29064 \n", "1996 488659 12863 109996 29229 \n", "1997 494793 12904 111324 29385 \n", "1998 499693 13045 112624 29699 \n", "1999 502867 13109 113893 29888 \n", "2000 507467 13288 114794 30362 \n", "2001 508726 13291 114870 30609 \n", "2002 512589 13324 115781 30742 \n", "2003 517401 13350 117074 31013 \n", "2004 521886 13388 118523 31361 \n", "2005 529846 13408 120113 31530 \n", "2006 538411 13418 121298 31738 \n", "2007 548617 13594 123513 32303 \n", "2008 560484 13778 126058 32956 \n", "2009 575475 13969 128288 33665 \n", "2010 586860 14170 130709 34049 \n", "2011 599230 14346 133142 34619 \n", "2012 613285 14475 134849 35099 \n", "2013 623966 14636 136825 35753 \n", "2014 634463 14811 138567 36099 \n", "2015 647676 14916 140043 36538 \n", "2016 658390 14942 140721 36951 \n", "2017 666759 14899 140856 37166 \n", "2018 673469 14898 141186 37167 \n", "2019 681071 14830 142034 37250 \n", "2020 693494 14811 143574 37357 \n", "2021 697010 14787 144147 37323 \n", "2022 699827 14860 144699 37444 \n", "\n", "region K-1108 Sandnes K-1111 Sokndal K-1112 Lund K-1114 Bjerkreim \\\n", "year \n", "1986 41803 3483 3110 2283 \n", "1987 42887 3487 3109 2305 \n", "1988 43525 3507 3113 2320 \n", "1989 44613 3497 3138 2309 \n", "1990 45339 3487 3101 2340 \n", "1991 45983 3453 3086 2373 \n", "1992 46747 3486 3059 2373 \n", "1993 47848 3501 3083 2432 \n", "1994 48956 3508 3071 2437 \n", "1995 49763 3517 3072 2458 \n", "1996 50273 3495 3063 2449 \n", "1997 50974 3484 3091 2449 \n", "1998 51863 3424 3084 2437 \n", "1999 53092 3394 3092 2454 \n", "2000 54016 3358 3096 2456 \n", "2001 54893 3354 3114 2483 \n", "2002 55984 3309 3130 2467 \n", "2003 56805 3294 3097 2480 \n", "2004 57737 3320 3105 2461 \n", "2005 58720 3309 3129 2463 \n", "2006 60039 3301 3098 2475 \n", "2007 61610 3266 3120 2507 \n", "2008 63153 3242 3112 2539 \n", "2009 64565 3246 3111 2580 \n", "2010 65820 3285 3139 2583 \n", "2011 67411 3265 3186 2651 \n", "2012 69004 3257 3183 2739 \n", "2013 71273 3286 3173 2779 \n", "2014 73142 3303 3225 2820 \n", "2015 74832 3309 3247 2861 \n", "2016 76058 3313 3243 2825 \n", "2017 76742 3316 3259 2826 \n", "2018 77574 3331 3237 2826 \n", "2019 78439 3305 3213 2807 \n", "2020 79537 3280 3202 2787 \n", "2021 80450 3257 3174 2791 \n", "2022 81305 3281 3178 2789 \n", "\n", "region K-1119 Hå K-1120 Klepp ... K-5435 Nordkapp \\\n", "year ... \n", "1986 12715 11358 ... 4393 \n", "1987 12802 11565 ... 4214 \n", "1988 12868 11688 ... 4127 \n", "1989 12988 11796 ... 4061 \n", "1990 13034 11788 ... 3975 \n", "1991 13022 11871 ... 3986 \n", "1992 13067 11953 ... 3994 \n", "1993 13041 12202 ... 3962 \n", "1994 13409 12381 ... 3970 \n", "1995 13268 12605 ... 3914 \n", "1996 13280 12757 ... 3852 \n", "1997 13356 12950 ... 3771 \n", "1998 13498 13240 ... 3606 \n", "1999 13723 13548 ... 3554 \n", "2000 13921 13789 ... 3517 \n", "2001 14017 13884 ... 3505 \n", "2002 14203 14009 ... 3513 \n", "2003 14417 14135 ... 3497 \n", "2004 14570 14313 ... 3468 \n", "2005 14784 14536 ... 3415 \n", "2006 14883 14832 ... 3330 \n", "2007 15072 15271 ... 3274 \n", "2008 15438 15839 ... 3219 \n", "2009 15949 16350 ... 3180 \n", "2010 16342 16918 ... 3185 \n", "2011 16822 17397 ... 3224 \n", "2012 17244 17746 ... 3228 \n", "2013 17635 18227 ... 3205 \n", "2014 18115 18485 ... 3213 \n", "2015 18528 18741 ... 3278 \n", "2016 18591 18970 ... 3276 \n", "2017 18800 19042 ... 3291 \n", "2018 18762 19217 ... 3239 \n", "2019 18814 19354 ... 3218 \n", "2020 18991 19588 ... 3162 \n", "2021 19120 19848 ... 3075 \n", "2022 19296 20163 ... 2947 \n", "\n", "region K-5436 Porsanger - Porsángu - Porsanki  K-5437 Kárásjohka - Karasjok \\\n", "year \n", "1986 4389 2694 \n", "1987 4404 2654 \n", "1988 4386 2670 \n", "1989 4443 2658 \n", "1990 4475 2652 \n", "1991 4514 2690 \n", "1992 4511 2726 \n", "1993 4535 2757 \n", "1994 4493 2786 \n", "1995 4461 2788 \n", "1996 4461 2789 \n", "1997 4471 2867 \n", "1998 4422 2857 \n", "1999 4397 2871 \n", "2000 4451 2901 \n", "2001 4358 2877 \n", "2002 4349 2852 \n", "2003 4294 2844 \n", "2004 4329 2865 \n", "2005 4299 2876 \n", "2006 4222 2889 \n", "2007 4141 2873 \n", "2008 4059 2866 \n", "2009 4000 2786 \n", "2010 3991 2789 \n", "2011 3980 2768 \n", "2012 3946 2763 \n", "2013 3968 2721 \n", "2014 3963 2698 \n", "2015 3925 2708 \n", "2016 3978 2668 \n", "2017 3971 2696 \n", "2018 3964 2701 \n", "2019 3944 2673 \n", "2020 3998 2628 \n", "2021 3921 2641 \n", "2022 3904 2584 \n", "\n", "region K-5438 Lebesby K-5439 Gamvik K-5440 Berlevåg K-5441 Deatnu - Tana \\\n", "year \n", "1986 1811 1523 1533 3309 \n", "1987 1794 1479 1469 3289 \n", "1988 1736 1458 1412 3215 \n", "1989 1761 1450 1374 3201 \n", "1990 1754 1424 1367 3195 \n", "1991 1695 1398 1340 3232 \n", "1992 1652 1388 1344 3268 \n", "1993 1630 1423 1320 3299 \n", "1994 1598 1461 1292 3274 \n", "1995 1578 1455 1324 3272 \n", "1996 1568 1410 1332 3198 \n", "1997 1576 1326 1264 3142 \n", "1998 1538 1337 1261 3137 \n", "1999 1483 1283 1252 3056 \n", "2000 1463 1288 1236 3074 \n", "2001 1524 1269 1212 3044 \n", "2002 1511 1234 1210 3039 \n", "2003 1500 1205 1193 3068 \n", "2004 1473 1134 1158 3004 \n", "2005 1430 1114 1133 3037 \n", "2006 1391 1076 1104 3006 \n", "2007 1357 1046 1086 2979 \n", "2008 1304 1040 1077 2954 \n", "2009 1332 1025 1061 2951 \n", "2010 1342 1009 1044 2912 \n", "2011 1336 991 1031 2897 \n", "2012 1356 1008 1015 2896 \n", "2013 1339 1063 1025 2900 \n", "2014 1341 1098 1057 2883 \n", "2015 1343 1116 1020 2909 \n", "2016 1318 1139 1000 2922 \n", "2017 1330 1137 991 2911 \n", "2018 1349 1153 983 2922 \n", "2019 1328 1169 981 2900 \n", "2020 1290 1132 957 2918 \n", "2021 1271 1097 928 2829 \n", "2022 1221 1057 906 2821 \n", "\n", "region K-5442 Unjárga - Nesseby K-5443 Båtsfjord K-5444 Sør-Varanger \n", "year \n", "1986 1006 2643 9853 \n", "1987 999 2550 9745 \n", "1988 1008 2461 9564 \n", "1989 1030 2401 9579 \n", "1990 1037 2346 9641 \n", "1991 1056 2341 9693 \n", "1992 1056 2321 9758 \n", "1993 1059 2370 9819 \n", "1994 1072 2474 9930 \n", "1995 1048 2547 9913 \n", "1996 1058 2622 10010 \n", "1997 1041 2550 9843 \n", "1998 1035 2544 9790 \n", "1999 1021 2454 9646 \n", "2000 965 2470 9532 \n", "2001 963 2451 9498 \n", "2002 966 2407 9608 \n", "2003 929 2404 9547 \n", "2004 927 2290 9500 \n", "2005 901 2185 9463 \n", "2006 892 2171 9464 \n", "2007 884 2113 9490 \n", "2008 856 2090 9518 \n", "2009 878 2074 9623 \n", "2010 884 2070 9738 \n", "2011 893 2071 9826 \n", "2012 901 2089 9860 \n", "2013 882 2162 9968 \n", "2014 919 2207 10090 \n", "2015 934 2235 10221 \n", "2016 959 2211 10227 \n", "2017 951 2267 10199 \n", "2018 944 2263 10171 \n", "2019 941 2270 10156 \n", "2020 926 2221 10158 \n", "2021 880 2200 10103 \n", "2022 854 2165 9925 \n", "\n", "[37 rows x 356 columns]" ] }, "execution_count": 50, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pop_wide = pop_long.unstack()\n", "pop_wide" ] }, { "cell_type": "code", "execution_count": null, "id": "ac175aa7", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.12" } }, "nbformat": 4, "nbformat_minor": 5 }