demo.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "    Author: Mikael Koli\n",
    "    email: koli.mikael@gmail.com\n",
    "    Date: 19.01.2019\n",
    "    State: Stable"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Demonstration of Finnish Business Portal"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This file demonstrates the use of Finnish Business Portal Python API. In order to replicate the demo, please make sure you have appropriate version of Python 3 and the libraries Pandas and Requests and their dependencies. After this, download this application from the source.\n",
    "\n",
    "## Navigation:\n",
    "* [Setup](#H0)\n",
    "  * [Import the module](#H0_imports)\n",
    "* [Parameters](#H1)\n",
    "* [Example Searches](#H20)\n",
    "* [Example Application](#H3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Setup<a class=\"anchor\" id=\"H0\"></a>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Python version: 3.6.6\n",
      "\n",
      "Time of Run: \n",
      "    Year:    2019\n",
      "    Month:   2\n",
      "    Day:     19\n",
      "\n"
     ]
    }
   ],
   "source": [
    "import datetime\n",
    "import platform\n",
    "import os\n",
    "import sys\n",
    "\n",
    "print(f'Python version: {platform.python_version()}')\n",
    "print(f'''\n",
    "Time of Run: \n",
    "    Year:    {datetime.datetime.now().year}\n",
    "    Month:   {datetime.datetime.now().month}\n",
    "    Day:     {datetime.datetime.now().day}\n",
    "''')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Import the module<a class=\"anchor\" id=\"H0_imports\"></a>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "import finnish_business_portal as busportal"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Parameters<a class=\"anchor\" id=\"H1\"></a>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The API options can be found using \"api_infos\" or \"api_options\" attributes of the class. You can copy-paste the string as an initial argument for the class initiation. This is the only required argument."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'BisCompanyDetails': 'Nouda yritys- ja yhteisötietojärjestelmään merkitty yritys Y-tunnuksen avulla',\n",
       " 'BisCompany': 'Hae yritys- ja yhteisötietojärjestelmään merkittyjä yrityksiä hakutermien avulla',\n",
       " 'TradeRegisterCompanyDetails': 'Nouda kaupparekisteriin merkitty yritys Y-tunnuksen avulla',\n",
       " 'TradeRegisterCompany': 'Hae kaupparekisteriin merkittyjä yrityksiä hakutermien avulla',\n",
       " 'TrCompanyPublicNotice': 'Hae kaupparekisterin kuulutustietoja hakutermien avulla'}"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "busportal.SearchModel.api_infos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['BisCompanyDetails',\n",
       " 'BisCompany',\n",
       " 'TradeRegisterCompanyDetails',\n",
       " 'TradeRegisterCompany',\n",
       " 'TrCompanyPublicNotice']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "busportal.SearchModel.api_options"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "portal = busportal.SearchModel(\"BisCompany\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can get allowed parameters for your selected API using method \".parameter_options\". For more detailed information, use \".parameter_infos\"."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['totalResults',\n",
       " 'maxResults',\n",
       " 'resultsFrom',\n",
       " 'name',\n",
       " 'businessId',\n",
       " 'registeredOffice',\n",
       " 'streetAddressPostCode',\n",
       " 'companyForm',\n",
       " 'businessLine',\n",
       " 'businessLineCode',\n",
       " 'companyRegistrationFrom',\n",
       " 'companyRegistrationTo']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal.parameter_options"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'totalResults': {'name': 'totalResults',\n",
       "  'description': 'Jos arvoksi valitaan true, hakutuloksen kokonaismäärä sisältyy tuloksiin totalResults-arvona. Muussa tapauksessa totalResults-arvo asetetaan arvoksi -1',\n",
       "  'defaultValue': 'false',\n",
       "  'required': False,\n",
       "  'type': 'string',\n",
       "  'paramType': 'query',\n",
       "  'enum': ['true', 'false']},\n",
       " 'maxResults': {'name': 'maxResults',\n",
       "  'description': 'Tulosten enimmäismääränä on annettu luku',\n",
       "  'defaultValue': '10',\n",
       "  'required': False,\n",
       "  'type': 'string',\n",
       "  'paramType': 'query',\n",
       "  'minimum': '0.0',\n",
       "  'maximum': '1000.0'}}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Returning only two parameters for clarity\n",
    "{key: val for i, (key, val) in enumerate(portal.parameter_infos.items()) if i < 2}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There is also a method \".help()\" to give thorough information of the APIs."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There are also other keyword arguments you can use in the class initiation.\n",
    "\n",
    "These are:\n",
    "- wait_time: seconds to wait before each call to slow down querying. Be nice to the APIs. (default: 2)\n",
    "- loop_results: True to loop all found entries (causing multiple additional queries), False to return the first query (default: False) \n",
    "- deep: True to go through all detailed URLs giving more data but more queries (default: False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Example Searches<a class=\"anchor\" id=\"H20\"></a>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:finnish_business_portal.core.model:2 queries to make (time taken > 4)...\n",
      "WARNING:finnish_business_portal.core.model:Not all entries in the API searched (10), set loop_results=True to get all.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<finnish_business_portal.core.model.SearchModel at 0x27d5068f358>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal = busportal.SearchModel(\"BisCompany\")\n",
    "portal.search(name=[\"Fortum\", \"Nokia\"], companyForm=\"oy\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The search returned itself and no any data. The data is in the attribute \"results\" but by default this is just a list of dictionaries. To turn the data to table format, use to_frame() (requires Pandas) and then access the results attribute."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>addresses</th>\n",
       "      <th>auxiliaryNames</th>\n",
       "      <th>businessIdChanges</th>\n",
       "      <th>businessLines</th>\n",
       "      <th>companyForm</th>\n",
       "      <th>companyForms</th>\n",
       "      <th>contactDetails</th>\n",
       "      <th>detailsUri</th>\n",
       "      <th>languages</th>\n",
       "      <th>liquidations</th>\n",
       "      <th>name</th>\n",
       "      <th>names</th>\n",
       "      <th>registedOffices</th>\n",
       "      <th>registeredEntries</th>\n",
       "      <th>registrationDate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2679784-7</th>\n",
       "      <td>[{'careOf': None, 'street': 'PL 100', 'postCod...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'changeDate': '2015-06-30', 'change': 'DIF',...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '68209', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '010 4511', 'type': '...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Fortum Real Estate Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Fortum Re...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'ESPOO', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2015-03-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2947233-5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2947233-5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Saneeraus Asiantuntijat Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-10-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2892396-6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2892396-6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian JV-Saneeraus Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2889182-9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2889182-9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Timanttityö Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2876707-8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2876707-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian KamiPark Kuutti Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821488-7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2821488-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian KamiPark Norppa Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-03-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2756326-8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2756326-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian KamiPark Halli Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2733848-2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2733848-2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Jäähalli Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2726719-4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2726719-4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Neulomo Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2699718-7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2699718-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Kuusikuutio Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2655044-9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2655044-9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokia Technologies Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-11-19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    addresses auxiliaryNames  \\\n",
       "businessId                                                                     \n",
       "2679784-7   [{'careOf': None, 'street': 'PL 100', 'postCod...             []   \n",
       "2947233-5                                                 NaN            NaN   \n",
       "2892396-6                                                 NaN            NaN   \n",
       "2889182-9                                                 NaN            NaN   \n",
       "2876707-8                                                 NaN            NaN   \n",
       "2821488-7                                                 NaN            NaN   \n",
       "2756326-8                                                 NaN            NaN   \n",
       "2733848-2                                                 NaN            NaN   \n",
       "2726719-4                                                 NaN            NaN   \n",
       "2699718-7                                                 NaN            NaN   \n",
       "2655044-9                                                 NaN            NaN   \n",
       "\n",
       "                                            businessIdChanges  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'changeDate': '2015-06-30', 'change': 'DIF',...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "\n",
       "                                                businessLines companyForm  \\\n",
       "businessId                                                                  \n",
       "2679784-7   [{'order': 0, 'version': 1, 'code': '68209', '...          OY   \n",
       "2947233-5                                                 NaN          OY   \n",
       "2892396-6                                                 NaN          OY   \n",
       "2889182-9                                                 NaN          OY   \n",
       "2876707-8                                                 NaN          OY   \n",
       "2821488-7                                                 NaN          OY   \n",
       "2756326-8                                                 NaN          OY   \n",
       "2733848-2                                                 NaN          OY   \n",
       "2726719-4                                                 NaN          OY   \n",
       "2699718-7                                                 NaN          OY   \n",
       "2655044-9                                                 NaN          OY   \n",
       "\n",
       "                                                 companyForms  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "\n",
       "                                               contactDetails  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'version': 1, 'value': '010 4511', 'type': '...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "\n",
       "                                                   detailsUri  \\\n",
       "businessId                                                      \n",
       "2679784-7                                                None   \n",
       "2947233-5   http://avoindata.prh.fi/opendata/bis/v1/2947233-5   \n",
       "2892396-6   http://avoindata.prh.fi/opendata/bis/v1/2892396-6   \n",
       "2889182-9   http://avoindata.prh.fi/opendata/bis/v1/2889182-9   \n",
       "2876707-8   http://avoindata.prh.fi/opendata/bis/v1/2876707-8   \n",
       "2821488-7   http://avoindata.prh.fi/opendata/bis/v1/2821488-7   \n",
       "2756326-8   http://avoindata.prh.fi/opendata/bis/v1/2756326-8   \n",
       "2733848-2   http://avoindata.prh.fi/opendata/bis/v1/2733848-2   \n",
       "2726719-4   http://avoindata.prh.fi/opendata/bis/v1/2726719-4   \n",
       "2699718-7   http://avoindata.prh.fi/opendata/bis/v1/2699718-7   \n",
       "2655044-9   http://avoindata.prh.fi/opendata/bis/v1/2655044-9   \n",
       "\n",
       "                                                    languages liquidations  \\\n",
       "businessId                                                                   \n",
       "2679784-7   [{'version': 1, 'name': 'Suomi', 'registration...           []   \n",
       "2947233-5                                                 NaN          NaN   \n",
       "2892396-6                                                 NaN          NaN   \n",
       "2889182-9                                                 NaN          NaN   \n",
       "2876707-8                                                 NaN          NaN   \n",
       "2821488-7                                                 NaN          NaN   \n",
       "2756326-8                                                 NaN          NaN   \n",
       "2733848-2                                                 NaN          NaN   \n",
       "2726719-4                                                 NaN          NaN   \n",
       "2699718-7                                                 NaN          NaN   \n",
       "2655044-9                                                 NaN          NaN   \n",
       "\n",
       "                                         name  \\\n",
       "businessId                                      \n",
       "2679784-7               Fortum Real Estate Oy   \n",
       "2947233-5   Nokian Saneeraus Asiantuntijat Oy   \n",
       "2892396-6              Nokian JV-Saneeraus Oy   \n",
       "2889182-9               Nokian Timanttityö Oy   \n",
       "2876707-8           Nokian KamiPark Kuutti Oy   \n",
       "2821488-7           Nokian KamiPark Norppa Oy   \n",
       "2756326-8            Nokian KamiPark Halli Oy   \n",
       "2733848-2                  Nokian Jäähalli Oy   \n",
       "2726719-4                   Nokian Neulomo Oy   \n",
       "2699718-7               Nokian Kuusikuutio Oy   \n",
       "2655044-9               Nokia Technologies Oy   \n",
       "\n",
       "                                                        names  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'order': 0, 'version': 1, 'name': 'Fortum Re...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "\n",
       "                                              registedOffices  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'order': 0, 'version': 1, 'name': 'ESPOO', '...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "\n",
       "                                            registeredEntries registrationDate  \n",
       "businessId                                                                      \n",
       "2679784-7   [{'authority': 1, 'register': 4, 'status': 1, ...       2015-03-03  \n",
       "2947233-5                                                 NaN       2018-10-19  \n",
       "2892396-6                                                 NaN       2018-02-09  \n",
       "2889182-9                                                 NaN       2018-02-01  \n",
       "2876707-8                                                 NaN       2017-12-18  \n",
       "2821488-7                                                 NaN       2017-03-09  \n",
       "2756326-8                                                 NaN       2016-04-08  \n",
       "2733848-2                                                 NaN       2015-12-29  \n",
       "2726719-4                                                 NaN       2015-11-25  \n",
       "2699718-7                                                 NaN       2015-07-06  \n",
       "2655044-9                                                 NaN       2014-11-19  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal.to_frame().results"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The class does not loop the results by default and is showing only the number of companies specified in max_results. To get all of the companies, \n",
    "a) increase \"max_results\" (may crash the query if too large) or \n",
    "b) set \"loop_results_\" to True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:finnish_business_portal.core.model:2 queries to make (time taken > 4)...\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>addresses</th>\n",
       "      <th>auxiliaryNames</th>\n",
       "      <th>businessIdChanges</th>\n",
       "      <th>businessLines</th>\n",
       "      <th>companyForm</th>\n",
       "      <th>companyForms</th>\n",
       "      <th>contactDetails</th>\n",
       "      <th>detailsUri</th>\n",
       "      <th>languages</th>\n",
       "      <th>liquidations</th>\n",
       "      <th>name</th>\n",
       "      <th>names</th>\n",
       "      <th>registedOffices</th>\n",
       "      <th>registeredEntries</th>\n",
       "      <th>registrationDate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2679784-7</th>\n",
       "      <td>[{'careOf': None, 'street': 'PL 100', 'postCod...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'changeDate': '2015-06-30', 'change': 'DIF',...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '68209', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '010 4511', 'type': '...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Fortum Real Estate Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Fortum Re...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'ESPOO', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2015-03-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2947233-5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2947233-5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Saneeraus Asiantuntijat Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-10-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2892396-6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2892396-6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian JV-Saneeraus Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2889182-9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2889182-9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Timanttityö Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2876707-8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2876707-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian KamiPark Kuutti Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821488-7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2821488-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian KamiPark Norppa Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-03-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2756326-8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2756326-8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian KamiPark Halli Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2733848-2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2733848-2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Jäähalli Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2726719-4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2726719-4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Neulomo Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2699718-7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2699718-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Kuusikuutio Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2655044-9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2655044-9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokia Technologies Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2644660-9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2644660-9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nokian Ramirakennus Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2636612-3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2636612-3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kirstua Vesa Oy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-08-22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    addresses auxiliaryNames  \\\n",
       "businessId                                                                     \n",
       "2679784-7   [{'careOf': None, 'street': 'PL 100', 'postCod...             []   \n",
       "2947233-5                                                 NaN            NaN   \n",
       "2892396-6                                                 NaN            NaN   \n",
       "2889182-9                                                 NaN            NaN   \n",
       "2876707-8                                                 NaN            NaN   \n",
       "2821488-7                                                 NaN            NaN   \n",
       "2756326-8                                                 NaN            NaN   \n",
       "2733848-2                                                 NaN            NaN   \n",
       "2726719-4                                                 NaN            NaN   \n",
       "2699718-7                                                 NaN            NaN   \n",
       "2655044-9                                                 NaN            NaN   \n",
       "2644660-9                                                 NaN            NaN   \n",
       "2636612-3                                                 NaN            NaN   \n",
       "\n",
       "                                            businessIdChanges  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'changeDate': '2015-06-30', 'change': 'DIF',...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "2644660-9                                                 NaN   \n",
       "2636612-3                                                 NaN   \n",
       "\n",
       "                                                businessLines companyForm  \\\n",
       "businessId                                                                  \n",
       "2679784-7   [{'order': 0, 'version': 1, 'code': '68209', '...          OY   \n",
       "2947233-5                                                 NaN          OY   \n",
       "2892396-6                                                 NaN          OY   \n",
       "2889182-9                                                 NaN          OY   \n",
       "2876707-8                                                 NaN          OY   \n",
       "2821488-7                                                 NaN          OY   \n",
       "2756326-8                                                 NaN          OY   \n",
       "2733848-2                                                 NaN          OY   \n",
       "2726719-4                                                 NaN          OY   \n",
       "2699718-7                                                 NaN          OY   \n",
       "2655044-9                                                 NaN          OY   \n",
       "2644660-9                                                 NaN          OY   \n",
       "2636612-3                                                 NaN          OY   \n",
       "\n",
       "                                                 companyForms  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "2644660-9                                                 NaN   \n",
       "2636612-3                                                 NaN   \n",
       "\n",
       "                                               contactDetails  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'version': 1, 'value': '010 4511', 'type': '...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "2644660-9                                                 NaN   \n",
       "2636612-3                                                 NaN   \n",
       "\n",
       "                                                   detailsUri  \\\n",
       "businessId                                                      \n",
       "2679784-7                                                None   \n",
       "2947233-5   http://avoindata.prh.fi/opendata/bis/v1/2947233-5   \n",
       "2892396-6   http://avoindata.prh.fi/opendata/bis/v1/2892396-6   \n",
       "2889182-9   http://avoindata.prh.fi/opendata/bis/v1/2889182-9   \n",
       "2876707-8   http://avoindata.prh.fi/opendata/bis/v1/2876707-8   \n",
       "2821488-7   http://avoindata.prh.fi/opendata/bis/v1/2821488-7   \n",
       "2756326-8   http://avoindata.prh.fi/opendata/bis/v1/2756326-8   \n",
       "2733848-2   http://avoindata.prh.fi/opendata/bis/v1/2733848-2   \n",
       "2726719-4   http://avoindata.prh.fi/opendata/bis/v1/2726719-4   \n",
       "2699718-7   http://avoindata.prh.fi/opendata/bis/v1/2699718-7   \n",
       "2655044-9   http://avoindata.prh.fi/opendata/bis/v1/2655044-9   \n",
       "2644660-9   http://avoindata.prh.fi/opendata/bis/v1/2644660-9   \n",
       "2636612-3   http://avoindata.prh.fi/opendata/bis/v1/2636612-3   \n",
       "\n",
       "                                                    languages liquidations  \\\n",
       "businessId                                                                   \n",
       "2679784-7   [{'version': 1, 'name': 'Suomi', 'registration...           []   \n",
       "2947233-5                                                 NaN          NaN   \n",
       "2892396-6                                                 NaN          NaN   \n",
       "2889182-9                                                 NaN          NaN   \n",
       "2876707-8                                                 NaN          NaN   \n",
       "2821488-7                                                 NaN          NaN   \n",
       "2756326-8                                                 NaN          NaN   \n",
       "2733848-2                                                 NaN          NaN   \n",
       "2726719-4                                                 NaN          NaN   \n",
       "2699718-7                                                 NaN          NaN   \n",
       "2655044-9                                                 NaN          NaN   \n",
       "2644660-9                                                 NaN          NaN   \n",
       "2636612-3                                                 NaN          NaN   \n",
       "\n",
       "                                         name  \\\n",
       "businessId                                      \n",
       "2679784-7               Fortum Real Estate Oy   \n",
       "2947233-5   Nokian Saneeraus Asiantuntijat Oy   \n",
       "2892396-6              Nokian JV-Saneeraus Oy   \n",
       "2889182-9               Nokian Timanttityö Oy   \n",
       "2876707-8           Nokian KamiPark Kuutti Oy   \n",
       "2821488-7           Nokian KamiPark Norppa Oy   \n",
       "2756326-8            Nokian KamiPark Halli Oy   \n",
       "2733848-2                  Nokian Jäähalli Oy   \n",
       "2726719-4                   Nokian Neulomo Oy   \n",
       "2699718-7               Nokian Kuusikuutio Oy   \n",
       "2655044-9               Nokia Technologies Oy   \n",
       "2644660-9              Nokian Ramirakennus Oy   \n",
       "2636612-3                     Kirstua Vesa Oy   \n",
       "\n",
       "                                                        names  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'order': 0, 'version': 1, 'name': 'Fortum Re...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "2644660-9                                                 NaN   \n",
       "2636612-3                                                 NaN   \n",
       "\n",
       "                                              registedOffices  \\\n",
       "businessId                                                      \n",
       "2679784-7   [{'order': 0, 'version': 1, 'name': 'ESPOO', '...   \n",
       "2947233-5                                                 NaN   \n",
       "2892396-6                                                 NaN   \n",
       "2889182-9                                                 NaN   \n",
       "2876707-8                                                 NaN   \n",
       "2821488-7                                                 NaN   \n",
       "2756326-8                                                 NaN   \n",
       "2733848-2                                                 NaN   \n",
       "2726719-4                                                 NaN   \n",
       "2699718-7                                                 NaN   \n",
       "2655044-9                                                 NaN   \n",
       "2644660-9                                                 NaN   \n",
       "2636612-3                                                 NaN   \n",
       "\n",
       "                                            registeredEntries registrationDate  \n",
       "businessId                                                                      \n",
       "2679784-7   [{'authority': 1, 'register': 4, 'status': 1, ...       2015-03-03  \n",
       "2947233-5                                                 NaN       2018-10-19  \n",
       "2892396-6                                                 NaN       2018-02-09  \n",
       "2889182-9                                                 NaN       2018-02-01  \n",
       "2876707-8                                                 NaN       2017-12-18  \n",
       "2821488-7                                                 NaN       2017-03-09  \n",
       "2756326-8                                                 NaN       2016-04-08  \n",
       "2733848-2                                                 NaN       2015-12-29  \n",
       "2726719-4                                                 NaN       2015-11-25  \n",
       "2699718-7                                                 NaN       2015-07-06  \n",
       "2655044-9                                                 NaN       2014-11-19  \n",
       "2644660-9                                                 NaN       2014-09-30  \n",
       "2636612-3                                                 NaN       2014-08-22  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal = busportal.SearchModel(\"BisCompany\", loop_results=True)\n",
    "portal.search(name=[\"Fortum\", \"Nokia\"], companyForm=\"oy\")\n",
    "portal.to_frame().results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:finnish_business_portal.core.model:2 queries to make (time taken > 4)...\n",
      "WARNING:finnish_business_portal.core.model:Not all entries in the API searched (10 vs 12), set loop_results=True to get all.\n",
      "INFO:finnish_business_portal.core.model:10 queries to make (time taken > 20)...\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>addresses</th>\n",
       "      <th>auxiliaryNames</th>\n",
       "      <th>businessIdChanges</th>\n",
       "      <th>businessLines</th>\n",
       "      <th>companyForm</th>\n",
       "      <th>companyForms</th>\n",
       "      <th>contactDetails</th>\n",
       "      <th>detailsUri</th>\n",
       "      <th>languages</th>\n",
       "      <th>liquidations</th>\n",
       "      <th>name</th>\n",
       "      <th>names</th>\n",
       "      <th>registedOffices</th>\n",
       "      <th>registeredEntries</th>\n",
       "      <th>registrationDate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2947233-5</th>\n",
       "      <td>[{'careOf': 'Jari-Pekka Karjalainen', 'street'...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '41200', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '0405155979', 'type':...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian Saneeraus Asiantuntijat Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Sa...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2018-10-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2892396-6</th>\n",
       "      <td>[{'careOf': None, 'street': 'Tammikatu 10', 'p...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '81100', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[]</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian JV-Saneeraus Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian JV...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2018-02-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2889182-9</th>\n",
       "      <td>[{'careOf': None, 'street': 'Taivalkunnantie 1...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '43999', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[]</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian Timanttityö Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Ti...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2018-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2876707-8</th>\n",
       "      <td>[{'careOf': None, 'street': 'Tattikatu 10', 'p...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '68209', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '0400 736855', 'type'...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian KamiPark Kuutti Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Ka...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2017-12-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821488-7</th>\n",
       "      <td>[{'careOf': None, 'street': 'Tattikatu 10', 'p...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '68209', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '0400736855', 'type':...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian KamiPark Norppa Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Ka...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2017-03-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2756326-8</th>\n",
       "      <td>[{'careOf': None, 'street': 'Tattikatu 10', 'p...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '68209', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '0400 736855', 'type'...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian KamiPark Halli Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Ka...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2016-04-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2733848-2</th>\n",
       "      <td>[{'careOf': None, 'street': 'Hinttalankatu 6',...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '93110', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '0407799069', 'type':...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian Jäähalli Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Jä...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2015-12-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2726719-4</th>\n",
       "      <td>[{'careOf': None, 'street': 'Kauppakatu 4 A 10...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'changeDate': '2018-06-19', 'change': '48', ...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '13990', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '0405006774', 'type':...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[{'version': 1, 'description': 'Konkurssissa',...</td>\n",
       "      <td>Nokian Neulomo Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Ne...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2015-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2699718-7</th>\n",
       "      <td>[{'careOf': None, 'street': 'Tattikatu 10', 'p...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '68209', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '0400-736855', 'type'...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokian Kuusikuutio Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokian Ku...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'NOKIA', '...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2015-07-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2655044-9</th>\n",
       "      <td>[{'careOf': None, 'street': 'PL 226', 'postCod...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'code': '72193', '...</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'version': 1, 'name': 'Limited company', 'ty...</td>\n",
       "      <td>[{'version': 1, 'value': '010 44 88 000', 'typ...</td>\n",
       "      <td>None</td>\n",
       "      <td>[{'version': 1, 'name': 'Suomi', 'registration...</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nokia Technologies Oy</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'Nokia Tec...</td>\n",
       "      <td>[{'order': 0, 'version': 1, 'name': 'HELSINKI'...</td>\n",
       "      <td>[{'authority': 1, 'register': 4, 'status': 1, ...</td>\n",
       "      <td>2014-11-19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    addresses auxiliaryNames  \\\n",
       "businessId                                                                     \n",
       "2947233-5   [{'careOf': 'Jari-Pekka Karjalainen', 'street'...             []   \n",
       "2892396-6   [{'careOf': None, 'street': 'Tammikatu 10', 'p...             []   \n",
       "2889182-9   [{'careOf': None, 'street': 'Taivalkunnantie 1...             []   \n",
       "2876707-8   [{'careOf': None, 'street': 'Tattikatu 10', 'p...             []   \n",
       "2821488-7   [{'careOf': None, 'street': 'Tattikatu 10', 'p...             []   \n",
       "2756326-8   [{'careOf': None, 'street': 'Tattikatu 10', 'p...             []   \n",
       "2733848-2   [{'careOf': None, 'street': 'Hinttalankatu 6',...             []   \n",
       "2726719-4   [{'careOf': None, 'street': 'Kauppakatu 4 A 10...             []   \n",
       "2699718-7   [{'careOf': None, 'street': 'Tattikatu 10', 'p...             []   \n",
       "2655044-9   [{'careOf': None, 'street': 'PL 226', 'postCod...             []   \n",
       "\n",
       "                                            businessIdChanges  \\\n",
       "businessId                                                      \n",
       "2947233-5                                                  []   \n",
       "2892396-6                                                  []   \n",
       "2889182-9                                                  []   \n",
       "2876707-8                                                  []   \n",
       "2821488-7                                                  []   \n",
       "2756326-8                                                  []   \n",
       "2733848-2                                                  []   \n",
       "2726719-4   [{'changeDate': '2018-06-19', 'change': '48', ...   \n",
       "2699718-7                                                  []   \n",
       "2655044-9                                                  []   \n",
       "\n",
       "                                                businessLines companyForm  \\\n",
       "businessId                                                                  \n",
       "2947233-5   [{'order': 0, 'version': 1, 'code': '41200', '...          OY   \n",
       "2892396-6   [{'order': 0, 'version': 1, 'code': '81100', '...          OY   \n",
       "2889182-9   [{'order': 0, 'version': 1, 'code': '43999', '...          OY   \n",
       "2876707-8   [{'order': 0, 'version': 1, 'code': '68209', '...          OY   \n",
       "2821488-7   [{'order': 0, 'version': 1, 'code': '68209', '...          OY   \n",
       "2756326-8   [{'order': 0, 'version': 1, 'code': '68209', '...          OY   \n",
       "2733848-2   [{'order': 0, 'version': 1, 'code': '93110', '...          OY   \n",
       "2726719-4   [{'order': 0, 'version': 1, 'code': '13990', '...          OY   \n",
       "2699718-7   [{'order': 0, 'version': 1, 'code': '68209', '...          OY   \n",
       "2655044-9   [{'order': 0, 'version': 1, 'code': '72193', '...          OY   \n",
       "\n",
       "                                                 companyForms  \\\n",
       "businessId                                                      \n",
       "2947233-5   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2892396-6   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2889182-9   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2876707-8   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2821488-7   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2756326-8   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2733848-2   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2726719-4   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2699718-7   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "2655044-9   [{'version': 1, 'name': 'Limited company', 'ty...   \n",
       "\n",
       "                                               contactDetails detailsUri  \\\n",
       "businessId                                                                 \n",
       "2947233-5   [{'version': 1, 'value': '0405155979', 'type':...       None   \n",
       "2892396-6                                                  []       None   \n",
       "2889182-9                                                  []       None   \n",
       "2876707-8   [{'version': 1, 'value': '0400 736855', 'type'...       None   \n",
       "2821488-7   [{'version': 1, 'value': '0400736855', 'type':...       None   \n",
       "2756326-8   [{'version': 1, 'value': '0400 736855', 'type'...       None   \n",
       "2733848-2   [{'version': 1, 'value': '0407799069', 'type':...       None   \n",
       "2726719-4   [{'version': 1, 'value': '0405006774', 'type':...       None   \n",
       "2699718-7   [{'version': 1, 'value': '0400-736855', 'type'...       None   \n",
       "2655044-9   [{'version': 1, 'value': '010 44 88 000', 'typ...       None   \n",
       "\n",
       "                                                    languages  \\\n",
       "businessId                                                      \n",
       "2947233-5   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2892396-6   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2889182-9   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2876707-8   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2821488-7   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2756326-8   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2733848-2   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2726719-4   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2699718-7   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "2655044-9   [{'version': 1, 'name': 'Suomi', 'registration...   \n",
       "\n",
       "                                                 liquidations  \\\n",
       "businessId                                                      \n",
       "2947233-5                                                  []   \n",
       "2892396-6                                                  []   \n",
       "2889182-9                                                  []   \n",
       "2876707-8                                                  []   \n",
       "2821488-7                                                  []   \n",
       "2756326-8                                                  []   \n",
       "2733848-2                                                  []   \n",
       "2726719-4   [{'version': 1, 'description': 'Konkurssissa',...   \n",
       "2699718-7                                                  []   \n",
       "2655044-9                                                  []   \n",
       "\n",
       "                                         name  \\\n",
       "businessId                                      \n",
       "2947233-5   Nokian Saneeraus Asiantuntijat Oy   \n",
       "2892396-6              Nokian JV-Saneeraus Oy   \n",
       "2889182-9               Nokian Timanttityö Oy   \n",
       "2876707-8           Nokian KamiPark Kuutti Oy   \n",
       "2821488-7           Nokian KamiPark Norppa Oy   \n",
       "2756326-8            Nokian KamiPark Halli Oy   \n",
       "2733848-2                  Nokian Jäähalli Oy   \n",
       "2726719-4                   Nokian Neulomo Oy   \n",
       "2699718-7               Nokian Kuusikuutio Oy   \n",
       "2655044-9               Nokia Technologies Oy   \n",
       "\n",
       "                                                        names  \\\n",
       "businessId                                                      \n",
       "2947233-5   [{'order': 0, 'version': 1, 'name': 'Nokian Sa...   \n",
       "2892396-6   [{'order': 0, 'version': 1, 'name': 'Nokian JV...   \n",
       "2889182-9   [{'order': 0, 'version': 1, 'name': 'Nokian Ti...   \n",
       "2876707-8   [{'order': 0, 'version': 1, 'name': 'Nokian Ka...   \n",
       "2821488-7   [{'order': 0, 'version': 1, 'name': 'Nokian Ka...   \n",
       "2756326-8   [{'order': 0, 'version': 1, 'name': 'Nokian Ka...   \n",
       "2733848-2   [{'order': 0, 'version': 1, 'name': 'Nokian Jä...   \n",
       "2726719-4   [{'order': 0, 'version': 1, 'name': 'Nokian Ne...   \n",
       "2699718-7   [{'order': 0, 'version': 1, 'name': 'Nokian Ku...   \n",
       "2655044-9   [{'order': 0, 'version': 1, 'name': 'Nokia Tec...   \n",
       "\n",
       "                                              registedOffices  \\\n",
       "businessId                                                      \n",
       "2947233-5   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2892396-6   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2889182-9   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2876707-8   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2821488-7   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2756326-8   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2733848-2   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2726719-4   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2699718-7   [{'order': 0, 'version': 1, 'name': 'NOKIA', '...   \n",
       "2655044-9   [{'order': 0, 'version': 1, 'name': 'HELSINKI'...   \n",
       "\n",
       "                                            registeredEntries registrationDate  \n",
       "businessId                                                                      \n",
       "2947233-5   [{'authority': 1, 'register': 4, 'status': 1, ...       2018-10-19  \n",
       "2892396-6   [{'authority': 1, 'register': 4, 'status': 1, ...       2018-02-09  \n",
       "2889182-9   [{'authority': 1, 'register': 4, 'status': 1, ...       2018-02-01  \n",
       "2876707-8   [{'authority': 1, 'register': 4, 'status': 1, ...       2017-12-18  \n",
       "2821488-7   [{'authority': 1, 'register': 4, 'status': 1, ...       2017-03-09  \n",
       "2756326-8   [{'authority': 1, 'register': 4, 'status': 1, ...       2016-04-08  \n",
       "2733848-2   [{'authority': 1, 'register': 4, 'status': 1, ...       2015-12-29  \n",
       "2726719-4   [{'authority': 1, 'register': 4, 'status': 1, ...       2015-11-25  \n",
       "2699718-7   [{'authority': 1, 'register': 4, 'status': 1, ...       2015-07-06  \n",
       "2655044-9   [{'authority': 1, 'register': 4, 'status': 1, ...       2014-11-19  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal = busportal.SearchModel(\"BisCompany\", loop_results=False, deep=True)\n",
    "portal.search(name=[\"Fortum\", \"Nokia\"], companyForm=\"oy\", total_results=\"True\")\n",
    "portal.to_frame().results"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "And finally testing with other API."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['totalResults',\n",
       " 'maxResults',\n",
       " 'resultsFrom',\n",
       " 'name',\n",
       " 'businessId',\n",
       " 'registeredOffice',\n",
       " 'companyForm',\n",
       " 'companyRegistrationFrom',\n",
       " 'companyRegistrationTo',\n",
       " 'companyChangedSince',\n",
       " 'recordNumber',\n",
       " 'entryCode',\n",
       " 'noticeRegistrationFrom',\n",
       " 'noticeRegistrationTo',\n",
       " 'noticeRegistrationType']"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal.api = \"TradeRegisterCompany\"\n",
    "portal.parameter_options"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:finnish_business_portal.core.model:1 queries to make (time taken > 2)...\n",
      "INFO:finnish_business_portal.core.model:9 queries to make (time taken > 18)...\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>addresses</th>\n",
       "      <th>auxiliaryNames</th>\n",
       "      <th>bisDetailsUri</th>\n",
       "      <th>checkDate</th>\n",
       "      <th>companyForm</th>\n",
       "      <th>companyForms</th>\n",
       "      <th>detailsUri</th>\n",
       "      <th>language</th>\n",
       "      <th>latestRegistrationDate</th>\n",
       "      <th>name</th>\n",
       "      <th>names</th>\n",
       "      <th>publicNotices</th>\n",
       "      <th>registeredOffices</th>\n",
       "      <th>registrationDate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2802278-9</th>\n",
       "      <td>[{'street': 'Lehtisenkuja 20', 'postCode': '49...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2802278-9</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2017-01-1...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2802278-9</td>\n",
       "      <td>FI</td>\n",
       "      <td>2018-05-30</td>\n",
       "      <td>Renkaat Performance Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renkaat Performance Oy'...</td>\n",
       "      <td>[{'recordNumber': '2018/34104W', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Virolahti', 'language':...</td>\n",
       "      <td>2017-01-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2784387-6</th>\n",
       "      <td>[{'street': 'Halmetie 7', 'postCode': '00730',...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2784387-6</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2016-10-1...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2784387-6</td>\n",
       "      <td>FI</td>\n",
       "      <td>2016-10-14</td>\n",
       "      <td>Renkaat123 Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renkaat123 Oy', 'regist...</td>\n",
       "      <td>[{'recordNumber': '2016/240032', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Helsinki', 'language': ...</td>\n",
       "      <td>2016-10-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2673098-4</th>\n",
       "      <td>[{'street': 'Rattitie 12-14', 'postCode': '007...</td>\n",
       "      <td>[{'order': 1, 'name': 'ROMUFIN', 'registration...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2673098-4</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2015-02-1...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2673098-4</td>\n",
       "      <td>FI</td>\n",
       "      <td>2019-01-10</td>\n",
       "      <td>Renku Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renku Oy', 'registratio...</td>\n",
       "      <td>[{'recordNumber': '2019/10726W', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Helsinki', 'language': ...</td>\n",
       "      <td>2015-02-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2631713-7</th>\n",
       "      <td>[{'street': 'Marsinkuja 2', 'postCode': '01480...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2631713-7</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2014-08-0...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2631713-7</td>\n",
       "      <td>FI</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>Renkipoika Etelä-Suomi Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renkipoika Etelä-Suomi ...</td>\n",
       "      <td>[{'recordNumber': '2018/54916T', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Vantaa', 'language': 'E...</td>\n",
       "      <td>2014-08-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2447504-3</th>\n",
       "      <td>[{'street': 'Tupalankatu 3', 'postCode': '1568...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2447504-3</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2011-12-2...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2447504-3</td>\n",
       "      <td>FI</td>\n",
       "      <td>2018-05-03</td>\n",
       "      <td>Renkomäen Autohuolto Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renkomäen Autohuolto Oy...</td>\n",
       "      <td>[{'recordNumber': '2018/22639U', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Lahti', 'language': 'EN...</td>\n",
       "      <td>2011-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2308053-3</th>\n",
       "      <td>[{'street': 'Ulvomäentie 20', 'postCode': '041...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2308053-3</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2010-01-1...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2308053-3</td>\n",
       "      <td>FI</td>\n",
       "      <td>2018-05-12</td>\n",
       "      <td>Renkipankki Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renkipankki Oy', 'regis...</td>\n",
       "      <td>[{'recordNumber': '2018/26313T', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Helsinki', 'language': ...</td>\n",
       "      <td>2010-01-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2074073-5</th>\n",
       "      <td>[{'street': 'Paistontie 203', 'postCode': '124...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2074073-5</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2006-11-2...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2074073-5</td>\n",
       "      <td>FI</td>\n",
       "      <td>2018-01-31</td>\n",
       "      <td>Renkipoeka Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renkipoeka Oy', 'regist...</td>\n",
       "      <td>[{'recordNumber': '2018/11746V', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Kuopio', 'language': 'E...</td>\n",
       "      <td>2006-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2056821-8</th>\n",
       "      <td>[{'street': 'Tupalankatu 9', 'postCode': '1568...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/2056821-8</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2006-09-0...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/2056821-8</td>\n",
       "      <td>FI</td>\n",
       "      <td>2018-05-10</td>\n",
       "      <td>Renksu Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renksu Oy', 'registrati...</td>\n",
       "      <td>[{'recordNumber': '2018/25013X', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Lahti', 'language': 'EN...</td>\n",
       "      <td>2006-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1713450-7</th>\n",
       "      <td>[{'street': 'Koskelantie 15', 'postCode': '622...</td>\n",
       "      <td>[]</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/bis/v1/1713450-7</td>\n",
       "      <td>None</td>\n",
       "      <td>OY</td>\n",
       "      <td>[{'type': 'OY', 'registrationDate': '2001-09-0...</td>\n",
       "      <td>http://avoindata.prh.fi/opendata/tr/v1/1713450-7</td>\n",
       "      <td>FI</td>\n",
       "      <td>2018-10-02</td>\n",
       "      <td>Renko &amp; Renko Oy</td>\n",
       "      <td>[{'order': 0, 'name': 'Renko &amp; Renko Oy', 'reg...</td>\n",
       "      <td>[{'recordNumber': '2018/48628W', 'registration...</td>\n",
       "      <td>[{'registeredOffice': 'Kauhava', 'language': '...</td>\n",
       "      <td>2001-09-07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    addresses  \\\n",
       "businessId                                                      \n",
       "2802278-9   [{'street': 'Lehtisenkuja 20', 'postCode': '49...   \n",
       "2784387-6   [{'street': 'Halmetie 7', 'postCode': '00730',...   \n",
       "2673098-4   [{'street': 'Rattitie 12-14', 'postCode': '007...   \n",
       "2631713-7   [{'street': 'Marsinkuja 2', 'postCode': '01480...   \n",
       "2447504-3   [{'street': 'Tupalankatu 3', 'postCode': '1568...   \n",
       "2308053-3   [{'street': 'Ulvomäentie 20', 'postCode': '041...   \n",
       "2074073-5   [{'street': 'Paistontie 203', 'postCode': '124...   \n",
       "2056821-8   [{'street': 'Tupalankatu 9', 'postCode': '1568...   \n",
       "1713450-7   [{'street': 'Koskelantie 15', 'postCode': '622...   \n",
       "\n",
       "                                               auxiliaryNames  \\\n",
       "businessId                                                      \n",
       "2802278-9                                                  []   \n",
       "2784387-6                                                  []   \n",
       "2673098-4   [{'order': 1, 'name': 'ROMUFIN', 'registration...   \n",
       "2631713-7                                                  []   \n",
       "2447504-3                                                  []   \n",
       "2308053-3                                                  []   \n",
       "2074073-5                                                  []   \n",
       "2056821-8                                                  []   \n",
       "1713450-7                                                  []   \n",
       "\n",
       "                                                bisDetailsUri checkDate  \\\n",
       "businessId                                                                \n",
       "2802278-9   http://avoindata.prh.fi/opendata/bis/v1/2802278-9      None   \n",
       "2784387-6   http://avoindata.prh.fi/opendata/bis/v1/2784387-6      None   \n",
       "2673098-4   http://avoindata.prh.fi/opendata/bis/v1/2673098-4      None   \n",
       "2631713-7   http://avoindata.prh.fi/opendata/bis/v1/2631713-7      None   \n",
       "2447504-3   http://avoindata.prh.fi/opendata/bis/v1/2447504-3      None   \n",
       "2308053-3   http://avoindata.prh.fi/opendata/bis/v1/2308053-3      None   \n",
       "2074073-5   http://avoindata.prh.fi/opendata/bis/v1/2074073-5      None   \n",
       "2056821-8   http://avoindata.prh.fi/opendata/bis/v1/2056821-8      None   \n",
       "1713450-7   http://avoindata.prh.fi/opendata/bis/v1/1713450-7      None   \n",
       "\n",
       "           companyForm                                       companyForms  \\\n",
       "businessId                                                                  \n",
       "2802278-9           OY  [{'type': 'OY', 'registrationDate': '2017-01-1...   \n",
       "2784387-6           OY  [{'type': 'OY', 'registrationDate': '2016-10-1...   \n",
       "2673098-4           OY  [{'type': 'OY', 'registrationDate': '2015-02-1...   \n",
       "2631713-7           OY  [{'type': 'OY', 'registrationDate': '2014-08-0...   \n",
       "2447504-3           OY  [{'type': 'OY', 'registrationDate': '2011-12-2...   \n",
       "2308053-3           OY  [{'type': 'OY', 'registrationDate': '2010-01-1...   \n",
       "2074073-5           OY  [{'type': 'OY', 'registrationDate': '2006-11-2...   \n",
       "2056821-8           OY  [{'type': 'OY', 'registrationDate': '2006-09-0...   \n",
       "1713450-7           OY  [{'type': 'OY', 'registrationDate': '2001-09-0...   \n",
       "\n",
       "                                                  detailsUri language  \\\n",
       "businessId                                                              \n",
       "2802278-9   http://avoindata.prh.fi/opendata/tr/v1/2802278-9       FI   \n",
       "2784387-6   http://avoindata.prh.fi/opendata/tr/v1/2784387-6       FI   \n",
       "2673098-4   http://avoindata.prh.fi/opendata/tr/v1/2673098-4       FI   \n",
       "2631713-7   http://avoindata.prh.fi/opendata/tr/v1/2631713-7       FI   \n",
       "2447504-3   http://avoindata.prh.fi/opendata/tr/v1/2447504-3       FI   \n",
       "2308053-3   http://avoindata.prh.fi/opendata/tr/v1/2308053-3       FI   \n",
       "2074073-5   http://avoindata.prh.fi/opendata/tr/v1/2074073-5       FI   \n",
       "2056821-8   http://avoindata.prh.fi/opendata/tr/v1/2056821-8       FI   \n",
       "1713450-7   http://avoindata.prh.fi/opendata/tr/v1/1713450-7       FI   \n",
       "\n",
       "           latestRegistrationDate                       name  \\\n",
       "businessId                                                     \n",
       "2802278-9              2018-05-30     Renkaat Performance Oy   \n",
       "2784387-6              2016-10-14              Renkaat123 Oy   \n",
       "2673098-4              2019-01-10                   Renku Oy   \n",
       "2631713-7              2019-01-01  Renkipoika Etelä-Suomi Oy   \n",
       "2447504-3              2018-05-03    Renkomäen Autohuolto Oy   \n",
       "2308053-3              2018-05-12             Renkipankki Oy   \n",
       "2074073-5              2018-01-31              Renkipoeka Oy   \n",
       "2056821-8              2018-05-10                  Renksu Oy   \n",
       "1713450-7              2018-10-02           Renko & Renko Oy   \n",
       "\n",
       "                                                        names  \\\n",
       "businessId                                                      \n",
       "2802278-9   [{'order': 0, 'name': 'Renkaat Performance Oy'...   \n",
       "2784387-6   [{'order': 0, 'name': 'Renkaat123 Oy', 'regist...   \n",
       "2673098-4   [{'order': 0, 'name': 'Renku Oy', 'registratio...   \n",
       "2631713-7   [{'order': 0, 'name': 'Renkipoika Etelä-Suomi ...   \n",
       "2447504-3   [{'order': 0, 'name': 'Renkomäen Autohuolto Oy...   \n",
       "2308053-3   [{'order': 0, 'name': 'Renkipankki Oy', 'regis...   \n",
       "2074073-5   [{'order': 0, 'name': 'Renkipoeka Oy', 'regist...   \n",
       "2056821-8   [{'order': 0, 'name': 'Renksu Oy', 'registrati...   \n",
       "1713450-7   [{'order': 0, 'name': 'Renko & Renko Oy', 'reg...   \n",
       "\n",
       "                                                publicNotices  \\\n",
       "businessId                                                      \n",
       "2802278-9   [{'recordNumber': '2018/34104W', 'registration...   \n",
       "2784387-6   [{'recordNumber': '2016/240032', 'registration...   \n",
       "2673098-4   [{'recordNumber': '2019/10726W', 'registration...   \n",
       "2631713-7   [{'recordNumber': '2018/54916T', 'registration...   \n",
       "2447504-3   [{'recordNumber': '2018/22639U', 'registration...   \n",
       "2308053-3   [{'recordNumber': '2018/26313T', 'registration...   \n",
       "2074073-5   [{'recordNumber': '2018/11746V', 'registration...   \n",
       "2056821-8   [{'recordNumber': '2018/25013X', 'registration...   \n",
       "1713450-7   [{'recordNumber': '2018/48628W', 'registration...   \n",
       "\n",
       "                                            registeredOffices registrationDate  \n",
       "businessId                                                                      \n",
       "2802278-9   [{'registeredOffice': 'Virolahti', 'language':...       2017-01-13  \n",
       "2784387-6   [{'registeredOffice': 'Helsinki', 'language': ...       2016-10-14  \n",
       "2673098-4   [{'registeredOffice': 'Helsinki', 'language': ...       2015-02-11  \n",
       "2631713-7   [{'registeredOffice': 'Vantaa', 'language': 'E...       2014-08-05  \n",
       "2447504-3   [{'registeredOffice': 'Lahti', 'language': 'EN...       2011-12-22  \n",
       "2308053-3   [{'registeredOffice': 'Helsinki', 'language': ...       2010-01-13  \n",
       "2074073-5   [{'registeredOffice': 'Kuopio', 'language': 'E...       2006-11-29  \n",
       "2056821-8   [{'registeredOffice': 'Lahti', 'language': 'EN...       2006-09-08  \n",
       "1713450-7   [{'registeredOffice': 'Kauhava', 'language': '...       2001-09-07  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal.search(name=\"Renk\", company_registration_from=\"2000-01-01\")\n",
    "portal.to_frame().results"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some of the columns may seem to be confusing as they are list of dictionaries. You can \"flat\" them passing True to the to_frame method."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"10\" halign=\"left\">addresses 0</th>\n",
       "      <th>...</th>\n",
       "      <th>registeredOffices 0</th>\n",
       "      <th colspan=\"4\" halign=\"left\">registeredOffices 1</th>\n",
       "      <th colspan=\"4\" halign=\"left\">registeredOffices 2</th>\n",
       "      <th>registrationDate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>street</th>\n",
       "      <th>postCode</th>\n",
       "      <th>type</th>\n",
       "      <th>city</th>\n",
       "      <th>country</th>\n",
       "      <th>website</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>registrationDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>...</th>\n",
       "      <th>endDate</th>\n",
       "      <th>registeredOffice</th>\n",
       "      <th>language</th>\n",
       "      <th>registrationDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>registeredOffice</th>\n",
       "      <th>language</th>\n",
       "      <th>registrationDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>registrationDate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2802278-9</th>\n",
       "      <td>Lehtisenkuja 20</td>\n",
       "      <td>49900</td>\n",
       "      <td>1</td>\n",
       "      <td>Virolahti</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>+358 46 5257742</td>\n",
       "      <td>None</td>\n",
       "      <td>2016-12-22</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Virolahti</td>\n",
       "      <td>SE</td>\n",
       "      <td>2017-01-13</td>\n",
       "      <td>None</td>\n",
       "      <td>Virolahti</td>\n",
       "      <td>FI</td>\n",
       "      <td>2017-01-13</td>\n",
       "      <td>None</td>\n",
       "      <td>2017-01-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2784387-6</th>\n",
       "      <td>Halmetie 7</td>\n",
       "      <td>00730</td>\n",
       "      <td>1</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>FI</td>\n",
       "      <td>www.renkaat123.fi</td>\n",
       "      <td>+3725042886</td>\n",
       "      <td>None</td>\n",
       "      <td>2016-09-27</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Helsingfors</td>\n",
       "      <td>SE</td>\n",
       "      <td>2016-10-14</td>\n",
       "      <td>None</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>FI</td>\n",
       "      <td>2016-10-14</td>\n",
       "      <td>None</td>\n",
       "      <td>2016-10-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2673098-4</th>\n",
       "      <td>Rattitie 12-14</td>\n",
       "      <td>00770</td>\n",
       "      <td>1</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2015-02-04</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Helsingfors</td>\n",
       "      <td>SE</td>\n",
       "      <td>2015-02-11</td>\n",
       "      <td>None</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>FI</td>\n",
       "      <td>2015-02-11</td>\n",
       "      <td>None</td>\n",
       "      <td>2015-02-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2631713-7</th>\n",
       "      <td>Marsinkuja 2</td>\n",
       "      <td>01480</td>\n",
       "      <td>1</td>\n",
       "      <td>Vantaa</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Vanda</td>\n",
       "      <td>SE</td>\n",
       "      <td>2014-08-05</td>\n",
       "      <td>None</td>\n",
       "      <td>Vantaa</td>\n",
       "      <td>FI</td>\n",
       "      <td>2014-08-05</td>\n",
       "      <td>None</td>\n",
       "      <td>2014-08-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2447504-3</th>\n",
       "      <td>Tupalankatu 3</td>\n",
       "      <td>15680</td>\n",
       "      <td>1</td>\n",
       "      <td>LAHTI</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>09 85684050</td>\n",
       "      <td>None</td>\n",
       "      <td>2012-03-08</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Lahtis</td>\n",
       "      <td>SE</td>\n",
       "      <td>2011-12-22</td>\n",
       "      <td>None</td>\n",
       "      <td>Lahti</td>\n",
       "      <td>FI</td>\n",
       "      <td>2011-12-22</td>\n",
       "      <td>None</td>\n",
       "      <td>2011-12-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2308053-3</th>\n",
       "      <td>Ulvomäentie 20</td>\n",
       "      <td>04130</td>\n",
       "      <td>2</td>\n",
       "      <td>SIPOO</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>0442622410</td>\n",
       "      <td>None</td>\n",
       "      <td>2010-01-15</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Helsingfors</td>\n",
       "      <td>SE</td>\n",
       "      <td>2010-01-13</td>\n",
       "      <td>None</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>FI</td>\n",
       "      <td>2010-01-13</td>\n",
       "      <td>None</td>\n",
       "      <td>2010-01-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2074073-5</th>\n",
       "      <td>Paistontie 203</td>\n",
       "      <td>12400</td>\n",
       "      <td>1</td>\n",
       "      <td>Tervakoski</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>0405591068</td>\n",
       "      <td>None</td>\n",
       "      <td>2015-02-05</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Kuopio</td>\n",
       "      <td>SE</td>\n",
       "      <td>2006-11-29</td>\n",
       "      <td>None</td>\n",
       "      <td>Kuopio</td>\n",
       "      <td>FI</td>\n",
       "      <td>2006-11-29</td>\n",
       "      <td>None</td>\n",
       "      <td>2006-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2056821-8</th>\n",
       "      <td>Tupalankatu 9</td>\n",
       "      <td>15680</td>\n",
       "      <td>1</td>\n",
       "      <td>LAHTI</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>0387870</td>\n",
       "      <td>038787500</td>\n",
       "      <td>2007-01-11</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Lahtis</td>\n",
       "      <td>SE</td>\n",
       "      <td>2006-09-08</td>\n",
       "      <td>None</td>\n",
       "      <td>Lahti</td>\n",
       "      <td>FI</td>\n",
       "      <td>2006-09-08</td>\n",
       "      <td>None</td>\n",
       "      <td>2006-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1713450-7</th>\n",
       "      <td>Koskelantie 15</td>\n",
       "      <td>62240</td>\n",
       "      <td>2</td>\n",
       "      <td>HUHMARKOSKI</td>\n",
       "      <td>FI</td>\n",
       "      <td>None</td>\n",
       "      <td>0505773000 064354022</td>\n",
       "      <td>None</td>\n",
       "      <td>2005-11-18</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>Kauhava</td>\n",
       "      <td>SE</td>\n",
       "      <td>2001-09-07</td>\n",
       "      <td>None</td>\n",
       "      <td>Kauhava</td>\n",
       "      <td>FI</td>\n",
       "      <td>2001-09-07</td>\n",
       "      <td>None</td>\n",
       "      <td>2001-09-07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 101 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                addresses 0                                     \\\n",
       "                     street postCode type         city country   \n",
       "businessId                                                       \n",
       "2802278-9   Lehtisenkuja 20    49900    1    Virolahti      FI   \n",
       "2784387-6        Halmetie 7    00730    1     Helsinki      FI   \n",
       "2673098-4    Rattitie 12-14    00770    1     Helsinki      FI   \n",
       "2631713-7      Marsinkuja 2    01480    1       Vantaa      FI   \n",
       "2447504-3     Tupalankatu 3    15680    1        LAHTI      FI   \n",
       "2308053-3    Ulvomäentie 20    04130    2        SIPOO      FI   \n",
       "2074073-5    Paistontie 203    12400    1   Tervakoski      FI   \n",
       "2056821-8     Tupalankatu 9    15680    1        LAHTI      FI   \n",
       "1713450-7    Koskelantie 15    62240    2  HUHMARKOSKI      FI   \n",
       "\n",
       "                                                                \\\n",
       "                      website                 phone        fax   \n",
       "businessId                                                       \n",
       "2802278-9                None       +358 46 5257742       None   \n",
       "2784387-6   www.renkaat123.fi           +3725042886       None   \n",
       "2673098-4                None                  None       None   \n",
       "2631713-7                None                  None       None   \n",
       "2447504-3                None           09 85684050       None   \n",
       "2308053-3                None            0442622410       None   \n",
       "2074073-5                None            0405591068       None   \n",
       "2056821-8                None               0387870  038787500   \n",
       "1713450-7                None  0505773000 064354022       None   \n",
       "\n",
       "                                     ... registeredOffices 0  \\\n",
       "           registrationDate endDate  ...             endDate   \n",
       "businessId                           ...                       \n",
       "2802278-9        2016-12-22    None  ...                None   \n",
       "2784387-6        2016-09-27    None  ...                None   \n",
       "2673098-4        2015-02-04    None  ...                None   \n",
       "2631713-7        2017-04-28    None  ...                None   \n",
       "2447504-3        2012-03-08    None  ...                None   \n",
       "2308053-3        2010-01-15    None  ...                None   \n",
       "2074073-5        2015-02-05    None  ...                None   \n",
       "2056821-8        2007-01-11    None  ...                None   \n",
       "1713450-7        2005-11-18    None  ...                None   \n",
       "\n",
       "           registeredOffices 1                                    \\\n",
       "              registeredOffice language registrationDate endDate   \n",
       "businessId                                                         \n",
       "2802278-9            Virolahti       SE       2017-01-13    None   \n",
       "2784387-6          Helsingfors       SE       2016-10-14    None   \n",
       "2673098-4          Helsingfors       SE       2015-02-11    None   \n",
       "2631713-7                Vanda       SE       2014-08-05    None   \n",
       "2447504-3               Lahtis       SE       2011-12-22    None   \n",
       "2308053-3          Helsingfors       SE       2010-01-13    None   \n",
       "2074073-5               Kuopio       SE       2006-11-29    None   \n",
       "2056821-8               Lahtis       SE       2006-09-08    None   \n",
       "1713450-7              Kauhava       SE       2001-09-07    None   \n",
       "\n",
       "           registeredOffices 2                                    \\\n",
       "              registeredOffice language registrationDate endDate   \n",
       "businessId                                                         \n",
       "2802278-9            Virolahti       FI       2017-01-13    None   \n",
       "2784387-6             Helsinki       FI       2016-10-14    None   \n",
       "2673098-4             Helsinki       FI       2015-02-11    None   \n",
       "2631713-7               Vantaa       FI       2014-08-05    None   \n",
       "2447504-3                Lahti       FI       2011-12-22    None   \n",
       "2308053-3             Helsinki       FI       2010-01-13    None   \n",
       "2074073-5               Kuopio       FI       2006-11-29    None   \n",
       "2056821-8                Lahti       FI       2006-09-08    None   \n",
       "1713450-7              Kauhava       FI       2001-09-07    None   \n",
       "\n",
       "           registrationDate  \n",
       "           registrationDate  \n",
       "businessId                   \n",
       "2802278-9        2017-01-13  \n",
       "2784387-6        2016-10-14  \n",
       "2673098-4        2015-02-11  \n",
       "2631713-7        2014-08-05  \n",
       "2447504-3        2011-12-22  \n",
       "2308053-3        2010-01-13  \n",
       "2074073-5        2006-11-29  \n",
       "2056821-8        2006-09-08  \n",
       "1713450-7        2001-09-07  \n",
       "\n",
       "[9 rows x 101 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal.to_frame(True).results"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "But on the other hands, they were list of dicts for a reason."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Example Application<a class=\"anchor\" id=\"H3\"></a>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Using a bit of data manipulation with Pandas, one can put the data any desirable format."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:finnish_business_portal.core.model:1 queries to make (time taken > 2)...\n",
      "WARNING:finnish_business_portal.core.model:Not all entries in the API searched (10), set loop_results=True to get all.\n",
      "INFO:finnish_business_portal.core.model:10 queries to make (time taken > 20)...\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<finnish_business_portal.core.model.SearchModel at 0x27d507a2400>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "portal = busportal.SearchModel(\"BisCompany\", loop_results=False, deep=True)\n",
    "portal.search(name=\"Fortum\", companyForm=\"oy\", companyRegistrationFrom=\"2000-01-01\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_fortum = portal.to_frame(True).results"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If case you need to get street addresses from a company/companies, you can do it like the following:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>city</th>\n",
       "      <th>country</th>\n",
       "      <th>endDate</th>\n",
       "      <th>postCode</th>\n",
       "      <th>street</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2679784-7</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Real Estate Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 1</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>00048</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum Real Estate Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 2</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilalahdentie 2-4</td>\n",
       "      <td>Fortum Real Estate Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">2481332-1</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>00048</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum Power and Heat Holding Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 1</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum Power and Heat Holding Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 2</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilalahdentie 2-4</td>\n",
       "      <td>Fortum Power and Heat Holding Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 3</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Power and Heat Holding Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">2481338-0</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>00048</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum C&amp;H Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 1</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum C&amp;H Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 2</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilalahdentie 2-4</td>\n",
       "      <td>Fortum C&amp;H Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 3</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum C&amp;H Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">2481336-4</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>00048</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum Norm Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 1</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum Norm Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 2</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilalahdentie 2-4</td>\n",
       "      <td>Fortum Norm Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 3</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Norm Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">2185030-3</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 1</td>\n",
       "      <td>Fortum Growth Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 1</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum Growth Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 2</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilalahdentie 2-4</td>\n",
       "      <td>Fortum Growth Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 3</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Growth Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">2079891-0</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilaniementie 1</td>\n",
       "      <td>Fortum Asiakaspalvelu Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 1</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Asiakaspalvelu Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 2</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-08-24</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Asiakaspalvelu Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 3</th>\n",
       "      <td>ESPOO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02150</td>\n",
       "      <td>Keilalahdentie 2-4</td>\n",
       "      <td>Fortum Asiakaspalvelu Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">1852328-0</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-10-10</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Markets Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addresses 1</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Markets Oy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852303-7</th>\n",
       "      <th>addresses 0</th>\n",
       "      <td>FORTUM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>00048</td>\n",
       "      <td>PL 100</td>\n",
       "      <td>Fortum Heat and Gas Oy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          city  country     endDate postCode  \\\n",
       "businessId                                                     \n",
       "2679784-7  addresses 0  FORTUM      NaN        None    00048   \n",
       "           addresses 1  FORTUM      NaN  2017-12-18    00048   \n",
       "           addresses 2   ESPOO      NaN        None    02150   \n",
       "2481332-1  addresses 0  FORTUM      NaN  2017-12-18    00048   \n",
       "           addresses 1   ESPOO      NaN  2017-12-18    02150   \n",
       "           addresses 2   ESPOO      NaN        None    02150   \n",
       "           addresses 3  FORTUM      NaN         NaN    00048   \n",
       "2481338-0  addresses 0  FORTUM      NaN  2017-12-18    00048   \n",
       "           addresses 1   ESPOO      NaN  2017-12-18    02150   \n",
       "           addresses 2   ESPOO      NaN        None    02150   \n",
       "           addresses 3  FORTUM      NaN         NaN    00048   \n",
       "2481336-4  addresses 0  FORTUM      NaN  2017-12-18    00048   \n",
       "           addresses 1   ESPOO      NaN  2017-12-18    02150   \n",
       "           addresses 2   ESPOO      NaN        None    02150   \n",
       "           addresses 3  FORTUM      NaN         NaN    00048   \n",
       "2185030-3  addresses 0  FORTUM      NaN  2017-12-18    00048   \n",
       "           addresses 1   ESPOO      NaN  2017-12-18    02150   \n",
       "           addresses 2   ESPOO      NaN        None    02150   \n",
       "           addresses 3  FORTUM      NaN         NaN    00048   \n",
       "2079891-0  addresses 0   ESPOO      NaN  2017-12-18    02150   \n",
       "           addresses 1  FORTUM      NaN        None    00048   \n",
       "           addresses 2  FORTUM      NaN  2016-08-24    00048   \n",
       "           addresses 3   ESPOO      NaN         NaN    02150   \n",
       "1852328-0  addresses 0  FORTUM      NaN  2017-10-10    00048   \n",
       "           addresses 1  FORTUM      NaN        None    00048   \n",
       "1852303-7  addresses 0  FORTUM      NaN        None    00048   \n",
       "\n",
       "                                    street                              name  \n",
       "businessId                                                                    \n",
       "2679784-7  addresses 0              PL 100             Fortum Real Estate Oy  \n",
       "           addresses 1    Keilaniementie 1             Fortum Real Estate Oy  \n",
       "           addresses 2  Keilalahdentie 2-4             Fortum Real Estate Oy  \n",
       "2481332-1  addresses 0    Keilaniementie 1  Fortum Power and Heat Holding Oy  \n",
       "           addresses 1    Keilaniementie 1  Fortum Power and Heat Holding Oy  \n",
       "           addresses 2  Keilalahdentie 2-4  Fortum Power and Heat Holding Oy  \n",
       "           addresses 3              PL 100  Fortum Power and Heat Holding Oy  \n",
       "2481338-0  addresses 0    Keilaniementie 1                     Fortum C&H Oy  \n",
       "           addresses 1    Keilaniementie 1                     Fortum C&H Oy  \n",
       "           addresses 2  Keilalahdentie 2-4                     Fortum C&H Oy  \n",
       "           addresses 3              PL 100                     Fortum C&H Oy  \n",
       "2481336-4  addresses 0    Keilaniementie 1                    Fortum Norm Oy  \n",
       "           addresses 1    Keilaniementie 1                    Fortum Norm Oy  \n",
       "           addresses 2  Keilalahdentie 2-4                    Fortum Norm Oy  \n",
       "           addresses 3              PL 100                    Fortum Norm Oy  \n",
       "2185030-3  addresses 0                PL 1                  Fortum Growth Oy  \n",
       "           addresses 1    Keilaniementie 1                  Fortum Growth Oy  \n",
       "           addresses 2  Keilalahdentie 2-4                  Fortum Growth Oy  \n",
       "           addresses 3              PL 100                  Fortum Growth Oy  \n",
       "2079891-0  addresses 0    Keilaniementie 1          Fortum Asiakaspalvelu Oy  \n",
       "           addresses 1              PL 100          Fortum Asiakaspalvelu Oy  \n",
       "           addresses 2              PL 100          Fortum Asiakaspalvelu Oy  \n",
       "           addresses 3  Keilalahdentie 2-4          Fortum Asiakaspalvelu Oy  \n",
       "1852328-0  addresses 0              PL 100                 Fortum Markets Oy  \n",
       "           addresses 1              PL 100                 Fortum Markets Oy  \n",
       "1852303-7  addresses 0              PL 100            Fortum Heat and Gas Oy  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "first_level = \"address\"\n",
    "second_level = (\"street\", \"postCode\", \"city\", \"country\", \"endDate\")\n",
    "(\n",
    "    df_fortum[\n",
    "        [col for col in df_fortum.columns \n",
    "         if col[0].startswith(first_level) \n",
    "         and col[1] in second_level]\n",
    "    ]\n",
    "    .stack(0)\n",
    ").join(df_fortum[\"name\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "What happens here is that we take only the columns that have word \"address\" in the first level (ie. addresses 0) and the second level must in the list \"street\", \"postCode\", \"city\", \"country\" or \"endDate\". Then we put the first level as index level (\"stack(0)\") and join the name column to the results.\n",
    "\n",
    "Note that the data is straight from the API and may have confusing fields (ie. there might not be a city named as \"Fortum\"). This has nothing to do with this software.\n",
    "\n",
    "Easy and convenient way to transform the data. We can also use the same method with other columns:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>change</th>\n",
       "      <th>changeDate</th>\n",
       "      <th>newBusinessId</th>\n",
       "      <th>oldBusinessId</th>\n",
       "      <th>source</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2679784-7</th>\n",
       "      <th>businessIdChanges 0</th>\n",
       "      <td>DIF</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>2679784-7</td>\n",
       "      <td>1852303-7</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 1</th>\n",
       "      <td>47</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>2679784-7</td>\n",
       "      <td>1852303-7</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2059590-2</th>\n",
       "      <th>businessIdChanges 0</th>\n",
       "      <td>FUU</td>\n",
       "      <td>2007-05-01</td>\n",
       "      <td>1852328-0</td>\n",
       "      <td>2059590-2</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 1</th>\n",
       "      <td>DIF</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>2059590-2</td>\n",
       "      <td>0100468-7</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 2</th>\n",
       "      <td>47</td>\n",
       "      <td>2007-01-01</td>\n",
       "      <td>2059590-2</td>\n",
       "      <td>0100468-7</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">2059592-9</th>\n",
       "      <th>businessIdChanges 0</th>\n",
       "      <td>FUU</td>\n",
       "      <td>2007-05-01</td>\n",
       "      <td>0109160-2</td>\n",
       "      <td>2059592-9</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 1</th>\n",
       "      <td>DIF</td>\n",
       "      <td>2006-12-31</td>\n",
       "      <td>2059592-9</td>\n",
       "      <td>0100468-7</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 2</th>\n",
       "      <td>47</td>\n",
       "      <td>2007-01-01</td>\n",
       "      <td>2059592-9</td>\n",
       "      <td>0100468-7</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">1852328-0</th>\n",
       "      <th>businessIdChanges 0</th>\n",
       "      <td>FUU</td>\n",
       "      <td>2013-05-31</td>\n",
       "      <td>1852328-0</td>\n",
       "      <td>1466058-7</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 1</th>\n",
       "      <td>44</td>\n",
       "      <td>2013-06-01</td>\n",
       "      <td>1852328-0</td>\n",
       "      <td>1466058-7</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 2</th>\n",
       "      <td>DIF</td>\n",
       "      <td>2004-02-01</td>\n",
       "      <td>1852328-0</td>\n",
       "      <td>1570867-7</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 3</th>\n",
       "      <td>FUU</td>\n",
       "      <td>2006-01-12</td>\n",
       "      <td>1852328-0</td>\n",
       "      <td>1759819-2</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 4</th>\n",
       "      <td>FUU</td>\n",
       "      <td>2007-05-01</td>\n",
       "      <td>1852328-0</td>\n",
       "      <td>2059590-2</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">1852303-7</th>\n",
       "      <th>businessIdChanges 0</th>\n",
       "      <td>DIF</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>2679784-7</td>\n",
       "      <td>1852303-7</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 1</th>\n",
       "      <td>47</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>2679784-7</td>\n",
       "      <td>1852303-7</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessIdChanges 2</th>\n",
       "      <td>DIF</td>\n",
       "      <td>2004-05-01</td>\n",
       "      <td>1852303-7</td>\n",
       "      <td>0111973-2</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               change  changeDate newBusinessId oldBusinessId  \\\n",
       "businessId                                                                      \n",
       "2679784-7  businessIdChanges 0    DIF  2015-06-30     2679784-7     1852303-7   \n",
       "           businessIdChanges 1     47  2015-07-01     2679784-7     1852303-7   \n",
       "2059590-2  businessIdChanges 0    FUU  2007-05-01     1852328-0     2059590-2   \n",
       "           businessIdChanges 1    DIF  2006-12-31     2059590-2     0100468-7   \n",
       "           businessIdChanges 2     47  2007-01-01     2059590-2     0100468-7   \n",
       "2059592-9  businessIdChanges 0    FUU  2007-05-01     0109160-2     2059592-9   \n",
       "           businessIdChanges 1    DIF  2006-12-31     2059592-9     0100468-7   \n",
       "           businessIdChanges 2     47  2007-01-01     2059592-9     0100468-7   \n",
       "1852328-0  businessIdChanges 0    FUU  2013-05-31     1852328-0     1466058-7   \n",
       "           businessIdChanges 1     44  2013-06-01     1852328-0     1466058-7   \n",
       "           businessIdChanges 2    DIF  2004-02-01     1852328-0     1570867-7   \n",
       "           businessIdChanges 3    FUU  2006-01-12     1852328-0     1759819-2   \n",
       "           businessIdChanges 4    FUU  2007-05-01     1852328-0     2059590-2   \n",
       "1852303-7  businessIdChanges 0    DIF  2015-06-30     2679784-7     1852303-7   \n",
       "           businessIdChanges 1     47  2015-07-01     2679784-7     1852303-7   \n",
       "           businessIdChanges 2    DIF  2004-05-01     1852303-7     0111973-2   \n",
       "\n",
       "                                source  \n",
       "businessId                              \n",
       "2679784-7  businessIdChanges 0     1.0  \n",
       "           businessIdChanges 1     2.0  \n",
       "2059590-2  businessIdChanges 0     1.0  \n",
       "           businessIdChanges 1     1.0  \n",
       "           businessIdChanges 2     2.0  \n",
       "2059592-9  businessIdChanges 0     1.0  \n",
       "           businessIdChanges 1     1.0  \n",
       "           businessIdChanges 2     2.0  \n",
       "1852328-0  businessIdChanges 0     1.0  \n",
       "           businessIdChanges 1     2.0  \n",
       "           businessIdChanges 2     1.0  \n",
       "           businessIdChanges 3     1.0  \n",
       "           businessIdChanges 4     1.0  \n",
       "1852303-7  businessIdChanges 0     1.0  \n",
       "           businessIdChanges 1     2.0  \n",
       "           businessIdChanges 2     1.0  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "first_level = \"businessIdChanges\"\n",
    "(\n",
    "    df_fortum[\n",
    "        [col for col in df_fortum.columns if col[0].startswith(first_level)]\n",
    "    ]\n",
    "    .stack(0)\n",
    "    .dropna(axis=1, how=\"all\")\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The codes can also easily be turned in the full name. Please see the API documentation for the codings."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>language</th>\n",
       "      <th>registrationDate</th>\n",
       "      <th>source</th>\n",
       "      <th>type</th>\n",
       "      <th>value</th>\n",
       "      <th>version</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>businessId</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2679784-7</th>\n",
       "      <th>contactDetails 2</th>\n",
       "      <td>EN</td>\n",
       "      <td>2015-06-05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Telephone</td>\n",
       "      <td>010 4511</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2481332-1</th>\n",
       "      <th>contactDetails 2</th>\n",
       "      <td>EN</td>\n",
       "      <td>2012-05-30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Telephone</td>\n",
       "      <td>0104511</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2481338-0</th>\n",
       "      <th>contactDetails 2</th>\n",
       "      <td>EN</td>\n",
       "      <td>2012-05-30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Telephone</td>\n",
       "      <td>0104511</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2481336-4</th>\n",
       "      <th>contactDetails 2</th>\n",
       "      <td>EN</td>\n",
       "      <td>2012-05-30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Telephone</td>\n",
       "      <td>0104511</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2185030-3</th>\n",
       "      <th>contactDetails 2</th>\n",
       "      <td>EN</td>\n",
       "      <td>2008-03-20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Telephone</td>\n",
       "      <td>0104511</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2079891-0</th>\n",
       "      <th>contactDetails 11</th>\n",
       "      <td>EN</td>\n",
       "      <td>2007-12-19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fax</td>\n",
       "      <td>0104532353</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contactDetails 8</th>\n",
       "      <td>EN</td>\n",
       "      <td>2007-12-19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Telephone</td>\n",
       "      <td>0104511</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             language registrationDate  source       type  \\\n",
       "businessId                                                                  \n",
       "2679784-7  contactDetails 2        EN       2015-06-05     0.0  Telephone   \n",
       "2481332-1  contactDetails 2        EN       2012-05-30     0.0  Telephone   \n",
       "2481338-0  contactDetails 2        EN       2012-05-30     0.0  Telephone   \n",
       "2481336-4  contactDetails 2        EN       2012-05-30     0.0  Telephone   \n",
       "2185030-3  contactDetails 2        EN       2008-03-20     0.0  Telephone   \n",
       "2079891-0  contactDetails 11       EN       2007-12-19     0.0        Fax   \n",
       "           contactDetails 8        EN       2007-12-19     0.0  Telephone   \n",
       "\n",
       "                                   value  version  \n",
       "businessId                                         \n",
       "2679784-7  contactDetails 2     010 4511      1.0  \n",
       "2481332-1  contactDetails 2      0104511      1.0  \n",
       "2481338-0  contactDetails 2      0104511      1.0  \n",
       "2481336-4  contactDetails 2      0104511      1.0  \n",
       "2185030-3  contactDetails 2      0104511      1.0  \n",
       "2079891-0  contactDetails 11  0104532353      1.0  \n",
       "           contactDetails 8      0104511      1.0  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(\n",
    "    df_fortum[\n",
    "        [col for col in df_fortum.columns if col[0].startswith(\"contactDetails\")]\n",
    "    ]\n",
    "    .stack(0)\n",
    "    .query('language == \"EN\" & endDate != endDate')\n",
    "    .dropna(how=\"all\", axis=1)\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Thanks to the versatileness of Pandas, you can also query the data in single line. Note that NaN values are never equal to themselves thus you can query them with using the logic."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Additional Links"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The meaning of \"entryCodes\" and \"typeOfRegistration\" can be found from the API's website.\n",
    "- Entry codes: http://avoindata.prh.fi/tr-codes_v1.fi.txt\n",
    "- Type of Registration: http://avoindata.prh.fi/tr-type_v1.fi.txt"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [default]",
   "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.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}