data_analytics_36_vk.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import time\n",
    "from pprint import pprint"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://api.vk.com/method/groups.getMembers'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "params = {\n",
    "    'group_id': 'intelligentart',\n",
    "    'v': 5.73,\n",
    "    'access_token': '0bacdcbf0bacdcbf0bacdcbfca0bd98be200bac0bacdcbf54602e6c585bfb326e7d4966',\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "req = requests.get(url, params)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = req.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'response': {'count': 37797,\n",
       "  'items': [2047,\n",
       "   2150,\n",
       "   2257,\n",
       "   3049,\n",
       "   3856,\n",
       "   5681,\n",
       "   5855,\n",
       "   6358,\n",
       "   6652,\n",
       "   7224,\n",
       "   7520,\n",
       "   8890,\n",
       "   10705,\n",
       "   12097,\n",
       "   12422,\n",
       "   13259,\n",
       "   13504,\n",
       "   14922,\n",
       "   15544,\n",
       "   19594,\n",
       "   20007,\n",
       "   22013,\n",
       "   22284,\n",
       "   24174,\n",
       "   24705,\n",
       "   24883,\n",
       "   25082,\n",
       "   25992,\n",
       "   26491,\n",
       "   26637,\n",
       "   30777,\n",
       "   31497,\n",
       "   34583,\n",
       "   35306,\n",
       "   35990,\n",
       "   37093,\n",
       "   38294,\n",
       "   39243,\n",
       "   40864,\n",
       "   43117,\n",
       "   44523,\n",
       "   46162,\n",
       "   46240,\n",
       "   47753,\n",
       "   49085,\n",
       "   49250,\n",
       "   49802,\n",
       "   49861,\n",
       "   52234,\n",
       "   52894,\n",
       "   52961,\n",
       "   53771,\n",
       "   54880,\n",
       "   55253,\n",
       "   55560,\n",
       "   55589,\n",
       "   55623,\n",
       "   57371,\n",
       "   57595,\n",
       "   57680,\n",
       "   58102,\n",
       "   58645,\n",
       "   59339,\n",
       "   59612,\n",
       "   60229,\n",
       "   63225,\n",
       "   64310,\n",
       "   65132,\n",
       "   65765,\n",
       "   68186,\n",
       "   68629,\n",
       "   69334,\n",
       "   69815,\n",
       "   71909,\n",
       "   73019,\n",
       "   73732,\n",
       "   76127,\n",
       "   76473,\n",
       "   77485,\n",
       "   77695,\n",
       "   77711,\n",
       "   78858,\n",
       "   80096,\n",
       "   80573,\n",
       "   82318,\n",
       "   83429,\n",
       "   84128,\n",
       "   87605,\n",
       "   87732,\n",
       "   91211,\n",
       "   91691,\n",
       "   95239,\n",
       "   97396,\n",
       "   97979,\n",
       "   100012,\n",
       "   101563,\n",
       "   101665,\n",
       "   103799,\n",
       "   104003,\n",
       "   104191,\n",
       "   104334,\n",
       "   104427,\n",
       "   105386,\n",
       "   106272,\n",
       "   106416,\n",
       "   106761,\n",
       "   107204,\n",
       "   107389,\n",
       "   107884,\n",
       "   109449,\n",
       "   110088,\n",
       "   111938,\n",
       "   113309,\n",
       "   115007,\n",
       "   115426,\n",
       "   118375,\n",
       "   118566,\n",
       "   119012,\n",
       "   119039,\n",
       "   123142,\n",
       "   123454,\n",
       "   124398,\n",
       "   126881,\n",
       "   127431,\n",
       "   127517,\n",
       "   128335,\n",
       "   130768,\n",
       "   131144,\n",
       "   131354,\n",
       "   133647,\n",
       "   133829,\n",
       "   134072,\n",
       "   134125,\n",
       "   134552,\n",
       "   134648,\n",
       "   135435,\n",
       "   137228,\n",
       "   138118,\n",
       "   140621,\n",
       "   142556,\n",
       "   143843,\n",
       "   145148,\n",
       "   145311,\n",
       "   145869,\n",
       "   146438,\n",
       "   148899,\n",
       "   151388,\n",
       "   152424,\n",
       "   153633,\n",
       "   154002,\n",
       "   155954,\n",
       "   156253,\n",
       "   159386,\n",
       "   159702,\n",
       "   159902,\n",
       "   162133,\n",
       "   164021,\n",
       "   165398,\n",
       "   165483,\n",
       "   165636,\n",
       "   165932,\n",
       "   166367,\n",
       "   166758,\n",
       "   167551,\n",
       "   167770,\n",
       "   168860,\n",
       "   173391,\n",
       "   173563,\n",
       "   174360,\n",
       "   174565,\n",
       "   175625,\n",
       "   177258,\n",
       "   177718,\n",
       "   179699,\n",
       "   180469,\n",
       "   181626,\n",
       "   182520,\n",
       "   188171,\n",
       "   188210,\n",
       "   189110,\n",
       "   189972,\n",
       "   189997,\n",
       "   190331,\n",
       "   191093,\n",
       "   191215,\n",
       "   192373,\n",
       "   192393,\n",
       "   192434,\n",
       "   194193,\n",
       "   195479,\n",
       "   195925,\n",
       "   196544,\n",
       "   198115,\n",
       "   198435,\n",
       "   200366,\n",
       "   200416,\n",
       "   207801,\n",
       "   208286,\n",
       "   211462,\n",
       "   212641,\n",
       "   213078,\n",
       "   214807,\n",
       "   214821,\n",
       "   216113,\n",
       "   216904,\n",
       "   217511,\n",
       "   217827,\n",
       "   217942,\n",
       "   219470,\n",
       "   222873,\n",
       "   223895,\n",
       "   224286,\n",
       "   225344,\n",
       "   227331,\n",
       "   228312,\n",
       "   229790,\n",
       "   230161,\n",
       "   230976,\n",
       "   231794,\n",
       "   237519,\n",
       "   237586,\n",
       "   237768,\n",
       "   237952,\n",
       "   244159,\n",
       "   245581,\n",
       "   245723,\n",
       "   246069,\n",
       "   248667,\n",
       "   249160,\n",
       "   250546,\n",
       "   250988,\n",
       "   251274,\n",
       "   252030,\n",
       "   252367,\n",
       "   252575,\n",
       "   253821,\n",
       "   253931,\n",
       "   255565,\n",
       "   256867,\n",
       "   257857,\n",
       "   260084,\n",
       "   262619,\n",
       "   263746,\n",
       "   264730,\n",
       "   265240,\n",
       "   266165,\n",
       "   267014,\n",
       "   268574,\n",
       "   269455,\n",
       "   269666,\n",
       "   269869,\n",
       "   270881,\n",
       "   272477,\n",
       "   273080,\n",
       "   273380,\n",
       "   275803,\n",
       "   276621,\n",
       "   276789,\n",
       "   277106,\n",
       "   278637,\n",
       "   282424,\n",
       "   282479,\n",
       "   283226,\n",
       "   285284,\n",
       "   285677,\n",
       "   286666,\n",
       "   289443,\n",
       "   290170,\n",
       "   291292,\n",
       "   292840,\n",
       "   293664,\n",
       "   294951,\n",
       "   299782,\n",
       "   301904,\n",
       "   303990,\n",
       "   304291,\n",
       "   306812,\n",
       "   313258,\n",
       "   318079,\n",
       "   319768,\n",
       "   320081,\n",
       "   323042,\n",
       "   323743,\n",
       "   325279,\n",
       "   325302,\n",
       "   326960,\n",
       "   327971,\n",
       "   329179,\n",
       "   329653,\n",
       "   332596,\n",
       "   335784,\n",
       "   339833,\n",
       "   341152,\n",
       "   342202,\n",
       "   343195,\n",
       "   343942,\n",
       "   350005,\n",
       "   350857,\n",
       "   351027,\n",
       "   352918,\n",
       "   356048,\n",
       "   356334,\n",
       "   356737,\n",
       "   357814,\n",
       "   358113,\n",
       "   358158,\n",
       "   358735,\n",
       "   359539,\n",
       "   361152,\n",
       "   362342,\n",
       "   362370,\n",
       "   362767,\n",
       "   365356,\n",
       "   366197,\n",
       "   366460,\n",
       "   369432,\n",
       "   370360,\n",
       "   371826,\n",
       "   373252,\n",
       "   374113,\n",
       "   374287,\n",
       "   376723,\n",
       "   378530,\n",
       "   379482,\n",
       "   381910,\n",
       "   382011,\n",
       "   383069,\n",
       "   385422,\n",
       "   386127,\n",
       "   386136,\n",
       "   386533,\n",
       "   387278,\n",
       "   387752,\n",
       "   389367,\n",
       "   392128,\n",
       "   392334,\n",
       "   393119,\n",
       "   393156,\n",
       "   394640,\n",
       "   395837,\n",
       "   395917,\n",
       "   397147,\n",
       "   397434,\n",
       "   398085,\n",
       "   398720,\n",
       "   399048,\n",
       "   400492,\n",
       "   401374,\n",
       "   401625,\n",
       "   402959,\n",
       "   409657,\n",
       "   410418,\n",
       "   410588,\n",
       "   410729,\n",
       "   419574,\n",
       "   420107,\n",
       "   420749,\n",
       "   420927,\n",
       "   422440,\n",
       "   425055,\n",
       "   425103,\n",
       "   426816,\n",
       "   427389,\n",
       "   428268,\n",
       "   428921,\n",
       "   432679,\n",
       "   432778,\n",
       "   433069,\n",
       "   433394,\n",
       "   434465,\n",
       "   437886,\n",
       "   438299,\n",
       "   438528,\n",
       "   441719,\n",
       "   442103,\n",
       "   443429,\n",
       "   444145,\n",
       "   446086,\n",
       "   447886,\n",
       "   449079,\n",
       "   449186,\n",
       "   449234,\n",
       "   450029,\n",
       "   450441,\n",
       "   452538,\n",
       "   453042,\n",
       "   453609,\n",
       "   454861,\n",
       "   458686,\n",
       "   458750,\n",
       "   459084,\n",
       "   459402,\n",
       "   460473,\n",
       "   461702,\n",
       "   462746,\n",
       "   462771,\n",
       "   465179,\n",
       "   466406,\n",
       "   467159,\n",
       "   470486,\n",
       "   470636,\n",
       "   470755,\n",
       "   470891,\n",
       "   471362,\n",
       "   471470,\n",
       "   471545,\n",
       "   471561,\n",
       "   472887,\n",
       "   474675,\n",
       "   476141,\n",
       "   477851,\n",
       "   478065,\n",
       "   478574,\n",
       "   478684,\n",
       "   480598,\n",
       "   480730,\n",
       "   481159,\n",
       "   481807,\n",
       "   482604,\n",
       "   485927,\n",
       "   486662,\n",
       "   488061,\n",
       "   488742,\n",
       "   489336,\n",
       "   491030,\n",
       "   491045,\n",
       "   491541,\n",
       "   491645,\n",
       "   492820,\n",
       "   494070,\n",
       "   494380,\n",
       "   497236,\n",
       "   497311,\n",
       "   497635,\n",
       "   503726,\n",
       "   504683,\n",
       "   505345,\n",
       "   505690,\n",
       "   506671,\n",
       "   509104,\n",
       "   509148,\n",
       "   509491,\n",
       "   510964,\n",
       "   511900,\n",
       "   513362,\n",
       "   515831,\n",
       "   518376,\n",
       "   519565,\n",
       "   520080,\n",
       "   520463,\n",
       "   522977,\n",
       "   524520,\n",
       "   533912,\n",
       "   536863,\n",
       "   539125,\n",
       "   541941,\n",
       "   543516,\n",
       "   544132,\n",
       "   544536,\n",
       "   545798,\n",
       "   546236,\n",
       "   547428,\n",
       "   548048,\n",
       "   548579,\n",
       "   549960,\n",
       "   549999,\n",
       "   550456,\n",
       "   551211,\n",
       "   551500,\n",
       "   552896,\n",
       "   553612,\n",
       "   553716,\n",
       "   554263,\n",
       "   558915,\n",
       "   561197,\n",
       "   562977,\n",
       "   566608,\n",
       "   567083,\n",
       "   572019,\n",
       "   574668,\n",
       "   577681,\n",
       "   578964,\n",
       "   579705,\n",
       "   580966,\n",
       "   580969,\n",
       "   581837,\n",
       "   583194,\n",
       "   585548,\n",
       "   588228,\n",
       "   590665,\n",
       "   591923,\n",
       "   595715,\n",
       "   595786,\n",
       "   597515,\n",
       "   598923,\n",
       "   602394,\n",
       "   602742,\n",
       "   603122,\n",
       "   603265,\n",
       "   606153,\n",
       "   606785,\n",
       "   607135,\n",
       "   607591,\n",
       "   611869,\n",
       "   611883,\n",
       "   614296,\n",
       "   615040,\n",
       "   617393,\n",
       "   617650,\n",
       "   618167,\n",
       "   620565,\n",
       "   622390,\n",
       "   624576,\n",
       "   624738,\n",
       "   625814,\n",
       "   626124,\n",
       "   631959,\n",
       "   632639,\n",
       "   633497,\n",
       "   633833,\n",
       "   633958,\n",
       "   636104,\n",
       "   638673,\n",
       "   640835,\n",
       "   641663,\n",
       "   642121,\n",
       "   642122,\n",
       "   645337,\n",
       "   645456,\n",
       "   645943,\n",
       "   646407,\n",
       "   648530,\n",
       "   654163,\n",
       "   655517,\n",
       "   660739,\n",
       "   661055,\n",
       "   662168,\n",
       "   663037,\n",
       "   664890,\n",
       "   665532,\n",
       "   665762,\n",
       "   666510,\n",
       "   666841,\n",
       "   667152,\n",
       "   669353,\n",
       "   670192,\n",
       "   673356,\n",
       "   673847,\n",
       "   675388,\n",
       "   676521,\n",
       "   677289,\n",
       "   678525,\n",
       "   679270,\n",
       "   679393,\n",
       "   685920,\n",
       "   687462,\n",
       "   688421,\n",
       "   688776,\n",
       "   688975,\n",
       "   692271,\n",
       "   692378,\n",
       "   692391,\n",
       "   693858,\n",
       "   695009,\n",
       "   695388,\n",
       "   695528,\n",
       "   696056,\n",
       "   699628,\n",
       "   700139,\n",
       "   700554,\n",
       "   703035,\n",
       "   703495,\n",
       "   705650,\n",
       "   707396,\n",
       "   707527,\n",
       "   707955,\n",
       "   708033,\n",
       "   708476,\n",
       "   710324,\n",
       "   713558,\n",
       "   714036,\n",
       "   716723,\n",
       "   719007,\n",
       "   719131,\n",
       "   719823,\n",
       "   720459,\n",
       "   723404,\n",
       "   726974,\n",
       "   727577,\n",
       "   728698,\n",
       "   730399,\n",
       "   730641,\n",
       "   733307,\n",
       "   733988,\n",
       "   735633,\n",
       "   735742,\n",
       "   735927,\n",
       "   736029,\n",
       "   736618,\n",
       "   739155,\n",
       "   740097,\n",
       "   741337,\n",
       "   742561,\n",
       "   742888,\n",
       "   744363,\n",
       "   744604,\n",
       "   744734,\n",
       "   745052,\n",
       "   747738,\n",
       "   748430,\n",
       "   748722,\n",
       "   752721,\n",
       "   752993,\n",
       "   754936,\n",
       "   763465,\n",
       "   763894,\n",
       "   764640,\n",
       "   767639,\n",
       "   771438,\n",
       "   771524,\n",
       "   774226,\n",
       "   774870,\n",
       "   776853,\n",
       "   779977,\n",
       "   780592,\n",
       "   780934,\n",
       "   783411,\n",
       "   783716,\n",
       "   784212,\n",
       "   788469,\n",
       "   790811,\n",
       "   791575,\n",
       "   791737,\n",
       "   793683,\n",
       "   794725,\n",
       "   796638,\n",
       "   798628,\n",
       "   802391,\n",
       "   802451,\n",
       "   803541,\n",
       "   803725,\n",
       "   804132,\n",
       "   804972,\n",
       "   806924,\n",
       "   806929,\n",
       "   808099,\n",
       "   809062,\n",
       "   809076,\n",
       "   812736,\n",
       "   813514,\n",
       "   815092,\n",
       "   815805,\n",
       "   816059,\n",
       "   819137,\n",
       "   819753,\n",
       "   819991,\n",
       "   822071,\n",
       "   823356,\n",
       "   824914,\n",
       "   827650,\n",
       "   828129,\n",
       "   831953,\n",
       "   832263,\n",
       "   832410,\n",
       "   833258,\n",
       "   834893,\n",
       "   835908,\n",
       "   837857,\n",
       "   841196,\n",
       "   841312,\n",
       "   843067,\n",
       "   845716,\n",
       "   846380,\n",
       "   849016,\n",
       "   850300,\n",
       "   850502,\n",
       "   850770,\n",
       "   851089,\n",
       "   851528,\n",
       "   856414,\n",
       "   859329,\n",
       "   859623,\n",
       "   863247,\n",
       "   867636,\n",
       "   868965,\n",
       "   871321,\n",
       "   871995,\n",
       "   872881,\n",
       "   874325,\n",
       "   875923,\n",
       "   876686,\n",
       "   877321,\n",
       "   878679,\n",
       "   878687,\n",
       "   879841,\n",
       "   880264,\n",
       "   882319,\n",
       "   882754,\n",
       "   884626,\n",
       "   887395,\n",
       "   887870,\n",
       "   888060,\n",
       "   888077,\n",
       "   889112,\n",
       "   890129,\n",
       "   890678,\n",
       "   891635,\n",
       "   892259,\n",
       "   892544,\n",
       "   893539,\n",
       "   895678,\n",
       "   897865,\n",
       "   898375,\n",
       "   899529,\n",
       "   900712,\n",
       "   901295,\n",
       "   901752,\n",
       "   901756,\n",
       "   902778,\n",
       "   903689,\n",
       "   904895,\n",
       "   906120,\n",
       "   908260,\n",
       "   909426,\n",
       "   912103,\n",
       "   913445,\n",
       "   913747,\n",
       "   915280,\n",
       "   915806,\n",
       "   918583,\n",
       "   923350,\n",
       "   924152,\n",
       "   927824,\n",
       "   931086,\n",
       "   931428,\n",
       "   932126,\n",
       "   933020,\n",
       "   934574,\n",
       "   937420,\n",
       "   937747,\n",
       "   938937,\n",
       "   944732,\n",
       "   945744,\n",
       "   947622,\n",
       "   951518,\n",
       "   952836,\n",
       "   953259,\n",
       "   955867,\n",
       "   960056,\n",
       "   960518,\n",
       "   960684,\n",
       "   965279,\n",
       "   967441,\n",
       "   967508,\n",
       "   968449,\n",
       "   970352,\n",
       "   972867,\n",
       "   973010,\n",
       "   973071,\n",
       "   973123,\n",
       "   974732,\n",
       "   975907,\n",
       "   976018,\n",
       "   977887,\n",
       "   978459,\n",
       "   978866,\n",
       "   978881,\n",
       "   978929,\n",
       "   981859,\n",
       "   982050,\n",
       "   989549,\n",
       "   993851,\n",
       "   995787,\n",
       "   996068,\n",
       "   996523,\n",
       "   1007002,\n",
       "   1008067,\n",
       "   1008861,\n",
       "   1009869,\n",
       "   1010284,\n",
       "   1012061,\n",
       "   1012428,\n",
       "   1014679,\n",
       "   1014700,\n",
       "   1016798,\n",
       "   1019421,\n",
       "   1021052,\n",
       "   1024379,\n",
       "   1027624,\n",
       "   1029031,\n",
       "   1029891,\n",
       "   1031927,\n",
       "   1032118,\n",
       "   1034759,\n",
       "   1035110,\n",
       "   1035833,\n",
       "   1038274,\n",
       "   1040520,\n",
       "   1044926,\n",
       "   1045125,\n",
       "   1045893,\n",
       "   1047487,\n",
       "   1048573,\n",
       "   1049044,\n",
       "   1051544,\n",
       "   1051952,\n",
       "   1052128,\n",
       "   1056256,\n",
       "   1060139,\n",
       "   1063007,\n",
       "   1066969,\n",
       "   1073293,\n",
       "   1077314,\n",
       "   1081170,\n",
       "   1083418,\n",
       "   1083467,\n",
       "   1085721,\n",
       "   1088069,\n",
       "   1092615,\n",
       "   1094395,\n",
       "   1095670,\n",
       "   1096254,\n",
       "   1103548,\n",
       "   1104920,\n",
       "   1105243,\n",
       "   1105292,\n",
       "   1105754,\n",
       "   1107660,\n",
       "   1112391,\n",
       "   1112779,\n",
       "   1113753,\n",
       "   1114849,\n",
       "   1122260,\n",
       "   1123672,\n",
       "   1125070,\n",
       "   1125955,\n",
       "   1126383,\n",
       "   1126779,\n",
       "   1127199,\n",
       "   1127879,\n",
       "   1129879,\n",
       "   1132559,\n",
       "   1132772,\n",
       "   1133081,\n",
       "   1134049,\n",
       "   1136921,\n",
       "   1137185,\n",
       "   1137395,\n",
       "   1138026,\n",
       "   1142234,\n",
       "   1142519,\n",
       "   1142797,\n",
       "   1147038,\n",
       "   1149003,\n",
       "   1149334,\n",
       "   1152005,\n",
       "   1152216,\n",
       "   1152794,\n",
       "   1153586,\n",
       "   1154101,\n",
       "   1154766,\n",
       "   1160832,\n",
       "   1161683,\n",
       "   1163777,\n",
       "   1164528,\n",
       "   1165308,\n",
       "   1166609,\n",
       "   1169053,\n",
       "   1180261,\n",
       "   1182406,\n",
       "   1183593,\n",
       "   1186523,\n",
       "   1186670,\n",
       "   1188100,\n",
       "   1188553,\n",
       "   1189943,\n",
       "   1190036,\n",
       "   1193012,\n",
       "   1195599,\n",
       "   1201697,\n",
       "   1202806,\n",
       "   1205879,\n",
       "   1208355,\n",
       "   1208596,\n",
       "   1210020,\n",
       "   1213675,\n",
       "   1214326,\n",
       "   1216139,\n",
       "   1219342,\n",
       "   1221739,\n",
       "   1221808,\n",
       "   1225736,\n",
       "   1226730,\n",
       "   1228660,\n",
       "   1230904,\n",
       "   1232456,\n",
       "   1233554,\n",
       "   1233709,\n",
       "   1235486,\n",
       "   1235767,\n",
       "   1241324,\n",
       "   1241815,\n",
       "   1242309,\n",
       "   1243985,\n",
       "   1245112,\n",
       "   1245329,\n",
       "   1246227,\n",
       "   1249680,\n",
       "   1250156,\n",
       "   1251256,\n",
       "   1252171,\n",
       "   1253156,\n",
       "   1254134,\n",
       "   1260458,\n",
       "   1260705,\n",
       "   1260729,\n",
       "   1261647,\n",
       "   1261938,\n",
       "   1263478,\n",
       "   1265936,\n",
       "   1267712,\n",
       "   1270717,\n",
       "   1271899,\n",
       "   1272795,\n",
       "   1274364,\n",
       "   1274665,\n",
       "   1275202,\n",
       "   1277327,\n",
       "   1277386,\n",
       "   1278029,\n",
       "   1280873,\n",
       "   1281165,\n",
       "   1281478,\n",
       "   1281976,\n",
       "   1282570,\n",
       "   1284952,\n",
       "   1290660,\n",
       "   1292771,\n",
       "   1294286,\n",
       "   1296026,\n",
       "   1296396,\n",
       "   1297575,\n",
       "   1298304,\n",
       "   1300415,\n",
       "   1300590,\n",
       "   1300628,\n",
       "   1304925,\n",
       "   1305508,\n",
       "   1306361,\n",
       "   1307391,\n",
       "   1308660,\n",
       "   1309840,\n",
       "   1310764,\n",
       "   1312933,\n",
       "   1321281,\n",
       "   1326816,\n",
       "   1326956,\n",
       "   1327270,\n",
       "   1330597,\n",
       "   1331254,\n",
       "   1332892,\n",
       "   1334207,\n",
       "   1334510,\n",
       "   1334897,\n",
       "   1336136,\n",
       "   1337499,\n",
       "   1338627,\n",
       "   1340465,\n",
       "   1341980,\n",
       "   1342244,\n",
       "   1349516,\n",
       "   1350592,\n",
       "   1351383,\n",
       "   1352030,\n",
       "   1353315,\n",
       "   1354793,\n",
       "   1356944,\n",
       "   1357155,\n",
       "   1360666,\n",
       "   1360815,\n",
       "   1360921,\n",
       "   1362303,\n",
       "   1366764,\n",
       "   1373787,\n",
       "   1380219,\n",
       "   1380396,\n",
       "   1381988,\n",
       "   1383347,\n",
       "   1385166,\n",
       "   1386615,\n",
       "   1387844,\n",
       "   1389137,\n",
       "   1389264,\n",
       "   1390131,\n",
       "   1390724,\n",
       "   1393383,\n",
       "   1394188,\n",
       "   1394543,\n",
       "   1397441,\n",
       "   1397844]}}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1000"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len([x for x in data['response']['items'] if x > 1000]) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[2047,\n",
       " 2150,\n",
       " 2257,\n",
       " 3049,\n",
       " 3856,\n",
       " 5681,\n",
       " 5855,\n",
       " 6358,\n",
       " 6652,\n",
       " 7224,\n",
       " 7520,\n",
       " 8890,\n",
       " 10705,\n",
       " 12097,\n",
       " 12422,\n",
       " 13259,\n",
       " 13504,\n",
       " 14922,\n",
       " 15544,\n",
       " 19594]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "users_for_checking = data['response']['items'][:20]\n",
    "users_for_checking"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "count  = 100\n",
    "offset = 0\n",
    "size = 1000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Выгружаю 100 пользователей с offset = 0\n",
      "Выгружаю 100 пользователей с offset = 100\n",
      "Выгружаю 100 пользователей с offset = 200\n",
      "Выгружаю 100 пользователей с offset = 300\n",
      "Выгружаю 100 пользователей с offset = 400\n",
      "Выгружаю 100 пользователей с offset = 500\n",
      "Выгружаю 100 пользователей с offset = 600\n",
      "Выгружаю 100 пользователей с offset = 700\n",
      "Выгружаю 100 пользователей с offset = 800\n",
      "Выгружаю 100 пользователей с offset = 900\n",
      "Выгружаю 100 пользователей с offset = 1000\n"
     ]
    }
   ],
   "source": [
    "user_ids = []\n",
    "while offset <= size:\n",
    "    print(f'Выгружаю {count} пользователей с offset = {offset}')\n",
    "    params = {\n",
    "    'group_id': 'intelligentart',\n",
    "    'v': 5.73,\n",
    "    'count': count,\n",
    "    'offset': offset,\n",
    "    'access_token': '0bacdcbf0bacdcbf0bacdcbfca0bd98be200bac0bacdcbf54602e6c585bfb326e7d4966',\n",
    "}\n",
    "    req = requests.get(url, params)\n",
    "    data_ = req.json()\n",
    "#     size = int(data_['response']['count'])\n",
    "    user_ids += data_['response']['items']\n",
    "    offset += count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'response': {'count': 37797, 'items': [1398572, 1398793, 1399531, 1400837, 1405829, 1410248, 1412794, 1416451, 1417537, 1419379, 1422966, 1430125, 1430607, 1431395, 1431860, 1432172, 1436461, 1440104, 1443122, 1445110, 1445523, 1445583, 1447804, 1450552, 1451405, 1451751, 1453995, 1459003, 1461873, 1463272, 1463507, 1463974, 1468418, 1469306, 1471590, 1472069, 1472798, 1473192, 1474794, 1475165, 1475874, 1477604, 1481085, 1482854, 1483462, 1487179, 1487436, 1495458, 1497662, 1497682, 1500097, 1500452, 1506356, 1509228, 1512510, 1516546, 1517575, 1518355, 1521001, 1523540, 1523946, 1528673, 1531078, 1531871, 1532324, 1533050, 1535089, 1535770, 1536649, 1537059, 1539741, 1541620, 1546937, 1547802, 1550170, 1553740, 1555874, 1558469, 1558564, 1562057, 1564861, 1565102, 1565404, 1565569, 1567903, 1572741, 1572864, 1573186, 1573749, 1573973, 1580197, 1582487, 1582624, 1583843, 1585003, 1586415, 1587894, 1588712, 1589013, 1590296]}}\n"
     ]
    }
   ],
   "source": [
    "print(data_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[2047, 2150, 2257, 3049, 3856, 5681, 5855, 6358, 6652, 7224, 7520, 8890, 10705, 12097, 12422, 13259, 13504, 14922, 15544, 19594, 20007, 22013, 22284, 24174, 24705, 24883, 25082, 25992, 26491, 26637, 30777, 31497, 34583, 35306, 35990, 37093, 38294, 39243, 40864, 43117, 44523, 46162, 46240, 47753, 49085, 49250, 49802, 49861, 52234, 52894, 52961, 53771, 54880, 55253, 55560, 55589, 55623, 57371, 57595, 57680, 58102, 58645, 59339, 59612, 60229, 63225, 64310, 65132, 65765, 68186, 68629, 69334, 69815, 71909, 73019, 73732, 76127, 76473, 77485, 77695, 77711, 78858, 80096, 80573, 82318, 83429, 84128, 87605, 87732, 91211, 91691, 95239, 97396, 97979, 100012, 101563, 101665, 103799, 104003, 104191, 104334, 104427, 105386, 106272, 106416, 106761, 107204, 107389, 107884, 109449, 110088, 111938, 113309, 115007, 115426, 118375, 118566, 119012, 119039, 123142, 123454, 124398, 126881, 127431, 127517, 128335, 130768, 131144, 131354, 133647, 133829, 134072, 134125, 134552, 134648, 135435, 137228, 138118, 140621, 142556, 143843, 145148, 145311, 145869, 146438, 148899, 151388, 152424, 153633, 154002, 155954, 156253, 159386, 159702, 159902, 162133, 164021, 165398, 165483, 165636, 165932, 166367, 166758, 167551, 167770, 168860, 173391, 173563, 174360, 174565, 175625, 177258, 177718, 179699, 180469, 181626, 182520, 188171, 188210, 189110, 189972, 189997, 190331, 191093, 191215, 192373, 192393, 192434, 194193, 195479, 195925, 196544, 198115, 198435, 200366, 200416, 207801, 208286, 211462, 212641, 213078, 214807, 214821, 216113, 216904, 217511, 217827, 217942, 219470, 222873, 223895, 224286, 225344, 227331, 228312, 229790, 230161, 230976, 231794, 237519, 237586, 237768, 237952, 244159, 245581, 245723, 246069, 248667, 249160, 250546, 250988, 251274, 252030, 252367, 252575, 253821, 253931, 255565, 256867, 257857, 260084, 262619, 263746, 264730, 265240, 266165, 267014, 268574, 269455, 269666, 269869, 270881, 272477, 273080, 273380, 275803, 276621, 276789, 277106, 278637, 282424, 282479, 283226, 285284, 285677, 286666, 289443, 290170, 291292, 292840, 293664, 294951, 299782, 301904, 303990, 304291, 306812, 313258, 318079, 319768, 320081, 323042, 323743, 325279, 325302, 326960, 327971, 329179, 329653, 332596, 335784, 339833, 341152, 342202, 343195, 343942, 350005, 350857, 351027, 352918, 356048, 356334, 356737, 357814, 358113, 358158, 358735, 359539, 361152, 362342, 362370, 362767, 365356, 366197, 366460, 369432, 370360, 371826, 373252, 374113, 374287, 376723, 378530, 379482, 381910, 382011, 383069, 385422, 386127, 386136, 386533, 387278, 387752, 389367, 392128, 392334, 393119, 393156, 394640, 395837, 395917, 397147, 397434, 398085, 398720, 399048, 400492, 401374, 401625, 402959, 409657, 410418, 410588, 410729, 419574, 420107, 420749, 420927, 422440, 425055, 425103, 426816, 427389, 428268, 428921, 432679, 432778, 433069, 433394, 434465, 437886, 438299, 438528, 441719, 442103, 443429, 444145, 446086, 447886, 449079, 449186, 449234, 450029, 450441, 452538, 453042, 453609, 454861, 458686, 458750, 459084, 459402, 460473, 461702, 462746, 462771, 465179, 466406, 467159, 470486, 470636, 470755, 470891, 471362, 471470, 471545, 471561, 472887, 474675, 476141, 477851, 478065, 478574, 478684, 480598, 480730, 481159, 481807, 482604, 485927, 486662, 488061, 488742, 489336, 491030, 491045, 491541, 491645, 492820, 494070, 494380, 497236, 497311, 497635, 503726, 504683, 505345, 505690, 506671, 509104, 509148, 509491, 510964, 511900, 513362, 515831, 518376, 519565, 520080, 520463, 522977, 524520, 533912, 536863, 539125, 541941, 543516, 544132, 544536, 545798, 546236, 547428, 548048, 548579, 549960, 549999, 550456, 551211, 551500, 552896, 553612, 553716, 554263, 558915, 561197, 562977, 566608, 567083, 572019, 574668, 577681, 578964, 579705, 580966, 580969, 581837, 583194, 585548, 588228, 590665, 591923, 595715, 595786, 597515, 598923, 602394, 602742, 603122, 603265, 606153, 606785, 607135, 607591, 611869, 611883, 614296, 615040, 617393, 617650, 618167, 620565, 622390, 624576, 624738, 625814, 626124, 631959, 632639, 633497, 633833, 633958, 636104, 638673, 640835, 641663, 642121, 642122, 645337, 645456, 645943, 646407, 648530, 654163, 655517, 660739, 661055, 662168, 663037, 664890, 665532, 665762, 666510, 666841, 667152, 669353, 670192, 673356, 673847, 675388, 676521, 677289, 678525, 679270, 679393, 685920, 687462, 688421, 688776, 688975, 692271, 692378, 692391, 693858, 695009, 695388, 695528, 696056, 699628, 700139, 700554, 703035, 703495, 705650, 707396, 707527, 707955, 708033, 708476, 710324, 713558, 714036, 716723, 719007, 719131, 719823, 720459, 723404, 726974, 727577, 728698, 730399, 730641, 733307, 733988, 735633, 735742, 735927, 736029, 736618, 739155, 740097, 741337, 742561, 742888, 744363, 744604, 744734, 745052, 747738, 748430, 748722, 752721, 752993, 754936, 763465, 763894, 764640, 767639, 771438, 771524, 774226, 774870, 776853, 779977, 780592, 780934, 783411, 783716, 784212, 788469, 790811, 791575, 791737, 793683, 794725, 796638, 798628, 802391, 802451, 803541, 803725, 804132, 804972, 806924, 806929, 808099, 809062, 809076, 812736, 813514, 815092, 815805, 816059, 819137, 819753, 819991, 822071, 823356, 824914, 827650, 828129, 831953, 832263, 832410, 833258, 834893, 835908, 837857, 841196, 841312, 843067, 845716, 846380, 849016, 850300, 850502, 850770, 851089, 851528, 856414, 859329, 859623, 863247, 867636, 868965, 871321, 871995, 872881, 874325, 875923, 876686, 877321, 878679, 878687, 879841, 880264, 882319, 882754, 884626, 887395, 887870, 888060, 888077, 889112, 890129, 890678, 891635, 892259, 892544, 893539, 895678, 897865, 898375, 899529, 900712, 901295, 901752, 901756, 902778, 903689, 904895, 906120, 908260, 909426, 912103, 913445, 913747, 915280, 915806, 918583, 923350, 924152, 927824, 931086, 931428, 932126, 933020, 934574, 937420, 937747, 938937, 944732, 945744, 947622, 951518, 952836, 953259, 955867, 960056, 960518, 960684, 965279, 967441, 967508, 968449, 970352, 972867, 973010, 973071, 973123, 974732, 975907, 976018, 977887, 978459, 978866, 978881, 978929, 981859, 982050, 989549, 993851, 995787, 996068, 996523, 1007002, 1008067, 1008861, 1009869, 1010284, 1012061, 1012428, 1014679, 1014700, 1016798, 1019421, 1021052, 1024379, 1027624, 1029031, 1029891, 1031927, 1032118, 1034759, 1035110, 1035833, 1038274, 1040520, 1044926, 1045125, 1045893, 1047487, 1048573, 1049044, 1051544, 1051952, 1052128, 1056256, 1060139, 1063007, 1066969, 1073293, 1077314, 1081170, 1083418, 1083467, 1085721, 1088069, 1092615, 1094395, 1095670, 1096254, 1103548, 1104920, 1105243, 1105292, 1105754, 1107660, 1112391, 1112779, 1113753, 1114849, 1122260, 1123672, 1125070, 1125955, 1126383, 1126779, 1127199, 1127879, 1129879, 1132559, 1132772, 1133081, 1134049, 1136921, 1137185, 1137395, 1138026, 1142234, 1142519, 1142797, 1147038, 1149003, 1149334, 1152005, 1152216, 1152794, 1153586, 1154101, 1154766, 1160832, 1161683, 1163777, 1164528, 1165308, 1166609, 1169053, 1180261, 1182406, 1183593, 1186523, 1186670, 1188100, 1188553, 1189943, 1190036, 1193012, 1195599, 1201697, 1202806, 1205879, 1208355, 1208596, 1210020, 1213675, 1214326, 1216139, 1219342, 1221739, 1221808, 1225736, 1226730, 1228660, 1230904, 1232456, 1233554, 1233709, 1235486, 1235767, 1241324, 1241815, 1242309, 1243985, 1245112, 1245329, 1246227, 1249680, 1250156, 1251256, 1252171, 1253156, 1254134, 1260458, 1260705, 1260729, 1261647, 1261938, 1263478, 1265936, 1267712, 1270717, 1271899, 1272795, 1274364, 1274665, 1275202, 1277327, 1277386, 1278029, 1280873, 1281165, 1281478, 1281976, 1282570, 1284952, 1290660, 1292771, 1294286, 1296026, 1296396, 1297575, 1298304, 1300415, 1300590, 1300628, 1304925, 1305508, 1306361, 1307391, 1308660, 1309840, 1310764, 1312933, 1321281, 1326816, 1326956, 1327270, 1330597, 1331254, 1332892, 1334207, 1334510, 1334897, 1336136, 1337499, 1338627, 1340465, 1341980, 1342244, 1349516, 1350592, 1351383, 1352030, 1353315, 1354793, 1356944, 1357155, 1360666, 1360815, 1360921, 1362303, 1366764, 1373787, 1380219, 1380396, 1381988, 1383347, 1385166, 1386615, 1387844, 1389137, 1389264, 1390131, 1390724, 1393383, 1394188, 1394543, 1397441, 1397844, 1398572, 1398793, 1399531, 1400837, 1405829, 1410248, 1412794, 1416451, 1417537, 1419379, 1422966, 1430125, 1430607, 1431395, 1431860, 1432172, 1436461, 1440104, 1443122, 1445110, 1445523, 1445583, 1447804, 1450552, 1451405, 1451751, 1453995, 1459003, 1461873, 1463272, 1463507, 1463974, 1468418, 1469306, 1471590, 1472069, 1472798, 1473192, 1474794, 1475165, 1475874, 1477604, 1481085, 1482854, 1483462, 1487179, 1487436, 1495458, 1497662, 1497682, 1500097, 1500452, 1506356, 1509228, 1512510, 1516546, 1517575, 1518355, 1521001, 1523540, 1523946, 1528673, 1531078, 1531871, 1532324, 1533050, 1535089, 1535770, 1536649, 1537059, 1539741, 1541620, 1546937, 1547802, 1550170, 1553740, 1555874, 1558469, 1558564, 1562057, 1564861, 1565102, 1565404, 1565569, 1567903, 1572741, 1572864, 1573186, 1573749, 1573973, 1580197, 1582487, 1582624, 1583843, 1585003, 1586415, 1587894, 1588712, 1589013, 1590296]\n"
     ]
    }
   ],
   "source": [
    "print(user_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "users_for_checking == user_ids"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "count  = 500\n",
    "offset = 0\n",
    "size = 1000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Выгружаю 500 пользователей с offset = 0\n",
      "Выгружаю 500 пользователей с offset = 500\n"
     ]
    }
   ],
   "source": [
    "user_ids = []\n",
    "while offset < size:\n",
    "    print(f'Выгружаю {count} пользователей с offset = {offset}')\n",
    "    params = {\n",
    "    'group_id': 'intelligentart',\n",
    "    'v': 5.73,\n",
    "    'count': count,\n",
    "    'offset': offset,\n",
    "    'access_token': '0bacdcbf0bacdcbf0bacdcbfca0bd98be200bac0bacdcbf54602e6c585bfb326e7d4966',\n",
    "}\n",
    "    req = requests.get(url, params)\n",
    "    data_ = req.json()\n",
    "    user_ids += data_['response']['items']\n",
    "    offset += count\n",
    "    # Использование задержки для большого объема выгрузки\n",
    "\n",
    "#     print('Ожидаю 0.5 секунды...')\n",
    "#     time.sleep(0.5)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_ = 'https://api.vk.com/method/users.get?'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "params_ = {\n",
    "    'user_ids': '1, 2, 3',\n",
    "    'v': 5.73,\n",
    "    'lang': 'ru',\n",
    "    'fields': 'sex, bdate, city',\n",
    "    'access_token': '0bacdcbf0bacdcbf0bacdcbfca0bd98be200bac0bacdcbf54602e6c585bfb326e7d4966',\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "city_data = requests.get(url_, params_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'response': [{'bdate': '10.10.1984',\n",
      "               'city': {'id': 2, 'title': 'Санкт-Петербург'},\n",
      "               'first_name': 'Павел',\n",
      "               'id': 1,\n",
      "               'last_name': 'Дуров',\n",
      "               'sex': 2},\n",
      "              {'first_name': 'Александра',\n",
      "               'id': 2,\n",
      "               'last_name': 'Владимирова',\n",
      "               'sex': 1},\n",
      "              {'deactivated': 'deleted',\n",
      "               'first_name': 'DELETED',\n",
      "               'id': 3,\n",
      "               'last_name': '',\n",
      "               'sex': 0}]}\n"
     ]
    }
   ],
   "source": [
    "pprint(city_data.json())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "rows_limit = 1000\n",
    "users_lists = []\n",
    "position = 0\n",
    "while position < len(user_ids):\n",
    "    users_lists.append(user_ids[position:position + rows_limit])\n",
    "#     users_lists += user_ids[position:position + rows_limit]\n",
    "    position += rows_limit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[2047, 2150, 2257, 3049, 3856, 5681, 5855, 6358, 6652, 7224, 7520, 8890, 10705, 12097, 12422, 13259, 13504, 14922, 15544, 19594, 20007, 22013, 22284, 24174, 24705, 24883, 25082, 25992, 26491, 26637, 30777, 31497, 34583, 35306, 35990, 37093, 38294, 39243, 40864, 43117, 44523, 46162, 46240, 47753, 49085, 49250, 49802, 49861, 52234, 52894, 52961, 53771, 54880, 55253, 55560, 55589, 55623, 57371, 57595, 57680, 58102, 58645, 59339, 59612, 60229, 63225, 64310, 65132, 65765, 68186, 68629, 69334, 69815, 71909, 73019, 73732, 76127, 76473, 77485, 77695, 77711, 78858, 80096, 80573, 82318, 83429, 84128, 87605, 87732, 91211, 91691, 95239, 97396, 97979, 100012, 101563, 101665, 103799, 104003, 104191, 104334, 104427, 105386, 106272, 106416, 106761, 107204, 107389, 107884, 109449, 110088, 111938, 113309, 115007, 115426, 118375, 118566, 119012, 119039, 123142, 123454, 124398, 126881, 127431, 127517, 128335, 130768, 131144, 131354, 133647, 133829, 134072, 134125, 134552, 134648, 135435, 137228, 138118, 140621, 142556, 143843, 145148, 145311, 145869, 146438, 148899, 151388, 152424, 153633, 154002, 155954, 156253, 159386, 159702, 159902, 162133, 164021, 165398, 165483, 165636, 165932, 166367, 166758, 167551, 167770, 168860, 173391, 173563, 174360, 174565, 175625, 177258, 177718, 179699, 180469, 181626, 182520, 188171, 188210, 189110, 189972, 189997, 190331, 191093, 191215, 192373, 192393, 192434, 194193, 195479, 195925, 196544, 198115, 198435, 200366, 200416, 207801, 208286, 211462, 212641, 213078, 214807, 214821, 216113, 216904, 217511, 217827, 217942, 219470, 222873, 223895, 224286, 225344, 227331, 228312, 229790, 230161, 230976, 231794, 237519, 237586, 237768, 237952, 244159, 245581, 245723, 246069, 248667, 249160, 250546, 250988, 251274, 252030, 252367, 252575, 253821, 253931, 255565, 256867, 257857, 260084, 262619, 263746, 264730, 265240, 266165, 267014, 268574, 269455, 269666, 269869, 270881, 272477, 273080, 273380, 275803, 276621, 276789, 277106, 278637, 282424, 282479, 283226, 285284, 285677, 286666, 289443, 290170, 291292, 292840, 293664, 294951, 299782, 301904, 303990, 304291, 306812, 313258, 318079, 319768, 320081, 323042, 323743, 325279, 325302, 326960, 327971, 329179, 329653, 332596, 335784, 339833, 341152, 342202, 343195, 343942, 350005, 350857, 351027, 352918, 356048, 356334, 356737, 357814, 358113, 358158, 358735, 359539, 361152, 362342, 362370, 362767, 365356, 366197, 366460, 369432, 370360, 371826, 373252, 374113, 374287, 376723, 378530, 379482, 381910, 382011, 383069, 385422, 386127, 386136, 386533, 387278, 387752, 389367, 392128, 392334, 393119, 393156, 394640, 395837, 395917, 397147, 397434, 398085, 398720, 399048, 400492, 401374, 401625, 402959, 409657, 410418, 410588, 410729, 419574, 420107, 420749, 420927, 422440, 425055, 425103, 426816, 427389, 428268, 428921, 432679, 432778, 433069, 433394, 434465, 437886, 438299, 438528, 441719, 442103, 443429, 444145, 446086, 447886, 449079, 449186, 449234, 450029, 450441, 452538, 453042, 453609, 454861, 458686, 458750, 459084, 459402, 460473, 461702, 462746, 462771, 465179, 466406, 467159, 470486, 470636, 470755, 470891, 471362, 471470, 471545, 471561, 472887, 474675, 476141, 477851, 478065, 478574, 478684, 480598, 480730, 481159, 481807, 482604, 485927, 486662, 488061, 488742, 489336, 491030, 491045, 491541, 491645, 492820, 494070, 494380, 497236, 497311, 497635, 503726, 504683, 505345, 505690, 506671, 509104, 509148, 509491, 510964, 511900, 513362, 515831, 518376, 519565, 520080, 520463, 522977, 524520, 533912, 536863, 539125, 541941, 543516, 544132, 544536, 545798, 546236, 547428, 548048, 548579, 549960, 549999, 550456, 551211, 551500, 552896, 553612, 553716, 554263, 558915, 561197, 562977, 566608, 567083, 572019, 574668, 577681, 578964, 579705, 580966, 580969, 581837, 583194, 585548, 588228, 590665, 591923, 595715, 595786, 597515, 598923, 602394, 602742, 603122, 603265, 606153, 606785, 607135, 607591, 611869, 611883, 614296, 615040, 617393, 617650, 618167, 620565, 622390, 624576, 624738, 625814, 626124, 631959, 632639, 633497, 633833, 633958, 636104, 638673, 640835, 641663, 642121, 642122, 645337, 645456, 645943, 646407, 648530, 654163, 655517, 660739, 661055, 662168, 663037, 664890, 665532, 665762, 666510, 666841, 667152, 669353, 670192, 673356, 673847, 675388, 676521, 677289, 678525, 679270, 679393, 685920, 687462, 688421, 688776, 688975, 692271, 692378, 692391, 693858, 695009, 695388, 695528, 696056, 699628, 700139, 700554, 703035, 703495, 705650, 707396, 707527, 707955, 708033, 708476, 710324, 713558, 714036, 716723, 719007, 719131, 719823, 720459, 723404, 726974, 727577, 728698, 730399, 730641, 733307, 733988, 735633, 735742, 735927, 736029, 736618, 739155, 740097, 741337, 742561, 742888, 744363, 744604, 744734, 745052, 747738, 748430, 748722, 752721, 752993, 754936, 763465, 763894, 764640, 767639, 771438, 771524, 774226, 774870, 776853, 779977, 780592, 780934, 783411, 783716, 784212, 788469, 790811, 791575, 791737, 793683, 794725, 796638, 798628, 802391, 802451, 803541, 803725, 804132, 804972, 806924, 806929, 808099, 809062, 809076, 812736, 813514, 815092, 815805, 816059, 819137, 819753, 819991, 822071, 823356, 824914, 827650, 828129, 831953, 832263, 832410, 833258, 834893, 835908, 837857, 841196, 841312, 843067, 845716, 846380, 849016, 850300, 850502, 850770, 851089, 851528, 856414, 859329, 859623, 863247, 867636, 868965, 871321, 871995, 872881, 874325, 875923, 876686, 877321, 878679, 878687, 879841, 880264, 882319, 882754, 884626, 887395, 887870, 888060, 888077, 889112, 890129, 890678, 891635, 892259, 892544, 893539, 895678, 897865, 898375, 899529, 900712, 901295, 901752, 901756, 902778, 903689, 904895, 906120, 908260, 909426, 912103, 913445, 913747, 915280, 915806, 918583, 923350, 924152, 927824, 931086, 931428, 932126, 933020, 934574, 937420, 937747, 938937, 944732, 945744, 947622, 951518, 952836, 953259, 955867, 960056, 960518, 960684, 965279, 967441, 967508, 968449, 970352, 972867, 973010, 973071, 973123, 974732, 975907, 976018, 977887, 978459, 978866, 978881, 978929, 981859, 982050, 989549, 993851, 995787, 996068, 996523, 1007002, 1008067, 1008861, 1009869, 1010284, 1012061, 1012428, 1014679, 1014700, 1016798, 1019421, 1021052, 1024379, 1027624, 1029031, 1029891, 1031927, 1032118, 1034759, 1035110, 1035833, 1038274, 1040520, 1044926, 1045125, 1045893, 1047487, 1048573, 1049044, 1051544, 1051952, 1052128, 1056256, 1060139, 1063007, 1066969, 1073293, 1077314, 1081170, 1083418, 1083467, 1085721, 1088069, 1092615, 1094395, 1095670, 1096254, 1103548, 1104920, 1105243, 1105292, 1105754, 1107660, 1112391, 1112779, 1113753, 1114849, 1122260, 1123672, 1125070, 1125955, 1126383, 1126779, 1127199, 1127879, 1129879, 1132559, 1132772, 1133081, 1134049, 1136921, 1137185, 1137395, 1138026, 1142234, 1142519, 1142797, 1147038, 1149003, 1149334, 1152005, 1152216, 1152794, 1153586, 1154101, 1154766, 1160832, 1161683, 1163777, 1164528, 1165308, 1166609, 1169053, 1180261, 1182406, 1183593, 1186523, 1186670, 1188100, 1188553, 1189943, 1190036, 1193012, 1195599, 1201697, 1202806, 1205879, 1208355, 1208596, 1210020, 1213675, 1214326, 1216139, 1219342, 1221739, 1221808, 1225736, 1226730, 1228660, 1230904, 1232456, 1233554, 1233709, 1235486, 1235767, 1241324, 1241815, 1242309, 1243985, 1245112, 1245329, 1246227, 1249680, 1250156, 1251256, 1252171, 1253156, 1254134, 1260458, 1260705, 1260729, 1261647, 1261938, 1263478, 1265936, 1267712, 1270717, 1271899, 1272795, 1274364, 1274665, 1275202, 1277327, 1277386, 1278029, 1280873, 1281165, 1281478, 1281976, 1282570, 1284952, 1290660, 1292771, 1294286, 1296026, 1296396, 1297575, 1298304, 1300415, 1300590, 1300628, 1304925, 1305508, 1306361, 1307391, 1308660, 1309840, 1310764, 1312933, 1321281, 1326816, 1326956, 1327270, 1330597, 1331254, 1332892, 1334207, 1334510, 1334897, 1336136, 1337499, 1338627, 1340465, 1341980, 1342244, 1349516, 1350592, 1351383, 1352030, 1353315, 1354793, 1356944, 1357155, 1360666, 1360815, 1360921, 1362303, 1366764, 1373787, 1380219, 1380396, 1381988, 1383347, 1385166, 1386615, 1387844, 1389137, 1389264, 1390131, 1390724, 1393383, 1394188, 1394543, 1397441, 1397844]]\n"
     ]
    }
   ],
   "source": [
    "print(users_lists)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# users_list = [1, 2, 3]\n",
    "# users_list = [str(x) for x in users_list]\n",
    "# users_string = ','.join(users_list)\n",
    "# print(users_string)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[2047, 2150, 2257, 3049, 3856, 5681, 5855, 6358, 6652, 7224, 7520, 8890, 10705, 12097, 12422, 13259, 13504, 14922, 15544, 19594, 20007, 22013, 22284, 24174, 24705, 24883, 25082, 25992, 26491, 26637, 30777, 31497, 34583, 35306, 35990, 37093, 38294, 39243, 40864, 43117, 44523, 46162, 46240, 47753, 49085, 49250, 49802, 49861, 52234, 52894, 52961, 53771, 54880, 55253, 55560, 55589, 55623, 57371, 57595, 57680, 58102, 58645, 59339, 59612, 60229, 63225, 64310, 65132, 65765, 68186, 68629, 69334, 69815, 71909, 73019, 73732, 76127, 76473, 77485, 77695, 77711, 78858, 80096, 80573, 82318, 83429, 84128, 87605, 87732, 91211, 91691, 95239, 97396, 97979, 100012, 101563, 101665, 103799, 104003, 104191, 104334, 104427, 105386, 106272, 106416, 106761, 107204, 107389, 107884, 109449, 110088, 111938, 113309, 115007, 115426, 118375, 118566, 119012, 119039, 123142, 123454, 124398, 126881, 127431, 127517, 128335, 130768, 131144, 131354, 133647, 133829, 134072, 134125, 134552, 134648, 135435, 137228, 138118, 140621, 142556, 143843, 145148, 145311, 145869, 146438, 148899, 151388, 152424, 153633, 154002, 155954, 156253, 159386, 159702, 159902, 162133, 164021, 165398, 165483, 165636, 165932, 166367, 166758, 167551, 167770, 168860, 173391, 173563, 174360, 174565, 175625, 177258, 177718, 179699, 180469, 181626, 182520, 188171, 188210, 189110, 189972, 189997, 190331, 191093, 191215, 192373, 192393, 192434, 194193, 195479, 195925, 196544, 198115, 198435, 200366, 200416, 207801, 208286, 211462, 212641, 213078, 214807, 214821, 216113, 216904, 217511, 217827, 217942, 219470, 222873, 223895, 224286, 225344, 227331, 228312, 229790, 230161, 230976, 231794, 237519, 237586, 237768, 237952, 244159, 245581, 245723, 246069, 248667, 249160, 250546, 250988, 251274, 252030, 252367, 252575, 253821, 253931, 255565, 256867, 257857, 260084, 262619, 263746, 264730, 265240, 266165, 267014, 268574, 269455, 269666, 269869, 270881, 272477, 273080, 273380, 275803, 276621, 276789, 277106, 278637, 282424, 282479, 283226, 285284, 285677, 286666, 289443, 290170, 291292, 292840, 293664, 294951, 299782, 301904, 303990, 304291, 306812, 313258, 318079, 319768, 320081, 323042, 323743, 325279, 325302, 326960, 327971, 329179, 329653, 332596, 335784, 339833, 341152, 342202, 343195, 343942, 350005, 350857, 351027, 352918, 356048, 356334, 356737, 357814, 358113, 358158, 358735, 359539, 361152, 362342, 362370, 362767, 365356, 366197, 366460, 369432, 370360, 371826, 373252, 374113, 374287, 376723, 378530, 379482, 381910, 382011, 383069, 385422, 386127, 386136, 386533, 387278, 387752, 389367, 392128, 392334, 393119, 393156, 394640, 395837, 395917, 397147, 397434, 398085, 398720, 399048, 400492, 401374, 401625, 402959, 409657, 410418, 410588, 410729, 419574, 420107, 420749, 420927, 422440, 425055, 425103, 426816, 427389, 428268, 428921, 432679, 432778, 433069, 433394, 434465, 437886, 438299, 438528, 441719, 442103, 443429, 444145, 446086, 447886, 449079, 449186, 449234, 450029, 450441, 452538, 453042, 453609, 454861, 458686, 458750, 459084, 459402, 460473, 461702, 462746, 462771, 465179, 466406, 467159, 470486, 470636, 470755, 470891, 471362, 471470, 471545, 471561, 472887, 474675, 476141, 477851, 478065, 478574, 478684, 480598, 480730, 481159, 481807, 482604, 485927, 486662, 488061, 488742, 489336, 491030, 491045, 491541, 491645, 492820, 494070, 494380, 497236, 497311, 497635, 503726, 504683, 505345, 505690, 506671, 509104, 509148, 509491, 510964, 511900, 513362, 515831, 518376, 519565, 520080, 520463, 522977, 524520, 533912, 536863, 539125, 541941, 543516, 544132, 544536, 545798, 546236, 547428, 548048, 548579, 549960, 549999, 550456, 551211, 551500, 552896, 553612, 553716, 554263, 558915, 561197, 562977, 566608, 567083, 572019, 574668, 577681, 578964, 579705, 580966, 580969, 581837, 583194, 585548, 588228, 590665, 591923, 595715, 595786, 597515, 598923, 602394, 602742, 603122, 603265, 606153, 606785, 607135, 607591, 611869, 611883, 614296, 615040, 617393, 617650, 618167, 620565, 622390, 624576, 624738, 625814, 626124, 631959, 632639, 633497, 633833, 633958, 636104, 638673, 640835, 641663, 642121, 642122, 645337, 645456, 645943, 646407, 648530, 654163, 655517, 660739, 661055, 662168, 663037, 664890, 665532, 665762, 666510, 666841, 667152, 669353, 670192, 673356, 673847, 675388, 676521, 677289, 678525, 679270, 679393, 685920, 687462, 688421, 688776, 688975, 692271, 692378, 692391, 693858, 695009, 695388, 695528, 696056, 699628, 700139, 700554, 703035, 703495, 705650, 707396, 707527, 707955, 708033, 708476, 710324, 713558, 714036, 716723, 719007, 719131, 719823, 720459, 723404, 726974, 727577, 728698, 730399, 730641, 733307, 733988, 735633, 735742, 735927, 736029, 736618, 739155, 740097, 741337, 742561, 742888, 744363, 744604, 744734, 745052, 747738, 748430, 748722, 752721, 752993, 754936, 763465, 763894, 764640, 767639, 771438, 771524, 774226, 774870, 776853, 779977, 780592, 780934, 783411, 783716, 784212, 788469, 790811, 791575, 791737, 793683, 794725, 796638, 798628, 802391, 802451, 803541, 803725, 804132, 804972, 806924, 806929, 808099, 809062, 809076, 812736, 813514, 815092, 815805, 816059, 819137, 819753, 819991, 822071, 823356, 824914, 827650, 828129, 831953, 832263, 832410, 833258, 834893, 835908, 837857, 841196, 841312, 843067, 845716, 846380, 849016, 850300, 850502, 850770, 851089, 851528, 856414, 859329, 859623, 863247, 867636, 868965, 871321, 871995, 872881, 874325, 875923, 876686, 877321, 878679, 878687, 879841, 880264, 882319, 882754, 884626, 887395, 887870, 888060, 888077, 889112, 890129, 890678, 891635, 892259, 892544, 893539, 895678, 897865, 898375, 899529, 900712, 901295, 901752, 901756, 902778, 903689, 904895, 906120, 908260, 909426, 912103, 913445, 913747, 915280, 915806, 918583, 923350, 924152, 927824, 931086, 931428, 932126, 933020, 934574, 937420, 937747, 938937, 944732, 945744, 947622, 951518, 952836, 953259, 955867, 960056, 960518, 960684, 965279, 967441, 967508, 968449, 970352, 972867, 973010, 973071, 973123, 974732, 975907, 976018, 977887, 978459, 978866, 978881, 978929, 981859, 982050, 989549, 993851, 995787, 996068, 996523, 1007002, 1008067, 1008861, 1009869, 1010284, 1012061, 1012428, 1014679, 1014700, 1016798, 1019421, 1021052, 1024379, 1027624, 1029031, 1029891, 1031927, 1032118, 1034759, 1035110, 1035833, 1038274, 1040520, 1044926, 1045125, 1045893, 1047487, 1048573, 1049044, 1051544, 1051952, 1052128, 1056256, 1060139, 1063007, 1066969, 1073293, 1077314, 1081170, 1083418, 1083467, 1085721, 1088069, 1092615, 1094395, 1095670, 1096254, 1103548, 1104920, 1105243, 1105292, 1105754, 1107660, 1112391, 1112779, 1113753, 1114849, 1122260, 1123672, 1125070, 1125955, 1126383, 1126779, 1127199, 1127879, 1129879, 1132559, 1132772, 1133081, 1134049, 1136921, 1137185, 1137395, 1138026, 1142234, 1142519, 1142797, 1147038, 1149003, 1149334, 1152005, 1152216, 1152794, 1153586, 1154101, 1154766, 1160832, 1161683, 1163777, 1164528, 1165308, 1166609, 1169053, 1180261, 1182406, 1183593, 1186523, 1186670, 1188100, 1188553, 1189943, 1190036, 1193012, 1195599, 1201697, 1202806, 1205879, 1208355, 1208596, 1210020, 1213675, 1214326, 1216139, 1219342, 1221739, 1221808, 1225736, 1226730, 1228660, 1230904, 1232456, 1233554, 1233709, 1235486, 1235767, 1241324, 1241815, 1242309, 1243985, 1245112, 1245329, 1246227, 1249680, 1250156, 1251256, 1252171, 1253156, 1254134, 1260458, 1260705, 1260729, 1261647, 1261938, 1263478, 1265936, 1267712, 1270717, 1271899, 1272795, 1274364, 1274665, 1275202, 1277327, 1277386, 1278029, 1280873, 1281165, 1281478, 1281976, 1282570, 1284952, 1290660, 1292771, 1294286, 1296026, 1296396, 1297575, 1298304, 1300415, 1300590, 1300628, 1304925, 1305508, 1306361, 1307391, 1308660, 1309840, 1310764, 1312933, 1321281, 1326816, 1326956, 1327270, 1330597, 1331254, 1332892, 1334207, 1334510, 1334897, 1336136, 1337499, 1338627, 1340465, 1341980, 1342244, 1349516, 1350592, 1351383, 1352030, 1353315, 1354793, 1356944, 1357155, 1360666, 1360815, 1360921, 1362303, 1366764, 1373787, 1380219, 1380396, 1381988, 1383347, 1385166, 1386615, 1387844, 1389137, 1389264, 1390131, 1390724, 1393383, 1394188, 1394543, 1397441, 1397844]\n"
     ]
    }
   ],
   "source": [
    "users_list = [str(x) for x in users_lists]\n",
    "users_string = ','.join(users_list)\n",
    "print(users_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('[2047, 2150, 2257, 3049, 3856, 5681, 5855, 6358, 6652, 7224, 7520, 8890, '\n",
      " '10705, 12097, 12422, 13259, 13504, 14922, 15544, 19594, 20007, 22013, 22284, '\n",
      " '24174, 24705, 24883, 25082, 25992, 26491, 26637, 30777, 31497, 34583, 35306, '\n",
      " '35990, 37093, 38294, 39243, 40864, 43117, 44523, 46162, 46240, 47753, 49085, '\n",
      " '49250, 49802, 49861, 52234, 52894, 52961, 53771, 54880, 55253, 55560, 55589, '\n",
      " '55623, 57371, 57595, 57680, 58102, 58645, 59339, 59612, 60229, 63225, 64310, '\n",
      " '65132, 65765, 68186, 68629, 69334, 69815, 71909, 73019, 73732, 76127, 76473, '\n",
      " '77485, 77695, 77711, 78858, 80096, 80573, 82318, 83429, 84128, 87605, 87732, '\n",
      " '91211, 91691, 95239, 97396, 97979, 100012, 101563, 101665, 103799, 104003, '\n",
      " '104191, 104334, 104427, 105386, 106272, 106416, 106761, 107204, 107389, '\n",
      " '107884, 109449, 110088, 111938, 113309, 115007, 115426, 118375, 118566, '\n",
      " '119012, 119039, 123142, 123454, 124398, 126881, 127431, 127517, 128335, '\n",
      " '130768, 131144, 131354, 133647, 133829, 134072, 134125, 134552, 134648, '\n",
      " '135435, 137228, 138118, 140621, 142556, 143843, 145148, 145311, 145869, '\n",
      " '146438, 148899, 151388, 152424, 153633, 154002, 155954, 156253, 159386, '\n",
      " '159702, 159902, 162133, 164021, 165398, 165483, 165636, 165932, 166367, '\n",
      " '166758, 167551, 167770, 168860, 173391, 173563, 174360, 174565, 175625, '\n",
      " '177258, 177718, 179699, 180469, 181626, 182520, 188171, 188210, 189110, '\n",
      " '189972, 189997, 190331, 191093, 191215, 192373, 192393, 192434, 194193, '\n",
      " '195479, 195925, 196544, 198115, 198435, 200366, 200416, 207801, 208286, '\n",
      " '211462, 212641, 213078, 214807, 214821, 216113, 216904, 217511, 217827, '\n",
      " '217942, 219470, 222873, 223895, 224286, 225344, 227331, 228312, 229790, '\n",
      " '230161, 230976, 231794, 237519, 237586, 237768, 237952, 244159, 245581, '\n",
      " '245723, 246069, 248667, 249160, 250546, 250988, 251274, 252030, 252367, '\n",
      " '252575, 253821, 253931, 255565, 256867, 257857, 260084, 262619, 263746, '\n",
      " '264730, 265240, 266165, 267014, 268574, 269455, 269666, 269869, 270881, '\n",
      " '272477, 273080, 273380, 275803, 276621, 276789, 277106, 278637, 282424, '\n",
      " '282479, 283226, 285284, 285677, 286666, 289443, 290170, 291292, 292840, '\n",
      " '293664, 294951, 299782, 301904, 303990, 304291, 306812, 313258, 318079, '\n",
      " '319768, 320081, 323042, 323743, 325279, 325302, 326960, 327971, 329179, '\n",
      " '329653, 332596, 335784, 339833, 341152, 342202, 343195, 343942, 350005, '\n",
      " '350857, 351027, 352918, 356048, 356334, 356737, 357814, 358113, 358158, '\n",
      " '358735, 359539, 361152, 362342, 362370, 362767, 365356, 366197, 366460, '\n",
      " '369432, 370360, 371826, 373252, 374113, 374287, 376723, 378530, 379482, '\n",
      " '381910, 382011, 383069, 385422, 386127, 386136, 386533, 387278, 387752, '\n",
      " '389367, 392128, 392334, 393119, 393156, 394640, 395837, 395917, 397147, '\n",
      " '397434, 398085, 398720, 399048, 400492, 401374, 401625, 402959, 409657, '\n",
      " '410418, 410588, 410729, 419574, 420107, 420749, 420927, 422440, 425055, '\n",
      " '425103, 426816, 427389, 428268, 428921, 432679, 432778, 433069, 433394, '\n",
      " '434465, 437886, 438299, 438528, 441719, 442103, 443429, 444145, 446086, '\n",
      " '447886, 449079, 449186, 449234, 450029, 450441, 452538, 453042, 453609, '\n",
      " '454861, 458686, 458750, 459084, 459402, 460473, 461702, 462746, 462771, '\n",
      " '465179, 466406, 467159, 470486, 470636, 470755, 470891, 471362, 471470, '\n",
      " '471545, 471561, 472887, 474675, 476141, 477851, 478065, 478574, 478684, '\n",
      " '480598, 480730, 481159, 481807, 482604, 485927, 486662, 488061, 488742, '\n",
      " '489336, 491030, 491045, 491541, 491645, 492820, 494070, 494380, 497236, '\n",
      " '497311, 497635, 503726, 504683, 505345, 505690, 506671, 509104, 509148, '\n",
      " '509491, 510964, 511900, 513362, 515831, 518376, 519565, 520080, 520463, '\n",
      " '522977, 524520, 533912, 536863, 539125, 541941, 543516, 544132, 544536, '\n",
      " '545798, 546236, 547428, 548048, 548579, 549960, 549999, 550456, 551211, '\n",
      " '551500, 552896, 553612, 553716, 554263, 558915, 561197, 562977, 566608, '\n",
      " '567083, 572019, 574668, 577681, 578964, 579705, 580966, 580969, 581837, '\n",
      " '583194, 585548, 588228, 590665, 591923, 595715, 595786, 597515, 598923, '\n",
      " '602394, 602742, 603122, 603265, 606153, 606785, 607135, 607591, 611869, '\n",
      " '611883, 614296, 615040, 617393, 617650, 618167, 620565, 622390, 624576, '\n",
      " '624738, 625814, 626124, 631959, 632639, 633497, 633833, 633958, 636104, '\n",
      " '638673, 640835, 641663, 642121, 642122, 645337, 645456, 645943, 646407, '\n",
      " '648530, 654163, 655517, 660739, 661055, 662168, 663037, 664890, 665532, '\n",
      " '665762, 666510, 666841, 667152, 669353, 670192, 673356, 673847, 675388, '\n",
      " '676521, 677289, 678525, 679270, 679393, 685920, 687462, 688421, 688776, '\n",
      " '688975, 692271, 692378, 692391, 693858, 695009, 695388, 695528, 696056, '\n",
      " '699628, 700139, 700554, 703035, 703495, 705650, 707396, 707527, 707955, '\n",
      " '708033, 708476, 710324, 713558, 714036, 716723, 719007, 719131, 719823, '\n",
      " '720459, 723404, 726974, 727577, 728698, 730399, 730641, 733307, 733988, '\n",
      " '735633, 735742, 735927, 736029, 736618, 739155, 740097, 741337, 742561, '\n",
      " '742888, 744363, 744604, 744734, 745052, 747738, 748430, 748722, 752721, '\n",
      " '752993, 754936, 763465, 763894, 764640, 767639, 771438, 771524, 774226, '\n",
      " '774870, 776853, 779977, 780592, 780934, 783411, 783716, 784212, 788469, '\n",
      " '790811, 791575, 791737, 793683, 794725, 796638, 798628, 802391, 802451, '\n",
      " '803541, 803725, 804132, 804972, 806924, 806929, 808099, 809062, 809076, '\n",
      " '812736, 813514, 815092, 815805, 816059, 819137, 819753, 819991, 822071, '\n",
      " '823356, 824914, 827650, 828129, 831953, 832263, 832410, 833258, 834893, '\n",
      " '835908, 837857, 841196, 841312, 843067, 845716, 846380, 849016, 850300, '\n",
      " '850502, 850770, 851089, 851528, 856414, 859329, 859623, 863247, 867636, '\n",
      " '868965, 871321, 871995, 872881, 874325, 875923, 876686, 877321, 878679, '\n",
      " '878687, 879841, 880264, 882319, 882754, 884626, 887395, 887870, 888060, '\n",
      " '888077, 889112, 890129, 890678, 891635, 892259, 892544, 893539, 895678, '\n",
      " '897865, 898375, 899529, 900712, 901295, 901752, 901756, 902778, 903689, '\n",
      " '904895, 906120, 908260, 909426, 912103, 913445, 913747, 915280, 915806, '\n",
      " '918583, 923350, 924152, 927824, 931086, 931428, 932126, 933020, 934574, '\n",
      " '937420, 937747, 938937, 944732, 945744, 947622, 951518, 952836, 953259, '\n",
      " '955867, 960056, 960518, 960684, 965279, 967441, 967508, 968449, 970352, '\n",
      " '972867, 973010, 973071, 973123, 974732, 975907, 976018, 977887, 978459, '\n",
      " '978866, 978881, 978929, 981859, 982050, 989549, 993851, 995787, 996068, '\n",
      " '996523, 1007002, 1008067, 1008861, 1009869, 1010284, 1012061, 1012428, '\n",
      " '1014679, 1014700, 1016798, 1019421, 1021052, 1024379, 1027624, 1029031, '\n",
      " '1029891, 1031927, 1032118, 1034759, 1035110, 1035833, 1038274, 1040520, '\n",
      " '1044926, 1045125, 1045893, 1047487, 1048573, 1049044, 1051544, 1051952, '\n",
      " '1052128, 1056256, 1060139, 1063007, 1066969, 1073293, 1077314, 1081170, '\n",
      " '1083418, 1083467, 1085721, 1088069, 1092615, 1094395, 1095670, 1096254, '\n",
      " '1103548, 1104920, 1105243, 1105292, 1105754, 1107660, 1112391, 1112779, '\n",
      " '1113753, 1114849, 1122260, 1123672, 1125070, 1125955, 1126383, 1126779, '\n",
      " '1127199, 1127879, 1129879, 1132559, 1132772, 1133081, 1134049, 1136921, '\n",
      " '1137185, 1137395, 1138026, 1142234, 1142519, 1142797, 1147038, 1149003, '\n",
      " '1149334, 1152005, 1152216, 1152794, 1153586, 1154101, 1154766, 1160832, '\n",
      " '1161683, 1163777, 1164528, 1165308, 1166609, 1169053, 1180261, 1182406, '\n",
      " '1183593, 1186523, 1186670, 1188100, 1188553, 1189943, 1190036, 1193012, '\n",
      " '1195599, 1201697, 1202806, 1205879, 1208355, 1208596, 1210020, 1213675, '\n",
      " '1214326, 1216139, 1219342, 1221739, 1221808, 1225736, 1226730, 1228660, '\n",
      " '1230904, 1232456, 1233554, 1233709, 1235486, 1235767, 1241324, 1241815, '\n",
      " '1242309, 1243985, 1245112, 1245329, 1246227, 1249680, 1250156, 1251256, '\n",
      " '1252171, 1253156, 1254134, 1260458, 1260705, 1260729, 1261647, 1261938, '\n",
      " '1263478, 1265936, 1267712, 1270717, 1271899, 1272795, 1274364, 1274665, '\n",
      " '1275202, 1277327, 1277386, 1278029, 1280873, 1281165, 1281478, 1281976, '\n",
      " '1282570, 1284952, 1290660, 1292771, 1294286, 1296026, 1296396, 1297575, '\n",
      " '1298304, 1300415, 1300590, 1300628, 1304925, 1305508, 1306361, 1307391, '\n",
      " '1308660, 1309840, 1310764, 1312933, 1321281, 1326816, 1326956, 1327270, '\n",
      " '1330597, 1331254, 1332892, 1334207, 1334510, 1334897, 1336136, 1337499, '\n",
      " '1338627, 1340465, 1341980, 1342244, 1349516, 1350592, 1351383, 1352030, '\n",
      " '1353315, 1354793, 1356944, 1357155, 1360666, 1360815, 1360921, 1362303, '\n",
      " '1366764, 1373787, 1380219, 1380396, 1381988, 1383347, 1385166, 1386615, '\n",
      " '1387844, 1389137, 1389264, 1390131, 1390724, 1393383, 1394188, 1394543, '\n",
      " '1397441, 1397844]')\n"
     ]
    }
   ],
   "source": [
    "pprint(users_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[2047, 2150, 2257, 3049, 3856, 5681, 5855, 6358, 6652, 7224, 7520, 8890, 10705, 12097, 12422, 13259, 13504, 14922, 15544, 19594, 20007, 22013, 22284, 24174, 24705, 24883, 25082, 25992, 26491, 26637, 30777, 31497, 34583, 35306, 35990, 37093, 38294, 39243, 40864, 43117, 44523, 46162, 46240, 47753, 49085, 49250, 49802, 49861, 52234, 52894, 52961, 53771, 54880, 55253, 55560, 55589, 55623, 57371, 57595, 57680, 58102, 58645, 59339, 59612, 60229, 63225, 64310, 65132, 65765, 68186, 68629, 69334, 69815, 71909, 73019, 73732, 76127, 76473, 77485, 77695, 77711, 78858, 80096, 80573, 82318, 83429, 84128, 87605, 87732, 91211, 91691, 95239, 97396, 97979, 100012, 101563, 101665, 103799, 104003, 104191, 104334, 104427, 105386, 106272, 106416, 106761, 107204, 107389, 107884, 109449, 110088, 111938, 113309, 115007, 115426, 118375, 118566, 119012, 119039, 123142, 123454, 124398, 126881, 127431, 127517, 128335, 130768, 131144, 131354, 133647, 133829, 134072, 134125, 134552, 134648, 135435, 137228, 138118, 140621, 142556, 143843, 145148, 145311, 145869, 146438, 148899, 151388, 152424, 153633, 154002, 155954, 156253, 159386, 159702, 159902, 162133, 164021, 165398, 165483, 165636, 165932, 166367, 166758, 167551, 167770, 168860, 173391, 173563, 174360, 174565, 175625, 177258, 177718, 179699, 180469, 181626, 182520, 188171, 188210, 189110, 189972, 189997, 190331, 191093, 191215, 192373, 192393, 192434, 194193, 195479, 195925, 196544, 198115, 198435, 200366, 200416, 207801, 208286, 211462, 212641, 213078, 214807, 214821, 216113, 216904, 217511, 217827, 217942, 219470, 222873, 223895, 224286, 225344, 227331, 228312, 229790, 230161, 230976, 231794, 237519, 237586, 237768, 237952, 244159, 245581, 245723, 246069, 248667, 249160, 250546, 250988, 251274, 252030, 252367, 252575, 253821, 253931, 255565, 256867, 257857, 260084, 262619, 263746, 264730, 265240, 266165, 267014, 268574, 269455, 269666, 269869, 270881, 272477, 273080, 273380, 275803, 276621, 276789, 277106, 278637, 282424, 282479, 283226, 285284, 285677, 286666, 289443, 290170, 291292, 292840, 293664, 294951, 299782, 301904, 303990, 304291, 306812, 313258, 318079, 319768, 320081, 323042, 323743, 325279, 325302, 326960, 327971, 329179, 329653, 332596, 335784, 339833, 341152, 342202, 343195, 343942, 350005, 350857, 351027, 352918, 356048, 356334, 356737, 357814, 358113, 358158, 358735, 359539, 361152, 362342, 362370, 362767, 365356, 366197, 366460, 369432, 370360, 371826, 373252, 374113, 374287, 376723, 378530, 379482, 381910, 382011, 383069, 385422, 386127, 386136, 386533, 387278, 387752, 389367, 392128, 392334, 393119, 393156, 394640, 395837, 395917, 397147, 397434, 398085, 398720, 399048, 400492, 401374, 401625, 402959, 409657, 410418, 410588, 410729, 419574, 420107, 420749, 420927, 422440, 425055, 425103, 426816, 427389, 428268, 428921, 432679, 432778, 433069, 433394, 434465, 437886, 438299, 438528, 441719, 442103, 443429, 444145, 446086, 447886, 449079, 449186, 449234, 450029, 450441, 452538, 453042, 453609, 454861, 458686, 458750, 459084, 459402, 460473, 461702, 462746, 462771, 465179, 466406, 467159, 470486, 470636, 470755, 470891, 471362, 471470, 471545, 471561, 472887, 474675, 476141, 477851, 478065, 478574, 478684, 480598, 480730, 481159, 481807, 482604, 485927, 486662, 488061, 488742, 489336, 491030, 491045, 491541, 491645, 492820, 494070, 494380, 497236, 497311, 497635, 503726, 504683, 505345, 505690, 506671, 509104, 509148, 509491, 510964, 511900, 513362, 515831, 518376, 519565, 520080, 520463, 522977, 524520, 533912, 536863, 539125, 541941, 543516, 544132, 544536, 545798, 546236, 547428, 548048, 548579, 549960, 549999, 550456, 551211, 551500, 552896, 553612, 553716, 554263, 558915, 561197, 562977, 566608, 567083, 572019, 574668, 577681, 578964, 579705, 580966, 580969, 581837, 583194, 585548, 588228, 590665, 591923, 595715, 595786, 597515, 598923, 602394, 602742, 603122, 603265, 606153, 606785, 607135, 607591, 611869, 611883, 614296, 615040, 617393, 617650, 618167, 620565, 622390, 624576, 624738, 625814, 626124, 631959, 632639, 633497, 633833, 633958, 636104, 638673, 640835, 641663, 642121, 642122, 645337, 645456, 645943, 646407, 648530, 654163, 655517, 660739, 661055, 662168, 663037, 664890, 665532, 665762, 666510, 666841, 667152, 669353, 670192, 673356, 673847, 675388, 676521, 677289, 678525, 679270, 679393, 685920, 687462, 688421, 688776, 688975, 692271, 692378, 692391, 693858, 695009, 695388, 695528, 696056, 699628, 700139, 700554, 703035, 703495, 705650, 707396, 707527, 707955, 708033, 708476, 710324, 713558, 714036, 716723, 719007, 719131, 719823, 720459, 723404, 726974, 727577, 728698, 730399, 730641, 733307, 733988, 735633, 735742, 735927, 736029, 736618, 739155, 740097, 741337, 742561, 742888, 744363, 744604, 744734, 745052, 747738, 748430, 748722, 752721, 752993, 754936, 763465, 763894, 764640, 767639, 771438, 771524, 774226, 774870, 776853, 779977, 780592, 780934, 783411, 783716, 784212, 788469, 790811, 791575, 791737, 793683, 794725, 796638, 798628, 802391, 802451, 803541, 803725, 804132, 804972, 806924, 806929, 808099, 809062, 809076, 812736, 813514, 815092, 815805, 816059, 819137, 819753, 819991, 822071, 823356, 824914, 827650, 828129, 831953, 832263, 832410, 833258, 834893, 835908, 837857, 841196, 841312, 843067, 845716, 846380, 849016, 850300, 850502, 850770, 851089, 851528, 856414, 859329, 859623, 863247, 867636, 868965, 871321, 871995, 872881, 874325, 875923, 876686, 877321, 878679, 878687, 879841, 880264, 882319, 882754, 884626, 887395, 887870, 888060, 888077, 889112, 890129, 890678, 891635, 892259, 892544, 893539, 895678, 897865, 898375, 899529, 900712, 901295, 901752, 901756, 902778, 903689, 904895, 906120, 908260, 909426, 912103, 913445, 913747, 915280, 915806, 918583, 923350, 924152, 927824, 931086, 931428, 932126, 933020, 934574, 937420, 937747, 938937, 944732, 945744, 947622, 951518, 952836, 953259, 955867, 960056, 960518, 960684, 965279, 967441, 967508, 968449, 970352, 972867, 973010, 973071, 973123, 974732, 975907, 976018, 977887, 978459, 978866, 978881, 978929, 981859, 982050, 989549, 993851, 995787, 996068, 996523, 1007002, 1008067, 1008861, 1009869, 1010284, 1012061, 1012428, 1014679, 1014700, 1016798, 1019421, 1021052, 1024379, 1027624, 1029031, 1029891, 1031927, 1032118, 1034759, 1035110, 1035833, 1038274, 1040520, 1044926, 1045125, 1045893, 1047487, 1048573, 1049044, 1051544, 1051952, 1052128, 1056256, 1060139, 1063007, 1066969, 1073293, 1077314, 1081170, 1083418, 1083467, 1085721, 1088069, 1092615, 1094395, 1095670, 1096254, 1103548, 1104920, 1105243, 1105292, 1105754, 1107660, 1112391, 1112779, 1113753, 1114849, 1122260, 1123672, 1125070, 1125955, 1126383, 1126779, 1127199, 1127879, 1129879, 1132559, 1132772, 1133081, 1134049, 1136921, 1137185, 1137395, 1138026, 1142234, 1142519, 1142797, 1147038, 1149003, 1149334, 1152005, 1152216, 1152794, 1153586, 1154101, 1154766, 1160832, 1161683, 1163777, 1164528, 1165308, 1166609, 1169053, 1180261, 1182406, 1183593, 1186523, 1186670, 1188100, 1188553, 1189943, 1190036, 1193012, 1195599, 1201697, 1202806, 1205879, 1208355, 1208596, 1210020, 1213675, 1214326, 1216139, 1219342, 1221739, 1221808, 1225736, 1226730, 1228660, 1230904, 1232456, 1233554, 1233709, 1235486, 1235767, 1241324, 1241815, 1242309, 1243985, 1245112, 1245329, 1246227, 1249680, 1250156, 1251256, 1252171, 1253156, 1254134, 1260458, 1260705, 1260729, 1261647, 1261938, 1263478, 1265936, 1267712, 1270717, 1271899, 1272795, 1274364, 1274665, 1275202, 1277327, 1277386, 1278029, 1280873, 1281165, 1281478, 1281976, 1282570, 1284952, 1290660, 1292771, 1294286, 1296026, 1296396, 1297575, 1298304, 1300415, 1300590, 1300628, 1304925, 1305508, 1306361, 1307391, 1308660, 1309840, 1310764, 1312933, 1321281, 1326816, 1326956, 1327270, 1330597, 1331254, 1332892, 1334207, 1334510, 1334897, 1336136, 1337499, 1338627, 1340465, 1341980, 1342244, 1349516, 1350592, 1351383, 1352030, 1353315, 1354793, 1356944, 1357155, 1360666, 1360815, 1360921, 1362303, 1366764, 1373787, 1380219, 1380396, 1381988, 1383347, 1385166, 1386615, 1387844, 1389137, 1389264, 1390131, 1390724, 1393383, 1394188, 1394543, 1397441, 1397844]\n"
     ]
    }
   ],
   "source": [
    "rows_limit = 1000\n",
    "# users_lists = []\n",
    "position = 0\n",
    "while position < len(user_ids):\n",
    "    users_lists.append(user_ids[position:position + rows_limit])\n",
    "#     users_lists += user_ids[position:position + rows_limit]\n",
    "    position += rows_limit\n",
    "    users_list = [str(x) for x in users_list]\n",
    "users_string = ','.join(users_list)\n",
    "print(users_list[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'id_' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-26-943dcf0f5e2d>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[0murl_\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m'https://api.vk.com/method/users.get?'\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      2\u001b[0m params_ = {\n\u001b[1;32m----> 3\u001b[1;33m     \u001b[1;34m'user_ids'\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mid_\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      4\u001b[0m     \u001b[1;34m'v'\u001b[0m\u001b[1;33m:\u001b[0m \u001b[1;36m5.73\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      5\u001b[0m     \u001b[1;34m'lang'\u001b[0m\u001b[1;33m:\u001b[0m \u001b[1;34m'ru'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'id_' is not defined"
     ]
    }
   ],
   "source": [
    "url_ = 'https://api.vk.com/method/users.get?'\n",
    "params_ = {\n",
    "    'user_ids': id_,\n",
    "    'v': 5.73,\n",
    "    'lang': 'ru',\n",
    "    'fields': 'sex, bdate, city',\n",
    "    'access_token': '0bacdcbf0bacdcbf0bacdcbfca0bd98be200bac0bacdcbf54602e6c585bfb326e7d4966',\n",
    "}\n",
    "\n",
    "city_data = requests.get(url_, params_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pprint(city_data.json())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}