panda/F6--
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
F6--/张阳脚本/F6汽车系统/客服积分批量修改.ipynb
T
panda 82af9b974b 20260602备份
2026-06-02 15:08:26 +08:00

409 lines
20 KiB
Plaintext
Raw Permalink Blame History

{
"cells": [
{
"cell_type": "markdown",
"id": "1d6ee92fe567f117",
"metadata": {},
"source": [
"客户积分批量修改\n",
"\n",
"单次删除10w，流失客户获取不到"
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "initial_id",
"metadata": {
"ExecuteTime": {
"end_time": "2026-02-03T09:06:58.436025100Z",
"start_time": "2026-02-03T08:57:47.208909600Z"
},
"collapsed": true
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"<>:69: SyntaxWarning: invalid escape sequence '\\I'\n",
"<>:69: SyntaxWarning: invalid escape sequence '\\I'\n",
"C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_7632\\3588797330.py:69: SyntaxWarning: invalid escape sequence '\\I'\n",
" ndf.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州积分客户信息-核销后1.csv\")\n"
]
},
{
"data": {
"application/vnd.jupyter.widget-view+json": {
"model_id": "b4f414e134b043f9a434e99bef7d02b2",
"version_major": 2,
"version_minor": 0
},
"text/plain": [
" 0%| | 0/260 [00:00<?, ?it/s]"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import requests\n",
"from tqdm.notebook import tqdm\n",
"import time\n",
"import random\n",
"\n",
"import pandas as pd\n",
"\n",
"\n",
"\n",
"cookies = {\n",
" 'memberSESSIONID': '627f27b2-8154-4338-874a-46afde892d0c',\n",
" 'erpLanguage': 'zh-CN',\n",
" 'prodOrg': '16075672590915518520',\n",
" 'unp': '16075954693997641815',\n",
" 'un': '16075954693997641815',\n",
" '_up': '-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.',\n",
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2216075954693997641815%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': '1779688780,1779850114,1779930850,1780295117',\n",
" 'HMACCOUNT': 'A6A0585E8C70051D',\n",
" 'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1780295119',\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/erp/view/index.html',\n",
" 'sec-ch-ua': '\"Chromium\";v=\"148\", \"Microsoft Edge\";v=\"148\", \"Not/A)Brand\";v=\"99\"',\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",
" 'traceparent': '00-120737cdb75f4501b4a4f5bd52e129b1-38dff64dce81188c-01',\n",
" 'tracestate': 'rum=v2&browser&dz2uw0c5ay@e5930ea8eb782ae&df337affccae4a26b03e3455a05a5522&uid_nli6u6uor4pqvx0f',\n",
" 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0',\n",
" 'x-requested-with': 'XMLHttpRequest',\n",
" # 'cookie': 'memberSESSIONID=627f27b2-8154-4338-874a-46afde892d0c; erpLanguage=zh-CN; prodOrg=16075672590915518520; unp=16075954693997641815; un=16075954693997641815; _up=-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2216075954693997641815%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=1779688780,1779850114,1779930850,1780295117; HMACCOUNT=A6A0585E8C70051D; Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1780295119',\n",
"}\n",
"\n",
"params = {\n",
" 'pageSize': '100',\n",
" 'pageNo': '1',\n",
"}\n",
"\n",
"response = requests.get(\n",
" 'https://yunxiu.f6car.cn/member/customer/listForPermission',\n",
" params=params,\n",
" cookies=cookies,\n",
" headers=headers,\n",
")\n",
"total = int(response.json()['data'][\"total\"])\n",
"total_page = total // 100 + 1\n",
"all_data = []\n",
"for i in tqdm(range(total_page)):\n",
" params['pageNo'] = str(i + 1)\n",
" response = requests.get(\n",
" 'https://yunxiu.f6car.cn/member/customer/listForPermission',\n",
" params=params,\n",
" cookies=cookies,\n",
" headers=headers,\n",
" )\n",
" reslut_list = response.json().get('data').get(\"data\")\n",
" all_data.extend(reslut_list)\n",
" time.sleep(0.5)\n",
"\n",
"ndf = pd.DataFrame(all_data)\n",
"ndf.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州积分客户信息-核销后1.csv\")\n"
]
},
{
"cell_type": "markdown",
"id": "76040d3d6324dd44",
"metadata": {},
"source": [
"处理"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "2897c87161a88d58",
"metadata": {
"ExecuteTime": {
"end_time": "2026-02-04T02:52:50.187746100Z",
"start_time": "2026-02-04T02:52:20.274151Z"
}
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"<>:63: SyntaxWarning: invalid escape sequence '\\I'\n",
"<>:65: SyntaxWarning: invalid escape sequence '\\I'\n",
"<>:63: SyntaxWarning: invalid escape sequence '\\I'\n",
"<>:65: SyntaxWarning: invalid escape sequence '\\I'\n",
"C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_7632\\2161723813.py:63: SyntaxWarning: invalid escape sequence '\\I'\n",
" df2.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户信息结果2.csv\")\n",
"C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_7632\\2161723813.py:65: SyntaxWarning: invalid escape sequence '\\I'\n",
" df3.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户报错信息2.csv\")\n"
]
},
{
"data": {
"application/vnd.jupyter.widget-view+json": {
"model_id": "33af6707c9b14461a11a0c33de5ed5c8",
"version_major": 2,
"version_minor": 0
},
"text/plain": [
" 0%| | 0/10 [00:00<?, ?it/s]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424976126067', '100000']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424971932047', '100000']\n",
"[{'success': False, 'code': 0, 'message': '充值失败，该客户未开启积分', 'data': None}, '12185724343350776493', '2767']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343342388224', '100000']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343333998664', '100000']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424976126067', '70841']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724424971932047', '13874']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343342388224', '99707']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343333998664', '21874']\n",
"[{'success': True, 'code': 200, 'message': None, 'data': True}, '12185724343333998664', '100000']\n"
]
}
],
"source": [
"import requests\n",
"import pandas as pd\n",
"from tqdm.notebook import tqdm\n",
"import time\n",
"import random\n",
"\n",
"cookies = {\n",
" 'memberSESSIONID': '627f27b2-8154-4338-874a-46afde892d0c',\n",
" 'erpLanguage': 'zh-CN',\n",
" 'prodOrg': '16075672590915518520',\n",
" 'unp': '16075954693997641815',\n",
" 'un': '16075954693997641815',\n",
" '_up': '-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.',\n",
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2216075954693997641815%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': '1779688780,1779850114,1779930850,1780295117',\n",
" 'HMACCOUNT': 'A6A0585E8C70051D',\n",
" 'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1780295119',\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/erp/view/index.html',\n",
" 'sec-ch-ua': '\"Chromium\";v=\"148\", \"Microsoft Edge\";v=\"148\", \"Not/A)Brand\";v=\"99\"',\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",
" 'traceparent': '00-120737cdb75f4501b4a4f5bd52e129b1-38dff64dce81188c-01',\n",
" 'tracestate': 'rum=v2&browser&dz2uw0c5ay@e5930ea8eb782ae&df337affccae4a26b03e3455a05a5522&uid_nli6u6uor4pqvx0f',\n",
" 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0',\n",
" 'x-requested-with': 'XMLHttpRequest',\n",
" # 'cookie': 'memberSESSIONID=627f27b2-8154-4338-874a-46afde892d0c; erpLanguage=zh-CN; prodOrg=16075672590915518520; unp=16075954693997641815; un=16075954693997641815; _up=-NillNN-qyBEJ--t3vnSknvoOF1_yvSEtckD2ng2U-BbUvDJppzQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqHPMWoI4j1gAP_fNRv-ZNHu3M-GTf3p-0HHKsqORWgOIdllLCNhJqrEj9_h_8_M64cWA.; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2216075954693997641815%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=1779688780,1779850114,1779930850,1780295117; HMACCOUNT=A6A0585E8C70051D; Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1780295119',\n",
"}\n",
"\n",
"\n",
"df = pd.read_excel(fr\"C:\\Users\\hp_z66\\Desktop\\万州积分客户信息-核销后.xlsx\", sheet_name=\"最终处理\").astype(str)\n",
"all_result_list =[]\n",
"error_list = []\n",
"for index, row in tqdm(df.iterrows(),total = len(df)):\n",
" time.sleep(random.randint(2, 4))\n",
" try:\n",
" json_data = {\n",
" 'customerId': row[\"客户id\"],\n",
" 'points': row['扣除'],\n",
" 'remark': '',\n",
" 'remarkDetail': '',\n",
" }\n",
" response1 = requests.post('https://yunxiu.f6car.cn/member/customer/points/deduct', cookies=cookies, headers=headers,json=json_data)\n",
" result = response1.json()\n",
" all_result_list.append([result,row[\"客户id\"],row['扣除']])\n",
" print([result,row[\"客户id\"],row['扣除']])\n",
" \n",
" except Exception as e :\n",
" print(f\"报错信息：{[result,row[\"客户id\"],row['扣除']]}\")\n",
" error_list.append([result,row[\"客户id\"],row['扣除']])\n",
"\n",
"\n",
"df2 = pd.DataFrame(all_result_list)\n",
"df2.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户信息结果2.csv\")\n",
"df3 = pd.DataFrame(error_list)\n",
"df3.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\万州客户报错信息2.csv\")\n",
"\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 13,
"id": "2fa5ba9202d993f5",
"metadata": {
"ExecuteTime": {
"end_time": "2026-02-04T02:49:20.745998Z",
"start_time": "2026-02-04T02:49:20.329441300Z"
}
},
"outputs": [],
"source": [
"df2 = pd.DataFrame(all_result_list)\n",
"df2.to_csv(fr\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\积分客户信息结果7.csv\")"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "0ca6cea6",
"metadata": {},
"outputs": [],
"source": [
"# 查询积分变动记录"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "544faa3e120e5392",
"metadata": {
"ExecuteTime": {
"end_time": "2026-02-03T09:38:32.709008600Z",
"start_time": "2026-02-03T09:38:32.287577Z"
}
},
"outputs": [
{
"data": {
"application/vnd.jupyter.widget-view+json": {
"model_id": "b2e91d697cbe4bb9a2befaf402a25d39",
"version_major": 2,
"version_minor": 0
},
"text/plain": [
" 0%| | 0/81 [00:00<?, ?it/s]"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import requests\n",
"import pandas as pd\n",
"from tqdm.notebook import tqdm\n",
"import time\n",
"\n",
"cookies = {\n",
" 'memberSESSIONID': '8fda24b1-43e8-46b7-8e81-44725f8fefee',\n",
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2210546443563961904423%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",
" 'erpLanguage': 'zh-CN',\n",
" 'prodOrg': '10546443563960461203',\n",
" 'unp': '10546443563961904423',\n",
" 'un': '10546443563961904423',\n",
" '_up': '-NillNN-qyBEJ--t3vnSknvoOFt6yfeJtM4A1Xg2XOZUVvXFpZrQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_MVro4n0gIO_vVRv-ZNHu3M-GTZ25y3EXOrq-tWgO0bmVbHOhFsrEj9_kC5lLD6QRM.',\n",
" 'tmall': 'false',\n",
" 'Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1769756586,1770022080,1770168808,1770175549',\n",
" 'Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a': '1770175549',\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/erp/view/index.html',\n",
" 'sec-ch-ua': '\"Not(A:Brand\";v=\"8\", \"Chromium\";v=\"144\", \"Microsoft Edge\";v=\"144\"',\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",
" 'traceparent': '00-57bb9b2437e844d1a9f370a0e8596ac2-053ca2ed20f7b0a1-01',\n",
" 'tracestate': 'rum=v2&browser&dz2uw0c5ay@e5930ea8eb782ae&c40a72c0393a4383be840fdfd4066b3c&uid_nli6u6uor4pqvx0f',\n",
" 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0',\n",
" 'x-requested-with': 'XMLHttpRequest',\n",
" # 'cookie': 'memberSESSIONID=8fda24b1-43e8-46b7-8e81-44725f8fefee; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2210546443563961904423%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; erpLanguage=zh-CN; prodOrg=10546443563960461203; unp=10546443563961904423; un=10546443563961904423; _up=-NillNN-qyBEJ--t3vnSknvoOFt6yfeJtM4A1Xg2XOZUVvXFpZrQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbqE_MVro4n0gIO_vVRv-ZNHu3M-GTZ25y3EXOrq-tWgO0bmVbHOhFsrEj9_kC5lLD6QRM.; tmall=false; Hm_lvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1769756586,1770022080,1770168808,1770175549; Hm_lpvt_25f5e7a3a5dbb293d7dd35d5f1be8d0a=1770175549; HMACCOUNT=A6A0585E8C70051D',\n",
"}\n",
"\n",
"df = pd.read_excel(fr\"C:\\Users\\hp_z66\\Desktop\\钉钉文件\\客户信息.xlsx\", sheet_name=\"验证\").astype(str)\n",
"info_list =[]\n",
"error_list = []\n",
"for index,row in tqdm(df.iterrows(),total = len(df)):\n",
" try:\n",
" params = {\n",
" 'customerId': row[\"客户id\"],\n",
" 'pageNo': '1',\n",
" 'pageSize': '10',\n",
" }\n",
"\n",
" response = requests.get(\n",
" 'https://yunxiu.f6car.cn/member/customer/points/charge/history',\n",
" params=params,\n",
" cookies=cookies,\n",
" headers=headers,\n",
" )\n",
" info = response.json().get(\"data\").get(\"data\",[])\n",
" info_list.extend(info)\n",
" time.sleep(0.5)\n",
" except:\n",
" print(f\"失败：{response.json()}\")\n",
" error_list.append([response.json(),row[\"客户id\"]])\n",
"\n",
"df5 = pd.DataFrame(info_list)\n",
"df5.to_csv(fr\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\积分明细2.csv\")\n"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "cca9de41",
"metadata": {},
"outputs": [],
"source": [
"\n",
"df5 = pd.DataFrame(info_list)\n",
"df5.to_csv(fr\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\积分明细1.csv\")"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "F6+宜搭+其它",
"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.13.11"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Reference in New Issue View Git Blame Copy Permalink