{ "cells": [ { "metadata": {}, "cell_type": "markdown", "source": "# 获取保险信息", "id": "4b8e2571236aa684" }, { "cell_type": "code", "id": "initial_id", "metadata": { "collapsed": true, "ExecuteTime": { "end_time": "2026-01-12T08:14:20.840555600Z", "start_time": "2026-01-12T08:07:20.790418800Z" } }, "source": [ "import requests\n", "import pandas as pd\n", "from tqdm.notebook import tqdm\n", "import time\n", "\n", "cookies = {\n", " 'f6-insuranceSESSIONID': 'OKIIR4IV41TYN6Zjfd7tskosjy2B0pOD7V9WCE1I',\n", " 'erpLanguage': 'zh-CN',\n", " 'prodOrg': '11240984669918320544',\n", " 'unp': '15928227236671578189',\n", " 'un': '15928227236671578189',\n", " '_up': '-NillNN-qyBEJ--t3vnSknvoOF52z_mPssoH0H05XeZYUfnAr5DQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqEvQdq40k3gYO_vZRv-ZNHu3M-GTc15q5F3WvrO5Tj-wblVHLPxtmrEj9y2ixrpr4PWk.',\n", " 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2215928227236671578189%22%2C%22first_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%7D',\n", " 'tmall': 'false',\n", " 'Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1767584648,1767752972,1767855605,1767926696',\n", " 'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1767926696',\n", " 'HMACCOUNT': 'A6A0585E8C70051D',\n", "}\n", "\n", "headers = {\n", " 'accept': 'application/json, text/plain, */*',\n", " 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n", " 'priority': 'u=1, i',\n", " 'referer': 'https://yunxiu.f6car.cn/f6-insurance/view/index.html',\n", " 'sec-ch-ua': '\"Microsoft Edge\";v=\"143\", \"Chromium\";v=\"143\", \"Not A(Brand\";v=\"24\"',\n", " 'sec-ch-ua-mobile': '?0',\n", " 'sec-ch-ua-platform': '\"Windows\"',\n", " 'sec-fetch-dest': 'empty',\n", " 'sec-fetch-mode': 'cors',\n", " 'sec-fetch-site': 'same-origin',\n", " 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0',\n", " # 'cookie': 'f6-insuranceSESSIONID=OKIIR4IV41TYN6Zjfd7tskosjy2B0pOD7V9WCE1I; erpLanguage=zh-CN; prodOrg=11240984669918320544; unp=15928227236671578189; un=15928227236671578189; _up=-NillNN-qyBEJ--t3vnSknvoOF52z_mPssoH0H05XeZYUfnAr5DQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqEvQdq40k3gYO_vZRv-ZNHu3M-GTc15q5F3WvrO5Tj-wblVHLPxtmrEj9y2ixrpr4PWk.; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2215928227236671578189%22%2C%22first_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df76a22f46-04a98afdd2a11d8-4c657b58-1327104-19b6df76a2312c7%22%7D; tmall=false; Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1767584648,1767752972,1767855605,1767926696; Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1767926696; HMACCOUNT=A6A0585E8C70051D',\n", "}\n", "all_info_data = []\n", "no_external_data = []\n", "for i in tqdm(range(1,215)):\n", " params = {\n", " 'currentPage': i,\n", " 'pageSize': '100',\n", " 'idOwnOrg': '11240984669918320544',\n", " 'idOwnOrgList': '11240984669918320544',\n", " 'beginInTime': '2025-01-12',\n", " 'endInTime': '2026-01-12',\n", " 'ddStatus': '0',\n", " }\n", "\n", " response = requests.get(\n", " 'https://yunxiu.f6car.cn/f6-insurance/insurance/arrivalCustomerList',\n", " params=params,\n", " cookies=cookies,\n", " headers=headers,\n", " )\n", "\n", " info_list = response.json().get('data').get('list')\n", " all_info_data.extend(info_list)\n", " time.sleep(1)\n", "\n", " for info in info_list:\n", " if not info[\"externalForceExpireDate\"]:\n", " no_external_data.append(info)\n", "\n", "df = pd.DataFrame(all_info_data)\n", "df.to_csv(r\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\全部保险机器人信息.csv\")\n", "\n", "df1 = pd.DataFrame(no_external_data)\n", "df.to_csv(r\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\需要重新获取保险机器人信息.csv\")\n", "\n", "\n", "\n" ], "outputs": [ { "data": { "text/plain": [ " 0%| | 0/214 [00:00:26: SyntaxWarning: invalid escape sequence '\\I'\n", "<>:26: SyntaxWarning: invalid escape sequence '\\I'\n", "C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_21084\\4123766677.py:26: SyntaxWarning: invalid escape sequence '\\I'\n", " df4.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\保险机器人获取日志1.csv\")\n" ] }, { "data": { "text/plain": [ " 0%| | 0/64 [00:00 \u001B[39m\u001B[32m25\u001B[39m df4 = \u001B[43mpd\u001B[49m\u001B[43m.\u001B[49m\u001B[43mDataframe\u001B[49m(all_result)\n\u001B[32m 26\u001B[39m df4.to_csv(\u001B[33m\"\u001B[39m\u001B[33mD:\u001B[39m\u001B[33m\\\u001B[39m\u001B[33mIdea Project\u001B[39m\u001B[33m\\\u001B[39m\u001B[33mF6+宜搭+其它(1)\u001B[39m\u001B[33m\\\u001B[39m\u001B[33m张阳脚本\u001B[39m\u001B[33m\\\u001B[39m\u001B[33m文件输出\u001B[39m\u001B[33m\\\u001B[39m\u001B[33m保险机器人获取日志1.csv\u001B[39m\u001B[33m\"\u001B[39m)\n", "\u001B[31mAttributeError\u001B[39m: module 'pandas' has no attribute 'Dataframe'" ] } ], "execution_count": 17 }, { "metadata": { "ExecuteTime": { "end_time": "2026-01-09T03:56:32.915335600Z", "start_time": "2026-01-09T03:56:32.868929900Z" } }, "cell_type": "code", "source": [ "df4 = pd.DataFrame(all_result)\n", "df4.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\保险机器人获取日志1.csv\")" ], "id": "4883144404cd4727", "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "<>:2: SyntaxWarning: invalid escape sequence '\\I'\n", "<>:2: SyntaxWarning: invalid escape sequence '\\I'\n", "C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_21084\\731492121.py:2: SyntaxWarning: invalid escape sequence '\\I'\n", " df4.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\保险机器人获取日志1.csv\")\n" ] } ], "execution_count": 18 }, { "metadata": { "ExecuteTime": { "end_time": "2026-01-09T03:22:36.371726600Z", "start_time": "2026-01-09T03:22:35.902822700Z" } }, "cell_type": "code", "source": [ "for index, row in tqdm(df2[:1].iterrows()):\n", " params = {\n", " 'idArrival': row[\"idArrival\"],\n", " }\n", "\n", " json_data = {}\n", "\n", " response = requests.post(\n", " 'https://yunxiu.f6car.cn/f6-insurance/insurance/syncExternalInsuranceInfo',\n", " params=params,\n", " cookies=cookies,\n", " headers=headers,\n", " json=json_data,\n", " )\n", " print(response.json())" ], "id": "736ccd5b4a800208", "outputs": [ { "data": { "text/plain": [ "0it [00:00, ?it/s]" ], "application/vnd.jupyter.widget-view+json": { "version_major": 2, "version_minor": 0, "model_id": "82cf780b937c4825a6508b2de112d9e7" } }, "metadata": {}, "output_type": "display_data", "jetTransient": { "display_id": null } }, { "name": "stdout", "output_type": "stream", "text": [ "{'code': 200, 'data': {'businessExpireDate': '', 'companyName': '', 'forceExpireDate': '2026-03-17', 'nextBusinessStartDate': '', 'nextForceStartDate': ''}, 'message': 'SUCCESS'}\n" ] } ], "execution_count": 11 } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 2 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython2", "version": "2.7.6" } }, "nbformat": 4, "nbformat_minor": 5 }