Skip to content

Instantly share code, notes, and snippets.

@jt14den

jt14den/jharkhand gov scrape.ipynb

Created November 3, 2016 03:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jt14den/b64b89314b5a8982e09d41b456033dc4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jt14den/b64b89314b5a8982e09d41b456033dc4 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
jharkhand gov scrape.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import requests\n",
"#!conda install -y bs4\n",
"#!pip install -y bs4\n",
"from bs4 import BeautifulSoup\n",
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [],
"source": [
"# the below gives pandas the ability to grab a html table\n",
"#!conda install -y html5lib"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Save the post url for gathering the municipal IDS. We also need to generate a range of district IDs -- 1-24. I then create an empty dictionary that we will store the combinations of district IDs and municipal IDs. "
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"block_muni = 'http://aahar.jharkhand.gov.in/dealer_user_logs/getBlockMunicipality'\n",
"\n",
"dist_ids = list(range(1,25))\n",
"block_ids = {}"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24]\n"
]
}
],
"source": [
"print(dist_ids)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Below we want to loop thru the dist_ids and for each we build up a post request as 'dist_post', then make the request as r, load `content` as a BeautifulSoup object. `temp` uses a list comprehension of tuples that includes the municipal name and option value. We add these along with the district id to the `blocks_ids` dictionary we created above. "
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"for d_id in dist_ids:\n",
" dist_post = {'data[DealerUserLog][district_id]':d_id}\n",
" r = requests.post(block_muni, data=dist_post)\n",
" content = r.text\n",
" soup = BeautifulSoup(content, \"html.parser\")\n",
" temp = [(option['value'],option.text) for option in soup.find_all('option', value=True)[1:]]\n",
" block_ids.update({d_id: temp})"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"You can inspect the variables created above individually like below. "
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"[<option value=\"\">-Select-<option value=\"407\">CHITARPUR</option>\n",
" <option value=\"408\">DULMI</option>\n",
" <option value=\"183\">GOLA</option>\n",
" <option value=\"184\">MANDU</option>\n",
" <option value=\"185\">PATRATU</option>\n",
" <option value=\"186\">RAMGARH</option>\n",
" <option value=\"421\">RAMGARH CANTT</option>\n",
" </option>,\n",
" <option value=\"407\">CHITARPUR</option>,\n",
" <option value=\"408\">DULMI</option>,\n",
" <option value=\"183\">GOLA</option>,\n",
" <option value=\"184\">MANDU</option>,\n",
" <option value=\"185\">PATRATU</option>,\n",
" <option value=\"186\">RAMGARH</option>,\n",
" <option value=\"421\">RAMGARH CANTT</option>]"
]
},
"execution_count": 32,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"soup.find_all('option',value=True)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We now have a dictionary of the district id and a list of the associated municipal IDs."
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"{1: [('1', 'BERMO'),\n",
" ('420', 'Bokaro Steel City(TA)'),\n",
" ('2', 'CHANDANKIYARI'),\n",
" ('3', 'CHANDRAPURA'),\n",
" ('4', 'CHAS'),\n",
" ('258', 'CHAS NAGAR PALIKA(MN)'),\n",
" ('5', 'GOMIA'),\n",
" ('6', 'JARIDIH'),\n",
" ('7', 'KASMAR'),\n",
" ('8', 'NAWADIH'),\n",
" ('9', 'PETERWAR'),\n",
" ('268', 'Phusro (NA)')],\n",
" 2: [('406', 'BACHRA CT(TA)'),\n",
" ('10', 'CHATRA'),\n",
" ('261', 'Chatra (MN)'),\n",
" ('11', 'GIDHOUR'),\n",
" ('12', 'ITKHORI'),\n",
" ('13', 'KANHACHATTI'),\n",
" ('14', 'KUNDA'),\n",
" ('15', 'LAWALONG'),\n",
" ('16', 'MAYURHAND'),\n",
" ('17', 'PATHALGADA'),\n",
" ('18', 'PRATAPPUR'),\n",
" ('19', 'SHALIGRAM RAM NARAYANPUR ALIAS HUNTERGANJ'),\n",
" ('20', 'SIMARIA'),\n",
" ('21', 'TANDWA')],\n",
" 3: [('22', 'DEOGHAR'),\n",
" ('251', 'DEOGHAR(CR)'),\n",
" ('23', 'DEVIPUR'),\n",
" ('24', 'KAROWN'),\n",
" ('25', 'MADHUPUR'),\n",
" ('252', 'MADHUPUR(MN)'),\n",
" ('26', 'MARGOMUNDA'),\n",
" ('27', 'MOHANPUR'),\n",
" ('28', 'PALOJORI'),\n",
" ('29', 'SARATH'),\n",
" ('30', 'SARWAN'),\n",
" ('31', 'SONARAITHARI')],\n",
" 4: [('32', 'BAGHMARA'),\n",
" ('33', 'BALIAPUR'),\n",
" ('257', 'CHIRKUNDA(NA)'),\n",
" ('34', 'DHANBAD'),\n",
" ('329', 'Dhanbad Municipal Corporation(CR)'),\n",
" ('35', 'GOVINDPUR'),\n",
" ('36', 'NIRSA'),\n",
" ('37', 'PURVI TUNDI'),\n",
" ('38', 'TOPCHANCHI'),\n",
" ('39', 'TUNDI')],\n",
" 5: [('303', 'Basukinath(NA)'),\n",
" ('40', 'DUMKA'),\n",
" ('256', 'Dumka Munispality(MN)'),\n",
" ('41', 'GOPIKANDER'),\n",
" ('42', 'JAMA'),\n",
" ('43', 'JARMUNDI'),\n",
" ('44', 'KATHIKUND'),\n",
" ('45', 'MASALIYA'),\n",
" ('46', 'RAMGARH'),\n",
" ('47', 'RANISHWAR'),\n",
" ('48', 'SARAIYAHAT'),\n",
" ('49', 'SIKARIPARA')],\n",
" 6: [('50', 'BAHRAGORA'),\n",
" ('51', 'BORAM'),\n",
" ('52', 'CHAKULIA'),\n",
" ('413', 'CHAKULIA(NP)'),\n",
" ('53', 'DHALBHUMGARH'),\n",
" ('54', 'DUMARIA'),\n",
" ('55', 'GHATSHILA'),\n",
" ('56', 'GOLMURI CUM JUGSALAI'),\n",
" ('57', 'GURABANDA'),\n",
" ('390', 'Jamshedpur(NA)'),\n",
" ('391', 'Jugsalai(MN)'),\n",
" ('389', 'Mango(NA)'),\n",
" ('58', 'MUSABANI'),\n",
" ('59', 'PATAMDA'),\n",
" ('60', 'POTKA')],\n",
" 7: [('61', 'BARDIHA'),\n",
" ('62', 'BHANDARIA'),\n",
" ('63', 'BHAWNATHPUR'),\n",
" ('64', 'BISHUNPURA'),\n",
" ('65', 'CHINIA'),\n",
" ('66', 'DANDA'),\n",
" ('67', 'DANDAI'),\n",
" ('68', 'DHURKI'),\n",
" ('69', 'GARHWA'),\n",
" ('260', 'Garhwa(MN)'),\n",
" ('70', 'KANDI'),\n",
" ('71', 'KETAR'),\n",
" ('72', 'KHARAUNDHI'),\n",
" ('73', 'MANJHIAON'),\n",
" ('404', 'Manjhiaon(MN)'),\n",
" ('74', 'MERAL'),\n",
" ('75', 'NAGAR UNTARI'),\n",
" ('76', 'RAMKANDA'),\n",
" ('77', 'RAMNA'),\n",
" ('78', 'RANKA'),\n",
" ('79', 'SAGMA'),\n",
" ('271', 'Sinduria(TA)')],\n",
" 8: [('80', 'BAGODAR'),\n",
" ('81', 'BENGABAD'),\n",
" ('82', 'BIRNI'),\n",
" ('83', 'DEORI'),\n",
" ('84', 'DHANWAR'),\n",
" ('298', 'Dhanwar(TA)'),\n",
" ('85', 'DUMRI'),\n",
" ('86', 'GANDEY'),\n",
" ('87', 'GAWAN'),\n",
" ('88', 'GIRIDIH'),\n",
" ('299', 'Giridih(MN)'),\n",
" ('301', 'Isri(TA)'),\n",
" ('89', 'JAMUA'),\n",
" ('300', 'Paratdih(TA)'),\n",
" ('90', 'PIRTAND'),\n",
" ('91', 'SURIYA'),\n",
" ('92', 'TISRI')],\n",
" 9: [('93', 'BASANTRAY'),\n",
" ('94', 'BOARIJOR'),\n",
" ('95', 'GODDA'),\n",
" ('253', 'GODDA MUNICIPALITY(MN)'),\n",
" ('96', 'MAHAGAMA'),\n",
" ('97', 'MEHARMA'),\n",
" ('98', 'PATHARGAMA'),\n",
" ('99', 'PORAIYAHAT'),\n",
" ('100', 'SUNDARPAHARI'),\n",
" ('101', 'THAKURGANGTI')],\n",
" 10: [('102', 'ALBERT EKKA'),\n",
" ('103', 'BASIA'),\n",
" ('104', 'BHARNO'),\n",
" ('105', 'BISHUNPUR'),\n",
" ('106', 'CHAINPUR'),\n",
" ('107', 'DUMRI'),\n",
" ('108', 'GHAGHRA'),\n",
" ('109', 'GUMLA'),\n",
" ('259', 'GUMLA(MN)'),\n",
" ('110', 'KAMDARA'),\n",
" ('111', 'PALKOT'),\n",
" ('112', 'RAIDIH'),\n",
" ('113', 'SISAI')],\n",
" 11: [('114', 'BARHI'),\n",
" ('115', 'BARKAGAON'),\n",
" ('116', 'BARKATHA'),\n",
" ('117', 'BISHNUGARH'),\n",
" ('418', 'CHALKUSHA'),\n",
" ('118', 'CHOUPARAN'),\n",
" ('119', 'CHURCHU'),\n",
" ('416', 'DADI'),\n",
" ('414', 'DARU'),\n",
" ('262', 'Hazaribag (MN)'),\n",
" ('120', 'ICHAK'),\n",
" ('415', 'KATKAMDAG'),\n",
" ('121', 'KATKAMSANDI'),\n",
" ('122', 'KEREDARI'),\n",
" ('123', 'PADMA'),\n",
" ('124', 'SADAR'),\n",
" ('417', 'TATIJHARIYA')],\n",
" 12: [('125', 'FATEHPUR'),\n",
" ('126', 'JAMTARA'),\n",
" ('266', 'Jamtara (NA)'),\n",
" ('127', 'KARMATANR VIDYASAGAR'),\n",
" ('128', 'KUNDHIT'),\n",
" ('267', 'Mihijam (NA)'),\n",
" ('129', 'NALA'),\n",
" ('130', 'NARAYANPUR')],\n",
" 13: [('137', 'CHANDWARA'),\n",
" ('138', 'DOMCHANCH'),\n",
" ('139', 'JAINAGAR'),\n",
" ('140', 'KODERMA'),\n",
" ('141', 'MARKACHO'),\n",
" ('263', 'Nagar Panchayat, Kodarma(NA)'),\n",
" ('264', 'Nagar Parshad, Jhumri Telaiya(MN)'),\n",
" ('142', 'SATGAWAN')],\n",
" 14: [('143', 'BALUMATH'),\n",
" ('144', 'BARIYATU'),\n",
" ('145', 'BARWADIH'),\n",
" ('275', 'Barwadih(TA)'),\n",
" ('146', 'CHANDWA'),\n",
" ('147', 'GARU'),\n",
" ('148', 'HERHANJ'),\n",
" ('149', 'LATEHAR'),\n",
" ('276', 'Latehar(NA)'),\n",
" ('150', 'MAHUADANR'),\n",
" ('151', 'MANIKA')],\n",
" 15: [('152', 'BHANDRA'),\n",
" ('409', 'KAIRO'),\n",
" ('153', 'KISKO'),\n",
" ('154', 'KURU'),\n",
" ('155', 'LOHARDAGA'),\n",
" ('269', 'Lohardaga (MN)'),\n",
" ('410', 'PESHRAR'),\n",
" ('156', 'SENHA')],\n",
" 16: [('157', 'AMRAPARA'),\n",
" ('158', 'HIRANPUR'),\n",
" ('159', 'LITTIPARA'),\n",
" ('160', 'MAHESHPUR'),\n",
" ('161', 'PAKUR'),\n",
" ('265', 'PAKUR (MN)'),\n",
" ('162', 'PAKURIA')],\n",
" 17: [('163', 'BISHRAMPUR'),\n",
" ('405', 'Bishrampur(NA)'),\n",
" ('164', 'CHAINPUR'),\n",
" ('165', 'CHHATARPUR'),\n",
" ('274', 'Daltonganj(MN)'),\n",
" ('166', 'HAIDERNAGAR'),\n",
" ('167', 'HARIHARGANJ'),\n",
" ('168', 'HUSSAINABAD'),\n",
" ('273', 'Hussainabad(NA)'),\n",
" ('169', 'LESLIGANJ'),\n",
" ('170', 'MANATU'),\n",
" ('171', 'MEDININAGAR'),\n",
" ('172', 'MOHAMADGANJ'),\n",
" ('173', 'NAWA BAZAR'),\n",
" ('174', 'NAWDIHA BAZAR'),\n",
" ('175', 'PADWA'),\n",
" ('176', 'PANDU'),\n",
" ('177', 'PANKI'),\n",
" ('178', 'PATAN'),\n",
" ('179', 'PIPRA'),\n",
" ('180', 'SATBARWA'),\n",
" ('181', 'TARHASI'),\n",
" ('182', 'UNTARI ROAD')],\n",
" 18: [('187', 'ANGARA'),\n",
" ('188', 'BERO'),\n",
" ('189', 'BUNDU'),\n",
" ('371', 'Bundu(nagar panchayat)'),\n",
" ('190', 'BURMU'),\n",
" ('191', 'CHANHO'),\n",
" ('192', 'ITKI'),\n",
" ('193', 'KANKE'),\n",
" ('194', 'KHELARI'),\n",
" ('195', 'LAPUNG'),\n",
" ('196', 'MANDAR'),\n",
" ('197', 'NAGRI'),\n",
" ('198', 'NAMKUM'),\n",
" ('199', 'ORMANJHI'),\n",
" ('200', 'RAHE'),\n",
" ('367', 'Ranchi(CR)'),\n",
" ('201', 'RATU'),\n",
" ('202', 'SILLI'),\n",
" ('203', 'SONAHATU'),\n",
" ('204', 'TAMAR')],\n",
" 19: [('205', 'BARHAIT'),\n",
" ('206', 'BARHARWA'),\n",
" ('207', 'BORIO'),\n",
" ('208', 'MANDRO'),\n",
" ('209', 'PATHNA'),\n",
" ('210', 'RAJMAHAL'),\n",
" ('255', 'RAJMAHAL(NA)'),\n",
" ('211', 'SAHIBGANJ'),\n",
" ('254', 'SAHIBGANJ(MN)'),\n",
" ('212', 'TALJHARI'),\n",
" ('213', 'UDHWA')],\n",
" 20: [('377', 'Adityapur(NA)'),\n",
" ('214', 'CHANDIL'),\n",
" ('215', 'GAMHARIA'),\n",
" ('216', 'ICHAGARH'),\n",
" ('217', 'KHARSAWAN'),\n",
" ('218', 'KUCHAI'),\n",
" ('219', 'KUKRU'),\n",
" ('220', 'NIMDEEH'),\n",
" ('221', 'RAJNAGAR'),\n",
" ('379', 'Seraikela(MN)'),\n",
" ('222', 'SERAIKELLA')],\n",
" 21: [('223', 'BANO'),\n",
" ('224', 'BANSJORE'),\n",
" ('225', 'BOLBA'),\n",
" ('226', 'JALDEGA'),\n",
" ('227', 'KERSAI'),\n",
" ('228', 'KOLEBIRA'),\n",
" ('229', 'KURDEG'),\n",
" ('230', 'PAKARTANR'),\n",
" ('231', 'SIMDEGA'),\n",
" ('270', 'Simdega (NA)'),\n",
" ('232', 'THETHAITANGER')],\n",
" 22: [('233', 'ANANDPUR'),\n",
" ('234', 'BANDGAON'),\n",
" ('235', 'CHAIBASA'),\n",
" ('386', 'Chaibasa(MN)'),\n",
" ('236', 'CHAKRADHARPUR'),\n",
" ('372', 'Chakradharpur(MN)'),\n",
" ('237', 'GOELKERA'),\n",
" ('238', 'GUDRI'),\n",
" ('239', 'HATGAMHARIA'),\n",
" ('240', 'JAGANNATHPUR'),\n",
" ('241', 'JHINKPANI'),\n",
" ('242', 'KHUNTPANI'),\n",
" ('243', 'KUMARDUNGI'),\n",
" ('244', 'MANJHARI'),\n",
" ('245', 'MANJHGAON'),\n",
" ('246', 'MANOHARPUR'),\n",
" ('247', 'NOAMUNDI'),\n",
" ('248', 'SONUA'),\n",
" ('249', 'TANTNAGAR'),\n",
" ('250', 'TONTO')],\n",
" 23: [('131', 'ARKI'),\n",
" ('132', 'KARRA'),\n",
" ('133', 'KHUNTI'),\n",
" ('370', 'Khunti(NA)'),\n",
" ('134', 'MURHU'),\n",
" ('135', 'RANIA'),\n",
" ('136', 'TORPA')],\n",
" 24: [('407', 'CHITARPUR'),\n",
" ('408', 'DULMI'),\n",
" ('183', 'GOLA'),\n",
" ('184', 'MANDU'),\n",
" ('185', 'PATRATU'),\n",
" ('186', 'RAMGARH'),\n",
" ('421', 'RAMGARH CANTT')]}"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"block_ids"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Next step is to iterate over the dictionary keys/value in block_ids and since the value is a list of tuple pairs, we can pull those out by an inter-loop that iterates over the municipal ids. "
]
},
{
"cell_type": "code",
"execution_count": 37,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '1', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '420', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '2', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '3', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '4', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '258', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '5', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '6', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '7', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '8', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '9', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '268', 'data[DealerUserLog][district_id]': 1}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '406', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '10', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '261', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '11', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '12', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '13', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '14', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '15', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '16', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '17', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '18', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '19', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '20', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '21', 'data[DealerUserLog][district_id]': 2}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '22', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '251', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '23', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '24', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '25', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '252', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '26', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '27', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '28', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '29', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '30', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '31', 'data[DealerUserLog][district_id]': 3}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '32', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '33', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '257', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '34', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '329', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '35', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '36', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '37', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '38', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '39', 'data[DealerUserLog][district_id]': 4}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '303', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '40', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '256', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '41', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '42', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '43', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '44', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '45', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '46', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '47', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '48', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '49', 'data[DealerUserLog][district_id]': 5}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '50', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '51', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '52', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '413', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '53', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '54', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '55', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '56', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '57', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '390', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '391', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '389', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '58', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '59', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '60', 'data[DealerUserLog][district_id]': 6}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '61', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '62', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '63', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '64', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '65', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '66', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '67', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '68', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '69', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '260', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '70', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '71', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '72', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '73', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '404', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '74', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '75', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '76', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '77', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '78', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '79', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '271', 'data[DealerUserLog][district_id]': 7}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '80', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '81', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '82', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '83', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '84', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '298', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '85', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '86', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '87', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '88', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '299', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '301', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '89', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '300', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '90', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '91', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '92', 'data[DealerUserLog][district_id]': 8}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '93', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '94', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '95', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '253', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '96', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '97', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '98', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '99', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '100', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '101', 'data[DealerUserLog][district_id]': 9}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '102', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '103', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '104', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '105', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '106', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '107', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '108', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '109', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '259', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '110', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '111', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '112', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '113', 'data[DealerUserLog][district_id]': 10}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '114', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '115', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '116', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '117', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '418', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '118', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '119', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '416', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '414', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '262', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '120', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '415', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '121', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '122', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '123', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '124', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '417', 'data[DealerUserLog][district_id]': 11}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '125', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '126', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '266', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '127', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '128', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '267', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '129', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '130', 'data[DealerUserLog][district_id]': 12}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '137', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '138', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '139', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '140', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '141', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '263', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '264', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '142', 'data[DealerUserLog][district_id]': 13}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '143', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '144', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '145', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '275', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '146', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '147', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '148', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '149', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '276', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '150', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '151', 'data[DealerUserLog][district_id]': 14}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '152', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '409', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '153', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '154', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '155', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '269', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '410', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '156', 'data[DealerUserLog][district_id]': 15}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '157', 'data[DealerUserLog][district_id]': 16}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '158', 'data[DealerUserLog][district_id]': 16}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '159', 'data[DealerUserLog][district_id]': 16}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '160', 'data[DealerUserLog][district_id]': 16}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '161', 'data[DealerUserLog][district_id]': 16}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '265', 'data[DealerUserLog][district_id]': 16}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '162', 'data[DealerUserLog][district_id]': 16}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '163', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '405', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '164', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '165', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '274', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '166', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '167', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '168', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '273', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '169', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '170', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '171', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '172', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '173', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '174', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '175', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '176', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '177', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '178', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '179', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '180', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '181', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '182', 'data[DealerUserLog][district_id]': 17}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '187', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '188', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '189', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '371', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '190', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '191', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '192', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '193', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '194', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '195', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '196', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '197', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '198', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '199', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '200', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '367', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '201', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '202', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '203', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '204', 'data[DealerUserLog][district_id]': 18}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '205', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '206', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '207', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '208', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '209', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '210', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '255', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '211', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '254', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '212', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '213', 'data[DealerUserLog][district_id]': 19}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '377', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '214', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '215', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '216', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '217', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '218', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '219', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '220', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '221', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '379', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '222', 'data[DealerUserLog][district_id]': 20}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '223', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '224', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '225', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '226', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '227', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '228', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '229', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '230', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '231', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '270', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '232', 'data[DealerUserLog][district_id]': 21}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '233', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '234', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '235', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '386', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '236', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '372', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '237', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '238', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '239', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '240', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '241', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '242', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '243', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '244', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '245', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '246', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '247', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '248', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '249', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '250', 'data[DealerUserLog][district_id]': 22}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '131', 'data[DealerUserLog][district_id]': 23}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '132', 'data[DealerUserLog][district_id]': 23}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '133', 'data[DealerUserLog][district_id]': 23}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '370', 'data[DealerUserLog][district_id]': 23}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '134', 'data[DealerUserLog][district_id]': 23}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '135', 'data[DealerUserLog][district_id]': 23}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '136', 'data[DealerUserLog][district_id]': 23}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '407', 'data[DealerUserLog][district_id]': 24}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '408', 'data[DealerUserLog][district_id]': 24}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '183', 'data[DealerUserLog][district_id]': 24}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '184', 'data[DealerUserLog][district_id]': 24}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '185', 'data[DealerUserLog][district_id]': 24}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '186', 'data[DealerUserLog][district_id]': 24}\n",
"{'data[DealerUserLog][stockdatefrom]': '27-10-2016', 'data[DealerUserLog][block_city_id]': '421', 'data[DealerUserLog][district_id]': 24}\n"
]
}
],
"source": [
"for key, value in block_ids.items():\n",
" for block in value:\n",
" block_post = {'data[DealerUserLog][district_id]':key,\n",
" 'data[DealerUserLog][block_city_id]': block[0],\n",
" 'data[DealerUserLog][stockdatefrom]':'27-10-2016' }\n",
" print(block_post)\n",
" #print(key, block[0], block[1])\n",
" "
]
},
{
"cell_type": "code",
"execution_count": 50,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"payload = {'data[DealerUserLog][district_id]':'1', 'data[DealerUserLog][block_city_id]':'1',\n",
" 'data[DealerUserLog][stockdatefrom]': '17-10-2016'}\n",
"\n",
"r = requests.post(\"http://aahar.jharkhand.gov.in/dealer_user_logs/hhdLoginDetail\", data=payload)\n",
"data = r.text"
]
},
{
"cell_type": "code",
"execution_count": 51,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"tab = pd.read_html(data, skiprows=1, header=0)"
]
},
{
"cell_type": "code",
"execution_count": 56,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"list"
]
},
"execution_count": 56,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"type(tab)"
]
},
{
"cell_type": "code",
"execution_count": 60,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Sl No.</th>\n",
" <th>Dealer Name</th>\n",
" <th>Dealer User Name</th>\n",
" <th>HHT Unique Id</th>\n",
" <th>HHT Login Time</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>PIYUSH KUMAR DEY</td>\n",
" <td>PIYUSH KUMAR DEY</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 03:58:29 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>SATENDRA PRASAD MODI</td>\n",
" <td>SATENDRA PRASAD MODI</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 10:08:07 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>JAI PRAKASH SAW</td>\n",
" <td>JAI PRAKASH SAW</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 08:38:20 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>BERMO JARIDIH UPBHOKTA BHANDAR</td>\n",
" <td>NITESH KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 02:23:17 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NITESH KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 02:28:04 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NITESH KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 02:33:23 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NITESH KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 02:36:07 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>5</td>\n",
" <td>YAMUNA YADAV</td>\n",
" <td>YAMUNA YADAV</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 07:34:19 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>YAMUNA YADAV</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 03:27:30 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>YAMUNA YADAV</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 07:39:55 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>6</td>\n",
" <td>ABHIMANYU KUMAR SINHA</td>\n",
" <td>ABHIMNYU KUMAR SINHA</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 01:44:55 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>ABHIMNYU KUMAR SINHA</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 01:50:34 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>7</td>\n",
" <td>MURALIDHAR NISHAD</td>\n",
" <td>MURALIDHAR NISHAD</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 06:39:36 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>8</td>\n",
" <td>RINTU SINGH</td>\n",
" <td>RINTU KUMAR SINGH</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 09:15:44 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>9</td>\n",
" <td>BHARAT SINGH</td>\n",
" <td>AJAY SINGH</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 02:37:28 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>10</td>\n",
" <td>KAMESHWAR PANDEY</td>\n",
" <td>AJAY PANDEY</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 12:52:49 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>11</td>\n",
" <td>PARWAT SINGH</td>\n",
" <td>PARBAT SINGH</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 04:31:51 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>PARBAT SINGH</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 04:46:35 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>PARBAT SINGH</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 04:47:17 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>12</td>\n",
" <td>BHARAT PRASAD SINHA</td>\n",
" <td>BHARAT PRASAD SINHA</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 02:18:13 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>13</td>\n",
" <td>MANOJ KUMAR</td>\n",
" <td>MANOJ KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 06:25:33 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>MANOJ KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 02:11:00 PM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>14</td>\n",
" <td>LAXMAN THAKUR</td>\n",
" <td>SURESH KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 07:54:41 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>SURESH KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>17-10-2016 08:47:39 PM</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Sl No. Dealer Name Dealer User Name \\\n",
"0 1 PIYUSH KUMAR DEY PIYUSH KUMAR DEY \n",
"1 2 SATENDRA PRASAD MODI SATENDRA PRASAD MODI \n",
"2 3 JAI PRAKASH SAW JAI PRAKASH SAW \n",
"3 4 BERMO JARIDIH UPBHOKTA BHANDAR NITESH KUMAR \n",
"4 NaN NaN NITESH KUMAR \n",
"5 NaN NaN NITESH KUMAR \n",
"6 NaN NaN NITESH KUMAR \n",
"7 5 YAMUNA YADAV YAMUNA YADAV \n",
"8 NaN NaN YAMUNA YADAV \n",
"9 NaN NaN YAMUNA YADAV \n",
"10 6 ABHIMANYU KUMAR SINHA ABHIMNYU KUMAR SINHA \n",
"11 NaN NaN ABHIMNYU KUMAR SINHA \n",
"12 7 MURALIDHAR NISHAD MURALIDHAR NISHAD \n",
"13 8 RINTU SINGH RINTU KUMAR SINGH \n",
"14 9 BHARAT SINGH AJAY SINGH \n",
"15 10 KAMESHWAR PANDEY AJAY PANDEY \n",
"16 11 PARWAT SINGH PARBAT SINGH \n",
"17 NaN NaN PARBAT SINGH \n",
"18 NaN NaN PARBAT SINGH \n",
"19 12 BHARAT PRASAD SINHA BHARAT PRASAD SINHA \n",
"20 13 MANOJ KUMAR MANOJ KUMAR \n",
"21 NaN NaN MANOJ KUMAR \n",
"22 14 LAXMAN THAKUR SURESH KUMAR \n",
"23 NaN NaN SURESH KUMAR \n",
"\n",
" HHT Unique Id HHT Login Time \n",
"0 NaN 17-10-2016 03:58:29 PM \n",
"1 NaN 17-10-2016 10:08:07 PM \n",
"2 NaN 17-10-2016 08:38:20 AM \n",
"3 NaN 17-10-2016 02:23:17 PM \n",
"4 NaN 17-10-2016 02:28:04 PM \n",
"5 NaN 17-10-2016 02:33:23 PM \n",
"6 NaN 17-10-2016 02:36:07 PM \n",
"7 NaN 17-10-2016 07:34:19 AM \n",
"8 NaN 17-10-2016 03:27:30 PM \n",
"9 NaN 17-10-2016 07:39:55 AM \n",
"10 NaN 17-10-2016 01:44:55 PM \n",
"11 NaN 17-10-2016 01:50:34 PM \n",
"12 NaN 17-10-2016 06:39:36 AM \n",
"13 NaN 17-10-2016 09:15:44 AM \n",
"14 NaN 17-10-2016 02:37:28 PM \n",
"15 NaN 17-10-2016 12:52:49 PM \n",
"16 NaN 17-10-2016 04:31:51 PM \n",
"17 NaN 17-10-2016 04:46:35 PM \n",
"18 NaN 17-10-2016 04:47:17 PM \n",
"19 NaN 17-10-2016 02:18:13 PM \n",
"20 NaN 17-10-2016 06:25:33 PM \n",
"21 NaN 17-10-2016 02:11:00 PM \n",
"22 NaN 17-10-2016 07:54:41 AM \n",
"23 NaN 17-10-2016 08:47:39 PM "
]
},
"execution_count": 60,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tab[0]"
]
},
{
"cell_type": "code",
"execution_count": 44,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"soup = BeautifulSoup(data, 'html.parser')"
]
},
{
"cell_type": "code",
"execution_count": 61,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"[<a href=\"#nav\" title=\"Show navigation\">Show navigation</a>,\n",
" <a href=\"#\" title=\"Hide navigation\">Hide navigation</a>,\n",
" <a class=\"\" href=\"/\" target=\"_top\">HOME</a>,\n",
" <a href=\"#\">CARDHOLDER ▾</a>,\n",
" <a class=\"\" href=\"/secc_districts/districts\" target=\"_top\">Digitization</a>,\n",
" <a class=\"\" href=\"/secc_cardholders/searchRation\" target=\"_top\">Rationcard Detail</a>,\n",
" <a class=\"\" href=\"/cardholder_transactions/searchTransaction\" target=\"_top\">Entitlement</a>,\n",
" <a href=\"#\">TRANSACTION ▾</a>,\n",
" <a class=\"\" href=\"/district_monthly_reports/\" target=\"_top\">Summary Report</a>,\n",
" <a class=\"\" href=\"/transactions/transactionView\" target=\"_top\">Datewise Report</a>,\n",
" <a href=\"#\">DEALER ▾</a>,\n",
" <a class=\"\" href=\"/district_reports/districtDealer\" target=\"_top\">Dealer Summary</a>,\n",
" <a class=\"\" href=\"/district_allocations/dealerBankSlip\" target=\"_top\">Dealer's Bank Slip</a>,\n",
" <a class=\"\" href=\"/bank_payments/bankReport\" target=\"_top\">Bank Payment Report</a>,\n",
" <a class=\"\" href=\"/secc_cardholders/searchAllocationDealerWise\" target=\"_top\">Allocation Report</a>,\n",
" <a href=\"#\">HHT ▾</a>,\n",
" <a class=\"\" href=\"/dealer_user_logs/hhdLogin\" target=\"_top\">HHT Login Details</a>,\n",
" <a class=\"\" href=\"/hhd_masters/\" target=\"_top\">HHT List</a>,\n",
" <a href=\"rentals.html\">POLICY ▾</a>,\n",
" <a class=\"\" href=\"/policy_temps/searchPolicyFilter\" target=\"_top\">Policy Report</a>,\n",
" <a href=\"#\">OFFICES ▾</a>,\n",
" <a class=\"\" href=\"/dso_masters/\" target=\"_top\">DSO</a>,\n",
" <a class=\"\" href=\"/sdo_masters/\" target=\"_top\">SDO</a>,\n",
" <a class=\"\" href=\"/depot_masters/depotStock\" target=\"_top\">Depot</a>,\n",
" <a href=\"http://jharkhandsamadhan.nic.in/\" target=\"_blank\">E-SAMADHAN</a>,\n",
" <a href=\"#\">RATION FORM ▾</a>,\n",
" <a href=\"/download/rural.pdf\"> Rural (Inclusion)</a>,\n",
" <a href=\"/download/urban.pdf\"> Urban (Inclusion)</a>,\n",
" <a href=\"http://pds.jharkhand.gov.in\" id=\"content\" target=\"_blank\"> OFFICIAL LOGIN </a>,\n",
" <a href=\"/transactions/hhdLoginTransaction/NGU2MTM5ZjktY2UxOC00ODIxLTlkNDgtMDllMDBhODYwOTJk/MTM1/MjAxNi0xMC0xMA==\">SLOMI DAHANGA</a>]"
]
},
"execution_count": 61,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"table = soup.find_all('a') \n",
"table"
]
},
{
"cell_type": "code",
"execution_count": 39,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"row = table.find_all('tr')[0:]"
]
},
{
"cell_type": "code",
"execution_count": 41,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"<tr class=\"heading\">\n",
"<th>Sl No.</th>\n",
"<th>Dealer Name</th>\n",
"<th>Dealer User Name</th>\n",
"<th>HHT Unique Id</th>\n",
"<th>HHT Login Time</th>\n",
"</tr>"
]
},
"execution_count": 41,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"row[1]"
]
},
{
"cell_type": "markdown",
"metadata": {
"collapsed": true
},
"source": [
"## Hello\n",
"\n",
"* bullets\n",
"* bullets"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Variable Type Data/Info\n",
"-----------------------------------\n",
"BeautifulSoup type <class 'bs4.BeautifulSoup'>\n",
"pd module <module 'pandas' from '/U<...>ages/pandas/__init__.py'>\n",
"requests module <module 'requests' from '<...>es/requests/__init__.py'>\n"
]
}
],
"source": [
"whos"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"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.5.1"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment