{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Бюджетные корректировки с использованием API\n",
"\n",
"Эта записная книжка работает на основе API к бюджету на ЕПБС (budget.gov.ru) отслеживание ежедневных изменений\n",
"Оно работает не очень быстро, поэтому некоторые функции могут исполняться до полутора минут.\n"
]
},
{
"cell_type": "code",
"execution_count": 66,
"metadata": {},
"outputs": [],
"source": [
"import sys, os\n",
"import xlrd\n",
"import json\n",
"import pprint\n",
"from IPython.display import HTML, display\n",
"import tabulate\n",
"import datetime\n",
"import requests\n",
"import pandas as pd"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Попробуем получить данные через API ЕПБС. Получим 10 записей за 15"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'data': [['Итого',\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" 14166316872.3,\n",
" 14144857358.1,\n",
" 14404624323],\n",
" ['Министерство промышленности и торговли Российской Федерации',\n",
" '020',\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" 401316349.9,\n",
" 419498420.3,\n",
" 432668900.7],\n",
" ['Общегосударственные вопросы',\n",
" '020',\n",
" '01',\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" 5085188.9,\n",
" 5028368.4,\n",
" 5058241.7],\n",
" ['Международные отношения и международное сотрудничество',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" None,\n",
" None,\n",
" None,\n",
" 4485240.5,\n",
" 4428420,\n",
" 4458293.3],\n",
" ['Государственная программа Российской Федерации \"Развитие внешнеэкономической деятельности\"',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '27000',\n",
" '00000',\n",
" None,\n",
" 4446945.3,\n",
" 4390184.7,\n",
" 4419938.1],\n",
" ['Подпрограмма \"Создание национальной системы поддержки развития внешнеэкономической деятельности\"',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '27300',\n",
" '00000',\n",
" None,\n",
" 4446945.3,\n",
" 4390184.7,\n",
" 4419938.1],\n",
" ['Основное мероприятие \"Развитие деятельности торговых представительств Российской Федерации в иностранных государствах по продвижению экономических интересов в глобальной экономике\"',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '27305',\n",
" '00000',\n",
" None,\n",
" 4446945.3,\n",
" 4390184.7,\n",
" 4419938.1],\n",
" ['Финансовое обеспечение выполнения функций федеральных государственных органов, оказания услуг и выполнения работ',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '27305',\n",
" '90000',\n",
" None,\n",
" 4446945.3,\n",
" 4390184.7,\n",
" 4419938.1],\n",
" ['Расходы на выплаты персоналу в целях обеспечения выполнения функций государственными (муниципальными) органами, казенными учреждениями, органами управления государственными внебюджетными фондами',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '27305',\n",
" '90000',\n",
" '100',\n",
" 3522452.6,\n",
" 3478587.8,\n",
" 3494306.1],\n",
" ['Закупка товаров, работ и услуг для обеспечения государственных (муниципальных) нужд',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '27305',\n",
" '90000',\n",
" '200',\n",
" 924286.1,\n",
" 911382,\n",
" 925417.1]],\n",
" 'total': 11402,\n",
" 'totalLimit': False}"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"TEST_URL = 'http://budget.gov.ru/epbs/reporting/Data?uuid=309a092f-777d-43ea-9f83-4b0370c7dcc2&dataVersion=15.03.2019%2006.58.00.271&dsCode=EBPS_177_001_BA_GridData&EBPS_177_001_BA_SearchIndFilter=kvsrName&EPBS_177_TreeFilter=1&rangeDatePickerFilter=18.06.2019&EPBS_177_periodFilter=2019&EPBS_177_budgetFilter=00000001&EBPS_177_001_BA_SearchFilter=&SBR_paramPeriod=2019-06-05T00:00:00.000Z&_dc=1560852158712&page=1&start=0&limit=10'\n",
"test = requests.get(TEST_URL)\n",
"test.json()\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Превратим код запроса в очень простую функцию и получим записи за 1 января 2019 года. "
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[['Итого',\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" 13723202137.8,\n",
" 14156438822.5,\n",
" 14417691459],\n",
" ['Министерство промышленности и торговли Российской Федерации',\n",
" '020',\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" 376467911.7,\n",
" 412702535.6,\n",
" 428248962.6],\n",
" ['Общегосударственные вопросы',\n",
" '020',\n",
" '01',\n",
" None,\n",
" None,\n",
" None,\n",
" None,\n",
" 638243.6,\n",
" 638183.7,\n",
" 638303.6],\n",
" ['Международные отношения и международное сотрудничество',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" None,\n",
" None,\n",
" None,\n",
" 38295.2,\n",
" 38235.3,\n",
" 38355.2],\n",
" ['Реализация функций иных федеральных органов государственной власти',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '99000',\n",
" '00000',\n",
" None,\n",
" 38295.2,\n",
" 38235.3,\n",
" 38355.2],\n",
" ['Иные непрограммные мероприятия',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '99900',\n",
" '00000',\n",
" None,\n",
" 38295.2,\n",
" 38235.3,\n",
" 38355.2],\n",
" ['Финансовое обеспечение выполнения функций федеральных государственных органов, оказания услуг и выполнения работ',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '99900',\n",
" '90000',\n",
" None,\n",
" 38295.2,\n",
" 38235.3,\n",
" 38355.2],\n",
" ['Иные бюджетные ассигнования',\n",
" '020',\n",
" '01',\n",
" '0108',\n",
" '99900',\n",
" '90000',\n",
" '800',\n",
" 38295.2,\n",
" 38235.3,\n",
" 38355.2],\n",
" ['Прикладные научные исследования в области общегосударственных вопросов',\n",
" '020',\n",
" '01',\n",
" '0112',\n",
" None,\n",
" None,\n",
" None,\n",
" 500000,\n",
" 500000,\n",
" 500000],\n",
" ['Государственная программа Российской Федерации \"Развитие авиационной промышленности\"',\n",
" '020',\n",
" '01',\n",
" '0112',\n",
" '17000',\n",
" '00000',\n",
" None,\n",
" 500000,\n",
" 500000,\n",
" 500000]]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"URLPAT = 'http://budget.gov.ru/epbs/reporting/Data?uuid=309a092f-777d-43ea-9f83-4b0370c7dcc2&dataVersion=15.03.2019%2006.58.00.271&dsCode=EBPS_177_001_BA_GridData&EBPS_177_001_BA_SearchIndFilter=kvsrName&EPBS_177_TreeFilter=1&EPBS_177_periodFilter=2019&EPBS_177_budgetFilter=00000001&EBPS_177_001_BA_SearchFilter=&SBR_paramPeriod=2019-06-05T00:00:00.000Z&_dc=1560852158712&page=1&start=0'\n",
"\n",
"def get_budget_data(adate, datalimit=10):\n",
" url = URLPAT + '&rangeDatePickerFilter=%s' % (adate.strftime('%d.%m.%Y')) + '&limit=%d' % (datalimit)\n",
" r = requests.get(url)\n",
" result = r.json()\n",
" return result['data']\n",
" \n",
"get_budget_data(datetime.date(2019, 1,1), 10)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"А теперь попробуем получить записи за несколько контрольных точек и сравним изменения. Например мы хотим получить сведения о бюджетных корректировках на 1 числа месяцев с января по июнь 2019 года и только в части итоговой суммы за 2019 год. Для этого нам надо запросить минимальное количество записей по каждой дате, посолкольку там итоговая сумма это самая первая запись из которой мы берем значение бюджета на 2019 год как основное поле."
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[{'date': '1.1.2019', 'budget': 13723202137.8},\n",
" {'date': '1.2.2019', 'budget': 14055695549.4},\n",
" {'date': '1.3.2019', 'budget': 14884258965.3},\n",
" {'date': '1.4.2019', 'budget': 14300260451.6},\n",
" {'date': '1.5.2019', 'budget': 14160837306},\n",
" {'date': '1.6.2019', 'budget': 14166696386.5}]"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"table = []\n",
"for m in range(1, 7):\n",
" data = get_budget_data(datetime.date(2019, m, 1), datalimit=10)\n",
" table.append({'date' : '1.%d.2019' % (m), 'budget' : data[0][7]})\n",
"table"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Добавим относительно измерения бюджета и несколько параметр изменения относительно прошлого периода period_change и относительно начала года (baseline_change)"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[{'date': '1.1.2019',\n",
" 'budget': 13723202137,\n",
" 'period_change': 0,\n",
" 'baseline_change': 0},\n",
" {'date': '1.2.2019',\n",
" 'budget': 14055695549,\n",
" 'period_change': 2.42,\n",
" 'baseline_change': 2.42},\n",
" {'date': '1.3.2019',\n",
" 'budget': 14884258965,\n",
" 'period_change': 5.89,\n",
" 'baseline_change': 8.46},\n",
" {'date': '1.4.2019',\n",
" 'budget': 14300260451,\n",
" 'period_change': -3.92,\n",
" 'baseline_change': 4.2},\n",
" {'date': '1.5.2019',\n",
" 'budget': 14160837306,\n",
" 'period_change': -0.97,\n",
" 'baseline_change': 3.19},\n",
" {'date': '1.6.2019',\n",
" 'budget': 14166696386,\n",
" 'period_change': 0.04,\n",
" 'baseline_change': 3.23}]"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"table = []\n",
"data = get_budget_data(datetime.date(2019, 1, 1), datalimit=10)\n",
"baseline = {'date' : '1.1.2019', 'budget' : int(data[0][7]), 'period_change': 0, 'baseline_change' : 0}\n",
"table.append(baseline)\n",
"for m in range(2, 7):\n",
" data = get_budget_data(datetime.date(2019, m, 1), datalimit=10)\n",
" value = int(data[0][7])\n",
"# print(value)\n",
" # print(table[-1])\n",
" record = {'date' : '1.%d.2019' % (m), 'budget' : value, \n",
" 'period_change' : round(100.0*(value - table[-1]['budget']) / table[-1]['budget'], 2),\n",
" 'baseline_change' : round(100.0*(value - baseline['budget']) / baseline['budget'], 2),\n",
" }\n",
" table.append(record)\n",
"table"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"положим полученное в DataFrame и посмотрим на изменения"
]
},
{
"cell_type": "code",
"execution_count": 9,
"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>date</th>\n",
" <th>budget</th>\n",
" <th>period_change</th>\n",
" <th>baseline_change</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1.1.2019</td>\n",
" <td>13723202137</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1.2.2019</td>\n",
" <td>14055695549</td>\n",
" <td>2.42</td>\n",
" <td>2.42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1.3.2019</td>\n",
" <td>14884258965</td>\n",
" <td>5.89</td>\n",
" <td>8.46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1.4.2019</td>\n",
" <td>14300260451</td>\n",
" <td>-3.92</td>\n",
" <td>4.20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1.5.2019</td>\n",
" <td>14160837306</td>\n",
" <td>-0.97</td>\n",
" <td>3.19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>1.6.2019</td>\n",
" <td>14166696386</td>\n",
" <td>0.04</td>\n",
" <td>3.23</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" date budget period_change baseline_change\n",
"0 1.1.2019 13723202137 0.00 0.00\n",
"1 1.2.2019 14055695549 2.42 2.42\n",
"2 1.3.2019 14884258965 5.89 8.46\n",
"3 1.4.2019 14300260451 -3.92 4.20\n",
"4 1.5.2019 14160837306 -0.97 3.19\n",
"5 1.6.2019 14166696386 0.04 3.23"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"fields = ['date', 'budget', 'period_change', 'baseline_change']\n",
"pd.DataFrame(table, columns=fields)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Переделаем теперь изначальную функцию так чтобы мы могли выгрузить все нужные нам данные и работать с ними без дополнительных обращений к API."
]
},
{
"cell_type": "code",
"execution_count": 63,
"metadata": {},
"outputs": [],
"source": [
"FULLURLPAT = 'http://budget.gov.ru/epbs/reporting/Data?uuid=309a092f-777d-43ea-9f83-4b0370c7dcc2&dataVersion=15.03.2019%2006.58.00.271&dsCode=EBPS_177_001_BA_GridData&EBPS_177_001_BA_SearchIndFilter=kvsrName&EPBS_177_TreeFilter=1&EPBS_177_periodFilter=2019&EPBS_177_budgetFilter=00000001&EBPS_177_001_BA_SearchFilter=&SBR_paramPeriod=2019-06-05T00:00:00.000Z&_dc=1560852158712&limit=500'\n",
"BASELIMIT = 500\n",
"keys = ['name', 'grbs', 'topic', 'subtopic', 'csr_program', 'csr_article', 'vr', 'budget2019', 'budget2020', 'budget2021']\n",
"def get_full_budget_data(adate):\n",
" start = 0\n",
" page = 1\n",
" out = []\n",
" while True:\n",
" print('Downloading data for %s' % (str(adate)))\n",
" url = FULLURLPAT + '&rangeDatePickerFilter=%s' % (adate.strftime('%d.%m.%Y')) + '&page=%d' % (page) + '&start=%d' % start\n",
" r = requests.get(url)\n",
" result = r.json()\n",
" if 'data' not in result:\n",
" break\n",
" for res in result['data']:\n",
" out.append(dict(zip(keys, res)))\n",
" if len(result['data']) != BASELIMIT:\n",
" break\n",
" page += 1\n",
" start += BASELIMIT\n",
" return out\n"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [],
"source": [
"full_2019_1_1 = get_full_budget_data(datetime.date(2019, 1,1))\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"создадим DataFrame с которым далее будем работать."
]
},
{
"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>name</th>\n",
" <th>grbs</th>\n",
" <th>topic</th>\n",
" <th>subtopic</th>\n",
" <th>csr_program</th>\n",
" <th>csr_article</th>\n",
" <th>vr</th>\n",
" <th>budget2019</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Итого</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>1.372320e+10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Министерство промышленности и торговли Российс...</td>\n",
" <td>020</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>3.764679e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Общегосударственные вопросы</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>6.382436e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Международные отношения и международное сотруд...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0108</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>3.829520e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Реализация функций иных федеральных органов го...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0108</td>\n",
" <td>99000</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>3.829520e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Иные непрограммные мероприятия</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0108</td>\n",
" <td>99900</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>3.829520e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0108</td>\n",
" <td>99900</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>3.829520e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Иные бюджетные ассигнования</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0108</td>\n",
" <td>99900</td>\n",
" <td>90000</td>\n",
" <td>800</td>\n",
" <td>3.829520e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Прикладные научные исследования в области обще...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0112</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>5.000000e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Государственная программа Российской Федерации...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0112</td>\n",
" <td>17000</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>5.000000e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Подпрограмма \"Авиационная наука и технологии\"</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0112</td>\n",
" <td>17700</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>5.000000e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Основное мероприятие \"Выполнение научно-исслед...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0112</td>\n",
" <td>17702</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>5.000000e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0112</td>\n",
" <td>17702</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>5.000000e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0112</td>\n",
" <td>17702</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>5.000000e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Другие общегосударственные вопросы</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0113</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>9.994840e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Государственная программа Российской Федерации...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0113</td>\n",
" <td>27000</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>9.994840e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Подпрограмма \"Создание национальной системы по...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0113</td>\n",
" <td>27300</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>9.994840e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Основное мероприятие \"Промоутерская поддержка ...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0113</td>\n",
" <td>27302</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>9.994840e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0113</td>\n",
" <td>27302</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>9.994840e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>020</td>\n",
" <td>01</td>\n",
" <td>0113</td>\n",
" <td>27302</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>9.994840e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Национальная оборона</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>3.247580e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Прикладные научные исследования в области наци...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0208</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>2.900000e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Государственная программа Российской Федерации...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0208</td>\n",
" <td>16000</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>2.900000e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Подпрограмма \"Содействие проведению научных ис...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0208</td>\n",
" <td>16600</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>2.900000e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Основное мероприятие \"Научные исследования и с...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0208</td>\n",
" <td>16602</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>2.900000e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0208</td>\n",
" <td>16602</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>2.900000e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0208</td>\n",
" <td>16602</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>2.900000e+03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Другие вопросы в области национальной обороны</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0209</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>3.244680e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Государственная программа Российской Федерации...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0209</td>\n",
" <td>44000</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>3.244680e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Подпрограмма \"Стимулирование развития оборонно...</td>\n",
" <td>020</td>\n",
" <td>02</td>\n",
" <td>0209</td>\n",
" <td>44100</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>3.244680e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10039</th>\n",
" <td>Реализация национального проекта \"Демография\"</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>131P5</td>\n",
" <td>P0000</td>\n",
" <td>None</td>\n",
" <td>1.700000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10040</th>\n",
" <td>Предоставление субсидий бюджетным, автономным ...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>131P5</td>\n",
" <td>P0000</td>\n",
" <td>600</td>\n",
" <td>1.700000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10041</th>\n",
" <td>Основное мероприятие \"Организация и проведение...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13106</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>1.200000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10042</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13106</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>1.200000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10043</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13106</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>1.200000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10044</th>\n",
" <td>Подпрограмма \"Развитие спорта высших достижени...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13200</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>4.157728e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10045</th>\n",
" <td>Основное мероприятие \"Организация и проведение...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13206</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>4.157728e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10046</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13206</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>4.157728e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10047</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13206</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>2.000000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10048</th>\n",
" <td>Предоставление субсидий бюджетным, автономным ...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13206</td>\n",
" <td>90000</td>\n",
" <td>600</td>\n",
" <td>3.957728e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10049</th>\n",
" <td>Федеральная целевая программа \"Развитие физиче...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13600</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>1.000000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10050</th>\n",
" <td>Иные мероприятия федеральной целевой программы</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13699</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>1.000000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10051</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13699</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>1.000000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10052</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1104</td>\n",
" <td>13699</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>1.000000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10053</th>\n",
" <td>Другие вопросы в области физической культуры и...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>9.740692e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10054</th>\n",
" <td>Государственная программа Российской Федерации...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13000</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>9.740692e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10055</th>\n",
" <td>Подпрограмма \"Управление развитием отрасли физ...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13400</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>9.740692e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10056</th>\n",
" <td>Основное мероприятие \"Реализация государственн...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13402</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>9.323346e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10057</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13402</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>9.323346e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10058</th>\n",
" <td>Расходы на выплаты персоналу в целях обеспечен...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13402</td>\n",
" <td>90000</td>\n",
" <td>100</td>\n",
" <td>2.535190e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10059</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13402</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>9.414930e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10060</th>\n",
" <td>Социальное обеспечение и иные выплаты населению</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13402</td>\n",
" <td>90000</td>\n",
" <td>300</td>\n",
" <td>1.800000e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10061</th>\n",
" <td>Капитальные вложения в объекты государственной...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13402</td>\n",
" <td>90000</td>\n",
" <td>400</td>\n",
" <td>4.666633e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10062</th>\n",
" <td>Иные бюджетные ассигнования</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13402</td>\n",
" <td>90000</td>\n",
" <td>800</td>\n",
" <td>1.000030e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10063</th>\n",
" <td>Основное мероприятие \"Развитие международного ...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13404</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10064</th>\n",
" <td>Субсидии на финансовое обеспечение мероприятий...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13404</td>\n",
" <td>60260</td>\n",
" <td>None</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10065</th>\n",
" <td>Предоставление субсидий бюджетным, автономным ...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13404</td>\n",
" <td>60260</td>\n",
" <td>600</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10066</th>\n",
" <td>Основное мероприятие \"Внедрение современных ин...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13405</td>\n",
" <td>00000</td>\n",
" <td>None</td>\n",
" <td>4.173460e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10067</th>\n",
" <td>Финансовое обеспечение выполнения функций феде...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13405</td>\n",
" <td>90000</td>\n",
" <td>None</td>\n",
" <td>4.173460e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10068</th>\n",
" <td>Закупка товаров, работ и услуг для обеспечения...</td>\n",
" <td>777</td>\n",
" <td>11</td>\n",
" <td>1105</td>\n",
" <td>13405</td>\n",
" <td>90000</td>\n",
" <td>200</td>\n",
" <td>4.173460e+04</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10069 rows × 8 columns</p>\n",
"</div>"
],
"text/plain": [
" name grbs topic subtopic \\\n",
"0 Итого None None None \n",
"1 Министерство промышленности и торговли Российс... 020 None None \n",
"2 Общегосударственные вопросы 020 01 None \n",
"3 Международные отношения и международное сотруд... 020 01 0108 \n",
"4 Реализация функций иных федеральных органов го... 020 01 0108 \n",
"5 Иные непрограммные мероприятия 020 01 0108 \n",
"6 Финансовое обеспечение выполнения функций феде... 020 01 0108 \n",
"7 Иные бюджетные ассигнования 020 01 0108 \n",
"8 Прикладные научные исследования в области обще... 020 01 0112 \n",
"9 Государственная программа Российской Федерации... 020 01 0112 \n",
"10 Подпрограмма \"Авиационная наука и технологии\" 020 01 0112 \n",
"11 Основное мероприятие \"Выполнение научно-исслед... 020 01 0112 \n",
"12 Финансовое обеспечение выполнения функций феде... 020 01 0112 \n",
"13 Закупка товаров, работ и услуг для обеспечения... 020 01 0112 \n",
"14 Другие общегосударственные вопросы 020 01 0113 \n",
"15 Государственная программа Российской Федерации... 020 01 0113 \n",
"16 Подпрограмма \"Создание национальной системы по... 020 01 0113 \n",
"17 Основное мероприятие \"Промоутерская поддержка ... 020 01 0113 \n",
"18 Финансовое обеспечение выполнения функций феде... 020 01 0113 \n",
"19 Закупка товаров, работ и услуг для обеспечения... 020 01 0113 \n",
"20 Национальная оборона 020 02 None \n",
"21 Прикладные научные исследования в области наци... 020 02 0208 \n",
"22 Государственная программа Российской Федерации... 020 02 0208 \n",
"23 Подпрограмма \"Содействие проведению научных ис... 020 02 0208 \n",
"24 Основное мероприятие \"Научные исследования и с... 020 02 0208 \n",
"25 Финансовое обеспечение выполнения функций феде... 020 02 0208 \n",
"26 Закупка товаров, работ и услуг для обеспечения... 020 02 0208 \n",
"27 Другие вопросы в области национальной обороны 020 02 0209 \n",
"28 Государственная программа Российской Федерации... 020 02 0209 \n",
"29 Подпрограмма \"Стимулирование развития оборонно... 020 02 0209 \n",
"... ... ... ... ... \n",
"10039 Реализация национального проекта \"Демография\" 777 11 1104 \n",
"10040 Предоставление субсидий бюджетным, автономным ... 777 11 1104 \n",
"10041 Основное мероприятие \"Организация и проведение... 777 11 1104 \n",
"10042 Финансовое обеспечение выполнения функций феде... 777 11 1104 \n",
"10043 Закупка товаров, работ и услуг для обеспечения... 777 11 1104 \n",
"10044 Подпрограмма \"Развитие спорта высших достижени... 777 11 1104 \n",
"10045 Основное мероприятие \"Организация и проведение... 777 11 1104 \n",
"10046 Финансовое обеспечение выполнения функций феде... 777 11 1104 \n",
"10047 Закупка товаров, работ и услуг для обеспечения... 777 11 1104 \n",
"10048 Предоставление субсидий бюджетным, автономным ... 777 11 1104 \n",
"10049 Федеральная целевая программа \"Развитие физиче... 777 11 1104 \n",
"10050 Иные мероприятия федеральной целевой программы 777 11 1104 \n",
"10051 Финансовое обеспечение выполнения функций феде... 777 11 1104 \n",
"10052 Закупка товаров, работ и услуг для обеспечения... 777 11 1104 \n",
"10053 Другие вопросы в области физической культуры и... 777 11 1105 \n",
"10054 Государственная программа Российской Федерации... 777 11 1105 \n",
"10055 Подпрограмма \"Управление развитием отрасли физ... 777 11 1105 \n",
"10056 Основное мероприятие \"Реализация государственн... 777 11 1105 \n",
"10057 Финансовое обеспечение выполнения функций феде... 777 11 1105 \n",
"10058 Расходы на выплаты персоналу в целях обеспечен... 777 11 1105 \n",
"10059 Закупка товаров, работ и услуг для обеспечения... 777 11 1105 \n",
"10060 Социальное обеспечение и иные выплаты населению 777 11 1105 \n",
"10061 Капитальные вложения в объекты государственной... 777 11 1105 \n",
"10062 Иные бюджетные ассигнования 777 11 1105 \n",
"10063 Основное мероприятие \"Развитие международного ... 777 11 1105 \n",
"10064 Субсидии на финансовое обеспечение мероприятий... 777 11 1105 \n",
"10065 Предоставление субсидий бюджетным, автономным ... 777 11 1105 \n",
"10066 Основное мероприятие \"Внедрение современных ин... 777 11 1105 \n",
"10067 Финансовое обеспечение выполнения функций феде... 777 11 1105 \n",
"10068 Закупка товаров, работ и услуг для обеспечения... 777 11 1105 \n",
"\n",
" csr_program csr_article vr budget2019 \n",
"0 None None None 1.372320e+10 \n",
"1 None None None 3.764679e+08 \n",
"2 None None None 6.382436e+05 \n",
"3 None None None 3.829520e+04 \n",
"4 99000 00000 None 3.829520e+04 \n",
"5 99900 00000 None 3.829520e+04 \n",
"6 99900 90000 None 3.829520e+04 \n",
"7 99900 90000 800 3.829520e+04 \n",
"8 None None None 5.000000e+05 \n",
"9 17000 00000 None 5.000000e+05 \n",
"10 17700 00000 None 5.000000e+05 \n",
"11 17702 00000 None 5.000000e+05 \n",
"12 17702 90000 None 5.000000e+05 \n",
"13 17702 90000 200 5.000000e+05 \n",
"14 None None None 9.994840e+04 \n",
"15 27000 00000 None 9.994840e+04 \n",
"16 27300 00000 None 9.994840e+04 \n",
"17 27302 00000 None 9.994840e+04 \n",
"18 27302 90000 None 9.994840e+04 \n",
"19 27302 90000 200 9.994840e+04 \n",
"20 None None None 3.247580e+06 \n",
"21 None None None 2.900000e+03 \n",
"22 16000 00000 None 2.900000e+03 \n",
"23 16600 00000 None 2.900000e+03 \n",
"24 16602 00000 None 2.900000e+03 \n",
"25 16602 90000 None 2.900000e+03 \n",
"26 16602 90000 200 2.900000e+03 \n",
"27 None None None 3.244680e+06 \n",
"28 44000 00000 None 3.244680e+06 \n",
"29 44100 00000 None 3.244680e+06 \n",
"... ... ... ... ... \n",
"10039 131P5 P0000 None 1.700000e+04 \n",
"10040 131P5 P0000 600 1.700000e+04 \n",
"10041 13106 00000 None 1.200000e+04 \n",
"10042 13106 90000 None 1.200000e+04 \n",
"10043 13106 90000 200 1.200000e+04 \n",
"10044 13200 00000 None 4.157728e+05 \n",
"10045 13206 00000 None 4.157728e+05 \n",
"10046 13206 90000 None 4.157728e+05 \n",
"10047 13206 90000 200 2.000000e+04 \n",
"10048 13206 90000 600 3.957728e+05 \n",
"10049 13600 00000 None 1.000000e+04 \n",
"10050 13699 00000 None 1.000000e+04 \n",
"10051 13699 90000 None 1.000000e+04 \n",
"10052 13699 90000 200 1.000000e+04 \n",
"10053 None None None 9.740692e+05 \n",
"10054 13000 00000 None 9.740692e+05 \n",
"10055 13400 00000 None 9.740692e+05 \n",
"10056 13402 00000 None 9.323346e+05 \n",
"10057 13402 90000 None 9.323346e+05 \n",
"10058 13402 90000 100 2.535190e+05 \n",
"10059 13402 90000 200 9.414930e+04 \n",
"10060 13402 90000 300 1.800000e+04 \n",
"10061 13402 90000 400 4.666633e+05 \n",
"10062 13402 90000 800 1.000030e+05 \n",
"10063 13404 00000 None 0.000000e+00 \n",
"10064 13404 60260 None 0.000000e+00 \n",
"10065 13404 60260 600 0.000000e+00 \n",
"10066 13405 00000 None 4.173460e+04 \n",
"10067 13405 90000 None 4.173460e+04 \n",
"10068 13405 90000 200 4.173460e+04 \n",
"\n",
"[10069 rows x 8 columns]"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"fields = ['name', 'grbs', 'topic', 'subtopic', 'csr_program', 'csr_article', 'vr', 'budget2019']\n",
"df = pd.DataFrame(full_2019_1_1, columns=fields)\n",
"df"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"А теперь сделаем выборку всех главных распределителей средств и то сколько средств выделено каждому из них."
]
},
{
"cell_type": "code",
"execution_count": 37,
"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>name</th>\n",
" <th>grbs</th>\n",
" <th>budget2019</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Министерство промышленности и торговли Российс...</td>\n",
" <td>020</td>\n",
" <td>3.764679e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>476</th>\n",
" <td>Министерство энергетики Российской Федерации</td>\n",
" <td>022</td>\n",
" <td>2.487886e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>548</th>\n",
" <td>Федеральная служба по надзору в сфере природоп...</td>\n",
" <td>048</td>\n",
" <td>4.295335e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>601</th>\n",
" <td>Федеральное агентство по недропользованию</td>\n",
" <td>049</td>\n",
" <td>2.891225e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>676</th>\n",
" <td>Министерство природных ресурсов и экологии Рос...</td>\n",
" <td>051</td>\n",
" <td>1.331377e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>839</th>\n",
" <td>Федеральное агентство водных ресурсов</td>\n",
" <td>052</td>\n",
" <td>1.296149e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>899</th>\n",
" <td>Федеральное агентство лесного хозяйства</td>\n",
" <td>053</td>\n",
" <td>3.244217e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>980</th>\n",
" <td>Министерство культуры Российской Федерации</td>\n",
" <td>054</td>\n",
" <td>1.153294e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1229</th>\n",
" <td>Министерство здравоохранения Российской Федерации</td>\n",
" <td>056</td>\n",
" <td>2.503724e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1538</th>\n",
" <td>Федеральная служба по надзору в сфере здравоох...</td>\n",
" <td>060</td>\n",
" <td>3.338408e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1563</th>\n",
" <td>Министерство строительства и жилищно-коммуналь...</td>\n",
" <td>069</td>\n",
" <td>6.040740e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1769</th>\n",
" <td>Министерство цифрового развития, связи и массо...</td>\n",
" <td>071</td>\n",
" <td>6.406013e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1891</th>\n",
" <td>Министерство просвещения Российской Федерации</td>\n",
" <td>073</td>\n",
" <td>3.834346e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2172</th>\n",
" <td>Министерство науки и высшего образования Росси...</td>\n",
" <td>075</td>\n",
" <td>5.044598e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2615</th>\n",
" <td>Федеральное агентство по рыболовству</td>\n",
" <td>076</td>\n",
" <td>1.783492e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2770</th>\n",
" <td>Федеральная служба по надзору в сфере образова...</td>\n",
" <td>077</td>\n",
" <td>1.983256e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2806</th>\n",
" <td>Федеральная служба по ветеринарному и фитосани...</td>\n",
" <td>081</td>\n",
" <td>1.481795e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2865</th>\n",
" <td>Министерство сельского хозяйства Российской Фе...</td>\n",
" <td>082</td>\n",
" <td>2.627092e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3046</th>\n",
" <td>Федеральное агентство связи</td>\n",
" <td>084</td>\n",
" <td>2.877481e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3113</th>\n",
" <td>Государственная фельдъегерская служба Российск...</td>\n",
" <td>089</td>\n",
" <td>3.758104e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3163</th>\n",
" <td>Федеральное агентство по делам молодежи</td>\n",
" <td>091</td>\n",
" <td>6.529040e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3210</th>\n",
" <td>Министерство финансов Российской Федерации</td>\n",
" <td>092</td>\n",
" <td>5.438722e+09</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3650</th>\n",
" <td>Федеральное агентство по делам Содружества Нез...</td>\n",
" <td>095</td>\n",
" <td>3.741280e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3713</th>\n",
" <td>Федеральная служба по надзору в сфере связи, и...</td>\n",
" <td>096</td>\n",
" <td>7.858479e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3754</th>\n",
" <td>Федеральное казначейство</td>\n",
" <td>100</td>\n",
" <td>3.703851e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3778</th>\n",
" <td>Министерство транспорта Российской Федерации</td>\n",
" <td>103</td>\n",
" <td>7.532092e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3946</th>\n",
" <td>Федеральная служба по надзору в сфере транспорта</td>\n",
" <td>106</td>\n",
" <td>4.831153e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3982</th>\n",
" <td>Федеральное агентство воздушного транспорта</td>\n",
" <td>107</td>\n",
" <td>4.835771e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4112</th>\n",
" <td>Федеральное дорожное агентство</td>\n",
" <td>108</td>\n",
" <td>4.929200e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4217</th>\n",
" <td>Федеральное агентство железнодорожного транспорта</td>\n",
" <td>109</td>\n",
" <td>8.224422e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7961</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>319</td>\n",
" <td>4.337353e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7975</th>\n",
" <td>Федеральная служба исполнения наказаний</td>\n",
" <td>320</td>\n",
" <td>2.814905e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8180</th>\n",
" <td>Федеральная служба государственной регистрации...</td>\n",
" <td>321</td>\n",
" <td>3.714834e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8249</th>\n",
" <td>Федеральная служба судебных приставов</td>\n",
" <td>322</td>\n",
" <td>4.850585e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8305</th>\n",
" <td>Государственная Дума Федерального Собрания Рос...</td>\n",
" <td>330</td>\n",
" <td>1.102721e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8344</th>\n",
" <td>Совет Федерации Федерального Собрания Российск...</td>\n",
" <td>333</td>\n",
" <td>5.851871e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8383</th>\n",
" <td>Министерство Российской Федерации по развитию ...</td>\n",
" <td>350</td>\n",
" <td>4.555481e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8444</th>\n",
" <td>Министерство Российской Федерации по делам Сев...</td>\n",
" <td>370</td>\n",
" <td>2.514073e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8547</th>\n",
" <td>Федеральное агентство по делам национальностей</td>\n",
" <td>380</td>\n",
" <td>1.943792e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8612</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>384</td>\n",
" <td>1.058232e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8684</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>385</td>\n",
" <td>9.657518e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8736</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>386</td>\n",
" <td>1.716879e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8798</th>\n",
" <td>Федеральное медико-биологическое агентство</td>\n",
" <td>388</td>\n",
" <td>5.388145e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8980</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>409</td>\n",
" <td>5.143250e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8991</th>\n",
" <td>Генеральная прокуратура Российской Федерации</td>\n",
" <td>415</td>\n",
" <td>9.592836e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9127</th>\n",
" <td>Следственный комитет Российской Федерации</td>\n",
" <td>417</td>\n",
" <td>4.334312e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9234</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>424</td>\n",
" <td>2.595145e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9254</th>\n",
" <td>Конституционный Суд Российской Федерации</td>\n",
" <td>436</td>\n",
" <td>6.874974e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9281</th>\n",
" <td>Верховный Суд Российской Федерации</td>\n",
" <td>437</td>\n",
" <td>5.350487e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9366</th>\n",
" <td>Судебный департамент при Верховном Суде Россий...</td>\n",
" <td>438</td>\n",
" <td>2.005092e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9439</th>\n",
" <td>Федеральная служба по экологическому, технолог...</td>\n",
" <td>498</td>\n",
" <td>5.106355e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9492</th>\n",
" <td>Федеральная служба по техническому и экспортно...</td>\n",
" <td>587</td>\n",
" <td>2.745650e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9500</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>595</td>\n",
" <td>1.809080e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9564</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>597</td>\n",
" <td>4.277213e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9573</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>693</td>\n",
" <td>2.222052e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9600</th>\n",
" <td>Федеральная служба по военно-техническому сотр...</td>\n",
" <td>721</td>\n",
" <td>6.279254e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9622</th>\n",
" <td>Федеральная служба по финансовому мониторингу</td>\n",
" <td>724</td>\n",
" <td>1.555656e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9659</th>\n",
" <td>Государственная корпорация по атомной энергии ...</td>\n",
" <td>725</td>\n",
" <td>7.607547e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9768</th>\n",
" <td>Государственная корпорация по космической деят...</td>\n",
" <td>730</td>\n",
" <td>1.231372e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9883</th>\n",
" <td>Министерство спорта Российской Федерации</td>\n",
" <td>777</td>\n",
" <td>4.232135e+07</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>93 rows × 3 columns</p>\n",
"</div>"
],
"text/plain": [
" name grbs budget2019\n",
"1 Министерство промышленности и торговли Российс... 020 3.764679e+08\n",
"476 Министерство энергетики Российской Федерации 022 2.487886e+07\n",
"548 Федеральная служба по надзору в сфере природоп... 048 4.295335e+06\n",
"601 Федеральное агентство по недропользованию 049 2.891225e+07\n",
"676 Министерство природных ресурсов и экологии Рос... 051 1.331377e+07\n",
"839 Федеральное агентство водных ресурсов 052 1.296149e+07\n",
"899 Федеральное агентство лесного хозяйства 053 3.244217e+07\n",
"980 Министерство культуры Российской Федерации 054 1.153294e+08\n",
"1229 Министерство здравоохранения Российской Федерации 056 2.503724e+08\n",
"1538 Федеральная служба по надзору в сфере здравоох... 060 3.338408e+06\n",
"1563 Министерство строительства и жилищно-коммуналь... 069 6.040740e+07\n",
"1769 Министерство цифрового развития, связи и массо... 071 6.406013e+07\n",
"1891 Министерство просвещения Российской Федерации 073 3.834346e+07\n",
"2172 Министерство науки и высшего образования Росси... 075 5.044598e+08\n",
"2615 Федеральное агентство по рыболовству 076 1.783492e+07\n",
"2770 Федеральная служба по надзору в сфере образова... 077 1.983256e+06\n",
"2806 Федеральная служба по ветеринарному и фитосани... 081 1.481795e+07\n",
"2865 Министерство сельского хозяйства Российской Фе... 082 2.627092e+08\n",
"3046 Федеральное агентство связи 084 2.877481e+07\n",
"3113 Государственная фельдъегерская служба Российск... 089 3.758104e+06\n",
"3163 Федеральное агентство по делам молодежи 091 6.529040e+06\n",
"3210 Министерство финансов Российской Федерации 092 5.438722e+09\n",
"3650 Федеральное агентство по делам Содружества Нез... 095 3.741280e+06\n",
"3713 Федеральная служба по надзору в сфере связи, и... 096 7.858479e+06\n",
"3754 Федеральное казначейство 100 3.703851e+07\n",
"3778 Министерство транспорта Российской Федерации 103 7.532092e+07\n",
"3946 Федеральная служба по надзору в сфере транспорта 106 4.831153e+06\n",
"3982 Федеральное агентство воздушного транспорта 107 4.835771e+07\n",
"4112 Федеральное дорожное агентство 108 4.929200e+08\n",
"4217 Федеральное агентство железнодорожного транспорта 109 8.224422e+07\n",
"... ... ... ...\n",
"7961 Федеральное государственное бюджетное учрежден... 319 4.337353e+06\n",
"7975 Федеральная служба исполнения наказаний 320 2.814905e+08\n",
"8180 Федеральная служба государственной регистрации... 321 3.714834e+07\n",
"8249 Федеральная служба судебных приставов 322 4.850585e+07\n",
"8305 Государственная Дума Федерального Собрания Рос... 330 1.102721e+07\n",
"8344 Совет Федерации Федерального Собрания Российск... 333 5.851871e+06\n",
"8383 Министерство Российской Федерации по развитию ... 350 4.555481e+07\n",
"8444 Министерство Российской Федерации по делам Сев... 370 2.514073e+07\n",
"8547 Федеральное агентство по делам национальностей 380 1.943792e+06\n",
"8612 Федеральное государственное бюджетное образова... 384 1.058232e+07\n",
"8684 Федеральное государственное бюджетное образова... 385 9.657518e+06\n",
"8736 Федеральное государственное бюджетное образова... 386 1.716879e+07\n",
"8798 Федеральное медико-биологическое агентство 388 5.388145e+07\n",
"8980 Федеральное государственное бюджетное учрежден... 409 5.143250e+06\n",
"8991 Генеральная прокуратура Российской Федерации 415 9.592836e+07\n",
"9127 Следственный комитет Российской Федерации 417 4.334312e+07\n",
"9234 Федеральное государственное бюджетное образова... 424 2.595145e+05\n",
"9254 Конституционный Суд Российской Федерации 436 6.874974e+05\n",
"9281 Верховный Суд Российской Федерации 437 5.350487e+06\n",
"9366 Судебный департамент при Верховном Суде Россий... 438 2.005092e+08\n",
"9439 Федеральная служба по экологическому, технолог... 498 5.106355e+06\n",
"9492 Федеральная служба по техническому и экспортно... 587 2.745650e+04\n",
"9500 Федеральное государственное бюджетное учрежден... 595 1.809080e+07\n",
"9564 Федеральное государственное бюджетное учрежден... 597 4.277213e+06\n",
"9573 Федеральное государственное бюджетное учрежден... 693 2.222052e+07\n",
"9600 Федеральная служба по военно-техническому сотр... 721 6.279254e+05\n",
"9622 Федеральная служба по финансовому мониторингу 724 1.555656e+06\n",
"9659 Государственная корпорация по атомной энергии ... 725 7.607547e+07\n",
"9768 Государственная корпорация по космической деят... 730 1.231372e+08\n",
"9883 Министерство спорта Российской Федерации 777 4.232135e+07\n",
"\n",
"[93 rows x 3 columns]"
]
},
"execution_count": 37,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['topic'].unique()\n",
"df_grbs = df.loc[df['topic'].isnull()].loc[df['grbs'].isnull() == False][['name','grbs', 'budget2019']]\n",
"df_grbs\n",
"#df_grbs.sort_values(by=['grbs'], ascending=True)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"А теперь получим данные по бюджету на 1 июня 2019 года для того чтобы дальше сравнить с данными за 1 января 2019"
]
},
{
"cell_type": "code",
"execution_count": 38,
"metadata": {},
"outputs": [],
"source": [
"full_2019_6_1 = get_full_budget_data(datetime.date(2019, 6,1))"
]
},
{
"cell_type": "code",
"execution_count": 45,
"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>name</th>\n",
" <th>grbs</th>\n",
" <th>budget2019</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Министерство промышленности и торговли Российс...</td>\n",
" <td>020</td>\n",
" <td>3.992163e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>531</th>\n",
" <td>Министерство энергетики Российской Федерации</td>\n",
" <td>022</td>\n",
" <td>2.757244e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>617</th>\n",
" <td>Федеральная служба по надзору в сфере природоп...</td>\n",
" <td>048</td>\n",
" <td>5.421428e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>680</th>\n",
" <td>Федеральное агентство по недропользованию</td>\n",
" <td>049</td>\n",
" <td>3.333260e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>761</th>\n",
" <td>Министерство природных ресурсов и экологии Рос...</td>\n",
" <td>051</td>\n",
" <td>1.420432e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>945</th>\n",
" <td>Федеральное агентство водных ресурсов</td>\n",
" <td>052</td>\n",
" <td>1.359286e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1011</th>\n",
" <td>Федеральное агентство лесного хозяйства</td>\n",
" <td>053</td>\n",
" <td>3.267829e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1099</th>\n",
" <td>Министерство культуры Российской Федерации</td>\n",
" <td>054</td>\n",
" <td>1.272740e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1370</th>\n",
" <td>Министерство здравоохранения Российской Федерации</td>\n",
" <td>056</td>\n",
" <td>2.869828e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1715</th>\n",
" <td>Федеральная служба по надзору в сфере здравоох...</td>\n",
" <td>060</td>\n",
" <td>3.783840e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1753</th>\n",
" <td>Министерство строительства и жилищно-коммуналь...</td>\n",
" <td>069</td>\n",
" <td>7.217885e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1990</th>\n",
" <td>Министерство цифрового развития, связи и массо...</td>\n",
" <td>071</td>\n",
" <td>6.447565e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2126</th>\n",
" <td>Министерство просвещения Российской Федерации</td>\n",
" <td>073</td>\n",
" <td>4.641098e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2449</th>\n",
" <td>Министерство науки и высшего образования Росси...</td>\n",
" <td>075</td>\n",
" <td>5.231231e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2938</th>\n",
" <td>Федеральное агентство по рыболовству</td>\n",
" <td>076</td>\n",
" <td>1.870721e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3109</th>\n",
" <td>Федеральная служба по надзору в сфере образова...</td>\n",
" <td>077</td>\n",
" <td>2.105152e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3162</th>\n",
" <td>Федеральная служба по ветеринарному и фитосани...</td>\n",
" <td>081</td>\n",
" <td>1.721586e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3228</th>\n",
" <td>Министерство сельского хозяйства Российской Фе...</td>\n",
" <td>082</td>\n",
" <td>2.669051e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3432</th>\n",
" <td>Федеральное агентство связи</td>\n",
" <td>084</td>\n",
" <td>2.883499e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3509</th>\n",
" <td>Государственная фельдъегерская служба Российск...</td>\n",
" <td>089</td>\n",
" <td>3.805020e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3564</th>\n",
" <td>Федеральное агентство по делам молодежи</td>\n",
" <td>091</td>\n",
" <td>6.703716e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3632</th>\n",
" <td>Министерство финансов Российской Федерации</td>\n",
" <td>092</td>\n",
" <td>5.425660e+09</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4089</th>\n",
" <td>Федеральное агентство по делам Содружества Нез...</td>\n",
" <td>095</td>\n",
" <td>3.989999e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4158</th>\n",
" <td>Федеральная служба по надзору в сфере связи, и...</td>\n",
" <td>096</td>\n",
" <td>9.201630e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4208</th>\n",
" <td>Федеральное казначейство</td>\n",
" <td>100</td>\n",
" <td>4.769361e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4246</th>\n",
" <td>Министерство транспорта Российской Федерации</td>\n",
" <td>103</td>\n",
" <td>8.277031e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4450</th>\n",
" <td>Федеральная служба по надзору в сфере транспорта</td>\n",
" <td>106</td>\n",
" <td>6.122622e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4499</th>\n",
" <td>Федеральное агентство воздушного транспорта</td>\n",
" <td>107</td>\n",
" <td>5.472618e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4651</th>\n",
" <td>Федеральное дорожное агентство</td>\n",
" <td>108</td>\n",
" <td>5.152407e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4773</th>\n",
" <td>Федеральное агентство железнодорожного транспорта</td>\n",
" <td>109</td>\n",
" <td>8.347352e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9019</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>319</td>\n",
" <td>4.337353e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9033</th>\n",
" <td>Федеральная служба исполнения наказаний</td>\n",
" <td>320</td>\n",
" <td>2.858950e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9244</th>\n",
" <td>Федеральная служба государственной регистрации...</td>\n",
" <td>321</td>\n",
" <td>4.508648e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9320</th>\n",
" <td>Федеральная служба судебных приставов</td>\n",
" <td>322</td>\n",
" <td>5.585255e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9382</th>\n",
" <td>Государственная Дума Федерального Собрания Рос...</td>\n",
" <td>330</td>\n",
" <td>1.102791e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9427</th>\n",
" <td>Совет Федерации Федерального Собрания Российск...</td>\n",
" <td>333</td>\n",
" <td>5.913998e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9473</th>\n",
" <td>Министерство Российской Федерации по развитию ...</td>\n",
" <td>350</td>\n",
" <td>5.675673e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9547</th>\n",
" <td>Министерство Российской Федерации по делам Сев...</td>\n",
" <td>370</td>\n",
" <td>2.548919e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9656</th>\n",
" <td>Федеральное агентство по делам национальностей</td>\n",
" <td>380</td>\n",
" <td>2.810832e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9733</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>384</td>\n",
" <td>1.062050e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9805</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>385</td>\n",
" <td>9.671824e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9865</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>386</td>\n",
" <td>1.721704e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9935</th>\n",
" <td>Федеральное медико-биологическое агентство</td>\n",
" <td>388</td>\n",
" <td>5.570812e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10142</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>409</td>\n",
" <td>5.143250e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10153</th>\n",
" <td>Генеральная прокуратура Российской Федерации</td>\n",
" <td>415</td>\n",
" <td>9.709056e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10296</th>\n",
" <td>Следственный комитет Российской Федерации</td>\n",
" <td>417</td>\n",
" <td>4.415449e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10409</th>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>424</td>\n",
" <td>2.595145e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10429</th>\n",
" <td>Конституционный Суд Российской Федерации</td>\n",
" <td>436</td>\n",
" <td>8.905147e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10462</th>\n",
" <td>Верховный Суд Российской Федерации</td>\n",
" <td>437</td>\n",
" <td>6.058675e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10549</th>\n",
" <td>Судебный департамент при Верховном Суде Россий...</td>\n",
" <td>438</td>\n",
" <td>2.263284e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10624</th>\n",
" <td>Федеральная служба по экологическому, технолог...</td>\n",
" <td>498</td>\n",
" <td>6.972328e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10690</th>\n",
" <td>Федеральная служба по техническому и экспортно...</td>\n",
" <td>587</td>\n",
" <td>5.730840e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10705</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>595</td>\n",
" <td>1.809306e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10775</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>597</td>\n",
" <td>4.277213e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10784</th>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>693</td>\n",
" <td>2.222052e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10811</th>\n",
" <td>Федеральная служба по военно-техническому сотр...</td>\n",
" <td>721</td>\n",
" <td>7.831110e+05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10846</th>\n",
" <td>Федеральная служба по финансовому мониторингу</td>\n",
" <td>724</td>\n",
" <td>1.851832e+06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10889</th>\n",
" <td>Государственная корпорация по атомной энергии ...</td>\n",
" <td>725</td>\n",
" <td>7.658831e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10998</th>\n",
" <td>Государственная корпорация по космической деят...</td>\n",
" <td>730</td>\n",
" <td>1.646841e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11137</th>\n",
" <td>Министерство спорта Российской Федерации</td>\n",
" <td>777</td>\n",
" <td>5.022286e+07</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>93 rows × 3 columns</p>\n",
"</div>"
],
"text/plain": [
" name grbs budget2019\n",
"1 Министерство промышленности и торговли Российс... 020 3.992163e+08\n",
"531 Министерство энергетики Российской Федерации 022 2.757244e+07\n",
"617 Федеральная служба по надзору в сфере природоп... 048 5.421428e+06\n",
"680 Федеральное агентство по недропользованию 049 3.333260e+07\n",
"761 Министерство природных ресурсов и экологии Рос... 051 1.420432e+07\n",
"945 Федеральное агентство водных ресурсов 052 1.359286e+07\n",
"1011 Федеральное агентство лесного хозяйства 053 3.267829e+07\n",
"1099 Министерство культуры Российской Федерации 054 1.272740e+08\n",
"1370 Министерство здравоохранения Российской Федерации 056 2.869828e+08\n",
"1715 Федеральная служба по надзору в сфере здравоох... 060 3.783840e+06\n",
"1753 Министерство строительства и жилищно-коммуналь... 069 7.217885e+07\n",
"1990 Министерство цифрового развития, связи и массо... 071 6.447565e+07\n",
"2126 Министерство просвещения Российской Федерации 073 4.641098e+07\n",
"2449 Министерство науки и высшего образования Росси... 075 5.231231e+08\n",
"2938 Федеральное агентство по рыболовству 076 1.870721e+07\n",
"3109 Федеральная служба по надзору в сфере образова... 077 2.105152e+06\n",
"3162 Федеральная служба по ветеринарному и фитосани... 081 1.721586e+07\n",
"3228 Министерство сельского хозяйства Российской Фе... 082 2.669051e+08\n",
"3432 Федеральное агентство связи 084 2.883499e+07\n",
"3509 Государственная фельдъегерская служба Российск... 089 3.805020e+06\n",
"3564 Федеральное агентство по делам молодежи 091 6.703716e+06\n",
"3632 Министерство финансов Российской Федерации 092 5.425660e+09\n",
"4089 Федеральное агентство по делам Содружества Нез... 095 3.989999e+06\n",
"4158 Федеральная служба по надзору в сфере связи, и... 096 9.201630e+06\n",
"4208 Федеральное казначейство 100 4.769361e+07\n",
"4246 Министерство транспорта Российской Федерации 103 8.277031e+07\n",
"4450 Федеральная служба по надзору в сфере транспорта 106 6.122622e+06\n",
"4499 Федеральное агентство воздушного транспорта 107 5.472618e+07\n",
"4651 Федеральное дорожное агентство 108 5.152407e+08\n",
"4773 Федеральное агентство железнодорожного транспорта 109 8.347352e+07\n",
"... ... ... ...\n",
"9019 Федеральное государственное бюджетное учрежден... 319 4.337353e+06\n",
"9033 Федеральная служба исполнения наказаний 320 2.858950e+08\n",
"9244 Федеральная служба государственной регистрации... 321 4.508648e+07\n",
"9320 Федеральная служба судебных приставов 322 5.585255e+07\n",
"9382 Государственная Дума Федерального Собрания Рос... 330 1.102791e+07\n",
"9427 Совет Федерации Федерального Собрания Российск... 333 5.913998e+06\n",
"9473 Министерство Российской Федерации по развитию ... 350 5.675673e+07\n",
"9547 Министерство Российской Федерации по делам Сев... 370 2.548919e+07\n",
"9656 Федеральное агентство по делам национальностей 380 2.810832e+06\n",
"9733 Федеральное государственное бюджетное образова... 384 1.062050e+07\n",
"9805 Федеральное государственное бюджетное образова... 385 9.671824e+06\n",
"9865 Федеральное государственное бюджетное образова... 386 1.721704e+07\n",
"9935 Федеральное медико-биологическое агентство 388 5.570812e+07\n",
"10142 Федеральное государственное бюджетное учрежден... 409 5.143250e+06\n",
"10153 Генеральная прокуратура Российской Федерации 415 9.709056e+07\n",
"10296 Следственный комитет Российской Федерации 417 4.415449e+07\n",
"10409 Федеральное государственное бюджетное образова... 424 2.595145e+05\n",
"10429 Конституционный Суд Российской Федерации 436 8.905147e+05\n",
"10462 Верховный Суд Российской Федерации 437 6.058675e+06\n",
"10549 Судебный департамент при Верховном Суде Россий... 438 2.263284e+08\n",
"10624 Федеральная служба по экологическому, технолог... 498 6.972328e+06\n",
"10690 Федеральная служба по техническому и экспортно... 587 5.730840e+04\n",
"10705 Федеральное государственное бюджетное учрежден... 595 1.809306e+07\n",
"10775 Федеральное государственное бюджетное учрежден... 597 4.277213e+06\n",
"10784 Федеральное государственное бюджетное учрежден... 693 2.222052e+07\n",
"10811 Федеральная служба по военно-техническому сотр... 721 7.831110e+05\n",
"10846 Федеральная служба по финансовому мониторингу 724 1.851832e+06\n",
"10889 Государственная корпорация по атомной энергии ... 725 7.658831e+07\n",
"10998 Государственная корпорация по космической деят... 730 1.646841e+08\n",
"11137 Министерство спорта Российской Федерации 777 5.022286e+07\n",
"\n",
"[93 rows x 3 columns]"
]
},
"execution_count": 45,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"fields = ['name', 'grbs', 'topic', 'subtopic', 'csr_program', 'csr_article', 'vr', 'budget2019']\n",
"df6 = pd.DataFrame(full_2019_6_1, columns=fields)\n",
"\n",
"df_grbs6 = df6.loc[df6['topic'].isnull()].loc[df6['grbs'].isnull() == False][['name','grbs', 'budget2019']]\n",
"df_grbs6\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Теперь у нас есть два DataFrame. Нам необходима функция которая бы сравнивала и выдавала отличия в контексте ГРБСов. Для этого вначале получим полный список кодов ГРБС в обоих наборах. Это просто перестраховка на случай если какие-то из них могли измениться. После чего составим таблицу сравнения по каждому ГРБС"
]
},
{
"cell_type": "code",
"execution_count": 70,
"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>grbs</th>\n",
" <th>name</th>\n",
" <th>left</th>\n",
" <th>right</th>\n",
" <th>diff</th>\n",
" <th>diff_share</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>321</td>\n",
" <td>Федеральная служба государственной регистрации...</td>\n",
" <td>3.714834e+07</td>\n",
" <td>4.508648e+07</td>\n",
" <td>7938142.4</td>\n",
" <td>21.368770</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>322</td>\n",
" <td>Федеральная служба судебных приставов</td>\n",
" <td>4.850585e+07</td>\n",
" <td>5.585255e+07</td>\n",
" <td>7346705.3</td>\n",
" <td>15.146020</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>056</td>\n",
" <td>Министерство здравоохранения Российской Федерации</td>\n",
" <td>2.503724e+08</td>\n",
" <td>2.869828e+08</td>\n",
" <td>36610386.6</td>\n",
" <td>14.622372</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>171</td>\n",
" <td>Федеральное агентство по государственным резервам</td>\n",
" <td>1.185634e+07</td>\n",
" <td>1.235127e+07</td>\n",
" <td>494920.8</td>\n",
" <td>4.174312</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>180</td>\n",
" <td>Федеральная служба войск национальной гвардии ...</td>\n",
" <td>2.396682e+08</td>\n",
" <td>2.419782e+08</td>\n",
" <td>2310093.5</td>\n",
" <td>0.963872</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>071</td>\n",
" <td>Министерство цифрового развития, связи и массо...</td>\n",
" <td>6.406013e+07</td>\n",
" <td>6.447565e+07</td>\n",
" <td>415518.1</td>\n",
" <td>0.648638</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>075</td>\n",
" <td>Министерство науки и высшего образования Росси...</td>\n",
" <td>5.044598e+08</td>\n",
" <td>5.231231e+08</td>\n",
" <td>18663237.2</td>\n",
" <td>3.699648</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>150</td>\n",
" <td>Федеральная служба по труду и занятости</td>\n",
" <td>9.733599e+07</td>\n",
" <td>9.807273e+07</td>\n",
" <td>736746.1</td>\n",
" <td>0.756910</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>106</td>\n",
" <td>Федеральная служба по надзору в сфере транспорта</td>\n",
" <td>4.831153e+06</td>\n",
" <td>6.122622e+06</td>\n",
" <td>1291469.6</td>\n",
" <td>26.732121</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>587</td>\n",
" <td>Федеральная служба по техническому и экспортно...</td>\n",
" <td>2.745650e+04</td>\n",
" <td>5.730840e+04</td>\n",
" <td>29851.9</td>\n",
" <td>108.724346</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>777</td>\n",
" <td>Министерство спорта Российской Федерации</td>\n",
" <td>4.232135e+07</td>\n",
" <td>5.022286e+07</td>\n",
" <td>7901510.2</td>\n",
" <td>18.670269</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>437</td>\n",
" <td>Верховный Суд Российской Федерации</td>\n",
" <td>5.350487e+06</td>\n",
" <td>6.058675e+06</td>\n",
" <td>708188.0</td>\n",
" <td>13.235955</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>724</td>\n",
" <td>Федеральная служба по финансовому мониторингу</td>\n",
" <td>1.555656e+06</td>\n",
" <td>1.851832e+06</td>\n",
" <td>296176.6</td>\n",
" <td>19.038696</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>597</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>4.277213e+06</td>\n",
" <td>4.277213e+06</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>092</td>\n",
" <td>Министерство финансов Российской Федерации</td>\n",
" <td>5.438722e+09</td>\n",
" <td>5.425660e+09</td>\n",
" <td>-13061900.3</td>\n",
" <td>-0.240165</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>069</td>\n",
" <td>Министерство строительства и жилищно-коммуналь...</td>\n",
" <td>6.040740e+07</td>\n",
" <td>7.217885e+07</td>\n",
" <td>11771449.2</td>\n",
" <td>19.486765</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>153</td>\n",
" <td>Федеральная таможенная служба</td>\n",
" <td>7.420655e+07</td>\n",
" <td>8.014390e+07</td>\n",
" <td>5937348.6</td>\n",
" <td>8.001111</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>103</td>\n",
" <td>Министерство транспорта Российской Федерации</td>\n",
" <td>7.532092e+07</td>\n",
" <td>8.277031e+07</td>\n",
" <td>7449389.4</td>\n",
" <td>9.890200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>384</td>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>1.058232e+07</td>\n",
" <td>1.062050e+07</td>\n",
" <td>38180.3</td>\n",
" <td>0.360793</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>595</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>1.809080e+07</td>\n",
" <td>1.809306e+07</td>\n",
" <td>2259.2</td>\n",
" <td>0.012488</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>187</td>\n",
" <td>Министерство обороны Российской Федерации</td>\n",
" <td>1.776080e+09</td>\n",
" <td>1.790729e+09</td>\n",
" <td>14649008.9</td>\n",
" <td>0.824794</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>333</td>\n",
" <td>Совет Федерации Федерального Собрания Российск...</td>\n",
" <td>5.851871e+06</td>\n",
" <td>5.913998e+06</td>\n",
" <td>62126.3</td>\n",
" <td>1.061648</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>330</td>\n",
" <td>Государственная Дума Федерального Собрания Рос...</td>\n",
" <td>1.102721e+07</td>\n",
" <td>1.102791e+07</td>\n",
" <td>700.0</td>\n",
" <td>0.006348</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>167</td>\n",
" <td>Федеральное агентство по управлению государств...</td>\n",
" <td>5.367362e+06</td>\n",
" <td>6.181555e+06</td>\n",
" <td>814192.1</td>\n",
" <td>15.169315</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>725</td>\n",
" <td>Государственная корпорация по атомной энергии ...</td>\n",
" <td>7.607547e+07</td>\n",
" <td>7.658831e+07</td>\n",
" <td>512838.5</td>\n",
" <td>0.674118</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>139</td>\n",
" <td>Министерство экономического развития Российско...</td>\n",
" <td>1.827283e+08</td>\n",
" <td>1.911448e+08</td>\n",
" <td>8416554.0</td>\n",
" <td>4.606049</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>073</td>\n",
" <td>Министерство просвещения Российской Федерации</td>\n",
" <td>3.834346e+07</td>\n",
" <td>4.641098e+07</td>\n",
" <td>8067516.4</td>\n",
" <td>21.040134</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>155</td>\n",
" <td>Федеральное архивное агентство</td>\n",
" <td>3.507863e+06</td>\n",
" <td>3.731550e+06</td>\n",
" <td>223687.3</td>\n",
" <td>6.376741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>157</td>\n",
" <td>Федеральная служба государственной статистики</td>\n",
" <td>1.836810e+07</td>\n",
" <td>2.250983e+07</td>\n",
" <td>4141734.9</td>\n",
" <td>22.548522</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>135</td>\n",
" <td>Федеральное агентство по печати и массовым ком...</td>\n",
" <td>7.182274e+07</td>\n",
" <td>7.847075e+07</td>\n",
" <td>6648010.5</td>\n",
" <td>9.256136</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>084</td>\n",
" <td>Федеральное агентство связи</td>\n",
" <td>2.877481e+07</td>\n",
" <td>2.883499e+07</td>\n",
" <td>60180.2</td>\n",
" <td>0.209142</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>149</td>\n",
" <td>Министерство труда и социальной защиты Российс...</td>\n",
" <td>2.612750e+08</td>\n",
" <td>2.676391e+08</td>\n",
" <td>6364093.6</td>\n",
" <td>2.435784</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>022</td>\n",
" <td>Министерство энергетики Российской Федерации</td>\n",
" <td>2.487886e+07</td>\n",
" <td>2.757244e+07</td>\n",
" <td>2693579.9</td>\n",
" <td>10.826781</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>053</td>\n",
" <td>Федеральное агентство лесного хозяйства</td>\n",
" <td>3.244217e+07</td>\n",
" <td>3.267829e+07</td>\n",
" <td>236124.3</td>\n",
" <td>0.727831</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>303</td>\n",
" <td>Управление делами Президента Российской Федерации</td>\n",
" <td>1.279698e+08</td>\n",
" <td>1.407950e+08</td>\n",
" <td>12825260.1</td>\n",
" <td>10.022103</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>161</td>\n",
" <td>Федеральная антимонопольная служба</td>\n",
" <td>3.375428e+06</td>\n",
" <td>4.389109e+06</td>\n",
" <td>1013681.5</td>\n",
" <td>30.031203</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>320</td>\n",
" <td>Федеральная служба исполнения наказаний</td>\n",
" <td>2.814905e+08</td>\n",
" <td>2.858950e+08</td>\n",
" <td>4404483.3</td>\n",
" <td>1.564701</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>182</td>\n",
" <td>Федеральная налоговая служба</td>\n",
" <td>1.298909e+08</td>\n",
" <td>1.878368e+08</td>\n",
" <td>57945909.3</td>\n",
" <td>44.611230</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>409</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>5.143250e+06</td>\n",
" <td>5.143250e+06</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>048</td>\n",
" <td>Федеральная служба по надзору в сфере природоп...</td>\n",
" <td>4.295335e+06</td>\n",
" <td>5.421428e+06</td>\n",
" <td>1126093.4</td>\n",
" <td>26.216661</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>160</td>\n",
" <td>Федеральная служба по регулированию алкогольно...</td>\n",
" <td>3.061183e+06</td>\n",
" <td>4.175132e+06</td>\n",
" <td>1113949.3</td>\n",
" <td>36.389505</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>305</td>\n",
" <td>Счетная палата Российской Федерации</td>\n",
" <td>4.340441e+06</td>\n",
" <td>4.571840e+06</td>\n",
" <td>231399.2</td>\n",
" <td>5.331237</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td>020</td>\n",
" <td>Министерство промышленности и торговли Российс...</td>\n",
" <td>3.764679e+08</td>\n",
" <td>3.992163e+08</td>\n",
" <td>22748438.2</td>\n",
" <td>6.042597</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>174</td>\n",
" <td>Федеральное агентство по туризму</td>\n",
" <td>6.305182e+06</td>\n",
" <td>6.349813e+06</td>\n",
" <td>44631.9</td>\n",
" <td>0.707861</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>095</td>\n",
" <td>Федеральное агентство по делам Содружества Нез...</td>\n",
" <td>3.741280e+06</td>\n",
" <td>3.989999e+06</td>\n",
" <td>248718.6</td>\n",
" <td>6.647954</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>380</td>\n",
" <td>Федеральное агентство по делам национальностей</td>\n",
" <td>1.943792e+06</td>\n",
" <td>2.810832e+06</td>\n",
" <td>867040.1</td>\n",
" <td>44.605603</td>\n",
" </tr>\n",
" <tr>\n",
" <th>79</th>\n",
" <td>436</td>\n",
" <td>Конституционный Суд Российской Федерации</td>\n",
" <td>6.874974e+05</td>\n",
" <td>8.905147e+05</td>\n",
" <td>203017.3</td>\n",
" <td>29.529901</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td>302</td>\n",
" <td>Уполномоченный по правам человека в Российской...</td>\n",
" <td>2.679217e+05</td>\n",
" <td>4.712895e+05</td>\n",
" <td>203367.8</td>\n",
" <td>75.905684</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>109</td>\n",
" <td>Федеральное агентство железнодорожного транспорта</td>\n",
" <td>8.224422e+07</td>\n",
" <td>8.347352e+07</td>\n",
" <td>1229302.1</td>\n",
" <td>1.494697</td>\n",
" </tr>\n",
" <tr>\n",
" <th>82</th>\n",
" <td>165</td>\n",
" <td>Федеральная служба по аккредитации</td>\n",
" <td>4.414640e+05</td>\n",
" <td>5.573343e+05</td>\n",
" <td>115870.3</td>\n",
" <td>26.246829</td>\n",
" </tr>\n",
" <tr>\n",
" <th>83</th>\n",
" <td>226</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>4.353930e+06</td>\n",
" <td>6.103930e+06</td>\n",
" <td>1750000.0</td>\n",
" <td>40.193576</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td>386</td>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>1.716879e+07</td>\n",
" <td>1.721704e+07</td>\n",
" <td>48244.8</td>\n",
" <td>0.281003</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>051</td>\n",
" <td>Министерство природных ресурсов и экологии Рос...</td>\n",
" <td>1.331377e+07</td>\n",
" <td>1.420432e+07</td>\n",
" <td>890554.0</td>\n",
" <td>6.688970</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>388</td>\n",
" <td>Федеральное медико-биологическое агентство</td>\n",
" <td>5.388145e+07</td>\n",
" <td>5.570812e+07</td>\n",
" <td>1826670.4</td>\n",
" <td>3.390166</td>\n",
" </tr>\n",
" <tr>\n",
" <th>87</th>\n",
" <td>498</td>\n",
" <td>Федеральная служба по экологическому, технолог...</td>\n",
" <td>5.106355e+06</td>\n",
" <td>6.972328e+06</td>\n",
" <td>1865973.8</td>\n",
" <td>36.542190</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>188</td>\n",
" <td>Министерство внутренних дел Российской Федерации</td>\n",
" <td>9.701729e+08</td>\n",
" <td>9.803770e+08</td>\n",
" <td>10204056.5</td>\n",
" <td>1.051777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>89</th>\n",
" <td>310</td>\n",
" <td>Министерство иностранных дел Российской Федерации</td>\n",
" <td>9.156380e+07</td>\n",
" <td>9.539028e+07</td>\n",
" <td>3826484.3</td>\n",
" <td>4.179036</td>\n",
" </tr>\n",
" <tr>\n",
" <th>90</th>\n",
" <td>089</td>\n",
" <td>Государственная фельдъегерская служба Российск...</td>\n",
" <td>3.758104e+06</td>\n",
" <td>3.805020e+06</td>\n",
" <td>46915.2</td>\n",
" <td>1.248374</td>\n",
" </tr>\n",
" <tr>\n",
" <th>91</th>\n",
" <td>370</td>\n",
" <td>Министерство Российской Федерации по делам Сев...</td>\n",
" <td>2.514073e+07</td>\n",
" <td>2.548919e+07</td>\n",
" <td>348458.2</td>\n",
" <td>1.386030</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92</th>\n",
" <td>730</td>\n",
" <td>Государственная корпорация по космической деят...</td>\n",
" <td>1.231372e+08</td>\n",
" <td>1.646841e+08</td>\n",
" <td>41546858.4</td>\n",
" <td>33.740292</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>93 rows × 6 columns</p>\n",
"</div>"
],
"text/plain": [
" grbs name left \\\n",
"0 321 Федеральная служба государственной регистрации... 3.714834e+07 \n",
"1 322 Федеральная служба судебных приставов 4.850585e+07 \n",
"2 056 Министерство здравоохранения Российской Федерации 2.503724e+08 \n",
"3 171 Федеральное агентство по государственным резервам 1.185634e+07 \n",
"4 180 Федеральная служба войск национальной гвардии ... 2.396682e+08 \n",
"5 071 Министерство цифрового развития, связи и массо... 6.406013e+07 \n",
"6 075 Министерство науки и высшего образования Росси... 5.044598e+08 \n",
"7 150 Федеральная служба по труду и занятости 9.733599e+07 \n",
"8 106 Федеральная служба по надзору в сфере транспорта 4.831153e+06 \n",
"9 587 Федеральная служба по техническому и экспортно... 2.745650e+04 \n",
"10 777 Министерство спорта Российской Федерации 4.232135e+07 \n",
"11 437 Верховный Суд Российской Федерации 5.350487e+06 \n",
"12 724 Федеральная служба по финансовому мониторингу 1.555656e+06 \n",
"13 597 Федеральное государственное бюджетное учрежден... 4.277213e+06 \n",
"14 092 Министерство финансов Российской Федерации 5.438722e+09 \n",
"15 069 Министерство строительства и жилищно-коммуналь... 6.040740e+07 \n",
"16 153 Федеральная таможенная служба 7.420655e+07 \n",
"17 103 Министерство транспорта Российской Федерации 7.532092e+07 \n",
"18 384 Федеральное государственное бюджетное образова... 1.058232e+07 \n",
"19 595 Федеральное государственное бюджетное учрежден... 1.809080e+07 \n",
"20 187 Министерство обороны Российской Федерации 1.776080e+09 \n",
"21 333 Совет Федерации Федерального Собрания Российск... 5.851871e+06 \n",
"22 330 Государственная Дума Федерального Собрания Рос... 1.102721e+07 \n",
"23 167 Федеральное агентство по управлению государств... 5.367362e+06 \n",
"24 725 Государственная корпорация по атомной энергии ... 7.607547e+07 \n",
"25 139 Министерство экономического развития Российско... 1.827283e+08 \n",
"26 073 Министерство просвещения Российской Федерации 3.834346e+07 \n",
"27 155 Федеральное архивное агентство 3.507863e+06 \n",
"28 157 Федеральная служба государственной статистики 1.836810e+07 \n",
"29 135 Федеральное агентство по печати и массовым ком... 7.182274e+07 \n",
".. ... ... ... \n",
"63 084 Федеральное агентство связи 2.877481e+07 \n",
"64 149 Министерство труда и социальной защиты Российс... 2.612750e+08 \n",
"65 022 Министерство энергетики Российской Федерации 2.487886e+07 \n",
"66 053 Федеральное агентство лесного хозяйства 3.244217e+07 \n",
"67 303 Управление делами Президента Российской Федерации 1.279698e+08 \n",
"68 161 Федеральная антимонопольная служба 3.375428e+06 \n",
"69 320 Федеральная служба исполнения наказаний 2.814905e+08 \n",
"70 182 Федеральная налоговая служба 1.298909e+08 \n",
"71 409 Федеральное государственное бюджетное учрежден... 5.143250e+06 \n",
"72 048 Федеральная служба по надзору в сфере природоп... 4.295335e+06 \n",
"73 160 Федеральная служба по регулированию алкогольно... 3.061183e+06 \n",
"74 305 Счетная палата Российской Федерации 4.340441e+06 \n",
"75 020 Министерство промышленности и торговли Российс... 3.764679e+08 \n",
"76 174 Федеральное агентство по туризму 6.305182e+06 \n",
"77 095 Федеральное агентство по делам Содружества Нез... 3.741280e+06 \n",
"78 380 Федеральное агентство по делам национальностей 1.943792e+06 \n",
"79 436 Конституционный Суд Российской Федерации 6.874974e+05 \n",
"80 302 Уполномоченный по правам человека в Российской... 2.679217e+05 \n",
"81 109 Федеральное агентство железнодорожного транспорта 8.224422e+07 \n",
"82 165 Федеральная служба по аккредитации 4.414640e+05 \n",
"83 226 Федеральное государственное бюджетное учрежден... 4.353930e+06 \n",
"84 386 Федеральное государственное бюджетное образова... 1.716879e+07 \n",
"85 051 Министерство природных ресурсов и экологии Рос... 1.331377e+07 \n",
"86 388 Федеральное медико-биологическое агентство 5.388145e+07 \n",
"87 498 Федеральная служба по экологическому, технолог... 5.106355e+06 \n",
"88 188 Министерство внутренних дел Российской Федерации 9.701729e+08 \n",
"89 310 Министерство иностранных дел Российской Федерации 9.156380e+07 \n",
"90 089 Государственная фельдъегерская служба Российск... 3.758104e+06 \n",
"91 370 Министерство Российской Федерации по делам Сев... 2.514073e+07 \n",
"92 730 Государственная корпорация по космической деят... 1.231372e+08 \n",
"\n",
" right diff diff_share \n",
"0 4.508648e+07 7938142.4 21.368770 \n",
"1 5.585255e+07 7346705.3 15.146020 \n",
"2 2.869828e+08 36610386.6 14.622372 \n",
"3 1.235127e+07 494920.8 4.174312 \n",
"4 2.419782e+08 2310093.5 0.963872 \n",
"5 6.447565e+07 415518.1 0.648638 \n",
"6 5.231231e+08 18663237.2 3.699648 \n",
"7 9.807273e+07 736746.1 0.756910 \n",
"8 6.122622e+06 1291469.6 26.732121 \n",
"9 5.730840e+04 29851.9 108.724346 \n",
"10 5.022286e+07 7901510.2 18.670269 \n",
"11 6.058675e+06 708188.0 13.235955 \n",
"12 1.851832e+06 296176.6 19.038696 \n",
"13 4.277213e+06 0.0 0.000000 \n",
"14 5.425660e+09 -13061900.3 -0.240165 \n",
"15 7.217885e+07 11771449.2 19.486765 \n",
"16 8.014390e+07 5937348.6 8.001111 \n",
"17 8.277031e+07 7449389.4 9.890200 \n",
"18 1.062050e+07 38180.3 0.360793 \n",
"19 1.809306e+07 2259.2 0.012488 \n",
"20 1.790729e+09 14649008.9 0.824794 \n",
"21 5.913998e+06 62126.3 1.061648 \n",
"22 1.102791e+07 700.0 0.006348 \n",
"23 6.181555e+06 814192.1 15.169315 \n",
"24 7.658831e+07 512838.5 0.674118 \n",
"25 1.911448e+08 8416554.0 4.606049 \n",
"26 4.641098e+07 8067516.4 21.040134 \n",
"27 3.731550e+06 223687.3 6.376741 \n",
"28 2.250983e+07 4141734.9 22.548522 \n",
"29 7.847075e+07 6648010.5 9.256136 \n",
".. ... ... ... \n",
"63 2.883499e+07 60180.2 0.209142 \n",
"64 2.676391e+08 6364093.6 2.435784 \n",
"65 2.757244e+07 2693579.9 10.826781 \n",
"66 3.267829e+07 236124.3 0.727831 \n",
"67 1.407950e+08 12825260.1 10.022103 \n",
"68 4.389109e+06 1013681.5 30.031203 \n",
"69 2.858950e+08 4404483.3 1.564701 \n",
"70 1.878368e+08 57945909.3 44.611230 \n",
"71 5.143250e+06 0.0 0.000000 \n",
"72 5.421428e+06 1126093.4 26.216661 \n",
"73 4.175132e+06 1113949.3 36.389505 \n",
"74 4.571840e+06 231399.2 5.331237 \n",
"75 3.992163e+08 22748438.2 6.042597 \n",
"76 6.349813e+06 44631.9 0.707861 \n",
"77 3.989999e+06 248718.6 6.647954 \n",
"78 2.810832e+06 867040.1 44.605603 \n",
"79 8.905147e+05 203017.3 29.529901 \n",
"80 4.712895e+05 203367.8 75.905684 \n",
"81 8.347352e+07 1229302.1 1.494697 \n",
"82 5.573343e+05 115870.3 26.246829 \n",
"83 6.103930e+06 1750000.0 40.193576 \n",
"84 1.721704e+07 48244.8 0.281003 \n",
"85 1.420432e+07 890554.0 6.688970 \n",
"86 5.570812e+07 1826670.4 3.390166 \n",
"87 6.972328e+06 1865973.8 36.542190 \n",
"88 9.803770e+08 10204056.5 1.051777 \n",
"89 9.539028e+07 3826484.3 4.179036 \n",
"90 3.805020e+06 46915.2 1.248374 \n",
"91 2.548919e+07 348458.2 1.386030 \n",
"92 1.646841e+08 41546858.4 33.740292 \n",
"\n",
"[93 rows x 6 columns]"
]
},
"execution_count": 70,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"unique_grbs = set(df_grbs['grbs'].unique()).union(df_grbs6['grbs'].unique())\n",
"\n",
"difftable = []\n",
"for ug in unique_grbs:\n",
" left = df_grbs.loc[df_grbs['grbs'] == ug] \n",
" right = df_grbs6.loc[df_grbs6['grbs'] == ug]\n",
" record = {'name' : left['name'].values[0], 'left' : left['budget2019'].values[0], 'right' : right['budget2019'].values[0]}\n",
" record['grbs'] = ug\n",
" record['diff'] = record['right'] - record['left']\n",
" record['diff_share'] = (record['right'] - record['left']) * 100.0 / record['left'] if record['left'] > 0 else 0 \n",
" difftable.append(record)\n",
"fields = ['grbs', 'name', 'left', 'right', 'diff', 'diff_share']\n",
"dfdiff = pd.DataFrame(difftable, columns=fields)\n",
"dfdiff"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Объединим всё вместе и сделаем функцию которая бы считала разницу в расходах ГРБС между 2-мя датами"
]
},
{
"cell_type": "code",
"execution_count": 72,
"metadata": {},
"outputs": [],
"source": [
"def grbs_date_diff(first, second):\n",
" fd = get_full_budget_data(first)\n",
" fields = ['name', 'grbs', 'topic', 'subtopic', 'csr_program', 'csr_article', 'vr', 'budget2019']\n",
" df_f = pd.DataFrame(fd, columns=fields)\n",
" df_first = df_f.loc[df_f['topic'].isnull()].loc[df_f['grbs'].isnull() == False][['name','grbs', 'budget2019']]\n",
"\n",
" sd = get_full_budget_data(second)\n",
" df_s = pd.DataFrame(sd, columns=fields)\n",
" df_second = df_s.loc[df_s['topic'].isnull()].loc[df_s['grbs'].isnull() == False][['name','grbs', 'budget2019']]\n",
" \n",
" unique_grbs = set(df_first['grbs'].unique()).union(df_second['grbs'].unique())\n",
"\n",
" difftable = []\n",
" for ug in unique_grbs:\n",
" left = df_first.loc[df_first['grbs'] == ug] \n",
" right = df_second.loc[df_second['grbs'] == ug]\n",
" record = {'name' : left['name'].values[0], 'left' : left['budget2019'].values[0], 'right' : right['budget2019'].values[0]}\n",
" record['grbs'] = ug\n",
" record['diff'] = record['right'] - record['left']\n",
" record['diff_share'] = (record['right'] - record['left']) * 100.0 / record['left'] if record['left'] > 0 else 0 \n",
" difftable.append(record)\n",
" fields = ['grbs', 'name', 'left', 'right', 'diff', 'diff_share']\n",
" dfdiff = pd.DataFrame(difftable, columns=fields)\n",
" return dfdiff\n"
]
},
{
"cell_type": "code",
"execution_count": 73,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-01-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n",
"Downloading data for 2019-03-01\n"
]
}
],
"source": [
"grbs_diff = grbs_date_diff(datetime.date(2019, 1,1), datetime.date(2019, 3, 1))"
]
},
{
"cell_type": "code",
"execution_count": 74,
"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>grbs</th>\n",
" <th>name</th>\n",
" <th>left</th>\n",
" <th>right</th>\n",
" <th>diff</th>\n",
" <th>diff_share</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>321</td>\n",
" <td>Федеральная служба государственной регистрации...</td>\n",
" <td>3.714834e+07</td>\n",
" <td>4.421538e+07</td>\n",
" <td>7067045.7</td>\n",
" <td>19.023856</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>322</td>\n",
" <td>Федеральная служба судебных приставов</td>\n",
" <td>4.850585e+07</td>\n",
" <td>5.022678e+07</td>\n",
" <td>1720929.6</td>\n",
" <td>3.547881</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>056</td>\n",
" <td>Министерство здравоохранения Российской Федерации</td>\n",
" <td>2.503724e+08</td>\n",
" <td>3.145265e+08</td>\n",
" <td>64154047.6</td>\n",
" <td>25.623449</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>171</td>\n",
" <td>Федеральное агентство по государственным резервам</td>\n",
" <td>1.185634e+07</td>\n",
" <td>1.674745e+07</td>\n",
" <td>4891109.8</td>\n",
" <td>41.253102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>180</td>\n",
" <td>Федеральная служба войск национальной гвардии ...</td>\n",
" <td>2.396682e+08</td>\n",
" <td>2.400250e+08</td>\n",
" <td>356878.5</td>\n",
" <td>0.148905</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>071</td>\n",
" <td>Министерство цифрового развития, связи и массо...</td>\n",
" <td>6.406013e+07</td>\n",
" <td>6.761068e+07</td>\n",
" <td>3550548.9</td>\n",
" <td>5.542525</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>075</td>\n",
" <td>Министерство науки и высшего образования Росси...</td>\n",
" <td>5.044598e+08</td>\n",
" <td>7.785733e+08</td>\n",
" <td>274113519.5</td>\n",
" <td>54.338028</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>150</td>\n",
" <td>Федеральная служба по труду и занятости</td>\n",
" <td>9.733599e+07</td>\n",
" <td>9.761644e+07</td>\n",
" <td>280449.9</td>\n",
" <td>0.288126</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>106</td>\n",
" <td>Федеральная служба по надзору в сфере транспорта</td>\n",
" <td>4.831153e+06</td>\n",
" <td>5.127324e+06</td>\n",
" <td>296170.9</td>\n",
" <td>6.130440</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>587</td>\n",
" <td>Федеральная служба по техническому и экспортно...</td>\n",
" <td>2.745650e+04</td>\n",
" <td>5.730840e+04</td>\n",
" <td>29851.9</td>\n",
" <td>108.724346</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>777</td>\n",
" <td>Министерство спорта Российской Федерации</td>\n",
" <td>4.232135e+07</td>\n",
" <td>4.954690e+07</td>\n",
" <td>7225546.8</td>\n",
" <td>17.073053</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>437</td>\n",
" <td>Верховный Суд Российской Федерации</td>\n",
" <td>5.350487e+06</td>\n",
" <td>5.359415e+06</td>\n",
" <td>8928.2</td>\n",
" <td>0.166867</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>724</td>\n",
" <td>Федеральная служба по финансовому мониторингу</td>\n",
" <td>1.555656e+06</td>\n",
" <td>2.040534e+06</td>\n",
" <td>484877.7</td>\n",
" <td>31.168699</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>597</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>4.277213e+06</td>\n",
" <td>4.277213e+06</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>092</td>\n",
" <td>Министерство финансов Российской Федерации</td>\n",
" <td>5.438722e+09</td>\n",
" <td>5.823450e+09</td>\n",
" <td>384728463.2</td>\n",
" <td>7.073877</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>069</td>\n",
" <td>Министерство строительства и жилищно-коммуналь...</td>\n",
" <td>6.040740e+07</td>\n",
" <td>7.011785e+07</td>\n",
" <td>9710444.3</td>\n",
" <td>16.074924</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>153</td>\n",
" <td>Федеральная таможенная служба</td>\n",
" <td>7.420655e+07</td>\n",
" <td>7.471885e+07</td>\n",
" <td>512294.1</td>\n",
" <td>0.690362</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>103</td>\n",
" <td>Министерство транспорта Российской Федерации</td>\n",
" <td>7.532092e+07</td>\n",
" <td>7.873608e+07</td>\n",
" <td>3415165.6</td>\n",
" <td>4.534153</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>384</td>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>1.058232e+07</td>\n",
" <td>1.186984e+07</td>\n",
" <td>1287519.2</td>\n",
" <td>12.166697</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>595</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>1.809080e+07</td>\n",
" <td>1.810459e+07</td>\n",
" <td>13795.2</td>\n",
" <td>0.076255</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>187</td>\n",
" <td>Министерство обороны Российской Федерации</td>\n",
" <td>1.776080e+09</td>\n",
" <td>1.804494e+09</td>\n",
" <td>28413910.8</td>\n",
" <td>1.599810</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>333</td>\n",
" <td>Совет Федерации Федерального Собрания Российск...</td>\n",
" <td>5.851871e+06</td>\n",
" <td>6.528795e+06</td>\n",
" <td>676923.5</td>\n",
" <td>11.567642</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>330</td>\n",
" <td>Государственная Дума Федерального Собрания Рос...</td>\n",
" <td>1.102721e+07</td>\n",
" <td>1.102721e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>167</td>\n",
" <td>Федеральное агентство по управлению государств...</td>\n",
" <td>5.367362e+06</td>\n",
" <td>5.451718e+06</td>\n",
" <td>84355.8</td>\n",
" <td>1.571643</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>725</td>\n",
" <td>Государственная корпорация по атомной энергии ...</td>\n",
" <td>7.607547e+07</td>\n",
" <td>7.619915e+07</td>\n",
" <td>123676.0</td>\n",
" <td>0.162570</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>139</td>\n",
" <td>Министерство экономического развития Российско...</td>\n",
" <td>1.827283e+08</td>\n",
" <td>2.917710e+08</td>\n",
" <td>109042747.3</td>\n",
" <td>59.674807</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>073</td>\n",
" <td>Министерство просвещения Российской Федерации</td>\n",
" <td>3.834346e+07</td>\n",
" <td>5.546139e+07</td>\n",
" <td>17117930.2</td>\n",
" <td>44.643671</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>155</td>\n",
" <td>Федеральное архивное агентство</td>\n",
" <td>3.507863e+06</td>\n",
" <td>3.709952e+06</td>\n",
" <td>202089.1</td>\n",
" <td>5.761032</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>157</td>\n",
" <td>Федеральная служба государственной статистики</td>\n",
" <td>1.836810e+07</td>\n",
" <td>1.948738e+07</td>\n",
" <td>1119281.1</td>\n",
" <td>6.093614</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>135</td>\n",
" <td>Федеральное агентство по печати и массовым ком...</td>\n",
" <td>7.182274e+07</td>\n",
" <td>7.192807e+07</td>\n",
" <td>105325.4</td>\n",
" <td>0.146646</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>084</td>\n",
" <td>Федеральное агентство связи</td>\n",
" <td>2.877481e+07</td>\n",
" <td>2.880382e+07</td>\n",
" <td>29009.3</td>\n",
" <td>0.100815</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>149</td>\n",
" <td>Министерство труда и социальной защиты Российс...</td>\n",
" <td>2.612750e+08</td>\n",
" <td>2.710460e+08</td>\n",
" <td>9771044.9</td>\n",
" <td>3.739755</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>022</td>\n",
" <td>Министерство энергетики Российской Федерации</td>\n",
" <td>2.487886e+07</td>\n",
" <td>2.490985e+07</td>\n",
" <td>30985.5</td>\n",
" <td>0.124545</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>053</td>\n",
" <td>Федеральное агентство лесного хозяйства</td>\n",
" <td>3.244217e+07</td>\n",
" <td>3.247280e+07</td>\n",
" <td>30631.9</td>\n",
" <td>0.094420</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>303</td>\n",
" <td>Управление делами Президента Российской Федерации</td>\n",
" <td>1.279698e+08</td>\n",
" <td>1.338413e+08</td>\n",
" <td>5871538.9</td>\n",
" <td>4.588224</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>161</td>\n",
" <td>Федеральная антимонопольная служба</td>\n",
" <td>3.375428e+06</td>\n",
" <td>3.382510e+06</td>\n",
" <td>7082.9</td>\n",
" <td>0.209837</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>320</td>\n",
" <td>Федеральная служба исполнения наказаний</td>\n",
" <td>2.814905e+08</td>\n",
" <td>2.842631e+08</td>\n",
" <td>2772639.2</td>\n",
" <td>0.984985</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>182</td>\n",
" <td>Федеральная налоговая служба</td>\n",
" <td>1.298909e+08</td>\n",
" <td>1.693756e+08</td>\n",
" <td>39484726.1</td>\n",
" <td>30.398388</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>409</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>5.143250e+06</td>\n",
" <td>5.143250e+06</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>048</td>\n",
" <td>Федеральная служба по надзору в сфере природоп...</td>\n",
" <td>4.295335e+06</td>\n",
" <td>4.331887e+06</td>\n",
" <td>36551.7</td>\n",
" <td>0.850963</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>160</td>\n",
" <td>Федеральная служба по регулированию алкогольно...</td>\n",
" <td>3.061183e+06</td>\n",
" <td>3.119087e+06</td>\n",
" <td>57903.9</td>\n",
" <td>1.891553</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>305</td>\n",
" <td>Счетная палата Российской Федерации</td>\n",
" <td>4.340441e+06</td>\n",
" <td>4.347102e+06</td>\n",
" <td>6660.7</td>\n",
" <td>0.153457</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td>020</td>\n",
" <td>Министерство промышленности и торговли Российс...</td>\n",
" <td>3.764679e+08</td>\n",
" <td>3.944092e+08</td>\n",
" <td>17941259.9</td>\n",
" <td>4.765681</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>174</td>\n",
" <td>Федеральное агентство по туризму</td>\n",
" <td>6.305182e+06</td>\n",
" <td>6.389091e+06</td>\n",
" <td>83909.8</td>\n",
" <td>1.330807</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>095</td>\n",
" <td>Федеральное агентство по делам Содружества Нез...</td>\n",
" <td>3.741280e+06</td>\n",
" <td>3.763294e+06</td>\n",
" <td>22013.7</td>\n",
" <td>0.588400</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>380</td>\n",
" <td>Федеральное агентство по делам национальностей</td>\n",
" <td>1.943792e+06</td>\n",
" <td>2.777898e+06</td>\n",
" <td>834105.6</td>\n",
" <td>42.911260</td>\n",
" </tr>\n",
" <tr>\n",
" <th>79</th>\n",
" <td>436</td>\n",
" <td>Конституционный Суд Российской Федерации</td>\n",
" <td>6.874974e+05</td>\n",
" <td>6.874974e+05</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td>302</td>\n",
" <td>Уполномоченный по правам человека в Российской...</td>\n",
" <td>2.679217e+05</td>\n",
" <td>2.974306e+05</td>\n",
" <td>29508.9</td>\n",
" <td>11.014001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>109</td>\n",
" <td>Федеральное агентство железнодорожного транспорта</td>\n",
" <td>8.224422e+07</td>\n",
" <td>9.922822e+07</td>\n",
" <td>16984005.5</td>\n",
" <td>20.650699</td>\n",
" </tr>\n",
" <tr>\n",
" <th>82</th>\n",
" <td>165</td>\n",
" <td>Федеральная служба по аккредитации</td>\n",
" <td>4.414640e+05</td>\n",
" <td>4.751911e+05</td>\n",
" <td>33727.1</td>\n",
" <td>7.639830</td>\n",
" </tr>\n",
" <tr>\n",
" <th>83</th>\n",
" <td>226</td>\n",
" <td>Федеральное государственное бюджетное учрежден...</td>\n",
" <td>4.353930e+06</td>\n",
" <td>5.053930e+06</td>\n",
" <td>700000.0</td>\n",
" <td>16.077430</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td>386</td>\n",
" <td>Федеральное государственное бюджетное образова...</td>\n",
" <td>1.716879e+07</td>\n",
" <td>1.717278e+07</td>\n",
" <td>3984.0</td>\n",
" <td>0.023205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>051</td>\n",
" <td>Министерство природных ресурсов и экологии Рос...</td>\n",
" <td>1.331377e+07</td>\n",
" <td>1.374256e+07</td>\n",
" <td>428789.1</td>\n",
" <td>3.220644</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>388</td>\n",
" <td>Федеральное медико-биологическое агентство</td>\n",
" <td>5.388145e+07</td>\n",
" <td>7.697875e+07</td>\n",
" <td>23097299.7</td>\n",
" <td>42.866887</td>\n",
" </tr>\n",
" <tr>\n",
" <th>87</th>\n",
" <td>498</td>\n",
" <td>Федеральная служба по экологическому, технолог...</td>\n",
" <td>5.106355e+06</td>\n",
" <td>5.197084e+06</td>\n",
" <td>90729.1</td>\n",
" <td>1.776788</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>188</td>\n",
" <td>Министерство внутренних дел Российской Федерации</td>\n",
" <td>9.701729e+08</td>\n",
" <td>9.743664e+08</td>\n",
" <td>4193490.8</td>\n",
" <td>0.432242</td>\n",
" </tr>\n",
" <tr>\n",
" <th>89</th>\n",
" <td>310</td>\n",
" <td>Министерство иностранных дел Российской Федерации</td>\n",
" <td>9.156380e+07</td>\n",
" <td>9.665852e+07</td>\n",
" <td>5094716.4</td>\n",
" <td>5.564116</td>\n",
" </tr>\n",
" <tr>\n",
" <th>90</th>\n",
" <td>089</td>\n",
" <td>Государственная фельдъегерская служба Российск...</td>\n",
" <td>3.758104e+06</td>\n",
" <td>3.760818e+06</td>\n",
" <td>2713.3</td>\n",
" <td>0.072199</td>\n",
" </tr>\n",
" <tr>\n",
" <th>91</th>\n",
" <td>370</td>\n",
" <td>Министерство Российской Федерации по делам Сев...</td>\n",
" <td>2.514073e+07</td>\n",
" <td>2.574120e+07</td>\n",
" <td>600467.7</td>\n",
" <td>2.388426</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92</th>\n",
" <td>730</td>\n",
" <td>Государственная корпорация по космической деят...</td>\n",
" <td>1.231372e+08</td>\n",
" <td>1.340640e+08</td>\n",
" <td>10926775.8</td>\n",
" <td>8.873658</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>93 rows × 6 columns</p>\n",
"</div>"
],
"text/plain": [
" grbs name left \\\n",
"0 321 Федеральная служба государственной регистрации... 3.714834e+07 \n",
"1 322 Федеральная служба судебных приставов 4.850585e+07 \n",
"2 056 Министерство здравоохранения Российской Федерации 2.503724e+08 \n",
"3 171 Федеральное агентство по государственным резервам 1.185634e+07 \n",
"4 180 Федеральная служба войск национальной гвардии ... 2.396682e+08 \n",
"5 071 Министерство цифрового развития, связи и массо... 6.406013e+07 \n",
"6 075 Министерство науки и высшего образования Росси... 5.044598e+08 \n",
"7 150 Федеральная служба по труду и занятости 9.733599e+07 \n",
"8 106 Федеральная служба по надзору в сфере транспорта 4.831153e+06 \n",
"9 587 Федеральная служба по техническому и экспортно... 2.745650e+04 \n",
"10 777 Министерство спорта Российской Федерации 4.232135e+07 \n",
"11 437 Верховный Суд Российской Федерации 5.350487e+06 \n",
"12 724 Федеральная служба по финансовому мониторингу 1.555656e+06 \n",
"13 597 Федеральное государственное бюджетное учрежден... 4.277213e+06 \n",
"14 092 Министерство финансов Российской Федерации 5.438722e+09 \n",
"15 069 Министерство строительства и жилищно-коммуналь... 6.040740e+07 \n",
"16 153 Федеральная таможенная служба 7.420655e+07 \n",
"17 103 Министерство транспорта Российской Федерации 7.532092e+07 \n",
"18 384 Федеральное государственное бюджетное образова... 1.058232e+07 \n",
"19 595 Федеральное государственное бюджетное учрежден... 1.809080e+07 \n",
"20 187 Министерство обороны Российской Федерации 1.776080e+09 \n",
"21 333 Совет Федерации Федерального Собрания Российск... 5.851871e+06 \n",
"22 330 Государственная Дума Федерального Собрания Рос... 1.102721e+07 \n",
"23 167 Федеральное агентство по управлению государств... 5.367362e+06 \n",
"24 725 Государственная корпорация по атомной энергии ... 7.607547e+07 \n",
"25 139 Министерство экономического развития Российско... 1.827283e+08 \n",
"26 073 Министерство просвещения Российской Федерации 3.834346e+07 \n",
"27 155 Федеральное архивное агентство 3.507863e+06 \n",
"28 157 Федеральная служба государственной статистики 1.836810e+07 \n",
"29 135 Федеральное агентство по печати и массовым ком... 7.182274e+07 \n",
".. ... ... ... \n",
"63 084 Федеральное агентство связи 2.877481e+07 \n",
"64 149 Министерство труда и социальной защиты Российс... 2.612750e+08 \n",
"65 022 Министерство энергетики Российской Федерации 2.487886e+07 \n",
"66 053 Федеральное агентство лесного хозяйства 3.244217e+07 \n",
"67 303 Управление делами Президента Российской Федерации 1.279698e+08 \n",
"68 161 Федеральная антимонопольная служба 3.375428e+06 \n",
"69 320 Федеральная служба исполнения наказаний 2.814905e+08 \n",
"70 182 Федеральная налоговая служба 1.298909e+08 \n",
"71 409 Федеральное государственное бюджетное учрежден... 5.143250e+06 \n",
"72 048 Федеральная служба по надзору в сфере природоп... 4.295335e+06 \n",
"73 160 Федеральная служба по регулированию алкогольно... 3.061183e+06 \n",
"74 305 Счетная палата Российской Федерации 4.340441e+06 \n",
"75 020 Министерство промышленности и торговли Российс... 3.764679e+08 \n",
"76 174 Федеральное агентство по туризму 6.305182e+06 \n",
"77 095 Федеральное агентство по делам Содружества Нез... 3.741280e+06 \n",
"78 380 Федеральное агентство по делам национальностей 1.943792e+06 \n",
"79 436 Конституционный Суд Российской Федерации 6.874974e+05 \n",
"80 302 Уполномоченный по правам человека в Российской... 2.679217e+05 \n",
"81 109 Федеральное агентство железнодорожного транспорта 8.224422e+07 \n",
"82 165 Федеральная служба по аккредитации 4.414640e+05 \n",
"83 226 Федеральное государственное бюджетное учрежден... 4.353930e+06 \n",
"84 386 Федеральное государственное бюджетное образова... 1.716879e+07 \n",
"85 051 Министерство природных ресурсов и экологии Рос... 1.331377e+07 \n",
"86 388 Федеральное медико-биологическое агентство 5.388145e+07 \n",
"87 498 Федеральная служба по экологическому, технолог... 5.106355e+06 \n",
"88 188 Министерство внутренних дел Российской Федерации 9.701729e+08 \n",
"89 310 Министерство иностранных дел Российской Федерации 9.156380e+07 \n",
"90 089 Государственная фельдъегерская служба Российск... 3.758104e+06 \n",
"91 370 Министерство Российской Федерации по делам Сев... 2.514073e+07 \n",
"92 730 Государственная корпорация по космической деят... 1.231372e+08 \n",
"\n",
" right diff diff_share \n",
"0 4.421538e+07 7067045.7 19.023856 \n",
"1 5.022678e+07 1720929.6 3.547881 \n",
"2 3.145265e+08 64154047.6 25.623449 \n",
"3 1.674745e+07 4891109.8 41.253102 \n",
"4 2.400250e+08 356878.5 0.148905 \n",
"5 6.761068e+07 3550548.9 5.542525 \n",
"6 7.785733e+08 274113519.5 54.338028 \n",
"7 9.761644e+07 280449.9 0.288126 \n",
"8 5.127324e+06 296170.9 6.130440 \n",
"9 5.730840e+04 29851.9 108.724346 \n",
"10 4.954690e+07 7225546.8 17.073053 \n",
"11 5.359415e+06 8928.2 0.166867 \n",
"12 2.040534e+06 484877.7 31.168699 \n",
"13 4.277213e+06 0.0 0.000000 \n",
"14 5.823450e+09 384728463.2 7.073877 \n",
"15 7.011785e+07 9710444.3 16.074924 \n",
"16 7.471885e+07 512294.1 0.690362 \n",
"17 7.873608e+07 3415165.6 4.534153 \n",
"18 1.186984e+07 1287519.2 12.166697 \n",
"19 1.810459e+07 13795.2 0.076255 \n",
"20 1.804494e+09 28413910.8 1.599810 \n",
"21 6.528795e+06 676923.5 11.567642 \n",
"22 1.102721e+07 0.0 0.000000 \n",
"23 5.451718e+06 84355.8 1.571643 \n",
"24 7.619915e+07 123676.0 0.162570 \n",
"25 2.917710e+08 109042747.3 59.674807 \n",
"26 5.546139e+07 17117930.2 44.643671 \n",
"27 3.709952e+06 202089.1 5.761032 \n",
"28 1.948738e+07 1119281.1 6.093614 \n",
"29 7.192807e+07 105325.4 0.146646 \n",
".. ... ... ... \n",
"63 2.880382e+07 29009.3 0.100815 \n",
"64 2.710460e+08 9771044.9 3.739755 \n",
"65 2.490985e+07 30985.5 0.124545 \n",
"66 3.247280e+07 30631.9 0.094420 \n",
"67 1.338413e+08 5871538.9 4.588224 \n",
"68 3.382510e+06 7082.9 0.209837 \n",
"69 2.842631e+08 2772639.2 0.984985 \n",
"70 1.693756e+08 39484726.1 30.398388 \n",
"71 5.143250e+06 0.0 0.000000 \n",
"72 4.331887e+06 36551.7 0.850963 \n",
"73 3.119087e+06 57903.9 1.891553 \n",
"74 4.347102e+06 6660.7 0.153457 \n",
"75 3.944092e+08 17941259.9 4.765681 \n",
"76 6.389091e+06 83909.8 1.330807 \n",
"77 3.763294e+06 22013.7 0.588400 \n",
"78 2.777898e+06 834105.6 42.911260 \n",
"79 6.874974e+05 0.0 0.000000 \n",
"80 2.974306e+05 29508.9 11.014001 \n",
"81 9.922822e+07 16984005.5 20.650699 \n",
"82 4.751911e+05 33727.1 7.639830 \n",
"83 5.053930e+06 700000.0 16.077430 \n",
"84 1.717278e+07 3984.0 0.023205 \n",
"85 1.374256e+07 428789.1 3.220644 \n",
"86 7.697875e+07 23097299.7 42.866887 \n",
"87 5.197084e+06 90729.1 1.776788 \n",
"88 9.743664e+08 4193490.8 0.432242 \n",
"89 9.665852e+07 5094716.4 5.564116 \n",
"90 3.760818e+06 2713.3 0.072199 \n",
"91 2.574120e+07 600467.7 2.388426 \n",
"92 1.340640e+08 10926775.8 8.873658 \n",
"\n",
"[93 rows x 6 columns]"
]
},
"execution_count": 74,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"grbs_diff"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Теперь у нас есть сравненительная таблица изменений бюджетных проектировок по расходам ГРБС на 2019 год. Но нас может интересовать не только ГРБС, но и госпрограммы. Как меняется структура госпрограмм в связи с изменениями? Попробуем это подсчитать и вернемся к изначальном данным из которых мы начинали работать с ГРБС\n"
]
},
{
"cell_type": "code",
"execution_count": 104,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/usr/local/lib/python3.6/dist-packages/ipykernel_launcher.py:2: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
" \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>prg</th>\n",
" <th>name</th>\n",
" <th>summ</th>\n",
" <th>total</th>\n",
" <th>share</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>31000</td>\n",
" <td>Обеспечение обороноспособности страны</td>\n",
" <td>1.400705e+09</td>\n",
" <td>9.636223e+09</td>\n",
" <td>14.535831</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>39000</td>\n",
" <td>Управление государственными финансами и регули...</td>\n",
" <td>1.279080e+09</td>\n",
" <td>9.636223e+09</td>\n",
" <td>13.273665</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>03000</td>\n",
" <td>Социальная поддержка граждан</td>\n",
" <td>9.599034e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>9.961407</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>36000</td>\n",
" <td>Развитие федеративных отношений и создание усл...</td>\n",
" <td>9.004934e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>9.344879</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>08000</td>\n",
" <td>Обеспечение общественного порядка и противодей...</td>\n",
" <td>6.917512e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>7.178654</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>24000</td>\n",
" <td>Развитие транспортной системы</td>\n",
" <td>6.899236e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>7.159689</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>47000</td>\n",
" <td>Научно-технологическое развитие Российской Фед...</td>\n",
" <td>6.735502e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>6.989774</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>01000</td>\n",
" <td>Развитие здравоохранения</td>\n",
" <td>3.585902e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>3.721273</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>42000</td>\n",
" <td>Юстиция</td>\n",
" <td>2.820447e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>2.926922</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>16000</td>\n",
" <td>Развитие промышленности и повышение ее конкуре...</td>\n",
" <td>2.801913e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>2.907688</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>25000</td>\n",
" <td>Государственная программа развития сельского х...</td>\n",
" <td>2.601461e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>2.699669</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>21000</td>\n",
" <td>Космическая деятельность России</td>\n",
" <td>1.951499e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>2.025170</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>23000</td>\n",
" <td>Информационное общество</td>\n",
" <td>1.923361e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>1.995969</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>10000</td>\n",
" <td>Защита населения и территорий от чрезвычайных ...</td>\n",
" <td>1.805341e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>1.873495</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>45000</td>\n",
" <td>Социально-экономическое развитие Республики Кр...</td>\n",
" <td>1.504670e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>1.561472</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>41000</td>\n",
" <td>Внешнеполитическая деятельность</td>\n",
" <td>1.199649e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>1.244936</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>11000</td>\n",
" <td>Развитие культуры и туризма</td>\n",
" <td>1.175977e+08</td>\n",
" <td>9.636223e+09</td>\n",
" <td>1.220371</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>15000</td>\n",
" <td>Экономическое развитие и инновационная экономика</td>\n",
" <td>8.297312e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.861054</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>27000</td>\n",
" <td>Развитие внешнеэкономической деятельности</td>\n",
" <td>7.697353e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.798794</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>22000</td>\n",
" <td>Развитие атомного энергопромышленного комплекса</td>\n",
" <td>7.084081e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.735151</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>37000</td>\n",
" <td>Социально-экономическое развитие Калининградск...</td>\n",
" <td>6.791320e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.704770</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>02000</td>\n",
" <td>Развитие образования</td>\n",
" <td>6.270753e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.650748</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>17000</td>\n",
" <td>Развитие авиационной промышленности</td>\n",
" <td>5.846182e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.606688</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>07000</td>\n",
" <td>Содействие занятости населения</td>\n",
" <td>5.838553e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.605896</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>05000</td>\n",
" <td>Обеспечение доступным и комфортным жильем и ко...</td>\n",
" <td>5.727432e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.594365</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>04000</td>\n",
" <td>Доступная среда</td>\n",
" <td>5.379924e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.558302</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>28000</td>\n",
" <td>Воспроизводство и использование природных ресу...</td>\n",
" <td>4.928678e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.511474</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>34000</td>\n",
" <td>Социально-экономическое развитие Дальнего Вост...</td>\n",
" <td>4.774189e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.495442</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>12000</td>\n",
" <td>Охрана окружающей среды</td>\n",
" <td>4.468669e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.463737</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>13000</td>\n",
" <td>Развитие физической культуры и спорта</td>\n",
" <td>3.591092e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.372666</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>29000</td>\n",
" <td>Развитие лесного хозяйства</td>\n",
" <td>3.245494e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.336801</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>30000</td>\n",
" <td>Развитие энергетики</td>\n",
" <td>1.595726e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.165597</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>38000</td>\n",
" <td>Управление федеральным имуществом</td>\n",
" <td>1.581141e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.164083</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>26000</td>\n",
" <td>Развитие рыбохозяйственного комплекса</td>\n",
" <td>1.384248e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.143650</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>35000</td>\n",
" <td>Развитие Северо-Кавказского федерального округа</td>\n",
" <td>1.301368e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.135050</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>20000</td>\n",
" <td>Развитие фармацевтической и медицинской промыш...</td>\n",
" <td>1.135440e+07</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.117830</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>19000</td>\n",
" <td>Развитие электронной и радиоэлектронной промыш...</td>\n",
" <td>9.910113e+06</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.102842</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>18000</td>\n",
" <td>Развитие судостроения и техники для освоения ш...</td>\n",
" <td>8.907866e+06</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.092441</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>44000</td>\n",
" <td>Развитие оборонно-промышленного комплекса</td>\n",
" <td>5.949180e+06</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.061738</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>43000</td>\n",
" <td>Социально-экономическое развитие Арктической з...</td>\n",
" <td>5.675800e+06</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.058901</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>46000</td>\n",
" <td>Реализация государственной национальной политики</td>\n",
" <td>2.378501e+06</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.024683</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>32000</td>\n",
" <td>Обеспечение государственной безопасности</td>\n",
" <td>1.583112e+06</td>\n",
" <td>9.636223e+09</td>\n",
" <td>0.016429</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" prg name summ \\\n",
"36 31000 Обеспечение обороноспособности страны 1.400705e+09 \n",
"34 39000 Управление государственными финансами и регули... 1.279080e+09 \n",
"21 03000 Социальная поддержка граждан 9.599034e+08 \n",
"35 36000 Развитие федеративных отношений и создание усл... 9.004934e+08 \n",
"4 08000 Обеспечение общественного порядка и противодей... 6.917512e+08 \n",
"37 24000 Развитие транспортной системы 6.899236e+08 \n",
"19 47000 Научно-технологическое развитие Российской Фед... 6.735502e+08 \n",
"22 01000 Развитие здравоохранения 3.585902e+08 \n",
"40 42000 Юстиция 2.820447e+08 \n",
"2 16000 Развитие промышленности и повышение ее конкуре... 2.801913e+08 \n",
"30 25000 Государственная программа развития сельского х... 2.601461e+08 \n",
"8 21000 Космическая деятельность России 1.951499e+08 \n",
"26 23000 Информационное общество 1.923361e+08 \n",
"10 10000 Защита населения и территорий от чрезвычайных ... 1.805341e+08 \n",
"15 45000 Социально-экономическое развитие Республики Кр... 1.504670e+08 \n",
"29 41000 Внешнеполитическая деятельность 1.199649e+08 \n",
"13 11000 Развитие культуры и туризма 1.175977e+08 \n",
"31 15000 Экономическое развитие и инновационная экономика 8.297312e+07 \n",
"1 27000 Развитие внешнеэкономической деятельности 7.697353e+07 \n",
"11 22000 Развитие атомного энергопромышленного комплекса 7.084081e+07 \n",
"33 37000 Социально-экономическое развитие Калининградск... 6.791320e+07 \n",
"12 02000 Развитие образования 6.270753e+07 \n",
"0 17000 Развитие авиационной промышленности 5.846182e+07 \n",
"38 07000 Содействие занятости населения 5.838553e+07 \n",
"24 05000 Обеспечение доступным и комфортным жильем и ко... 5.727432e+07 \n",
"27 04000 Доступная среда 5.379924e+07 \n",
"17 28000 Воспроизводство и использование природных ресу... 4.928678e+07 \n",
"23 34000 Социально-экономическое развитие Дальнего Вост... 4.774189e+07 \n",
"16 12000 Охрана окружающей среды 4.468669e+07 \n",
"28 13000 Развитие физической культуры и спорта 3.591092e+07 \n",
"18 29000 Развитие лесного хозяйства 3.245494e+07 \n",
"14 30000 Развитие энергетики 1.595726e+07 \n",
"39 38000 Управление федеральным имуществом 1.581141e+07 \n",
"32 26000 Развитие рыбохозяйственного комплекса 1.384248e+07 \n",
"25 35000 Развитие Северо-Кавказского федерального округа 1.301368e+07 \n",
"7 20000 Развитие фармацевтической и медицинской промыш... 1.135440e+07 \n",
"6 19000 Развитие электронной и радиоэлектронной промыш... 9.910113e+06 \n",
"5 18000 Развитие судостроения и техники для освоения ш... 8.907866e+06 \n",
"3 44000 Развитие оборонно-промышленного комплекса 5.949180e+06 \n",
"9 43000 Социально-экономическое развитие Арктической з... 5.675800e+06 \n",
"20 46000 Реализация государственной национальной политики 2.378501e+06 \n",
"41 32000 Обеспечение государственной безопасности 1.583112e+06 \n",
"\n",
" total share \n",
"36 9.636223e+09 14.535831 \n",
"34 9.636223e+09 13.273665 \n",
"21 9.636223e+09 9.961407 \n",
"35 9.636223e+09 9.344879 \n",
"4 9.636223e+09 7.178654 \n",
"37 9.636223e+09 7.159689 \n",
"19 9.636223e+09 6.989774 \n",
"22 9.636223e+09 3.721273 \n",
"40 9.636223e+09 2.926922 \n",
"2 9.636223e+09 2.907688 \n",
"30 9.636223e+09 2.699669 \n",
"8 9.636223e+09 2.025170 \n",
"26 9.636223e+09 1.995969 \n",
"10 9.636223e+09 1.873495 \n",
"15 9.636223e+09 1.561472 \n",
"29 9.636223e+09 1.244936 \n",
"13 9.636223e+09 1.220371 \n",
"31 9.636223e+09 0.861054 \n",
"1 9.636223e+09 0.798794 \n",
"11 9.636223e+09 0.735151 \n",
"33 9.636223e+09 0.704770 \n",
"12 9.636223e+09 0.650748 \n",
"0 9.636223e+09 0.606688 \n",
"38 9.636223e+09 0.605896 \n",
"24 9.636223e+09 0.594365 \n",
"27 9.636223e+09 0.558302 \n",
"17 9.636223e+09 0.511474 \n",
"23 9.636223e+09 0.495442 \n",
"16 9.636223e+09 0.463737 \n",
"28 9.636223e+09 0.372666 \n",
"18 9.636223e+09 0.336801 \n",
"14 9.636223e+09 0.165597 \n",
"39 9.636223e+09 0.164083 \n",
"32 9.636223e+09 0.143650 \n",
"25 9.636223e+09 0.135050 \n",
"7 9.636223e+09 0.117830 \n",
"6 9.636223e+09 0.102842 \n",
"5 9.636223e+09 0.092441 \n",
"3 9.636223e+09 0.061738 \n",
"9 9.636223e+09 0.058901 \n",
"20 9.636223e+09 0.024683 \n",
"41 9.636223e+09 0.016429 "
]
},
"execution_count": 104,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#df['topic'].unique()\n",
"df_programs = df.loc[df['vr'].isnull()].loc[df['csr_program'].isnull() == False][df['csr_program'].str[-3:] == '000'][df['name'].str.contains('программа') == True]\n",
"df_prguniq = df_programs['csr_program'].unique()\n",
"prg_table = []\n",
"for ug in df_prguniq:\n",
" prg = df_programs.loc[df_programs['csr_program'] == ug]\n",
" record = {'prg' : ug, 'name' : prg['name'].values[0].split('Российской Федерации', 1)[-1].strip().strip('\"'), 'summ' : sum(prg['budget2019'].values)}\n",
"# record['grbs'] = ug\n",
" # record['diff'] = record['right'] - record['left']\n",
"# record['diff_share'] = (record['right'] - record['left']) * 100.0 / record['left'] if record['left'] > 0 else 0 \n",
" prg_table.append(record)\n",
"prg_frame = pd.DataFrame(prg_table, columns=['prg', 'name', 'summ'])\n",
"\n",
"prg_frame['total'] = sum(prg_frame['summ'].values)\n",
"prg_frame['share'] = 100.0 * prg_frame['summ'] / prg_frame['total']\n",
"prg_frame.sort_values(by=['share'], ascending=False)\n",
"\n",
"#df.loc[df['csr_program'] == '91000']\n"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"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.7"
},
"pycharm": {
"stem_cell": {
"cell_type": "raw",
"source": [],
"metadata": {
"collapsed": false
}
}
}
},
"nbformat": 4,
"nbformat_minor": 2
}