1、常识面
- requests库: 使用requests库模仿收收恳求获得疑息
- BeautifulSoup库: 剖析页里并从中定位到响应标签页
- xlwt库: 使用此库可将数据输出到Excel表格
2、源码
- import pandas as pd # 存进excel数据
- import requests # 背页里收收恳求
- from bs4 import BeautifulSoup as BS
- import xlwt
- from datetime import datetime
- def get_weibo(weiboCookie):
- print("输出微专冷搜前50")
- # 目标地点
- url = 'https://s.weibo.com/top/su妹妹ary?cate=realtimehot'
- # 恳求头
- header = {
- 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36',
- 'Host': 's.weibo.com',
- 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
- 'Accept-Language': 'zh-CN,zh-Hans;q=0.9',
- 'Accept-Encoding': 'gzip, deflate, br',
- #活期 改换Cookie
- 'Cookie': weiboCookie
- }
- r = requests.get(url, headers=header) # 收收恳求
- # print(r.text)
- soup = BS(r.text, 'html.parser')
- # 冷搜标签: <td class=&#34;td-02&#34;> (&#39;div&#39;,{&#39;class&#39;:&#34;c-single-text-ellipsis&#34;})
- keywords = soup.find_all(&#39;td&#39;,{&#39;class&#39;:&#39;td-02&#39;})
- # hots = soup.find_all(&#39;td&#39;,{&#39;class&#39;:&#39;td-03&#39;})
- # print(keywords)
- datas = []
- i = 1
- for item in keywords[1:]: # 跳过第一条举荐置顶
- keyWord = str(item).split(&#34;</a>&#34;)[0].split(&#39;>&#39;)[2]
- hot = str(item).split(&#34;<span>&#34;)[1].split(&#39;</span>&#39;)[0]
- if hot != &#34;&#34;:
- # data = {
- # &#39;sort&#39;: i,
- # &#39;keyWord&#39;: keyWord,
- # &#39;hot&#39;: hot
- # }
- data = &#34;[&#34;+hot+&#34;]&#34;+&#34; &#34;+keyWord
- i += 1
- datas.append(data)
- print(datas)
- return datas
- def get_百度(百度Cookie):
- print(&#34;输出baidu冷搜前50&#34;)
- url = &#34;https://top.百度.com/board?tab=realtime&#34;
- # 恳求头
- header = {
- &#39;User-Agent&#39;: &#39;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36&#39;,
- &#39;Host&#39;: &#39;top.百度.com&#39;,
- &#39;Accept&#39;: &#39;text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9&#39;,
- &#39;Accept-Language&#39;: &#39;zh-CN,zh;q=0.9&#39;,
- &#39;Accept-Encoding&#39;: &#39;gzip, deflate, br&#39;,
- #活期 改换Cookie
- &#39;Cookie&#39;: 百度Cookie
- }
- r = requests.get(url,header)
- # print(r.text)
- soup = BS(r.text, &#39;html.parser&#39;)
- # 枢纽词汇的标签: <div class=&#34;c-single-text-ellipsis&#34;>
- # 冷度指数的标签:<div class=&#34;hot-index_1Bl1a&#34;>
- keywords = soup.find_all(&#39;div&#39;,{&#39;class&#39;:&#34;c-single-text-ellipsis&#34;})
- # print(keywords)
- hot_nums = soup.find_all(&#39;div&#39;,{&#39;class&#39;:&#34;hot-index_1Bl1a&#34;})
- # print(hot_nums)
- datas = []
- i=1
- for kw in keywords[1:]:
- keyWord = str(kw).split(&#39;>&#39;)[1].split(&#39;<&#39;)[0]
- hot = str(hot_nums[i]).split(&#39;>&#39;)[1].split(&#39;<&#39;)[0]
- data = &#34;[&#34; + hot + &#34;]&#34; + &#34; &#34; + keyWord
- i+=1
- datas.append(data)
- # print(data)
- print(datas)
- return datas
- def get_bili(biliCookie):
- print(&#34;输出B站冷搜前50&#34;)
- url = &#34;https://api.bilibili.com/x/web-interface/search/square?limit=50&#34;
- header = {
- &#39;User-Agent&#39;: &#39;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36&#39;,
- # &#39;Host&#39;: &#39;top.百度.com&#39;,
- &#39;Accept&#39;: &#39;text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9&#39;,
- &#39;Accept-Language&#39;: &#39;zh-CN,zh;q=0.9&#39;,
- &#39;Accept-Encoding&#39;: &#39;gzip, deflate, br&#39;,
- #活期 改换Cookie
- &#39;Cookie&#39;: biliCookie
- }
- r = requests.get(url, header).json()
- list = r[&#34;data&#34;][&#34;trending&#34;][&#34;list&#34;]
- # print(list)
- datas = []
- i = 1
- for kw in list:
- # data = {
- # &#39;sort&#39;: i,
- # &#39;keyWord&#39;:kw[&#39;show_name&#39;]
- # }
- data = kw[&#39;show_name&#39;]
- datas.append(data)
- i += 1
- print(datas)
- return datas
- # 无需cookie
- def get_toutiao():
- print(&#34;输出旧日头条冷搜前50&#34;)
- url = &#34;https://www.toutiao.com/hot-event/hot-board/?origin=toutiao_pc&#34;
- header = {
- &#39;User-Agent&#39;: &#39;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36&#39;,
- # &#39;Host&#39;: &#39;top.百度.com&#39;,
- &#39;Accept&#39;: &#39;text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9&#39;,
- &#39;Accept-Language&#39;: &#39;zh-CN,zh;q=0.9&#39;,
- &#39;Accept-Encoding&#39;: &#39;gzip, deflate, br&#39;,
- #活期 改换Cookie
- # &#39;Cookie&#39;: &#34;buvid3=691B51B2-68B0-433D-AA6A-8E6480662D8F155836infoc; rpdid=|(u)Yk)lmYuR0J&#39;ulmk||Ju~Y; LIVE_BUVID=AUTO7815963576068225; video_page_version=v_old_home; blackside_state=0; CURRENT_BLACKGAP=0; i-wanna-go-back=-1; fingerprint_s=2432558e03b7d0e4d3f2d656ba67bce7; CURRENT_QUALITY=80; canvasFp=866ed54e7230d22ab7cdec5d5dc73efd; webglFp=63c21fa0fd081da247c30126473061c3; screenInfo=2560*1440*24; feSign=d7345809c9bc39ccf355b231653d438a; payParams=%7B%22createIp%22%3A%22113.246.186.217%22%2C%22customerId%22%3A10034%2C%22deviceType%22%3A1%2C%22feeType%22%3A%22CNY%22%2C%22notifyUrl%22%3A%22http%3A//api.bilibili.co/pgc/internal/pay/order/notify/2%22%2C%22orderCreateTime%22%3A1645972374000%2C%22orderExpire%22%3A3600%2C%22orderId%22%3A%222022022722320002f%22%2C%22originalAmount%22%3A990%2C%22payAmount%22%3A490%2C%22productId%22%3A%2235%22%2C%22returnUrl%22%3A%22https%3A//www.bilibili.com/bangumi/play/ep384789%22%2C%22serviceType%22%3A0%2C%22showTitle%22%3A%22%u4ED8%u8D39-%u300A%u6E29%u6696%u7684%u62B1%u62B1%u300B%22%2C%22sign%22%3A%22b1ee653c0bbeae364198b3565d60f004%22%2C%22signType%22%3A%22MD5%22%2C%22timestamp%22%3A1645972374000%2C%22traceId%22%3A%224856fc19-ed67-4e73-9efc-3b8cd3f537ee%22%2C%22uid%22%3A382847812%2C%22version%22%3A%221.0%22%7D; _uuid=8737C173-3464-13E9-5A98-38BBB41D6CFC86923infoc; buvid_fp_plain=undefined; DedeUserID=382847812; DedeUserID__ckMd5=83d671e8bfb20c54; hit-dyn-v2=1; b_ut=5; nostalgia_conf=-1; buvid4=B2EB363E-6196-F7B4-4079-9F9A6ABCFB9862133-022012118-AiqhsCVq4sjMNhCDWE%2Fp4A%3D%3D; PVID=1; is-2022-channel=1; b_timer=%7B%22ffp%22%3A%7B%22333.26.fp.risk_691B51B2%22%3A%22182961A09D8%22%2C%22888.70641.fp.risk_691B51B2%22%3A%2218253269D8D%22%2C%22888.70253.fp.risk_691B51B2%22%3A%22182534851C1%22%2C%22333.1007.fp.risk_691B51B2%22%3A%22182A1DBDA1B%22%2C%22333.788.fp.risk_691B51B2%22%3A%2218297184A73%22%2C%22333.1073.fp.risk_691B51B2%22%3A%221826EDB5EA3%22%2C%22333.1193.fp.risk_691B51B2%22%3A%2218295F41C16%22%2C%22333.337.fp.risk_691B51B2%22%3A%221827802B04B%22%2C%22333.885.fp.risk_691B51B2%22%3A%22182A1DBF595%22%2C%22888.71209.fp.risk_691B51B2%22%3A%22182961CD695%22%2C%22888.453.fp.risk_691B51B2%22%3A%22182961CD727%22%2C%22333.999.fp.risk_691B51B2%22%3A%22182961DC78C%22%2C%22333.976.fp.risk_691B51B2%22%3A%221829622A043%22%2C%22444.41.fp.risk_691B51B2%22%3A%22182A1DBEE23%22%2C%22666.25.fp.risk_691B51B2%22%3A%22182A1DBD697%22%2C%22333.934.fp.risk_691B51B2%22%3A%221829A09B3E7%22%2C%22666.23.fp.risk_691B51B2%22%3A%221829A0A6DE2%22%2C%22666.32.fp.risk_691B51B2%22%3A%221829A0D0BAA%22%2C%22666.7.fp.risk_691B51B2%22%3A%22182A1DBE2E5%22%2C%22888.64379.fp.risk_691B51B2%22%3A%221829A0ED646%22%7D%7D; fingerprint3=c34d35184ac73b6da9c504153d73ccc5; fingerprint=afcf27eb2424f8b0f82d08e013ec90b5; buvid_fp=65780e1f523d56fc1f8ecae7ab14918b; b_nut=100; bsource=search_百度; innersign=0; SESSDATA=28e8743d%2C1679496140%2C835c2%2A91; bili_jct=cbc0ffa7b692efaf0a26a1121d7614ad; sid=7sbqtzd6; b_lsid=523F5104C_183741EA1C2; CURRENT_FNVAL=16; bp_video_offset_382847812=709805274986184700&#34;
- }
- r = requests.get(url, header).json()
- # print(r)
- list = r[&#34;data&#34;]
- datas = []
- i=1
- for kw in list:
- # print(kw)
- # data = {
- # &#39;sort&#39;: i,
- # &#39;keyWord&#39;: kw[&#39;Title&#39;],
- # &#39;hot&#39;: kw[&#39;HotValue&#39;]
- # }
- hot = kw[&#39;HotValue&#39;]
- keyWord = kw[&#39;Title&#39;]
- data = &#34;[&#34; + hot + &#34;]&#34; + &#34; &#34; + keyWord
- datas.append(data)
- i+=1
- print(datas)
- return datas
- def get_zhihu(zhihuCookie):
- print(&#34;输出知乎冷搜前50&#34;)
- url = &#34;https://www.zhihu.com/billboard&#34;
- # 恳求头
- header = {
- &#39;User-Agent&#39;: &#39;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36&#39;,
- #活期 改换Cookie
- &#39;Cookie&#39;: zhihuCookie
- }
- r = requests.get(url,header)
- # print(r.text)
- soup = BS(r.text, &#39;html.parser&#39;)
- # 枢纽词汇:<div class=&#34;HotList-itemTitle&#34;>
- # 冷度:<div class=&#34;HotList-itemMetrics&#34;>
- keywords = soup.find_all(&#39;div&#39;,{&#39;class&#39;:&#34;HotList-itemTitle&#34;})
- # print(keywords)
- hot_nums = soup.find_all(&#39;div&#39;,{&#39;class&#39;:&#34;HotList-itemMetrics&#34;})
- # print(hot_nums)
- i=0
- datas = []
- for kw in keywords:
- # data={
- # &#39;sort&#39;: i+1,
- # &#39;keyWord&#39;: str(kw).split(&#39;>&#39;)[1].split(&#39;<&#39;)[0],
- # &#39;hot&#39;: str(hot_nums[i]).split(&#39;>&#39;)[1].split(&#39;<&#39;)[0]
- # }
- hot = str(hot_nums[i]).split(&#39;>&#39;)[1].split(&#39;<&#39;)[0]
- keyWord = str(kw).split(&#39;>&#39;)[1].split(&#39;<&#39;)[0]
- data = &#34;[&#34; + hot + &#34;]&#34; + &#34; &#34; + keyWord
- datas.append(data)
- i+=1
- print(datas)
- return datas
- # 写进excel表格,就于后绝处置
- def write_to_excel(datas):
- &#34;&#34;&#34;
- col : 期望写正在表格第多少列
- col_name:列名(仄台名:微专、baidu、B站、头条、知乎)
- data : 列表格局的数据,与此中的枢纽词汇写进
- &#34;&#34;&#34;
- #创立 表格文献
- book = xlwt.Workbook(encoding=&#39;utf-8&#39;,style_compression=0)
- # 创界sheet表单
- sheet = book.add_sheet(&#34;各仄台冷搜榜单&#34;)
- for i,(plantform,data) in enumerate(datas.items()):
- sheet.col(i+1).width = 40*256 # 40个字严度
- print(plantform)
- sheet.write(0,i+1,plantform) # 尾止写进仄台名
- # print(data)
- for j,kw in enumerate(data):
- print(kw)
- sheet.write(j+1, i + 1, kw) # 尾止写进仄台名
- file_name = &#39;./&#39;+datetime.now().strftime(&#34;%Y_%m_%d_%H_%M_%S&#34;)+&#39;.xls&#39;
- # save_path = &#39;/&#39;
- book.save(file_name)
- all_data={}
- weiboCookie = &#39;login_sid_t=9e34d1c2379afc693202fa0ce161b730; cross_origin_proto=SSL; Apache=1593360874961.498.1618040796860; _s_tentry=passport.weibo.com; SINAGLOBAL=1593360874961.498.1618040796860; UOR=www.百度.com,weibo.com,www.百度.com; ULV=1652019581989:1:1:1:1593360874961.498.1618040796860:; SCF=Ah1HgEPMSYrKQ4D-B9CN78S3L3BFN-KVXQyCwxspmDuuf0Krk32yvMWS2Qso9el5QReOTw7R-pQRtBhmdmRGlFo.; SUB=_2AkMUH9bIf8NxqwFRmP0RxGvmaIlzyg7EieKiQycTJRMxHRl-yT9kqhcvtRB6P5_4JzpWHMtMDunzQTzsvdwCpeNPqT8X; SUBP=0033WrSXqPxfM72-Ws9jqgMF55529P9D9W59C8_VUmhFx8X-OZ.rVX0j&#39;
- weibo_datas = get_weibo(weiboCookie)
- all_data[&#39;微专&#39;] = weibo_datas
- 百度Cookie = &#39;BIDUPSID=018287A3B15818AFDA43A7138AF332FE; PSTM=1592003065; __yjs_duid=1_f323b8439ccfba4e5a49dcd1eead83001617900347690; BAIDUID=0A122DA944778214454BD4AE53B0D1E8:FG=1; MCITY=-%3A; BDUSS=GVMOEQ1ODRTZ09RSVEyUjVuN3I3WjlJNENpR0tIVVlmU3dLQnd6dllzRmQ1U0ZqSVFBQUFBJCQAAAAAAAAAAAEAAACkT4s00-u38dK7sd~Bub~sAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAF1Y-mJdWPpid; BDUSS_BFESS=GVMOEQ1ODRTZ09RSVEyUjVuN3I3WjlJNENpR0tIVVlmU3dLQnd6dllzRmQ1U0ZqSVFBQUFBJCQAAAAAAAAAAAEAAACkT4s00-u38dK7sd~Bub~sAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAF1Y-mJdWPpid; BDORZ=B490B5EBF6F3CD402E515D22BCDA1598; BDSFRCVID=Jo4OJexroG06EKOj21vGhLyRygKKg9TTDYLEOwXPsp3LGJLVcjg-EG0Pt8i0Cou-dk83ogKKLmOTHpKF_2uxOjjg8UtVJeC6EG0Ptf8g0M5; H_BDCLCKID_SF=tJ4DoD-hJKK3MCIwK-rjq4tehHRfW6v9WDTm_DoVXMJDoKOeWt6myfF15M7AWjoByH5I-pPKKR7oj4QPDJ-VjtI-3q7nQjQK3mkjbpnyfn02OIbPKtcryt4syPRr2xRnWTRiKfA-b4ncjRcTehoM3xI8LNj405OTbIFO0KJzJCFhbKLlejtWent8hMv-bD6b2IvKLnK8Kb7VbI09XMnkbfJBDxvmqRteJ2nA_56e2pRBDKbIQqOdLnD7yajK2bJQB5TO3b5nXMI-jtJb2MbpQT8rMMDOK5Oib4jIsR74ab3vOpRzXpO1KMPzBN5thURB2DkO-4bCWJ5TMl5jDh3Mb6ksDMDtqj-eJRADoD0Q5-5HDRcY-DTaKDCShUFsQT3AB2Q-5KL-0M5dSCo2QhoB5nIPQp8Lb4b8B23u_fbdJJjoSU5cQUb1QJ5-0xP8L4buX2TxoUJDQCnJhhvGqt7Ue5kebPRiWPr9QgbjahQ7tt5W8ncFbT7l5hKpbt-q0x-jLTnhVn0MBCK0bDP6j6Kbe5PW5ptXhPcKaKbyWJ3b2PK_Hn7zePRvDM4pbq7H2M-jJeTi2bF-t4QajhRw0RrJyUPseJOn0pcr36TuLhrTQJ7Hflvo34b8bIukQN3T-Tv0tg7yL66e2KP5Dn3oyUvVXp0nK-Rly5jtMgOBBJ0yQ4b4OR5JjxonDh83bG7MJUutfJKO_KL-JKP3H48k-4QEbbQH-UnLqMTyJgOZ04n-ah02Ml5oXPCKDJK1M-v8QJcMW23MVxbm3UTdsq76Wh35K5tTQP6rLtJB5-j4KKJxbInEhhOv5DcfMTvyhUJiBM7LBan7QpvIXKohJh7FM4tW3J0ZyxomtfQxtNRJ0DnjtpChbRO4-TFKejjyDx5; H_PS_PSSID=37151_36555_37356_37142_36885_37486_37403_37395_36803_36789_37436_37261_26350_37343_37351; BDSFRCVID_BFESS=Jo4OJexroG06EKOj21vGhLyRygKKg9TTDYLEOwXPsp3LGJLVcjg-EG0Pt8i0Cou-dk83ogKKLmOTHpKF_2uxOjjg8UtVJeC6EG0Ptf8g0M5; H_BDCLCKID_SF_BFESS=tJ4DoD-hJKK3MCIwK-rjq4tehHRfW6v9WDTm_DoVXMJDoKOeWt6myfF15M7AWjoByH5I-pPKKR7oj4QPDJ-VjtI-3q7nQjQK3mkjbpnyfn02OIbPKtcryt4syPRr2xRnWTRiKfA-b4ncjRcTehoM3xI8LNj405OTbIFO0KJzJCFhbKLlejtWent8hMv-bD6b2IvKLnK8Kb7VbI09XMnkbfJBDxvmqRteJ2nA_56e2pRBDKbIQqOdLnD7yajK2bJQB5TO3b5nXMI-jtJb2MbpQT8rMMDOK5Oib4jIsR74ab3vOpRzXpO1KMPzBN5thURB2DkO-4bCWJ5TMl5jDh3Mb6ksDMDtqj-eJRADoD0Q5-5HDRcY-DTaKDCShUFsQT3AB2Q-5KL-0M5dSCo2QhoB5nIPQp8Lb4b8B23u_fbdJJjoSU5cQUb1QJ5-0xP8L4buX2TxoUJDQCnJhhvGqt7Ue5kebPRiWPr9QgbjahQ7tt5W8ncFbT7l5hKpbt-q0x-jLTnhVn0MBCK0bDP6j6Kbe5PW5ptXhPcKaKbyWJ3b2PK_Hn7zePRvDM4pbq7H2M-jJeTi2bF-t4QajhRw0RrJyUPseJOn0pcr36TuLhrTQJ7Hflvo34b8bIukQN3T-Tv0tg7yL66e2KP5Dn3oyUvVXp0nK-Rly5jtMgOBBJ0yQ4b4OR5JjxonDh83bG7MJUutfJKO_KL-JKP3H48k-4QEbbQH-UnLqMTyJgOZ04n-ah02Ml5oXPCKDJK1M-v8QJcMW23MVxbm3UTdsq76Wh35K5tTQP6rLtJB5-j4KKJxbInEhhOv5DcfMTvyhUJiBM7LBan7QpvIXKohJh7FM4tW3J0ZyxomtfQxtNRJ0DnjtpChbRO4-TFKejjyDx5; delPer=0; PSINO=6; BAIDUID_BFESS=0A122DA944778214454BD4AE53B0D1E8:FG=1; BA_HECTOR=a10081al800h0h208lagohhl1hiu4p718; ZFY=RQxHkHiuouWI9wgxYJdvGzWC4HbbwozLptqnwDgnLdM:C&#39;
- 百度_datas = get_百度(百度Cookie)
- all_data[&#39;baidu&#39;] = 百度_datas
- biliCookie = &#34;buvid3=691B51B2-68B0-433D-AA6A-8E6480662D8F155836infoc; rpdid=|(u)Yk)lmYuR0J&#39;ulmk||Ju~Y; LIVE_BUVID=AUTO7815963576068225; video_page_version=v_old_home; blackside_state=0; CURRENT_BLACKGAP=0; i-wanna-go-back=-1; fingerprint_s=2432558e03b7d0e4d3f2d656ba67bce7; CURRENT_QUALITY=80; canvasFp=866ed54e7230d22ab7cdec5d5dc73efd; webglFp=63c21fa0fd081da247c30126473061c3; screenInfo=2560*1440*24; feSign=d7345809c9bc39ccf355b231653d438a; payParams=%7B%22createIp%22%3A%22113.246.186.217%22%2C%22customerId%22%3A10034%2C%22deviceType%22%3A1%2C%22feeType%22%3A%22CNY%22%2C%22notifyUrl%22%3A%22http%3A//api.bilibili.co/pgc/internal/pay/order/notify/2%22%2C%22orderCreateTime%22%3A1645972374000%2C%22orderExpire%22%3A3600%2C%22orderId%22%3A%222022022722320002f%22%2C%22originalAmount%22%3A990%2C%22payAmount%22%3A490%2C%22productId%22%3A%2235%22%2C%22returnUrl%22%3A%22https%3A//www.bilibili.com/bangumi/play/ep384789%22%2C%22serviceType%22%3A0%2C%22showTitle%22%3A%22%u4ED8%u8D39-%u300A%u6E29%u6696%u7684%u62B1%u62B1%u300B%22%2C%22sign%22%3A%22b1ee653c0bbeae364198b3565d60f004%22%2C%22signType%22%3A%22MD5%22%2C%22timestamp%22%3A1645972374000%2C%22traceId%22%3A%224856fc19-ed67-4e73-9efc-3b8cd3f537ee%22%2C%22uid%22%3A382847812%2C%22version%22%3A%221.0%22%7D; _uuid=8737C173-3464-13E9-5A98-38BBB41D6CFC86923infoc; buvid_fp_plain=undefined; DedeUserID=382847812; DedeUserID__ckMd5=83d671e8bfb20c54; hit-dyn-v2=1; b_ut=5; nostalgia_conf=-1; buvid4=B2EB363E-6196-F7B4-4079-9F9A6ABCFB9862133-022012118-AiqhsCVq4sjMNhCDWE%2Fp4A%3D%3D; PVID=1; is-2022-channel=1; b_timer=%7B%22ffp%22%3A%7B%22333.26.fp.risk_691B51B2%22%3A%22182961A09D8%22%2C%22888.70641.fp.risk_691B51B2%22%3A%2218253269D8D%22%2C%22888.70253.fp.risk_691B51B2%22%3A%22182534851C1%22%2C%22333.1007.fp.risk_691B51B2%22%3A%22182A1DBDA1B%22%2C%22333.788.fp.risk_691B51B2%22%3A%2218297184A73%22%2C%22333.1073.fp.risk_691B51B2%22%3A%221826EDB5EA3%22%2C%22333.1193.fp.risk_691B51B2%22%3A%2218295F41C16%22%2C%22333.337.fp.risk_691B51B2%22%3A%221827802B04B%22%2C%22333.885.fp.risk_691B51B2%22%3A%22182A1DBF595%22%2C%22888.71209.fp.risk_691B51B2%22%3A%22182961CD695%22%2C%22888.453.fp.risk_691B51B2%22%3A%22182961CD727%22%2C%22333.999.fp.risk_691B51B2%22%3A%22182961DC78C%22%2C%22333.976.fp.risk_691B51B2%22%3A%221829622A043%22%2C%22444.41.fp.risk_691B51B2%22%3A%22182A1DBEE23%22%2C%22666.25.fp.risk_691B51B2%22%3A%22182A1DBD697%22%2C%22333.934.fp.risk_691B51B2%22%3A%221829A09B3E7%22%2C%22666.23.fp.risk_691B51B2%22%3A%221829A0A6DE2%22%2C%22666.32.fp.risk_691B51B2%22%3A%221829A0D0BAA%22%2C%22666.7.fp.risk_691B51B2%22%3A%22182A1DBE2E5%22%2C%22888.64379.fp.risk_691B51B2%22%3A%221829A0ED646%22%7D%7D; fingerprint3=c34d35184ac73b6da9c504153d73ccc5; fingerprint=afcf27eb2424f8b0f82d08e013ec90b5; buvid_fp=65780e1f523d56fc1f8ecae7ab14918b; b_nut=100; bsource=search_百度; innersign=0; SESSDATA=28e8743d%2C1679496140%2C835c2%2A91; bili_jct=cbc0ffa7b692efaf0a26a1121d7614ad; sid=7sbqtzd6; b_lsid=523F5104C_183741EA1C2; CURRENT_FNVAL=16; bp_video_offset_382847812=709805274986184700&#34;
- bili_datas = get_bili(biliCookie)
- all_data[&#39;B站&#39;] = bili_datas
- all_data[&#39;旧日头条&#39;] = get_toutiao()
- zhihuCookie = &#39;_zap=de48c2fe-8bf5-432d-83ce-394a2e958a99; _xsrf=9d857c2e-9271-4208-8146-495716a85ee8; d_c0=AMDXx55UnRWPTjIcEgRhXmDtnx2gKPbJbR4=|1664115527; Hm_lvt_98beee57fd2ef70ccdd5ca52b9740c49=1664115529; Hm_lpvt_98beee57fd2ef70ccdd5ca52b9740c49=1664115529; SESSIONID=3qWbslXpdJfI5m7hXrV7e3LI7KOKqIJd13UQkZgQWaj; JOID=UlgQAE4pLVeKxd7ZCyrohPxliUEbGlkG7rOyhH1IZzTF9rbuZmRNZ-rA29oLOLw65k0lYdtnnhwBP2o9CwY3ID8=; osd=VlAQBU8tJVePxNrRCy_pgPRljEAfElkD77e6hHhJYzzF87fqbmRIZu7I298KPLQ640whadtinxgJP288Dw43JT4=; KLBRSID=2177cbf908056c6654e972f5ddc96dc2|1664115529|1664115527&#39;
- all_data[&#39;知乎&#39;] = get_zhihu(zhihuCookie)
- print(data)
- write_to_excel(datas=all_data)
复造代码 |