114 lines
6.0 KiB
Plaintext
114 lines
6.0 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"cell_type": "markdown",
|
|
"id": "92f27fd2",
|
|
"metadata": {},
|
|
"source": [
|
|
"管理后台-使用统计"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 2,
|
|
"id": "679fdcc5",
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stderr",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"<>:60: SyntaxWarning: invalid escape sequence '\\I'\n",
|
|
"<>:60: SyntaxWarning: invalid escape sequence '\\I'\n",
|
|
"C:\\Users\\hp_z66\\AppData\\Local\\Temp\\ipykernel_25140\\3645530864.py:60: SyntaxWarning: invalid escape sequence '\\I'\n",
|
|
" df.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(1)\\张阳脚本\\文件输出\\人员使用记录.csv\")\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"import requests\n",
|
|
"import pandas as pd\n",
|
|
"\n",
|
|
"cookies = {\n",
|
|
" 'fx-lang': 'zh_cn',\n",
|
|
" 'auth_token': 's%3A.9uztgExtmqUJXHCi00hv9SGq6eVYSvH%2BxQSwrox1Yls',\n",
|
|
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%2257956c24ceedab0c48c17b4e%22%2C%22first_id%22%3A%2219b6dd1a10c148a-063e3a033b10ed-4c657b58-2073600-19b6dd1a10d145b%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%22identities%22%3A%22eyIkaWRlbnRpdHlfY29va2llX2lkIjoiMTliNmRkMWExMGMxNDhhLTA2M2UzYTAzM2IxMGVkLTRjNjU3YjU4LTIwNzM2MDAtMTliNmRkMWExMGQxNDViIiwiJGlkZW50aXR5X2xvZ2luX2lkIjoiNTc5NTZjMjRjZWVkYWIwYzQ4YzE3YjRlIn0%3D%22%2C%22history_login_id%22%3A%7B%22name%22%3A%22%24identity_login_id%22%2C%22value%22%3A%2257956c24ceedab0c48c17b4e%22%7D%7D',\n",
|
|
" '_csrf': 's%3A_D_KxBikFhOaA2gkTYpORFF6.AqupOk5Q%2B7GUjR1bKbiQLAXksxGmkcsVthKkDYiBQRE',\n",
|
|
" 'Hm_lvt_de47dd1629940fe88b02865de93dd9fe': '1770176033,1770257492,1770281854,1770359422',\n",
|
|
" 'HMACCOUNT': 'A6A0585E8C70051D',\n",
|
|
" 'Hm_lpvt_de47dd1629940fe88b02865de93dd9fe': '1770600610',\n",
|
|
" 'GSuvNKHqfvX2r6v7P8HkZv2bow': 's%3ANKEleTNCioVWeMitYN3WOVYYmCXbGFB0.qD1J8obD4MP4FNXKiVimB2UWfI2g3Nm%2FFOuYEmdeQek',\n",
|
|
" 'JDY_SID': 's%3Aar54WVlu4J-OyZzN0zEvAOU_FgbWMSvc.nCgiElAa2EoL3zf2gCIUV4XCFBE6aF6fsodt4%2F1daj4',\n",
|
|
" 'acw_tc': '743e76f717706025725901488e72f65ae43f08af57c9b931c35df2a672f5ff',\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",
|
|
" 'content-type': 'application/json',\n",
|
|
" 'origin': 'https://www.jiandaoyun.com',\n",
|
|
" 'priority': 'u=1, i',\n",
|
|
" 'referer': 'https://www.jiandaoyun.com/product/usage_statistics',\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",
|
|
" '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-csrf-token': 'V3tEncMi-0KtoUAbnjwbKp66GsbVQMEL4bAc',\n",
|
|
" 'x-jdy-ver': '10.17.2',\n",
|
|
" 'x-request-id': 'c16157d6-0b12-4bf2-b56c-6858f66831e1',\n",
|
|
" # 'cookie': 'fx-lang=zh_cn; auth_token=s%3A.9uztgExtmqUJXHCi00hv9SGq6eVYSvH%2BxQSwrox1Yls; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%2257956c24ceedab0c48c17b4e%22%2C%22first_id%22%3A%2219b6dd1a10c148a-063e3a033b10ed-4c657b58-2073600-19b6dd1a10d145b%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%22identities%22%3A%22eyIkaWRlbnRpdHlfY29va2llX2lkIjoiMTliNmRkMWExMGMxNDhhLTA2M2UzYTAzM2IxMGVkLTRjNjU3YjU4LTIwNzM2MDAtMTliNmRkMWExMGQxNDViIiwiJGlkZW50aXR5X2xvZ2luX2lkIjoiNTc5NTZjMjRjZWVkYWIwYzQ4YzE3YjRlIn0%3D%22%2C%22history_login_id%22%3A%7B%22name%22%3A%22%24identity_login_id%22%2C%22value%22%3A%2257956c24ceedab0c48c17b4e%22%7D%7D; _csrf=s%3A_D_KxBikFhOaA2gkTYpORFF6.AqupOk5Q%2B7GUjR1bKbiQLAXksxGmkcsVthKkDYiBQRE; Hm_lvt_de47dd1629940fe88b02865de93dd9fe=1770176033,1770257492,1770281854,1770359422; HMACCOUNT=A6A0585E8C70051D; Hm_lpvt_de47dd1629940fe88b02865de93dd9fe=1770600610; GSuvNKHqfvX2r6v7P8HkZv2bow=s%3ANKEleTNCioVWeMitYN3WOVYYmCXbGFB0.qD1J8obD4MP4FNXKiVimB2UWfI2g3Nm%2FFOuYEmdeQek; JDY_SID=s%3Aar54WVlu4J-OyZzN0zEvAOU_FgbWMSvc.nCgiElAa2EoL3zf2gCIUV4XCFBE6aF6fsodt4%2F1daj4; acw_tc=743e76f717706025725901488e72f65ae43f08af57c9b931c35df2a672f5ff',\n",
|
|
"}\n",
|
|
"\n",
|
|
"json_data = {\n",
|
|
" 'from': None,\n",
|
|
" 'to': None,\n",
|
|
" 'granularity': 'daily',\n",
|
|
" 'members': [],\n",
|
|
" 'has_count': False,\n",
|
|
" 'sort': {},\n",
|
|
" 'limit': 50,\n",
|
|
" 'skip': 0,\n",
|
|
"}\n",
|
|
"all_data_list = []\n",
|
|
"for i in range(0,28):\n",
|
|
" json_data[\"skip\"] = i*50\n",
|
|
" response = requests.post(\n",
|
|
" 'https://www.jiandaoyun.com/corp/activity/user_user_metrics',\n",
|
|
" cookies=cookies,\n",
|
|
" headers=headers,\n",
|
|
" json=json_data,\n",
|
|
" )\n",
|
|
"\n",
|
|
" data_list = response.json().get(\"data\",[])\n",
|
|
" all_data_list.extend(data_list)\n",
|
|
"df = pd.DataFrame(all_data_list)\n",
|
|
"df.to_csv(\"D:\\Idea Project\\F6+宜搭+其它(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
|
|
}
|