Порядок получения данных

1. Парсинг сайтов

Коротко о том, что такое парсер/граббер/скраппер. Например, отсюда - http://myblaze.ru/chto-takoe-parser-grabber/

2. Предыдущий опыт

Работа с WebScrapper - специальное расширение для Chrome (http://webscraper.io/). Простой в освоении, т.к. не требует знания языков программирования. На основе данных, полученных в результате парсинга, создан проект “Рейтинг школ Запорожья” - http://uadata.blogspot.com/2015/03/blog-post_24.html

3. Постановка задачи

Получить данные о налоговой задолженности государственных предприятий. Открытого реестра в Интернете нет. Точка старта - материал “Топ 100 налоговых должников” (https://opendatabot.com/statistics/debts). В рейтинге представлены лишь некоторые госпредприятия.

4. Анализ и выбор методов решения

Со страницы рейтинга есть возможность перейти на страницу каждого из предприятий с подробной информацией, в т.ч. с информацией об актуальной сумме налоговой задолженности.

Ссылка на страницу каждого предприятия содержит его код ЕГРПОУ. Таким образом, имея список кодов интересуемых предприятий можно организовать “проход” по их страницам на opendatabot.com для сбора информации.

Эту задачу нельзя реализовать в WebScrapper., т.к. требуется написание отдельного кода на языке программирования, например R.

Для парсинга статических страниц в R можно использовать пакет rvest (пример работы с пакетом - http://stat4701.github.io/edav/2015/04/02/rvest_tutorial/).

Однако в нашем случае блок с необходимой информацией встраивается в станицу предприятия “на лету” через НТТР-запрос без перезагрузки страницу (это видно через Chrome – Developer Tools – Network при обновлении страницы). Этот блок (div.attention) остается пустым, пока вы прямо не обращаетесь к странице со скриптом, который делает запрос. Т.е. получить информацию простым считыванием структуры документа через rvest в этом случае невозможно.

Парсинг динамических страниц в R реализован с помощью пакета RSelenium (основы работы - https://cran.r-project.org/web/packages/RSelenium/vignettes/RSelenium-basics.html).

5. Виртуальный сервер

Для работы с пакетом RSelenium необходимо запустить виртуальный сервер.

Порядок установки и запуска (минимумом сторонних приложений и сервисов): - скачать файл selenium-server-standalone-x.x.x.jar вот отсюда #http://selenium-release.storage.googleapis.com/index.html - обновить/установить java вот отсюда https://java.com/ru/download/manual.jsp - скачать geckodriver вот отсюда https://github.com/mozilla/geckodriver/releases (зачем? - http://barancev.github.io/geckodriver/) - добавить путь к папке установки java (например, C:Files1.8.0_121) и к папке расположения файла geckodriver.exe в переменную PATH (что такое PATH? - http://barancev.github.io/what-is-path-env-var/#toc3)

6. Написание и тестирование кода

Поскольку в нашем случае речь идет о парсинге большого количества страниц (до 2500), то необходимо позаботится о функции обработки ошибок открытия страниц.
Это можно сделать с помощью функции tryCatch(). Примеры работы - http://stackoverflow.com/questions/12193779/how-to-write-trycatch-in-r и http://stackoverflow.com/questions/39056103/iterating-rvest-scrape-function-gives-error-in-open-connectionx-rb-time.

Последний пример наиболее подходит для нашей задачи.

Важно! Для работы скрипта необходимо вручную запустить виртуальный сервер через cmd.exe

Основные комментарии приведены прямо в коде.

7. Результаты и доработка

Результаты тестирвания на выборке 500 предприятий

## [1] "Connecting to remote server"
## $rotatable
## [1] FALSE
## 
## $raisesAccessibilityExceptions
## [1] FALSE
## 
## $firefoxOptions
## $firefoxOptions$args
## list()
## 
## $firefoxOptions$profile
## [1] "UEsDBBQACAgIAAq3NkoAAAAAAAAAAAAAAAAHAAAAdXNlci5qc51WTW/bMAy971cMOW3AKqTretlOXdcBA4Z1aFDsKMgSbauRJU0fcfPvR/mjSRNHbndKbJMS+fj4yOjBUeugfLconGnxiXhWQvdf6oo0TLXMAQHNCgVi8eFtyZSH91/exJ2nYAFtrHEhudTAVKj7Z4JGG8ln/DWE1rg1qUOwxNbS19uz9Nky788U6CrU6Pjx8vK52xiwAybwR0AAHkB8l86HK4yFK0C34OJhuKbBvB4pr51pgHrupA3URU2DbJLLxXL6osAKTxAOfauvlfEwnc1oLUyrlWEC79KsSsDWpv1Tg14hWgmpaXeLQdng02W0MYKpGexhE4xRnoBzxnGjvVH7cB+n72WljUbUGmgKcKvu0edz8eC9RKtgkAsOfETcSgyUcsd8nfdVUq+JsaApPAZwmqlUzFczqExlvYt6+rIWCuHkBp8Z54DljBoz90gHysEFP4nEU6Wkt4ptQdycL1e/DDInlfbTtDG+Erf6j9RYX3++JBIvMvd3P9FjwQoTw+dCMb1eHHOuT4gypeiDRzBSnLKH/ji2RysRbrQlbS0DKOkDHvA3SneKCYkGaxnI0E0j6zC5xIUsAIphYbAB8lTzibfRkhq7xuLZtAXFUwdFl0q6OEg5VVt3rCHRYoGBaIS23N6jyat1JNrUSjfZ8IBHJ8MWmaIA/xEfnOSBGicrqak1SvJtnqoaWmw7MuSTqeazQPuTSXq5ikUju1b53b286sj4Mt2cPCab8VN3DoVJRUHLE+q160NMs+34e9yIpizRDs6YtZ4g+0xLiy0VULKowrScjLBzbwf+TEd7zIcs20Y6I/dRqYLbkl4ZO/uPc7bZo0dEbu5/XpELwnZFOk7vgW1YPyGyonpYirFH8jw6jtvBQzfEspf0NE3H5/PcQ5zFYL71SrDiSIIkOufLUxran0o1C/hIYQN6RkH3JuMtMmw2nEIZvu407UWF8sAcrwfazE3dhvTkJiI2Nls0JPmLqPiMLwYBclJMC+qRBh2Kz8X05tOL9dnYfciiEGdG8mB7QlmGFWd+t9kbnL4b67vBiQoUO6nOIpeYNR3EXuuYftJ1K9APfd1vKSeXs2Fk0U6sBMKoK5rkf4YkNeC05DXw9bder772X14/zQgTQqaI2cwgmNyZ/3dXVqaq0sthictK/14vdRlfozRitxZSJfZpWdVBnRh2e67jjf+jbHRsBNLgWtgRcZFWSQcHGO02mbR5IrFxf5xZZXZ9r0ofbb8B7JaMf1BLBwh1hce1pQMAALUMAABQSwECFAAUAAgICAAKtzZKdYXHtaUDAAC1DAAABwAAAAAAAAAAAAAAAAAAAAAAdXNlci5qc1BLBQYAAAAAAQABADUAAADaAwAAAAA="
## 
## 
## $appBuildId
## [1] "20161208153507"
## 
## $version
## [1] ""
## 
## $platform
## [1] "XP"
## 
## $proxy
## named list()
## 
## $command_id
## [1] 1
## 
## $nativeEvents
## [1] TRUE
## 
## $specificationLevel
## [1] 0
## 
## $acceptSslCerts
## [1] FALSE
## 
## $processId
## [1] 6056
## 
## $webdriver.remote.sessionid
## [1] "ea944fea-e693-41a7-b369-bb6000bc1c2f"
## 
## $browserVersion
## [1] "50.1.0"
## 
## $platformVersion
## [1] "10.0"
## 
## $XULappId
## [1] "{ec8030f7-c20a-464f-9b0e-13a3a9e97384}"
## 
## $browserName
## [1] "firefox"
## 
## $takesScreenshot
## [1] TRUE
## 
## $javascriptEnabled
## [1] TRUE
## 
## $takesElementScreenshot
## [1] TRUE
## 
## $platformName
## [1] "windows_nt"
## 
## $cssSelectorsEnabled
## [1] TRUE
## 
## $id
## [1] "ea944fea-e693-41a7-b369-bb6000bc1c2f"

## Doing 12256 ... Done.
## Doing 15332 ... Done.
## Doing 18201 ... Done.
## Doing 26867 ... Done.
## Doing 32112 ... Done.
## Doing 32129 ... Done.
## Doing 34861 ... Done.
## Doing 36044 ... Done.
## Doing 41467 ... Done.
## Doing 100227 ... Done.
## Doing 113968 ... Done.
## Doing 113980 ... Done.
## Doing 114092 ... Done.
## Doing 116903 ... Done.
## Doing 130044 ... Done.
## Doing 130441 ... Done.
## Doing 130725 ... Done.
## Doing 130820 ... Done.
## Doing 130850 ... Done.
## Doing 130926 ... Done.
## Doing 131050 ... Done.
## Doing 131067 ... Done.
## Doing 131771 ... Done.
## Doing 131954 ... Done.
## Doing 132842 ... Done.
## Doing 147921 ... Done.
## Doing 149943 ... Done.
## Doing 150113 ... Done.
## Doing 151644 ... Done.
## Doing 152052 ... Done.
## Doing 152135 ... Done.
## Doing 152365 ... Done.
## Doing 152402 ... Done.
## Doing 152448 ... Done.
## Doing 152595 ... Done.
## Doing 152603 ... Done.
## Doing 159284 ... Done.
## Doing 159367 ... Done.
## Doing 159373 ... Done.
## Doing 159396 ... Done.
## Doing 159427 ... Done.
## Doing 159441 ... Done.
## Doing 159456 ... Done.
## Doing 159462 ... Done.
## Doing 159479 ... Done.
## Doing 159485 ... Done.
## Doing 165652 ... Done.
## Doing 167606 ... Done.
## Doing 168550 ... Done.
## Doing 170096 ... Done.
## Doing 171121 ... Done.
## Doing 171144 ... Done.
## Doing 174036 ... Done.
## Doing 174071 ... Done.
## Doing 174088 ... Done.
## Doing 174102 ... Done.
## Doing 174125 ... Done.
## Doing 174668 ... Done.
## Doing 174697 ... Done.
## Doing 174777 ... Done.
## Doing 174786 ... Done.
## Doing 174800 ... Done.
## Doing 175308 ... Done.
## Doing 175633 ... Done.
## Doing 175641 ... Done.
## Doing 175685 ... Done.
## Doing 175716 ... Done.
## Doing 175739 ... Done.
## Doing 175745 ... Done.
## Doing 175751 ... Done.
## Doing 175768 .......
## Doing 175774 ... Done.
## Doing 175811 ... Done.
## Doing 175840 ... Done.
## Doing 176087 ... Done.
## Doing 176408 ... Done.
## Doing 176516 ... Done.
## Doing 176644 ... Done.
## Doing 176785 ... Done.
## Doing 176791 ... Done.
## Doing 176839 ... Done.
## Doing 176868 ... Done.
## Doing 176897 ... Done.
## Doing 176934 ... Done.
## Doing 177081 ... Done.
## Doing 177129 ... Done.
## Doing 177632 ... Done.
## Doing 178011 ... Done.
## Doing 178028 ... Done.
## Doing 178063 ... Done.
## Doing 178136 .......
## Doing 178175 ... Done.
## Doing 178594 ... Done.
## Doing 179000 ... Done.
## Doing 179039 ... Done.
## Doing 179252 ... Done.
## Doing 179364 ... Done.
## Doing 179559 ... Done.
## Doing 179737 ... Done.
## Doing 179752 ... Done.
## Doing 179938 ... Done.
## Doing 179967 ... Done.
## Doing 180077 ... Done.
## Doing 180092 ... Done.
## Doing 180108 ... Done.
## Doing 180120 ... Done.
## Doing 180137 ... Done.
## Doing 180189 ... Done.
## Doing 180338 ... Done.
## Doing 180367 ... Done.
## Doing 180373 ... Done.
## Doing 180410 ... Done.
## Doing 180568 ... Done.
## Doing 180634 ... Done.
## Doing 180717 ... Done.
## Doing 180798 ... Done.
## Doing 180841 ... Done.
## Doing 180982 ... Done.
## Doing 180999 ... Done.
## Doing 181119 ... Done.
## Doing 181183 ... Done.
## Doing 181421 ... Done.
## Doing 181473 ... Done.
## Doing 181585 ... Done.
## Doing 181846 ... Done.
## Doing 181993 ... Done.
## Doing 182018 ... Done.
## Doing 182159 ... Done.
## Doing 182395 ... Done.
## Doing 183360 ... Done.
## Doing 183472 ... Done.
## Doing 183696 ... Done.
## Doing 183880 ... Done.
## Doing 184052 ... Done.
## Doing 184268 ... Done.
## Doing 184715 ... Done.
## Doing 185666 .......
## Doing 185755 ... Done.
## Doing 185778 ... Done.
## Doing 185790 ... Done.
## Doing 186022 ... Done.
## Doing 186080 ... Done.
## Doing 186192 ... Done.
## Doing 187369 ... Done.
## Doing 188311 ... Done.
## Doing 188334 ... Done.
## Doing 189635 ... Done.
## Doing 190325 ... Done.
## Doing 190414 ... Done.
## Doing 190443 ... Done.
## Doing 190454 ... Done.
## Doing 190503 ... Done.
## Doing 190578 ... Done.
## Doing 190696 ... Done.
## Doing 191017 ... Done.
## Doing 191141 ... Done.
## Doing 191170 ... Done.
## Doing 191508 ... Done.
## Doing 191951 ... Done.
## Doing 192614 ... Done.
## Doing 193016 ... Done.
## Doing 193683 ... Done.
## Doing 193714 ... Done.
## Doing 193720 ... Done.
## Doing 193737 ... Done.
## Doing 193766 ... Done.
## Doing 193772 ... Done.
## Doing 193795 ... Done.
## Doing 194122 ... Done.
## Doing 194317 ... Done.
## Doing 196173 ... Done.
## Doing 201081 ... Done.
## Doing 201514 ... Done.
## Doing 203625 ... Done.
## Doing 204895 ... Done.
## Doing 205015 ... Done.
## Doing 205096 ... Done.
## Doing 205104 ... Done.
## Doing 205937 ... Done.
## Doing 206138 ... Done.
## Doing 206256 ... Done.
## Doing 206300 ... Done.
## Doing 206539 ... Done.
## Doing 208054 ... Done.
## Doing 208213 ... Done.
## Doing 209102 ... Done.
## Doing 209119 ... Done.
## Doing 209131 ... Done.
## Doing 209154 ... Done.
## Doing 209160 ... Done.
## Doing 209355 ... Done.
## Doing 209740 ... Done.
## Doing 209830 ... Done.
## Doing 209875 ... Done.
## Doing 212630 ... Done.
## Doing 213121 ... Done.
## Doing 214511 ... Done.
## Doing 216488 ... Done.
## Doing 216869 ... Done.
## Doing 216875 ... Done.
## Doing 217018 ... Done.
## Doing 217159 ... Done.
## Doing 219388 ... Done.
## Doing 220477 ... Done.
## Doing 222120 ... Done.
## Doing 222367 ... Done.
## Doing 223705 ... Done.
## Doing 224294 ... Done.
## Doing 224834 ... Done.
## Doing 224857 ... Done.
## Doing 224892 ... Done.
## Doing 224946 ... Done.
## Doing 230480 ... Done.
## Doing 230496 ... Done.
## Doing 230774 ... Done.
## Doing 231320 ... Done.
## Doing 231878 ... Done.
## Doing 231981 ... Done.
## Doing 237630 ... Done.
## Doing 238180 ... Done.
## Doing 239066 ... Done.
## Doing 240106 ... Done.
## Doing 244127 ... Done.
## Doing 260652 ... Done.
## Doing 274453 ... Done.
## Doing 274536 ... Done.
## Doing 274660 ... Done.
## Doing 275955 ... Done.
## Doing 276127 ... Done.
## Doing 277693 ... Done.
## Doing 281051 ... Done.
## Doing 282406 ... Done.
## Doing 282435 ... Done.
## Doing 282464 ... Done.
## Doing 282553 ... Done.
## Doing 284569 ... Done.
## Doing 285735 ... Done.
## Doing 290446 ... Done.
## Doing 290452 ... Done.
## Doing 291687 ... Done.
## Doing 292184 ... Done.
## Doing 292273 ... Done.
## Doing 292296 ... Done.
## Doing 293574 ... Done.
## Doing 294314 ... Done.
## Doing 294349 ... Done.
## Doing 301925 ... Done.
## Doing 308488 ... Done.
## Doing 309306 ... Done.
## Doing 310858 ... Done.
## Doing 311303 ... Done.
## Doing 311496 ... Done.
## Doing 311533 ... Done.
## Doing 333339 ... Done.
## Doing 333380 ... Done.
## Doing 334422 ... Done.
## Doing 334439 ... Done.
## Doing 334764 ... Done.
## Doing 334770 ... Done.
## Doing 334824 ... Done.
## Doing 334882 ... Done.
## Doing 371943 ... Done.
## Doing 371989 ... Done.
## Doing 373735 ... Done.
## Doing 373741 ... Done.
## Doing 374580 ... Done.
## Doing 374628 ... Done.
## Doing 374634 ... Done.
## Doing 374663 ... Done.
## Doing 374686 ... Done.
## Doing 374700 ... Done.
## Doing 374717 ... Done.
## Doing 374733 ... Done.
## Doing 374769 ... Done.
## Doing 374781 ... Done.
## Doing 374798 ... Done.
## Doing 374806 ... Done.
## Doing 374829 ... Done.
## Doing 374841 ... Done.
## Doing 374893 ... Done.
## Doing 374918 ... Done.
## Doing 374947 ... Done.
## Doing 374953 ... Done.
## Doing 374982 ... Done.
## Doing 375020 ... Done.
## Doing 375036 ... Done.
## Doing 375059 ... Done.
## Doing 375065 ... Done.
## Doing 375071 ... Done.
## Doing 375088 ... Done.
## Doing 375094 ... Done.
## Doing 375102 ... Done.
## Doing 375125 ... Done.
## Doing 375131 ... Done.
## Doing 375148 ... Done.
## Doing 375154 ... Done.
## Doing 375195 ... Done.
## Doing 375208 ... Done.
## Doing 375214 ... Done.
## Doing 375220 ... Done.
## Doing 375237 ... Done.
## Doing 375250 ... Done.
## Doing 375266 ... Done.
## Doing 375272 ... Done.
## Doing 375289 ... Done.
## Doing 375303 ... Done.
## Doing 375314 ... Done.
## Doing 375332 ... Done.
## Doing 375349 ... Done.
## Doing 375355 ... Done.
## Doing 375361 ... Done.
## Doing 375378 ... Done.
## Doing 375390 ... Done.
## Doing 375409 ... Done.
## Doing 375415 ... Done.
## Doing 375421 ... Done.
## Doing 375444 ... Done.
## Doing 375450 ... Done.
## Doing 375504 ... Done.
## Doing 376372 ... Done.
## Doing 376998 ... Done.
## Doing 377822 ... Done.
## Doing 377905 ... Done.
## Doing 378844 ... Done.
## Doing 378856 ... Done.
## Doing 379790 ... Done.
## Doing 379850 ... Done.
## Doing 383544 ... Done.
## Doing 383567 ... Done.
## Doing 383596 ... Done.
## Doing 383604 ... Done.
## Doing 384549 ... Done.
## Doing 384682 ... Done.
## Doing 385034 ... Done.
## Doing 385069 ... Done.
## Doing 385106 ... Done.
## Doing 387128 ... Done.
## Doing 387298 ... Done.
## Doing 388168 ... Done.
## Doing 388211 .......
## Doing 411832 ... Done.
## Doing 411849 ... Done.
## Doing 411890 ... Done.
## Doing 412040 ... Done.
## Doing 412091 ... Done.
## Doing 412174 ... Done.
## Doing 412240 ... Done.
## Doing 412582 ... Done.
## Doing 412665 ... Done.
## Doing 412694 ... Done.
## Doing 412719 ... Done.
## Doing 412725 ... Done.
## Doing 412754 ... Done.
## Doing 412760 ... Done.
## Doing 412820 ... Done.
## Doing 412837 ... Done.
## Doing 412843 ... Done.
## Doing 412866 ... Done.
## Doing 412872 ... Done.
## Doing 412926 ... Done.
## Doing 412984 ... Done.
## Doing 412990 ... Done.
## Doing 413009 ... Done.
## Doing 413015 ... Done.
## Doing 413067 ... Done.
## Doing 413208 ... Done.
## Doing 413274 ... Done.
## Doing 413765 ... Done.
## Doing 413794 ... Done.
## Doing 413802 ... Done.
## Doing 413819 ... Done.
## Doing 413825 ... Done.
## Doing 413831 ... Done.
## Doing 413895 ... Done.
## Doing 413995 ... Done.
## Doing 415072 ... Done.
## Doing 415416 ... Done.
## Doing 415468 ... Done.
## Doing 415712 ... Done.
## Doing 415729 ... Done.
## Doing 426302 ... Done.
## Doing 434247 ... Done.
## Doing 449131 ... Done.
## Doing 451116 ... Done.
## Doing 467169 ... Done.
## Doing 467873 ... Done.
## Doing 468068 ... Done.
## Doing 468177 ... Done.
## Doing 470252 ... Done.
## Doing 472265 ... Done.
## Doing 472609 ... Done.
## Doing 479824 ... Done.
## Doing 480247 ... Done.
## Doing 481525 .......
## Doing 481531 ... Done.
## Doing 481548 ... Done.
## Doing 481554 ... Done.
## Doing 481653 ... Done.
## Doing 482329 ... Done.
## Doing 482714 ... Done.
## Doing 482973 ... Done.
## Doing 482986 ... Done.
## Doing 482996 ... Done.
## Doing 483004 ... Done.
## Doing 483010 ... Done.
## Doing 483027 ... Done.
## Doing 484015 ... Done.
## Doing 485517 ... Done.
## Doing 485670 ... Done.
## Doing 485829 ... Done.
## Doing 485836 ... Done.
## Doing 487155 ... Done.
## Doing 487172 ... Done.
## Doing 487462 ... Done.
## Doing 487522 ... Done.
## Doing 487545 ... Done.
## Doing 487551 ... Done.
## Doing 489797 ... Done.
## Doing 492279 ... Done.
## Doing 494373 ... Done.
## Doing 494427 ... Done.
## Doing 494500 ... Done.
## Doing 494522 ... Done.
## Doing 494597 ... Done.
## Doing 494605 ... Done.
## Doing 494611 ... Done.
## Doing 495800 ... Done.
## Doing 496550 ... Done.
## Doing 496573 ... Done.
## Doing 496633 ... Done.
## Doing 496656 ... Done.
## Doing 496685 ... Done.
## Doing 496722 ... Done.
## Doing 496739 ... Done.
## Doing 496840 ... Done.
## Doing 496892 ... Done.
## Doing 496917 ... Done.
## Doing 496923 ... Done.
## Doing 497029 ... Done.
## Doing 497070 ... Done.
## Doing 497294 ... Done.
## Doing 497302 ... Done.
## Doing 497319 ... Done.
## Doing 497348 ... Done.
## Doing 497638 ... Done.
## Doing 497644 ... Done.
## Doing 497673 ... Done.
## Doing 497681 ... Done.
## Doing 497696 ... Done.
## Doing 497704 ... Done.
## Doing 497727 ... Done.
## Doing 497800 ... Done.
## Doing 498052 ... Done.
## Doing 498069 ... Done.
## Doing 659101 ... Done.
## Doing 686247 ... Done.
## Doing 686374 ... Done.
## Doing 689102 ... Done.
## Doing 689177 ... Done.
## Doing 689183 ... Done.
## Doing 689190 ... Done.
## Doing 689208 ... Done.
## Doing 689214 ... Done.
## Doing 689237 ... Done.
## Doing 692127 ... Done.
## Doing 692239 ... Done.
## Doing 692334 ... Done.
## Doing 692386 ... Done.
## Doing 692630 ... Done.
## Doing 692831 ... Done.
## Doing 693138 ... Done.
## Doing 693150 ... Done.
## Doing 693227 ... Done.
## Doing 693233 ... Done.
## Doing 693279 ... Done.
## Doing 693316 ... Done.
## Doing 693322 ... Done.
## Doing 694037 ... Done.
## Doing 694095 ... Done.
## Doing 696817 ... Done.
## Doing 698041 ... Done.
## Doing 698236 ... Done.
## Doing 698897 ... Done.
## Doing 698986 ... Done.
## Doing 699218 ... Done.
## Doing 699224 ... Done.
## Doing 699276 ... Done.
## Doing 699299 ... Done.
## Doing 699750 ... Done.
## Doing 699773 ... Done.
## Doing 699862 ... Done.
## Doing 699900 ... Done.
## Doing 699945 ... Done.
## Doing 700186 ... Done.
## Doing 700192 ... Done.
## Doing 700269 ... Done.
## Doing 701932 ... Done.
## Doing 702009 ... Done.
## Doing 702587 ... Done.
## Doing 702897 ... Done.

## # A tibble: 500 <U+00D7> 2
##    edrpou   debt
##     <int>  <chr>
## 1   12256  24000
## 2   15332      0
## 3   18201 664780
## 4   26867      0
## 5   32112      0
## 6   32129  23120
## 7   34861      0
## 8   36044      0
## 9   41467      0
## 10 100227  12480
## # ... with 490 more rows

8. Донастройка по результатам тестирования