310 lines
12 KiB
Plaintext
310 lines
12 KiB
Plaintext
{
|
|
"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<?, ?it/s]"
|
|
],
|
|
"application/vnd.jupyter.widget-view+json": {
|
|
"version_major": 2,
|
|
"version_minor": 0,
|
|
"model_id": "6f8bc9c88d974e89b1312427a72e8c06"
|
|
}
|
|
},
|
|
"metadata": {},
|
|
"output_type": "display_data",
|
|
"jetTransient": {
|
|
"display_id": null
|
|
}
|
|
}
|
|
],
|
|
"execution_count": 2
|
|
},
|
|
{
|
|
"metadata": {},
|
|
"cell_type": "markdown",
|
|
"source": "# 重新获取",
|
|
"id": "1c3f24216d5b9b50"
|
|
},
|
|
{
|
|
"metadata": {
|
|
"ExecuteTime": {
|
|
"end_time": "2026-01-09T03:56:19.027590200Z",
|
|
"start_time": "2026-01-09T03:56:14.350182100Z"
|
|
}
|
|
},
|
|
"cell_type": "code",
|
|
"source": [
|
|
"import requests\n",
|
|
"import pandas as pd\n",
|
|
"from tqdm.notebook import tqdm\n",
|
|
"import time\n",
|
|
"\n",
|
|
"df2 = pd.read_excel(r\"C:\\Users\\hp_z66\\Desktop\\需要重新获取保险机器人信息.xlsx\", sheet_name='Sheet3')\n",
|
|
"all_result = []\n",
|
|
"for index, row in df2.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",
|
|
" result = response.json()\n",
|
|
" time.sleep(3)\n",
|
|
" all_result.append(result)\n",
|
|
"df4 = pd.DataFrame(all_result)\n",
|
|
"df4.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\保险机器人获取日志1.csv\")\n",
|
|
"\n",
|
|
"\n"
|
|
],
|
|
"id": "6d1498b4a7c20ef0",
|
|
"outputs": [
|
|
{
|
|
"name": "stderr",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"<>: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<?, ?it/s]"
|
|
],
|
|
"application/vnd.jupyter.widget-view+json": {
|
|
"version_major": 2,
|
|
"version_minor": 0,
|
|
"model_id": "873739bbf6804730b4c5a29fcad91492"
|
|
}
|
|
},
|
|
"metadata": {},
|
|
"output_type": "display_data",
|
|
"jetTransient": {
|
|
"display_id": null
|
|
}
|
|
},
|
|
{
|
|
"name": "stderr",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"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"
|
|
]
|
|
},
|
|
{
|
|
"ename": "AttributeError",
|
|
"evalue": "module 'pandas' has no attribute 'Dataframe'",
|
|
"output_type": "error",
|
|
"traceback": [
|
|
"\u001B[31m---------------------------------------------------------------------------\u001B[39m",
|
|
"\u001B[31mAttributeError\u001B[39m Traceback (most recent call last)",
|
|
"\u001B[36mCell\u001B[39m\u001B[36m \u001B[39m\u001B[32mIn[17]\u001B[39m\u001B[32m, line 25\u001B[39m\n\u001B[32m 23\u001B[39m time.sleep(\u001B[32m3\u001B[39m)\n\u001B[32m 24\u001B[39m all_result.append(result)\n\u001B[32m---> \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
|
|
}
|