{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Andmete visualiseerimine.ipynb","provenance":[],"collapsed_sections":[],"authorship_tag":"ABX9TyMBh5NV6b4ap/V3ZBy4EHKa"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","metadata":{"id":"XqwQH_G2g1YC"},"source":["# Andmete visualiseerimine ja tulemuste esitamine\n","Andmeteaduse projektide üheks sagedaseks ebaõnnestumise põhjuseks on asjaolu, et tulemusi ei esitleta tellija/kliendi jaoks arusaadavas vormis.\n","\n","Selles tööfailis teeme sissejuhatuse andmete visualiseerimisse ja vaatame erinevaid võimalusi."]},{"cell_type":"markdown","metadata":{"id":"hjw7Ad_shRp5"},"source":["# Andmete importimine\n","Esimese sammuna impordime eelmise koolituse lõpus salvestatud andmed, mis näitab Eesti ettevõtete makse, müügitulu ja töötajate arvu kvartalite ja tegevusvaldkondade alusel."]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"9HJVwlYFfzbm","executionInfo":{"status":"ok","timestamp":1639405838147,"user_tz":-120,"elapsed":531,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"8290b260-e9db-4976-9a36-ba658d6b21c8"},"source":["import pandas as pd\n","data_url = \"https://raw.githubusercontent.com/kristjan-eljand/andmeteadus_on_popp/main/maksud_kvartali_ja_tegevusvaldkonna_alusel.csv\"\n","start_data = pd.read_csv(data_url)\n","start_data"],"execution_count":1,"outputs":[{"output_type":"execute_result","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","
emtakquarternational_taxemployee_taxrevenueemployees
0AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT...2020_III315362654.0312685563.04.931157e+0728195.0
1AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS...2021_III278982967.0286911928.05.874143e+0729253.0
2EHITUS2020_III160967143.084367702.01.422454e+0953089.0
3EHITUS2021_III180173527.097812167.01.731195e+0952396.0
4EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2020_III21314.022570.02.066000e+039.0
5EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2021_III22138.023132.04.125000e+0310.0
6ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2020_III44920545.015793693.04.922087e+084838.0
7ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2021_III44481675.015258727.07.129062e+084510.0
8FINANTS- JA KINDLUSTUSTEGEVUS2020_III72238162.051069052.04.020034e+0813430.0
9FINANTS- JA KINDLUSTUSTEGEVUS2021_III81152769.057567790.05.423751e+0812534.0
10HALDUS- JA ABITEGEVUSED2020_III83901047.052669828.05.153248e+0840497.0
11HALDUS- JA ABITEGEVUSED2021_III100859320.063134698.05.265120e+0840904.0
12HARIDUS2020_III70841854.072336766.03.171459e+0767783.0
13HARIDUS2021_III78669628.078880665.03.930740e+0769387.0
14HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2020_III754239381.0163015898.07.753620e+0997290.0
15HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2021_III847094135.0193165679.09.594342e+0995601.0
16INFO JA SIDE2020_III138252812.097622174.01.050386e+0930030.0
17INFO JA SIDE2021_III180655907.0122273401.01.288662e+0930541.0
18KINNISVARAALANE TEGEVUS2020_III92451240.020128185.05.662990e+0823789.0
19KINNISVARAALANE TEGEVUS2021_III82661943.021628400.07.203238e+0817505.0
20KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2020_III1038.01094.00.000000e+005.0
21KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2021_III761.0799.03.654000e+034.0
22KUNST, MEELELAHUTUS JA VABA AEG2020_III34157853.020006426.06.538288e+0721181.0
23KUNST, MEELELAHUTUS JA VABA AEG2021_III40438036.023888293.09.845626e+0720063.0
24KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2020_III100191200.060220038.05.947420e+0836495.0
25KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2021_III123184637.073220894.01.239521e+0932378.0
26MAJUTUS JA TOITLUSTUS2020_III37057967.020851078.02.340850e+0825466.0
27MAJUTUS JA TOITLUSTUS2021_III42020277.025085196.02.812722e+0825446.0
28MUUD TEENINDAVAD TEGEVUSED2020_III18573231.014889536.06.955462e+0716830.0
29MUUD TEENINDAVAD TEGEVUSED2021_III21946045.015948043.08.653941e+0714795.0
30MÄETÖÖSTUS2020_III11195038.08277648.06.505738e+072937.0
31MÄETÖÖSTUS2021_III10391648.06670740.07.792065e+072087.0
32PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2020_III49764140.023583946.04.111492e+0816379.0
33PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2021_III63618682.026966134.05.390556e+0815536.0
34TERVISHOID JA SOTSIAALHOOLEKANNE2020_III96370237.099751829.02.019711e+0750671.0
35TERVISHOID JA SOTSIAALHOOLEKANNE2021_III109817885.0113762696.01.859716e+0751881.0
36TÖÖTLEV TÖÖSTUS2020_III323903600.0211585654.04.158945e+09108593.0
37TÖÖTLEV TÖÖSTUS2021_III361019081.0244706984.05.009826e+09108448.0
38VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE...2021_III17133600.09566442.02.381920e+083941.0
39VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE...2020_III17909215.08056822.01.623803e+083908.0
40VEONDUS JA LAONDUS2020_III237634194.071194623.01.315052e+0940866.0
41VEONDUS JA LAONDUS2021_III295400010.079402535.01.572818e+0939283.0
\n","
"],"text/plain":[" emtak ... employees\n","0 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT... ... 28195.0\n","1 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS... ... 29253.0\n","2 EHITUS ... 53089.0\n","3 EHITUS ... 52396.0\n","4 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 9.0\n","5 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 10.0\n","6 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 4838.0\n","7 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 4510.0\n","8 FINANTS- JA KINDLUSTUSTEGEVUS ... 13430.0\n","9 FINANTS- JA KINDLUSTUSTEGEVUS ... 12534.0\n","10 HALDUS- JA ABITEGEVUSED ... 40497.0\n","11 HALDUS- JA ABITEGEVUSED ... 40904.0\n","12 HARIDUS ... 67783.0\n","13 HARIDUS ... 69387.0\n","14 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 97290.0\n","15 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 95601.0\n","16 INFO JA SIDE ... 30030.0\n","17 INFO JA SIDE ... 30541.0\n","18 KINNISVARAALANE TEGEVUS ... 23789.0\n","19 KINNISVARAALANE TEGEVUS ... 17505.0\n","20 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 5.0\n","21 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 4.0\n","22 KUNST, MEELELAHUTUS JA VABA AEG ... 21181.0\n","23 KUNST, MEELELAHUTUS JA VABA AEG ... 20063.0\n","24 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 36495.0\n","25 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 32378.0\n","26 MAJUTUS JA TOITLUSTUS ... 25466.0\n","27 MAJUTUS JA TOITLUSTUS ... 25446.0\n","28 MUUD TEENINDAVAD TEGEVUSED ... 16830.0\n","29 MUUD TEENINDAVAD TEGEVUSED ... 14795.0\n","30 MÄETÖÖSTUS ... 2937.0\n","31 MÄETÖÖSTUS ... 2087.0\n","32 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 16379.0\n","33 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 15536.0\n","34 TERVISHOID JA SOTSIAALHOOLEKANNE ... 50671.0\n","35 TERVISHOID JA SOTSIAALHOOLEKANNE ... 51881.0\n","36 TÖÖTLEV TÖÖSTUS ... 108593.0\n","37 TÖÖTLEV TÖÖSTUS ... 108448.0\n","38 VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE... ... 3941.0\n","39 VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE... ... 3908.0\n","40 VEONDUS JA LAONDUS ... 40866.0\n","41 VEONDUS JA LAONDUS ... 39283.0\n","\n","[42 rows x 6 columns]"]},"metadata":{},"execution_count":1}]},{"cell_type":"markdown","metadata":{"id":"wMKM0KVAlMER"},"source":["# Andmete loetavuse parendamine\n","Üks lihtsaim ja võimsaim idee paremaks visualiseerimiseks, on esitada andmed õigetes suurusjärkudes, ilma liigse arvu komakohtadeta.\n","\n","Meie praeguses tabelis on numbrid liiga suured ja seetõttu on neid raske lugeda.\n","\n","Alljärgnevas näites jagame muudame maksud ja müügitulu miljoniteks ning töötajate arvu tuhandeteks. Samuti ümardame väärtused ühe komakohani."]},{"cell_type":"markdown","metadata":{"id":"IgVhSZpRpLXA"},"source":["## Numbrid õigesse suurusjärku"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"cE_v8_GcoQA4","executionInfo":{"status":"ok","timestamp":1639405908344,"user_tz":-120,"elapsed":348,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"5151c507-b9e6-40dd-db2f-49f0bcd3155c"},"source":["# Teeme algandmetest koopia, mida hakkame muutma\n","scaled_data = start_data.copy()\n","\n","# Jagame töötajate arvu tuhandega\n","scaled_data['employees'] = scaled_data['employees'] / 1000\n","\n","# Jagame maksud ja müügitulu miljoniga\n","vars_to_mln = ['national_tax', 'employee_tax', 'revenue']\n","scaled_data[vars_to_mln] = scaled_data[vars_to_mln] / 1000000\n","scaled_data"],"execution_count":2,"outputs":[{"output_type":"execute_result","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","
emtakquarternational_taxemployee_taxrevenueemployees
0AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT...2020_III315.362654312.68556349.31156728.195
1AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS...2021_III278.982967286.91192858.74142629.253
2EHITUS2020_III160.96714384.3677021422.45430653.089
3EHITUS2021_III180.17352797.8121671731.19488952.396
4EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2020_III0.0213140.0225700.0020660.009
5EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2021_III0.0221380.0231320.0041250.010
6ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2020_III44.92054515.793693492.2086924.838
7ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2021_III44.48167515.258727712.9061504.510
8FINANTS- JA KINDLUSTUSTEGEVUS2020_III72.23816251.069052402.00342513.430
9FINANTS- JA KINDLUSTUSTEGEVUS2021_III81.15276957.567790542.37507412.534
10HALDUS- JA ABITEGEVUSED2020_III83.90104752.669828515.32481340.497
11HALDUS- JA ABITEGEVUSED2021_III100.85932063.134698526.51201440.904
12HARIDUS2020_III70.84185472.33676631.71458967.783
13HARIDUS2021_III78.66962878.88066539.30739869.387
14HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2020_III754.239381163.0158987753.61962197.290
15HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2021_III847.094135193.1656799594.34162195.601
16INFO JA SIDE2020_III138.25281297.6221741050.38623730.030
17INFO JA SIDE2021_III180.655907122.2734011288.66155230.541
18KINNISVARAALANE TEGEVUS2020_III92.45124020.128185566.29902423.789
19KINNISVARAALANE TEGEVUS2021_III82.66194321.628400720.32381117.505
20KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2020_III0.0010380.0010940.0000000.005
21KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2021_III0.0007610.0007990.0036540.004
22KUNST, MEELELAHUTUS JA VABA AEG2020_III34.15785320.00642665.38288221.181
23KUNST, MEELELAHUTUS JA VABA AEG2021_III40.43803623.88829398.45626120.063
24KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2020_III100.19120060.220038594.74196336.495
25KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2021_III123.18463773.2208941239.52147632.378
26MAJUTUS JA TOITLUSTUS2020_III37.05796720.851078234.08498325.466
27MAJUTUS JA TOITLUSTUS2021_III42.02027725.085196281.27215125.446
28MUUD TEENINDAVAD TEGEVUSED2020_III18.57323114.88953669.55462116.830
29MUUD TEENINDAVAD TEGEVUSED2021_III21.94604515.94804386.53941014.795
30MÄETÖÖSTUS2020_III11.1950388.27764865.0573782.937
31MÄETÖÖSTUS2021_III10.3916486.67074077.9206532.087
32PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2020_III49.76414023.583946411.14922716.379
33PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2021_III63.61868226.966134539.05559715.536
34TERVISHOID JA SOTSIAALHOOLEKANNE2020_III96.37023799.75182920.19710750.671
35TERVISHOID JA SOTSIAALHOOLEKANNE2021_III109.817885113.76269618.59716551.881
36TÖÖTLEV TÖÖSTUS2020_III323.903600211.5856544158.944656108.593
37TÖÖTLEV TÖÖSTUS2021_III361.019081244.7069845009.825993108.448
38VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE...2021_III17.1336009.566442238.1919513.941
39VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE...2020_III17.9092158.056822162.3802793.908
40VEONDUS JA LAONDUS2020_III237.63419471.1946231315.05161940.866
41VEONDUS JA LAONDUS2021_III295.40001079.4025351572.81768539.283
\n","
"],"text/plain":[" emtak ... employees\n","0 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT... ... 28.195\n","1 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS... ... 29.253\n","2 EHITUS ... 53.089\n","3 EHITUS ... 52.396\n","4 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 0.009\n","5 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 0.010\n","6 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 4.838\n","7 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 4.510\n","8 FINANTS- JA KINDLUSTUSTEGEVUS ... 13.430\n","9 FINANTS- JA KINDLUSTUSTEGEVUS ... 12.534\n","10 HALDUS- JA ABITEGEVUSED ... 40.497\n","11 HALDUS- JA ABITEGEVUSED ... 40.904\n","12 HARIDUS ... 67.783\n","13 HARIDUS ... 69.387\n","14 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 97.290\n","15 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 95.601\n","16 INFO JA SIDE ... 30.030\n","17 INFO JA SIDE ... 30.541\n","18 KINNISVARAALANE TEGEVUS ... 23.789\n","19 KINNISVARAALANE TEGEVUS ... 17.505\n","20 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 0.005\n","21 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 0.004\n","22 KUNST, MEELELAHUTUS JA VABA AEG ... 21.181\n","23 KUNST, MEELELAHUTUS JA VABA AEG ... 20.063\n","24 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 36.495\n","25 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 32.378\n","26 MAJUTUS JA TOITLUSTUS ... 25.466\n","27 MAJUTUS JA TOITLUSTUS ... 25.446\n","28 MUUD TEENINDAVAD TEGEVUSED ... 16.830\n","29 MUUD TEENINDAVAD TEGEVUSED ... 14.795\n","30 MÄETÖÖSTUS ... 2.937\n","31 MÄETÖÖSTUS ... 2.087\n","32 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 16.379\n","33 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 15.536\n","34 TERVISHOID JA SOTSIAALHOOLEKANNE ... 50.671\n","35 TERVISHOID JA SOTSIAALHOOLEKANNE ... 51.881\n","36 TÖÖTLEV TÖÖSTUS ... 108.593\n","37 TÖÖTLEV TÖÖSTUS ... 108.448\n","38 VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE... ... 3.941\n","39 VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE... ... 3.908\n","40 VEONDUS JA LAONDUS ... 40.866\n","41 VEONDUS JA LAONDUS ... 39.283\n","\n","[42 rows x 6 columns]"]},"metadata":{},"execution_count":2}]},{"cell_type":"markdown","metadata":{"id":"ul8qsutzp_AU"},"source":["## Ümardamine\n","Meie ülaltoodud tabelis on nüüd liiga palju komakohti. Pandas `round` meetod võimaldab lihtsasti kõigi numbrilisi muutujaid ümardada."]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"nDKgKlQqozd2","executionInfo":{"status":"ok","timestamp":1639405944287,"user_tz":-120,"elapsed":312,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"f096be09-f1df-42c5-f203-f4f095711984"},"source":["rounded_data = scaled_data.round(decimals=0)\n","rounded_data"],"execution_count":3,"outputs":[{"output_type":"execute_result","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","
emtakquarternational_taxemployee_taxrevenueemployees
0AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT...2020_III315.0313.049.028.0
1AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS...2021_III279.0287.059.029.0
2EHITUS2020_III161.084.01422.053.0
3EHITUS2021_III180.098.01731.052.0
4EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2020_III0.00.00.00.0
5EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2021_III0.00.00.00.0
6ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2020_III45.016.0492.05.0
7ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2021_III44.015.0713.05.0
8FINANTS- JA KINDLUSTUSTEGEVUS2020_III72.051.0402.013.0
9FINANTS- JA KINDLUSTUSTEGEVUS2021_III81.058.0542.013.0
10HALDUS- JA ABITEGEVUSED2020_III84.053.0515.040.0
11HALDUS- JA ABITEGEVUSED2021_III101.063.0527.041.0
12HARIDUS2020_III71.072.032.068.0
13HARIDUS2021_III79.079.039.069.0
14HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2020_III754.0163.07754.097.0
15HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2021_III847.0193.09594.096.0
16INFO JA SIDE2020_III138.098.01050.030.0
17INFO JA SIDE2021_III181.0122.01289.031.0
18KINNISVARAALANE TEGEVUS2020_III92.020.0566.024.0
19KINNISVARAALANE TEGEVUS2021_III83.022.0720.018.0
20KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2020_III0.00.00.00.0
21KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2021_III0.00.00.00.0
22KUNST, MEELELAHUTUS JA VABA AEG2020_III34.020.065.021.0
23KUNST, MEELELAHUTUS JA VABA AEG2021_III40.024.098.020.0
24KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2020_III100.060.0595.036.0
25KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2021_III123.073.01240.032.0
26MAJUTUS JA TOITLUSTUS2020_III37.021.0234.025.0
27MAJUTUS JA TOITLUSTUS2021_III42.025.0281.025.0
28MUUD TEENINDAVAD TEGEVUSED2020_III19.015.070.017.0
29MUUD TEENINDAVAD TEGEVUSED2021_III22.016.087.015.0
30MÄETÖÖSTUS2020_III11.08.065.03.0
31MÄETÖÖSTUS2021_III10.07.078.02.0
32PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2020_III50.024.0411.016.0
33PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2021_III64.027.0539.016.0
34TERVISHOID JA SOTSIAALHOOLEKANNE2020_III96.0100.020.051.0
35TERVISHOID JA SOTSIAALHOOLEKANNE2021_III110.0114.019.052.0
36TÖÖTLEV TÖÖSTUS2020_III324.0212.04159.0109.0
37TÖÖTLEV TÖÖSTUS2021_III361.0245.05010.0108.0
38VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE...2021_III17.010.0238.04.0
39VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE...2020_III18.08.0162.04.0
40VEONDUS JA LAONDUS2020_III238.071.01315.041.0
41VEONDUS JA LAONDUS2021_III295.079.01573.039.0
\n","
"],"text/plain":[" emtak ... employees\n","0 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT... ... 28.0\n","1 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS... ... 29.0\n","2 EHITUS ... 53.0\n","3 EHITUS ... 52.0\n","4 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 0.0\n","5 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 0.0\n","6 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 5.0\n","7 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 5.0\n","8 FINANTS- JA KINDLUSTUSTEGEVUS ... 13.0\n","9 FINANTS- JA KINDLUSTUSTEGEVUS ... 13.0\n","10 HALDUS- JA ABITEGEVUSED ... 40.0\n","11 HALDUS- JA ABITEGEVUSED ... 41.0\n","12 HARIDUS ... 68.0\n","13 HARIDUS ... 69.0\n","14 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 97.0\n","15 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 96.0\n","16 INFO JA SIDE ... 30.0\n","17 INFO JA SIDE ... 31.0\n","18 KINNISVARAALANE TEGEVUS ... 24.0\n","19 KINNISVARAALANE TEGEVUS ... 18.0\n","20 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 0.0\n","21 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 0.0\n","22 KUNST, MEELELAHUTUS JA VABA AEG ... 21.0\n","23 KUNST, MEELELAHUTUS JA VABA AEG ... 20.0\n","24 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 36.0\n","25 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 32.0\n","26 MAJUTUS JA TOITLUSTUS ... 25.0\n","27 MAJUTUS JA TOITLUSTUS ... 25.0\n","28 MUUD TEENINDAVAD TEGEVUSED ... 17.0\n","29 MUUD TEENINDAVAD TEGEVUSED ... 15.0\n","30 MÄETÖÖSTUS ... 3.0\n","31 MÄETÖÖSTUS ... 2.0\n","32 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 16.0\n","33 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 16.0\n","34 TERVISHOID JA SOTSIAALHOOLEKANNE ... 51.0\n","35 TERVISHOID JA SOTSIAALHOOLEKANNE ... 52.0\n","36 TÖÖTLEV TÖÖSTUS ... 109.0\n","37 TÖÖTLEV TÖÖSTUS ... 108.0\n","38 VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE... ... 4.0\n","39 VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE... ... 4.0\n","40 VEONDUS JA LAONDUS ... 41.0\n","41 VEONDUS JA LAONDUS ... 39.0\n","\n","[42 rows x 6 columns]"]},"metadata":{},"execution_count":3}]},{"cell_type":"markdown","metadata":{"id":"n_06v-ODs1NS"},"source":["## Andmetüübi muutmine\n","Meie ülaltoodud tabelis on väärtused ümardatud küll null komakohani, aga kuna tegemist on `float` ehk komakohtadega andmetüübiga, näitab tabel meile ikka ühte komakohta.\n","\n","Selle parendamiseks muudame kõik numbrilised muutujad täisarvudeks, kasutades meetodit `convert_dtypes()`, mis püüab ise leida kõigile muutujatele õige tüübi."]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"c9KsPScqfPYd","executionInfo":{"status":"ok","timestamp":1639405978148,"user_tz":-120,"elapsed":297,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"5e4f6dce-f0ff-467b-f81e-f0abe7027eaf"},"source":["# Vaatame oma andmetabeli andmetüüpe\n","rounded_data.dtypes"],"execution_count":4,"outputs":[{"output_type":"execute_result","data":{"text/plain":["emtak object\n","quarter object\n","national_tax float64\n","employee_tax float64\n","revenue float64\n","employees float64\n","dtype: object"]},"metadata":{},"execution_count":4}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"RIjDOiNHtGAD","executionInfo":{"status":"ok","timestamp":1639406016273,"user_tz":-120,"elapsed":289,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"1006898d-d4e7-4187-d173-e00aaafc19bf"},"source":["# Kuna oleme kõik numbrilised muutujad ümardanud nullini\n","# saame kasutada convert_dtypes()\n","integer_data = rounded_data.convert_dtypes()\n","integer_data\n","\n","# NB: alternatiiv oleks muuta kõiki muutujad ühe kaupa\n","# integer_data['employee_tax'] = integer_data.employee_tax.astype('int')"],"execution_count":5,"outputs":[{"output_type":"execute_result","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","
emtakquarternational_taxemployee_taxrevenueemployees
0AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT...2020_III3153134928
1AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS...2021_III2792875929
2EHITUS2020_III16184142253
3EHITUS2021_III18098173152
4EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2020_III0000
5EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS...2021_III0000
6ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2020_III45164925
7ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT...2021_III44157135
8FINANTS- JA KINDLUSTUSTEGEVUS2020_III725140213
9FINANTS- JA KINDLUSTUSTEGEVUS2021_III815854213
10HALDUS- JA ABITEGEVUSED2020_III845351540
11HALDUS- JA ABITEGEVUSED2021_III1016352741
12HARIDUS2020_III71723268
13HARIDUS2021_III79793969
14HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2020_III754163775497
15HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO...2021_III847193959496
16INFO JA SIDE2020_III13898105030
17INFO JA SIDE2021_III181122128931
18KINNISVARAALANE TEGEVUS2020_III922056624
19KINNISVARAALANE TEGEVUS2021_III832272018
20KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2020_III0000
21KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU...2021_III0000
22KUNST, MEELELAHUTUS JA VABA AEG2020_III34206521
23KUNST, MEELELAHUTUS JA VABA AEG2021_III40249820
24KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2020_III1006059536
25KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS2021_III12373124032
26MAJUTUS JA TOITLUSTUS2020_III372123425
27MAJUTUS JA TOITLUSTUS2021_III422528125
28MUUD TEENINDAVAD TEGEVUSED2020_III19157017
29MUUD TEENINDAVAD TEGEVUSED2021_III22168715
30MÄETÖÖSTUS2020_III118653
31MÄETÖÖSTUS2021_III107782
32PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2020_III502441116
33PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK2021_III642753916
34TERVISHOID JA SOTSIAALHOOLEKANNE2020_III961002051
35TERVISHOID JA SOTSIAALHOOLEKANNE2021_III1101141952
36TÖÖTLEV TÖÖSTUS2020_III3242124159109
37TÖÖTLEV TÖÖSTUS2021_III3612455010108
38VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE...2021_III17102384
39VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE...2020_III1881624
40VEONDUS JA LAONDUS2020_III23871131541
41VEONDUS JA LAONDUS2021_III29579157339
\n","
"],"text/plain":[" emtak ... employees\n","0 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOT... ... 28\n","1 AVALIK HALDUS JA RIIGIKAITSE; KOHUSTUSLIK SOTS... ... 29\n","2 EHITUS ... 53\n","3 EHITUS ... 52\n","4 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 0\n","5 EKSTERRITORIAALSETE ORGANISATSIOONIDE JA ÜKSUS... ... 0\n","6 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 5\n","7 ELEKTRIENERGIA, GAASI, AURU JA KONDITSIONEERIT... ... 5\n","8 FINANTS- JA KINDLUSTUSTEGEVUS ... 13\n","9 FINANTS- JA KINDLUSTUSTEGEVUS ... 13\n","10 HALDUS- JA ABITEGEVUSED ... 40\n","11 HALDUS- JA ABITEGEVUSED ... 41\n","12 HARIDUS ... 68\n","13 HARIDUS ... 69\n","14 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 97\n","15 HULGI- JA JAEKAUBANDUS; MOOTORSÕIDUKITE JA MOO... ... 96\n","16 INFO JA SIDE ... 30\n","17 INFO JA SIDE ... 31\n","18 KINNISVARAALANE TEGEVUS ... 24\n","19 KINNISVARAALANE TEGEVUS ... 18\n","20 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 0\n","21 KODUMAJAPIDAMISTE KUI TÖÖANDJATE TEGEVUS; KODU... ... 0\n","22 KUNST, MEELELAHUTUS JA VABA AEG ... 21\n","23 KUNST, MEELELAHUTUS JA VABA AEG ... 20\n","24 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 36\n","25 KUTSE-, TEADUS- JA TEHNIKAALANE TEGEVUS ... 32\n","26 MAJUTUS JA TOITLUSTUS ... 25\n","27 MAJUTUS JA TOITLUSTUS ... 25\n","28 MUUD TEENINDAVAD TEGEVUSED ... 17\n","29 MUUD TEENINDAVAD TEGEVUSED ... 15\n","30 MÄETÖÖSTUS ... 3\n","31 MÄETÖÖSTUS ... 2\n","32 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 16\n","33 PÕLLUMAJANDUS, METSAMAJANDUS JA KALAPÜÜK ... 16\n","34 TERVISHOID JA SOTSIAALHOOLEKANNE ... 51\n","35 TERVISHOID JA SOTSIAALHOOLEKANNE ... 52\n","36 TÖÖTLEV TÖÖSTUS ... 109\n","37 TÖÖTLEV TÖÖSTUS ... 108\n","38 VEEVARUSTUS; KANALISATSIOON, JÄÄTME- JA SAASTE... ... 4\n","39 VEEVARUSTUS; KANALISATSIOON; JÄÄTME- JA SAASTE... ... 4\n","40 VEONDUS JA LAONDUS ... 41\n","41 VEONDUS JA LAONDUS ... 39\n","\n","[42 rows x 6 columns]"]},"metadata":{},"execution_count":5}]},{"cell_type":"markdown","metadata":{"id":"ENOrbgpq4XDw"},"source":["# Muudame tegevusala teksti lühemaks\n","Meie tabelis on mõnel juhul tegevusala tekst liiga pikk.\n","Pandas võimaldab tekste erineval viisil töödelda.\n","\n","Alljärgnevas näites käime läbi kõik tegevusalade kirjeldused ja:\n","* Kui tegevusala kirjeldus on pikem kui 30 tähemärki,\n","* Siis võtame esimesed 30 tähemärki ja lisame nendele kolm punkti.\n","* Kui tegevusala kirjeldus ei ole pikem kui 30 tähemärki, siis ei tehta midagi. "]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"CK8jt49342Q_","executionInfo":{"status":"ok","timestamp":1639406098349,"user_tz":-120,"elapsed":303,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"c56a29eb-0729-4631-ece3-ee8eb29d4293"},"source":["# Lühendame tegevusalade kirjeldused, mis on pikemad kui 30 tähemärki\n","for i, emtak in enumerate(integer_data['emtak']):\n"," if len(emtak) > 30:\n"," integer_data.at[i,'emtak'] = emtak[:30] + \"...\"\n","\n","integer_data\n"],"execution_count":6,"outputs":[{"output_type":"execute_result","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","
emtakquarternational_taxemployee_taxrevenueemployees
0AVALIK HALDUS JA RIIGIKAITSE;...2020_III3153134928
1AVALIK HALDUS JA RIIGIKAITSE; ...2021_III2792875929
2EHITUS2020_III16184142253
3EHITUS2021_III18098173152
4EKSTERRITORIAALSETE ORGANISATS...2020_III0000
5EKSTERRITORIAALSETE ORGANISATS...2021_III0000
6ELEKTRIENERGIA, GAASI, AURU JA...2020_III45164925
7ELEKTRIENERGIA, GAASI, AURU JA...2021_III44157135
8FINANTS- JA KINDLUSTUSTEGEVUS2020_III725140213
9FINANTS- JA KINDLUSTUSTEGEVUS2021_III815854213
10HALDUS- JA ABITEGEVUSED2020_III845351540
11HALDUS- JA ABITEGEVUSED2021_III1016352741
12HARIDUS2020_III71723268
13HARIDUS2021_III79793969
14HULGI- JA JAEKAUBANDUS; MOOTOR...2020_III754163775497
15HULGI- JA JAEKAUBANDUS; MOOTOR...2021_III847193959496
16INFO JA SIDE2020_III13898105030
17INFO JA SIDE2021_III181122128931
18KINNISVARAALANE TEGEVUS2020_III922056624
19KINNISVARAALANE TEGEVUS2021_III832272018
20KODUMAJAPIDAMISTE KUI TÖÖANDJA...2020_III0000
21KODUMAJAPIDAMISTE KUI TÖÖANDJA...2021_III0000
22KUNST, MEELELAHUTUS JA VABA AE...2020_III34206521
23KUNST, MEELELAHUTUS JA VABA AE...2021_III40249820
24KUTSE-, TEADUS- JA TEHNIKAALAN...2020_III1006059536
25KUTSE-, TEADUS- JA TEHNIKAALAN...2021_III12373124032
26MAJUTUS JA TOITLUSTUS2020_III372123425
27MAJUTUS JA TOITLUSTUS2021_III422528125
28MUUD TEENINDAVAD TEGEVUSED2020_III19157017
29MUUD TEENINDAVAD TEGEVUSED2021_III22168715
30MÄETÖÖSTUS2020_III118653
31MÄETÖÖSTUS2021_III107782
32PÕLLUMAJANDUS, METSAMAJANDUS J...2020_III502441116
33PÕLLUMAJANDUS, METSAMAJANDUS J...2021_III642753916
34TERVISHOID JA SOTSIAALHOOLEKAN...2020_III961002051
35TERVISHOID JA SOTSIAALHOOLEKAN...2021_III1101141952
36TÖÖTLEV TÖÖSTUS2020_III3242124159109
37TÖÖTLEV TÖÖSTUS2021_III3612455010108
38VEEVARUSTUS; KANALISATSIOON, J...2021_III17102384
39VEEVARUSTUS; KANALISATSIOON; J...2020_III1881624
40VEONDUS JA LAONDUS2020_III23871131541
41VEONDUS JA LAONDUS2021_III29579157339
\n","
"],"text/plain":[" emtak quarter ... revenue employees\n","0 AVALIK HALDUS JA RIIGIKAITSE;... 2020_III ... 49 28\n","1 AVALIK HALDUS JA RIIGIKAITSE; ... 2021_III ... 59 29\n","2 EHITUS 2020_III ... 1422 53\n","3 EHITUS 2021_III ... 1731 52\n","4 EKSTERRITORIAALSETE ORGANISATS... 2020_III ... 0 0\n","5 EKSTERRITORIAALSETE ORGANISATS... 2021_III ... 0 0\n","6 ELEKTRIENERGIA, GAASI, AURU JA... 2020_III ... 492 5\n","7 ELEKTRIENERGIA, GAASI, AURU JA... 2021_III ... 713 5\n","8 FINANTS- JA KINDLUSTUSTEGEVUS 2020_III ... 402 13\n","9 FINANTS- JA KINDLUSTUSTEGEVUS 2021_III ... 542 13\n","10 HALDUS- JA ABITEGEVUSED 2020_III ... 515 40\n","11 HALDUS- JA ABITEGEVUSED 2021_III ... 527 41\n","12 HARIDUS 2020_III ... 32 68\n","13 HARIDUS 2021_III ... 39 69\n","14 HULGI- JA JAEKAUBANDUS; MOOTOR... 2020_III ... 7754 97\n","15 HULGI- JA JAEKAUBANDUS; MOOTOR... 2021_III ... 9594 96\n","16 INFO JA SIDE 2020_III ... 1050 30\n","17 INFO JA SIDE 2021_III ... 1289 31\n","18 KINNISVARAALANE TEGEVUS 2020_III ... 566 24\n","19 KINNISVARAALANE TEGEVUS 2021_III ... 720 18\n","20 KODUMAJAPIDAMISTE KUI TÖÖANDJA... 2020_III ... 0 0\n","21 KODUMAJAPIDAMISTE KUI TÖÖANDJA... 2021_III ... 0 0\n","22 KUNST, MEELELAHUTUS JA VABA AE... 2020_III ... 65 21\n","23 KUNST, MEELELAHUTUS JA VABA AE... 2021_III ... 98 20\n","24 KUTSE-, TEADUS- JA TEHNIKAALAN... 2020_III ... 595 36\n","25 KUTSE-, TEADUS- JA TEHNIKAALAN... 2021_III ... 1240 32\n","26 MAJUTUS JA TOITLUSTUS 2020_III ... 234 25\n","27 MAJUTUS JA TOITLUSTUS 2021_III ... 281 25\n","28 MUUD TEENINDAVAD TEGEVUSED 2020_III ... 70 17\n","29 MUUD TEENINDAVAD TEGEVUSED 2021_III ... 87 15\n","30 MÄETÖÖSTUS 2020_III ... 65 3\n","31 MÄETÖÖSTUS 2021_III ... 78 2\n","32 PÕLLUMAJANDUS, METSAMAJANDUS J... 2020_III ... 411 16\n","33 PÕLLUMAJANDUS, METSAMAJANDUS J... 2021_III ... 539 16\n","34 TERVISHOID JA SOTSIAALHOOLEKAN... 2020_III ... 20 51\n","35 TERVISHOID JA SOTSIAALHOOLEKAN... 2021_III ... 19 52\n","36 TÖÖTLEV TÖÖSTUS 2020_III ... 4159 109\n","37 TÖÖTLEV TÖÖSTUS 2021_III ... 5010 108\n","38 VEEVARUSTUS; KANALISATSIOON, J... 2021_III ... 238 4\n","39 VEEVARUSTUS; KANALISATSIOON; J... 2020_III ... 162 4\n","40 VEONDUS JA LAONDUS 2020_III ... 1315 41\n","41 VEONDUS JA LAONDUS 2021_III ... 1573 39\n","\n","[42 rows x 6 columns]"]},"metadata":{},"execution_count":6}]},{"cell_type":"markdown","metadata":{"id":"BcT2RW_zu8RI"},"source":["# Fokusseerimine\n","Sageli üritavad andmeteadlased esitada ühes tabelis või graafikul liiga palju infot. Tulemuseks on, et infotarbija ei saa lõpuks mitte midagi aru.\n","\n","Andmeteadur peab **mõtlema, mida ta tahab öelda ja esitama info just sellisel kujul**.\n","\n","Näiteks võtame järgnevalt eesmärgiks **esitada lugejale Eesti ettevõtete müügitulu muutuse tegevusalade lõikes.**"]},{"cell_type":"markdown","metadata":{"id":"UQ5_40TpvhOi"},"source":["## Valime muutuja\n","\n","Kuna eesmärgiks on näidata müügitulu muutust tegevusalade lõikes, siis jätame analüüsi alles vaid selle ülesande täitmiseks vajalikud muutujad."]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"z55IwGMkwSjs","executionInfo":{"status":"ok","timestamp":1639406176245,"user_tz":-120,"elapsed":393,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"a234b487-1acb-431c-9e5d-0ce7f1d7b9d6"},"source":["columns_to_select = ['emtak', 'quarter', 'revenue']\n","revenue_data = integer_data[columns_to_select]\n","revenue_data"],"execution_count":7,"outputs":[{"output_type":"execute_result","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","
emtakquarterrevenue
0AVALIK HALDUS JA RIIGIKAITSE;...2020_III49
1AVALIK HALDUS JA RIIGIKAITSE; ...2021_III59
2EHITUS2020_III1422
3EHITUS2021_III1731
4EKSTERRITORIAALSETE ORGANISATS...2020_III0
5EKSTERRITORIAALSETE ORGANISATS...2021_III0
6ELEKTRIENERGIA, GAASI, AURU JA...2020_III492
7ELEKTRIENERGIA, GAASI, AURU JA...2021_III713
8FINANTS- JA KINDLUSTUSTEGEVUS2020_III402
9FINANTS- JA KINDLUSTUSTEGEVUS2021_III542
10HALDUS- JA ABITEGEVUSED2020_III515
11HALDUS- JA ABITEGEVUSED2021_III527
12HARIDUS2020_III32
13HARIDUS2021_III39
14HULGI- JA JAEKAUBANDUS; MOOTOR...2020_III7754
15HULGI- JA JAEKAUBANDUS; MOOTOR...2021_III9594
16INFO JA SIDE2020_III1050
17INFO JA SIDE2021_III1289
18KINNISVARAALANE TEGEVUS2020_III566
19KINNISVARAALANE TEGEVUS2021_III720
20KODUMAJAPIDAMISTE KUI TÖÖANDJA...2020_III0
21KODUMAJAPIDAMISTE KUI TÖÖANDJA...2021_III0
22KUNST, MEELELAHUTUS JA VABA AE...2020_III65
23KUNST, MEELELAHUTUS JA VABA AE...2021_III98
24KUTSE-, TEADUS- JA TEHNIKAALAN...2020_III595
25KUTSE-, TEADUS- JA TEHNIKAALAN...2021_III1240
26MAJUTUS JA TOITLUSTUS2020_III234
27MAJUTUS JA TOITLUSTUS2021_III281
28MUUD TEENINDAVAD TEGEVUSED2020_III70
29MUUD TEENINDAVAD TEGEVUSED2021_III87
30MÄETÖÖSTUS2020_III65
31MÄETÖÖSTUS2021_III78
32PÕLLUMAJANDUS, METSAMAJANDUS J...2020_III411
33PÕLLUMAJANDUS, METSAMAJANDUS J...2021_III539
34TERVISHOID JA SOTSIAALHOOLEKAN...2020_III20
35TERVISHOID JA SOTSIAALHOOLEKAN...2021_III19
36TÖÖTLEV TÖÖSTUS2020_III4159
37TÖÖTLEV TÖÖSTUS2021_III5010
38VEEVARUSTUS; KANALISATSIOON, J...2021_III238
39VEEVARUSTUS; KANALISATSIOON; J...2020_III162
40VEONDUS JA LAONDUS2020_III1315
41VEONDUS JA LAONDUS2021_III1573
\n","
"],"text/plain":[" emtak quarter revenue\n","0 AVALIK HALDUS JA RIIGIKAITSE;... 2020_III 49\n","1 AVALIK HALDUS JA RIIGIKAITSE; ... 2021_III 59\n","2 EHITUS 2020_III 1422\n","3 EHITUS 2021_III 1731\n","4 EKSTERRITORIAALSETE ORGANISATS... 2020_III 0\n","5 EKSTERRITORIAALSETE ORGANISATS... 2021_III 0\n","6 ELEKTRIENERGIA, GAASI, AURU JA... 2020_III 492\n","7 ELEKTRIENERGIA, GAASI, AURU JA... 2021_III 713\n","8 FINANTS- JA KINDLUSTUSTEGEVUS 2020_III 402\n","9 FINANTS- JA KINDLUSTUSTEGEVUS 2021_III 542\n","10 HALDUS- JA ABITEGEVUSED 2020_III 515\n","11 HALDUS- JA ABITEGEVUSED 2021_III 527\n","12 HARIDUS 2020_III 32\n","13 HARIDUS 2021_III 39\n","14 HULGI- JA JAEKAUBANDUS; MOOTOR... 2020_III 7754\n","15 HULGI- JA JAEKAUBANDUS; MOOTOR... 2021_III 9594\n","16 INFO JA SIDE 2020_III 1050\n","17 INFO JA SIDE 2021_III 1289\n","18 KINNISVARAALANE TEGEVUS 2020_III 566\n","19 KINNISVARAALANE TEGEVUS 2021_III 720\n","20 KODUMAJAPIDAMISTE KUI TÖÖANDJA... 2020_III 0\n","21 KODUMAJAPIDAMISTE KUI TÖÖANDJA... 2021_III 0\n","22 KUNST, MEELELAHUTUS JA VABA AE... 2020_III 65\n","23 KUNST, MEELELAHUTUS JA VABA AE... 2021_III 98\n","24 KUTSE-, TEADUS- JA TEHNIKAALAN... 2020_III 595\n","25 KUTSE-, TEADUS- JA TEHNIKAALAN... 2021_III 1240\n","26 MAJUTUS JA TOITLUSTUS 2020_III 234\n","27 MAJUTUS JA TOITLUSTUS 2021_III 281\n","28 MUUD TEENINDAVAD TEGEVUSED 2020_III 70\n","29 MUUD TEENINDAVAD TEGEVUSED 2021_III 87\n","30 MÄETÖÖSTUS 2020_III 65\n","31 MÄETÖÖSTUS 2021_III 78\n","32 PÕLLUMAJANDUS, METSAMAJANDUS J... 2020_III 411\n","33 PÕLLUMAJANDUS, METSAMAJANDUS J... 2021_III 539\n","34 TERVISHOID JA SOTSIAALHOOLEKAN... 2020_III 20\n","35 TERVISHOID JA SOTSIAALHOOLEKAN... 2021_III 19\n","36 TÖÖTLEV TÖÖSTUS 2020_III 4159\n","37 TÖÖTLEV TÖÖSTUS 2021_III 5010\n","38 VEEVARUSTUS; KANALISATSIOON, J... 2021_III 238\n","39 VEEVARUSTUS; KANALISATSIOON; J... 2020_III 162\n","40 VEONDUS JA LAONDUS 2020_III 1315\n","41 VEONDUS JA LAONDUS 2021_III 1573"]},"metadata":{},"execution_count":7}]},{"cell_type":"markdown","metadata":{"id":"2ztBq8Hswx7S"},"source":["# Muudame tabeli kuju\n","Meie praegune tabel on \"pikas\" formaadis, mis analüüsi teostamiseks on küll mugav, kuid lugeja eelistab ilmselt \"laia\" formaati, kus üks rida näitab ühte tegevusvaldkonda ja iga veerg näitab ühte kvartalit."]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":802},"id":"fWVOg63VxENC","executionInfo":{"status":"ok","timestamp":1639406240562,"user_tz":-120,"elapsed":280,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"87ff1000-6874-4b6f-c153-030fe7bbd5b3"},"source":["wide_revenue_data = revenue_data.pivot_table(index='emtak', columns='quarter', values='revenue')\n","wide_revenue_data"],"execution_count":8,"outputs":[{"output_type":"execute_result","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","
quarter2020_III2021_III
emtak
AVALIK HALDUS JA RIIGIKAITSE;...49<NA>
AVALIK HALDUS JA RIIGIKAITSE; ...<NA>59
EHITUS14221731
EKSTERRITORIAALSETE ORGANISATS...00
ELEKTRIENERGIA, GAASI, AURU JA...492713
FINANTS- JA KINDLUSTUSTEGEVUS402542
HALDUS- JA ABITEGEVUSED515527
HARIDUS3239
HULGI- JA JAEKAUBANDUS; MOOTOR...77549594
INFO JA SIDE10501289
KINNISVARAALANE TEGEVUS566720
KODUMAJAPIDAMISTE KUI TÖÖANDJA...00
KUNST, MEELELAHUTUS JA VABA AE...6598
KUTSE-, TEADUS- JA TEHNIKAALAN...5951240
MAJUTUS JA TOITLUSTUS234281
MUUD TEENINDAVAD TEGEVUSED7087
MÄETÖÖSTUS6578
PÕLLUMAJANDUS, METSAMAJANDUS J...411539
TERVISHOID JA SOTSIAALHOOLEKAN...2019
TÖÖTLEV TÖÖSTUS41595010
VEEVARUSTUS; KANALISATSIOON, J...<NA>238
VEEVARUSTUS; KANALISATSIOON; J...162<NA>
VEONDUS JA LAONDUS13151573
\n","
"],"text/plain":["quarter 2020_III 2021_III\n","emtak \n"," AVALIK HALDUS JA RIIGIKAITSE;... 49 \n","AVALIK HALDUS JA RIIGIKAITSE; ... 59\n","EHITUS 1422 1731\n","EKSTERRITORIAALSETE ORGANISATS... 0 0\n","ELEKTRIENERGIA, GAASI, AURU JA... 492 713\n","FINANTS- JA KINDLUSTUSTEGEVUS 402 542\n","HALDUS- JA ABITEGEVUSED 515 527\n","HARIDUS 32 39\n","HULGI- JA JAEKAUBANDUS; MOOTOR... 7754 9594\n","INFO JA SIDE 1050 1289\n","KINNISVARAALANE TEGEVUS 566 720\n","KODUMAJAPIDAMISTE KUI TÖÖANDJA... 0 0\n","KUNST, MEELELAHUTUS JA VABA AE... 65 98\n","KUTSE-, TEADUS- JA TEHNIKAALAN... 595 1240\n","MAJUTUS JA TOITLUSTUS 234 281\n","MUUD TEENINDAVAD TEGEVUSED 70 87\n","MÄETÖÖSTUS 65 78\n","PÕLLUMAJANDUS, METSAMAJANDUS J... 411 539\n","TERVISHOID JA SOTSIAALHOOLEKAN... 20 19\n","TÖÖTLEV TÖÖSTUS 4159 5010\n","VEEVARUSTUS; KANALISATSIOON, J... 238\n","VEEVARUSTUS; KANALISATSIOON; J... 162 \n","VEONDUS JA LAONDUS 1315 1573"]},"metadata":{},"execution_count":8}]},{"cell_type":"markdown","metadata":{"id":"89Cqx2Ko0qfg"},"source":["## Andmete parandamine\n","Meie ülaltoodud tabelis on probleem: Algandmetes on mõned tegevusalad natukene erinevalt nimetatud ning seetõttu saame me mõne tegevusala kohta kaks rida, mitte ühe (vt. näiteks \"VEEVARUSTUS; KANALISATSIOON,...\").\n","\n","Parandame andmestikku `revenue_data` selliselt, et paarisarvuga ridade tegevusala nimi tuleb temale eelnevalt paaritu arvuga realt."]},{"cell_type":"code","metadata":{"id":"XRgiokIxjfyY"},"source":["for i in range(0,10, 2):\n"," print(i)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":739},"id":"bT97Np_ZzDvI","executionInfo":{"status":"ok","timestamp":1639406379897,"user_tz":-120,"elapsed":336,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"8420ccdd-7371-4504-cf36-3e44ee3ad3e0"},"source":["# Paarisarvuga tegevusalade nimi tuleb temale eelnevalt realt\n","for i in range(0, len(revenue_data), 2):\n"," revenue_data.at[i+1, 'emtak'] = revenue_data.at[i, 'emtak']\n","\n","# Teeme uuesti oma 'laia' andmetabeli\n","wide_revenue_data = revenue_data.pivot_table(index='emtak', columns='quarter', values='revenue')\n","wide_revenue_data"],"execution_count":9,"outputs":[{"output_type":"execute_result","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","
quarter2020_III2021_III
emtak
AVALIK HALDUS JA RIIGIKAITSE;...4959
EHITUS14221731
EKSTERRITORIAALSETE ORGANISATS...00
ELEKTRIENERGIA, GAASI, AURU JA...492713
FINANTS- JA KINDLUSTUSTEGEVUS402542
HALDUS- JA ABITEGEVUSED515527
HARIDUS3239
HULGI- JA JAEKAUBANDUS; MOOTOR...77549594
INFO JA SIDE10501289
KINNISVARAALANE TEGEVUS566720
KODUMAJAPIDAMISTE KUI TÖÖANDJA...00
KUNST, MEELELAHUTUS JA VABA AE...6598
KUTSE-, TEADUS- JA TEHNIKAALAN...5951240
MAJUTUS JA TOITLUSTUS234281
MUUD TEENINDAVAD TEGEVUSED7087
MÄETÖÖSTUS6578
PÕLLUMAJANDUS, METSAMAJANDUS J...411539
TERVISHOID JA SOTSIAALHOOLEKAN...2019
TÖÖTLEV TÖÖSTUS41595010
VEEVARUSTUS; KANALISATSIOON, J...162238
VEONDUS JA LAONDUS13151573
\n","
"],"text/plain":["quarter 2020_III 2021_III\n","emtak \n"," AVALIK HALDUS JA RIIGIKAITSE;... 49 59\n","EHITUS 1422 1731\n","EKSTERRITORIAALSETE ORGANISATS... 0 0\n","ELEKTRIENERGIA, GAASI, AURU JA... 492 713\n","FINANTS- JA KINDLUSTUSTEGEVUS 402 542\n","HALDUS- JA ABITEGEVUSED 515 527\n","HARIDUS 32 39\n","HULGI- JA JAEKAUBANDUS; MOOTOR... 7754 9594\n","INFO JA SIDE 1050 1289\n","KINNISVARAALANE TEGEVUS 566 720\n","KODUMAJAPIDAMISTE KUI TÖÖANDJA... 0 0\n","KUNST, MEELELAHUTUS JA VABA AE... 65 98\n","KUTSE-, TEADUS- JA TEHNIKAALAN... 595 1240\n","MAJUTUS JA TOITLUSTUS 234 281\n","MUUD TEENINDAVAD TEGEVUSED 70 87\n","MÄETÖÖSTUS 65 78\n","PÕLLUMAJANDUS, METSAMAJANDUS J... 411 539\n","TERVISHOID JA SOTSIAALHOOLEKAN... 20 19\n","TÖÖTLEV TÖÖSTUS 4159 5010\n","VEEVARUSTUS; KANALISATSIOON, J... 162 238\n","VEONDUS JA LAONDUS 1315 1573"]},"metadata":{},"execution_count":9}]},{"cell_type":"markdown","metadata":{"id":"9UrwG8JY-TTN"},"source":["# Lisame muutuja, mis näitab protsentuaalset muutust"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":739},"id":"yAKPEpXo-cbH","executionInfo":{"status":"ok","timestamp":1639406427510,"user_tz":-120,"elapsed":280,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"c6b0454c-296b-4f7b-982c-0ac1cdf78e4e"},"source":["# Arvutame muutuse\n","muutus = wide_revenue_data['2021_III'] / wide_revenue_data['2020_III'] - 1\n","\n","# Korrutame muutuse 100-ga, et saada protsentuaalset väärtust\n","wide_revenue_data['Muutus (%)'] = muutus*100\n","\n","wide_revenue_data"],"execution_count":10,"outputs":[{"output_type":"execute_result","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","
quarter2020_III2021_IIIMuutus (%)
emtak
AVALIK HALDUS JA RIIGIKAITSE;...495920.408163
EHITUS1422173121.729958
EKSTERRITORIAALSETE ORGANISATS...00NaN
ELEKTRIENERGIA, GAASI, AURU JA...49271344.918699
FINANTS- JA KINDLUSTUSTEGEVUS40254234.825871
HALDUS- JA ABITEGEVUSED5155272.330097
HARIDUS323921.875000
HULGI- JA JAEKAUBANDUS; MOOTOR...7754959423.729688
INFO JA SIDE1050128922.761905
KINNISVARAALANE TEGEVUS56672027.208481
KODUMAJAPIDAMISTE KUI TÖÖANDJA...00NaN
KUNST, MEELELAHUTUS JA VABA AE...659850.769231
KUTSE-, TEADUS- JA TEHNIKAALAN...5951240108.403361
MAJUTUS JA TOITLUSTUS23428120.085470
MUUD TEENINDAVAD TEGEVUSED708724.285714
MÄETÖÖSTUS657820.000000
PÕLLUMAJANDUS, METSAMAJANDUS J...41153931.143552
TERVISHOID JA SOTSIAALHOOLEKAN...2019-5.000000
TÖÖTLEV TÖÖSTUS4159501020.461649
VEEVARUSTUS; KANALISATSIOON, J...16223846.913580
VEONDUS JA LAONDUS1315157319.619772
\n","
"],"text/plain":["quarter 2020_III 2021_III Muutus (%)\n","emtak \n"," AVALIK HALDUS JA RIIGIKAITSE;... 49 59 20.408163\n","EHITUS 1422 1731 21.729958\n","EKSTERRITORIAALSETE ORGANISATS... 0 0 NaN\n","ELEKTRIENERGIA, GAASI, AURU JA... 492 713 44.918699\n","FINANTS- JA KINDLUSTUSTEGEVUS 402 542 34.825871\n","HALDUS- JA ABITEGEVUSED 515 527 2.330097\n","HARIDUS 32 39 21.875000\n","HULGI- JA JAEKAUBANDUS; MOOTOR... 7754 9594 23.729688\n","INFO JA SIDE 1050 1289 22.761905\n","KINNISVARAALANE TEGEVUS 566 720 27.208481\n","KODUMAJAPIDAMISTE KUI TÖÖANDJA... 0 0 NaN\n","KUNST, MEELELAHUTUS JA VABA AE... 65 98 50.769231\n","KUTSE-, TEADUS- JA TEHNIKAALAN... 595 1240 108.403361\n","MAJUTUS JA TOITLUSTUS 234 281 20.085470\n","MUUD TEENINDAVAD TEGEVUSED 70 87 24.285714\n","MÄETÖÖSTUS 65 78 20.000000\n","PÕLLUMAJANDUS, METSAMAJANDUS J... 411 539 31.143552\n","TERVISHOID JA SOTSIAALHOOLEKAN... 20 19 -5.000000\n","TÖÖTLEV TÖÖSTUS 4159 5010 20.461649\n","VEEVARUSTUS; KANALISATSIOON, J... 162 238 46.913580\n","VEONDUS JA LAONDUS 1315 1573 19.619772"]},"metadata":{},"execution_count":10}]},{"cell_type":"markdown","metadata":{"id":"Zls5FCEjDVej"},"source":["# Sorteerime väärtused muutuse suuruse järjekorras"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":739},"id":"Q_VcNUsCDY4-","executionInfo":{"status":"ok","timestamp":1639406472654,"user_tz":-120,"elapsed":273,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"ecf61012-79bc-4b05-c78b-596cd23e07b2"},"source":["sorted_revenue_data = wide_revenue_data.sort_values(by=\"Muutus (%)\", ascending=False)\n","sorted_revenue_data "],"execution_count":11,"outputs":[{"output_type":"execute_result","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","
quarter2020_III2021_IIIMuutus (%)
emtak
KUTSE-, TEADUS- JA TEHNIKAALAN...5951240108.403361
KUNST, MEELELAHUTUS JA VABA AE...659850.769231
VEEVARUSTUS; KANALISATSIOON, J...16223846.913580
ELEKTRIENERGIA, GAASI, AURU JA...49271344.918699
FINANTS- JA KINDLUSTUSTEGEVUS40254234.825871
PÕLLUMAJANDUS, METSAMAJANDUS J...41153931.143552
KINNISVARAALANE TEGEVUS56672027.208481
MUUD TEENINDAVAD TEGEVUSED708724.285714
HULGI- JA JAEKAUBANDUS; MOOTOR...7754959423.729688
INFO JA SIDE1050128922.761905
HARIDUS323921.875000
EHITUS1422173121.729958
TÖÖTLEV TÖÖSTUS4159501020.461649
AVALIK HALDUS JA RIIGIKAITSE;...495920.408163
MAJUTUS JA TOITLUSTUS23428120.085470
MÄETÖÖSTUS657820.000000
VEONDUS JA LAONDUS1315157319.619772
HALDUS- JA ABITEGEVUSED5155272.330097
TERVISHOID JA SOTSIAALHOOLEKAN...2019-5.000000
EKSTERRITORIAALSETE ORGANISATS...00NaN
KODUMAJAPIDAMISTE KUI TÖÖANDJA...00NaN
\n","
"],"text/plain":["quarter 2020_III 2021_III Muutus (%)\n","emtak \n","KUTSE-, TEADUS- JA TEHNIKAALAN... 595 1240 108.403361\n","KUNST, MEELELAHUTUS JA VABA AE... 65 98 50.769231\n","VEEVARUSTUS; KANALISATSIOON, J... 162 238 46.913580\n","ELEKTRIENERGIA, GAASI, AURU JA... 492 713 44.918699\n","FINANTS- JA KINDLUSTUSTEGEVUS 402 542 34.825871\n","PÕLLUMAJANDUS, METSAMAJANDUS J... 411 539 31.143552\n","KINNISVARAALANE TEGEVUS 566 720 27.208481\n","MUUD TEENINDAVAD TEGEVUSED 70 87 24.285714\n","HULGI- JA JAEKAUBANDUS; MOOTOR... 7754 9594 23.729688\n","INFO JA SIDE 1050 1289 22.761905\n","HARIDUS 32 39 21.875000\n","EHITUS 1422 1731 21.729958\n","TÖÖTLEV TÖÖSTUS 4159 5010 20.461649\n"," AVALIK HALDUS JA RIIGIKAITSE;... 49 59 20.408163\n","MAJUTUS JA TOITLUSTUS 234 281 20.085470\n","MÄETÖÖSTUS 65 78 20.000000\n","VEONDUS JA LAONDUS 1315 1573 19.619772\n","HALDUS- JA ABITEGEVUSED 515 527 2.330097\n","TERVISHOID JA SOTSIAALHOOLEKAN... 20 19 -5.000000\n","EKSTERRITORIAALSETE ORGANISATS... 0 0 NaN\n","KODUMAJAPIDAMISTE KUI TÖÖANDJA... 0 0 NaN"]},"metadata":{},"execution_count":11}]},{"cell_type":"markdown","metadata":{"id":"0XFv9BPj97nr"},"source":["# Tabeli illustreerimine\n","Uuri lähemalt: https://pandas.pydata.org/docs/user_guide/style.html "]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"WKsdLtUE9_ap","executionInfo":{"status":"ok","timestamp":1639406566066,"user_tz":-120,"elapsed":300,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"92d5218d-a1e8-4322-ffc6-f98ba15dead7"},"source":["# Kaotame ära ridade ja veergude nimed, et need ei segaks meie pilti\n","sorted_revenue_data.rename_axis(None, axis=0, inplace=True)\n","sorted_revenue_data.rename_axis(None, axis=1, inplace=True)\n","\n","# Funktsioon, millega muudame tabeli väljanägemist\n","def illustrate_dataframe(dataframe):\n"," \"\"\"\n"," See funktsioon võtab sisendiks Panda Dataframe'i ja väljastab\n"," tulemused illustreeritud kujul.\n"," \"\"\"\n"," # Kasutame 'style' meetodit, et pääseda ligi tabeli kujundusele\n"," # Ja lisame muutuse veerule protsendi märgi\n"," illustrated = dataframe.style.format(na_rep=\"\",\n"," formatter={'Muutus (%)': '{:.1f} %'})\n","\n"," # Määrame interaktiivse disaini ehk mis juhtub, kui läheme mõne lahtri peale.\n"," illustrated = illustrated.set_table_styles([\n"," # Mis juhtub, kui läheme hiirega üle lahtri\n"," {'selector': 'td:hover', 'props': [('background-color', '#ffa82c'),\n"," ('color', '#ffffff')]},\n"," {'selector': 'tr:hover', 'props': [('background-color', '#ffecc8')]},\n"," \n"," # Joondame ridade pealkirjad paremale\n"," {'selector': 'th.row_heading', 'props': [('text-align', 'right')]},\n"," \n"," # Joondame veergude pealkirjad keskele\n"," # muudame lahtri alumise joone mustaks\n"," {'selector': 'th.col_heading', 'props': [('text-align', 'center'), \n"," ('padding', '0.8em'),\n"," ('border-bottom', '2px solid black'),\n"," ]},\n"," # Lisame lahtritele natukene tühja ruumi, et oleks\n"," # Paremini loetav\n"," {'selector': 'td', 'props': [('padding', '1em 2em')]},\n"," ])\n"," return illustrated\n","\n","# Kasutame funktsiooni\n","illustrate_dataframe(sorted_revenue_data)"],"execution_count":12,"outputs":[{"output_type":"execute_result","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","
2020_III 2021_III Muutus (%)
KUTSE-, TEADUS- JA TEHNIKAALAN...5951240108.4 %
KUNST, MEELELAHUTUS JA VABA AE...659850.8 %
VEEVARUSTUS; KANALISATSIOON, J...16223846.9 %
ELEKTRIENERGIA, GAASI, AURU JA...49271344.9 %
FINANTS- JA KINDLUSTUSTEGEVUS40254234.8 %
PÕLLUMAJANDUS, METSAMAJANDUS J...41153931.1 %
KINNISVARAALANE TEGEVUS56672027.2 %
MUUD TEENINDAVAD TEGEVUSED708724.3 %
HULGI- JA JAEKAUBANDUS; MOOTOR...7754959423.7 %
INFO JA SIDE1050128922.8 %
HARIDUS323921.9 %
EHITUS1422173121.7 %
TÖÖTLEV TÖÖSTUS4159501020.5 %
AVALIK HALDUS JA RIIGIKAITSE;...495920.4 %
MAJUTUS JA TOITLUSTUS23428120.1 %
MÄETÖÖSTUS657820.0 %
VEONDUS JA LAONDUS1315157319.6 %
HALDUS- JA ABITEGEVUSED5155272.3 %
TERVISHOID JA SOTSIAALHOOLEKAN...2019-5.0 %
EKSTERRITORIAALSETE ORGANISATS...00
KODUMAJAPIDAMISTE KUI TÖÖANDJA...00
"],"text/plain":[""]},"metadata":{},"execution_count":12}]},{"cell_type":"markdown","metadata":{"id":"Ug_Og_sL38JR"},"source":["# Sisendvorm ilma koodita\n","Colab võimaldab luua ka kasutajaliidese sisendvormiga, kuid ilma koodita. Teisisõnu, on võimalik luua juskui väike veebirakendus, mida jagada info tarbijaga.\n","\n","Vormi lisamiseks:\n","* Kliki koodilahtri paremas ääres kolmel täpil -> Add form\n","\n","Vormi väljade lisamisek:\n","* Kliki koodilahtri ääres kolmel täpil -> form -> Add a form field.\n","\n","Koodi peitmiseks:\n","* Hiire paremklikk -> form -> Hide code"]},{"cell_type":"code","metadata":{"id":"bYAch3lD9v_V","colab":{"base_uri":"https://localhost:8080/","height":194},"executionInfo":{"status":"ok","timestamp":1639406669531,"user_tz":-120,"elapsed":285,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"2857433d-d5fe-4bd7-e6c7-946e3d7d18a6"},"source":["#@title Eesti ettevõtete müügitulu tegevusala järgi\n","#@markdown *Kirjuta selle tegevusala algustäht, mille kohta soovid tulemusi näha.*\n","Tegevusala = \"M\" #@param {type:\"string\"}\n","\n","# Loome filtri\n","tegevusala_filter = sorted_revenue_data.index.str.startswith(Tegevusala)\n","\n","# Filtreerime andmed\n","filtered_data = sorted_revenue_data.loc[tegevusala_filter]\n","\n","# Väljastame tulemuse\n","# Kasutame eelnevalt loodud \"illustrate_dataframe\" funktsioooni\n","illustrate_dataframe(filtered_data)"],"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/html":["\n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n","
2020_III 2021_III Muutus (%)
MUUD TEENINDAVAD TEGEVUSED708724.3 %
MAJUTUS JA TOITLUSTUS23428120.1 %
MÄETÖÖSTUS657820.0 %
"],"text/plain":[""]},"metadata":{},"execution_count":14}]},{"cell_type":"markdown","metadata":{"id":"XsiutCOaFnD4"},"source":["# Graafikud\n","Graafikute tegemist on Python'l palju erinevaid tööriistu. Alljärgnevas näites kasutame me teeki nimega \"Plotly\", mis võimaldab interaktiivsete graafikute loomist.\n","\n","Loe Plotly kohta lähemalt https://plotly.com/python/plotly-express/"]},{"cell_type":"code","metadata":{"id":"Uvp6gHXHFok3","executionInfo":{"status":"ok","timestamp":1639406785752,"user_tz":-120,"elapsed":4693,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}}},"source":["# Installeerime Plotly oma keskkonda\n","!pip install -q plotly"],"execution_count":15,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":645},"id":"zoHJWP7tH48g","executionInfo":{"status":"ok","timestamp":1639406819352,"user_tz":-120,"elapsed":315,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"4b96487e-693a-4e27-df19-cb99a46c8dd5"},"source":["# Tegevusala on meil hetkel index - muudame ta tagasi muutujaks\n","plot_data = sorted_revenue_data.reset_index()\n","\n","# Anname talle mõistliku nimetuse\n","plot_data.rename(columns={'index': 'Tegevusala'}, inplace=True)\n","\n","# Jäjestame tabeli alates väikseimast muutuse väärtusest\n","# Meie graafikut on pärast parem lugeda\n","plot_data.sort_values(by='Muutus (%)', inplace=True)\n","\n","# Eemaldame tegevusalad, mille muutust me ei saanud arvutada\n","plot_data.dropna(inplace=True)\n","plot_data"],"execution_count":16,"outputs":[{"output_type":"execute_result","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","
Tegevusala2020_III2021_IIIMuutus (%)
18TERVISHOID JA SOTSIAALHOOLEKAN...2019-5.000000
17HALDUS- JA ABITEGEVUSED5155272.330097
16VEONDUS JA LAONDUS1315157319.619772
15MÄETÖÖSTUS657820.000000
14MAJUTUS JA TOITLUSTUS23428120.085470
13AVALIK HALDUS JA RIIGIKAITSE;...495920.408163
12TÖÖTLEV TÖÖSTUS4159501020.461649
11EHITUS1422173121.729958
10HARIDUS323921.875000
9INFO JA SIDE1050128922.761905
8HULGI- JA JAEKAUBANDUS; MOOTOR...7754959423.729688
7MUUD TEENINDAVAD TEGEVUSED708724.285714
6KINNISVARAALANE TEGEVUS56672027.208481
5PÕLLUMAJANDUS, METSAMAJANDUS J...41153931.143552
4FINANTS- JA KINDLUSTUSTEGEVUS40254234.825871
3ELEKTRIENERGIA, GAASI, AURU JA...49271344.918699
2VEEVARUSTUS; KANALISATSIOON, J...16223846.913580
1KUNST, MEELELAHUTUS JA VABA AE...659850.769231
0KUTSE-, TEADUS- JA TEHNIKAALAN...5951240108.403361
\n","
"],"text/plain":[" Tegevusala 2020_III 2021_III Muutus (%)\n","18 TERVISHOID JA SOTSIAALHOOLEKAN... 20 19 -5.000000\n","17 HALDUS- JA ABITEGEVUSED 515 527 2.330097\n","16 VEONDUS JA LAONDUS 1315 1573 19.619772\n","15 MÄETÖÖSTUS 65 78 20.000000\n","14 MAJUTUS JA TOITLUSTUS 234 281 20.085470\n","13 AVALIK HALDUS JA RIIGIKAITSE;... 49 59 20.408163\n","12 TÖÖTLEV TÖÖSTUS 4159 5010 20.461649\n","11 EHITUS 1422 1731 21.729958\n","10 HARIDUS 32 39 21.875000\n","9 INFO JA SIDE 1050 1289 22.761905\n","8 HULGI- JA JAEKAUBANDUS; MOOTOR... 7754 9594 23.729688\n","7 MUUD TEENINDAVAD TEGEVUSED 70 87 24.285714\n","6 KINNISVARAALANE TEGEVUS 566 720 27.208481\n","5 PÕLLUMAJANDUS, METSAMAJANDUS J... 411 539 31.143552\n","4 FINANTS- JA KINDLUSTUSTEGEVUS 402 542 34.825871\n","3 ELEKTRIENERGIA, GAASI, AURU JA... 492 713 44.918699\n","2 VEEVARUSTUS; KANALISATSIOON, J... 162 238 46.913580\n","1 KUNST, MEELELAHUTUS JA VABA AE... 65 98 50.769231\n","0 KUTSE-, TEADUS- JA TEHNIKAALAN... 595 1240 108.403361"]},"metadata":{},"execution_count":16}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":542},"id":"97gkwrE5F3zu","executionInfo":{"status":"ok","timestamp":1639406887738,"user_tz":-120,"elapsed":3291,"user":{"displayName":"Kristjan Eljand","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Gip4UgEVFXL2Q-oKuIBr2JP5268uFbs3Bf7aNhj=s64","userId":"12801037868987527469"}},"outputId":"51e48bc6-69ab-4015-dfc9-5c8b81294a36"},"source":["# Impordime Plotly express mooduli, mis võimaldab\n","# Kiiret graafikule kandmist\n","import plotly.express as px\n","\n","#Loome graafiku ja prindime välja\n","fig = px.bar(plot_data, \n"," title = \"Eesti ettevõtete müügitulu muutus (III kvartal 2021 vs 2020)\",\n"," y='Tegevusala', \n"," x='Muutus (%)', \n"," orientation='h')\n","fig.show()"],"execution_count":17,"outputs":[{"output_type":"display_data","data":{"text/html":["\n","\n","\n","
\n"," \n"," \n"," \n","
\n"," \n","
\n","\n",""]},"metadata":{}}]},{"cell_type":"markdown","metadata":{"id":"a-X2Q4POoJy6"},"source":["# Colab code snippets"]},{"cell_type":"code","metadata":{"id":"3MWCszg2oaj3"},"source":["# load an example dataset\n","from vega_datasets import data\n","cars = data.cars()\n","\n","# plot the dataset, referencing dataframe column names\n","import altair as alt\n","alt.Chart(plot_data).mark_bar().encode(\n"," x='Muutus (%)',\n"," y='Tegevusala'\n",")"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"WmGu5UHApGy7"},"source":["# load an example dataset\n","from vega_datasets import data\n","cars = data.cars()\n","\n","# plot the dataset, referencing dataframe column names\n","import altair as alt\n","alt.Chart(cars).mark_point().encode(\n"," x='Horsepower',\n"," y='Miles_per_Gallon',\n"," color='Origin'\n",").interactive()"],"execution_count":null,"outputs":[]}]}