# coding=gbk
import xlsxwriter as xw
import requests
import re
import json
import time
import random
from fake_useragent import UserAgent
import random
def get_ua():
user_agents = [
'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 OPR/26.0.1656.60',
'Opera/8.0 (Windows NT 5.1; U; en)',
'Mozilla/5.0 (Windows NT 5.1; U; en; rv:1.8.1) Gecko/20061208 Firefox/2.0.0 Opera 9.50',
'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; en) Opera 9.50',
'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0',
'Mozilla/5.0 (X11; U; Linux x86_64; zh-CN; rv:1.9.2.10) Gecko/20100922 Ubuntu/10.10 (maverick) Firefox/3.6.10',
'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/534.57.2 (KHTML, like Gecko) Version/5.1.7 Safari/534.57.2 ',
'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71 Safari/537.36',
'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11',
'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.133 Safari/534.16',
'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36',
'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko',
'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.11 TaoBrowser/2.0 Safari/536.11',
'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.71 Safari/537.1 LBBROWSER',
'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; QQDownload 732; .NET4.0C; .NET4.0E)',
'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.84 Safari/535.11 SE 2.X MetaSr 1.0',
'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; SV1; QQDownload 732; .NET4.0C; .NET4.0E; SE 2.X MetaSr 1.0) ',
]
user_agent = random.choice(user_agents) # random.choice(),���б��������ȡһ������
return user_agent
def cooies():
Cooies = [
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbUtSEEFzChJSeh1YAWJWFA4SXxQccwlEBnMZWQNjBhFaclRCFnUUR1NnGF4UZgsZWUFcQxRFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFD0BQfRlsBFcCIh8WC0AdcQhPXDYZWwZmCxRfQlFAHHABRlJ5H1UGZwUUWHJWcxY=; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_84be73e705554d7ba9f8703c91475426|1622685130814; __jda=122270672.16209731728481737821774.1620973173.1622434234.1622685131.6; __jdc=122270672; shshshfp=0674ab9706f98172ae9804359b80b89a; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM; shshshsID=6fc2f1cabe3066b623ea1ed54286e96a_3_1622685160990; __jdb=122270672.3.16209731728481737821774|6.1622685131',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; cud=054563a00d5d8aefbcbb26ec3d497881; shshshfpb=kEbSjelNOiy8smVKegvpgEA%3D%3D; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbUtSEEFzChJSeh1YAWJWFA4SXxQccwlEBnMZWQNjBhFaclRCFnUUR1NnGF4UZgsZWUFcQxRFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFD0BQfRlsBFcCIh8WC0AdcQhPXDYZWwZmCxRfQlFAHHABRlJ5H1UGZwUUWHJWcxY%3d; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_84be73e705554d7ba9f8703c91475426|1622685130814; cvt=7; __jda=122270672.16209731728481737821774.1620973173.1622434234.1622685131.6; __jdc=122270672; shshshfp=0674ab9706f98172ae9804359b80b89a; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM; shshshsID=6fc2f1cabe3066b623ea1ed54286e96a_3_1622685160990; __jdb=122270672.3.16209731728481737821774|6.1622685131; csn=3',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA%3D%3D; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbUtSEEFzChJSeh1YAWJWFA4SXxQccwlEBnMZWQNjBhFaclRCFnUUR1NnGF4UZgsZWUFcQxRFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFD0BQfRlsBFcCIh8WC0AdcQhPXDYZWwZmCxRfQlFAHHABRlJ5H1UGZwUUWHJWcxY%3d; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_84be73e705554d7ba9f8703c91475426|1622685130814; __jda=122270672.16209731728481737821774.1620973173.1622434234.1622685131.6; __jdc=122270672; shshshfp=0674ab9706f98172ae9804359b80b89a; shshshsID=6fc2f1cabe3066b623ea1ed54286e96a_3_1622685160990; __jdb=122270672.3.16209731728481737821774|6.1622685131; JSESSIONID=8978F14806112B33DB0F5163B0D39F25.s1; jwotest_product=99; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbUtSEEFzChJSeh1YAWJWFA4SXxQccwlEBnMZWQNjBhFaclRCFnUUR1NnGF4UZgsZWUFcQxRFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFD0BQfRlsBFcCIh8WC0AdcQhPXDYZWwZmCxRfQlFAHHABRlJ5H1UGZwUUWHJWcxY=; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_84be73e705554d7ba9f8703c91475426|1622685130814; __jda=122270672.16209731728481737821774.1620973173.1622434234.1622685131.6; __jdc=122270672; shshshfp=0674ab9706f98172ae9804359b80b89a; shshshsID=6fc2f1cabe3066b623ea1ed54286e96a_3_1622685160990; __jdb=122270672.3.16209731728481737821774|6.1622685131; jwotest_product=99; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM; JSESSIONID=B20366E12F0FA92CB7E9580A98507FC0.s1',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; qrsc=3; __jdc=122270672; rkv=1.0; __jda=122270672.16209731728481737821774.1620973173.1622770532.1622775046.10; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; shshshsID=8f19dde946441ff4cca33faf82d49cdb_1_1622775045880; __jda=122270672.16209731728481737821774.1620973173.1622770532.1622775046.10; __jdb=122270672.1.16209731728481737821774|10.1622775046; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; qrsc=3; __jdc=122270672; rkv=1.0; shshshsID=f0ae4c5c9deaabc1a71944554aec58b8_1_1622777849469; __jda=122270672.16209731728481737821774.1620973173.1622775046.1622777850.11; __jdb=122270672.1.16209731728481737821774|11.1622777850; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; qrsc=3; __jdc=122270672; rkv=1.0; __jda=122270672.16209731728481737821774.1620973173.1622775046.1622777850.11; __jdb=122270672.2.16209731728481737821774|11.1622777850; shshshsID=f0ae4c5c9deaabc1a71944554aec58b8_2_1622777950733; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; qrsc=3; __jdc=122270672; rkv=1.0; __jda=122270672.16209731728481737821774.1620973173.1622775046.1622777850.11; __jdb=122270672.3.16209731728481737821774|11.1622777850; shshshsID=f0ae4c5c9deaabc1a71944554aec58b8_3_1622778919311; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; qrsc=3; __jdc=122270672; rkv=1.0; __jda=122270672.16209731728481737821774.1620973173.1622775046.1622777850.11; __jdb=122270672.4.16209731728481737821774|11.1622777850; shshshsID=f0ae4c5c9deaabc1a71944554aec58b8_4_1622778955873; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; __jda=122270672.16209731728481737821774.1620973173.1622775046.1622777850.11; __jdb=122270672.5.16209731728481737821774|11.1622777850; shshshsID=f0ae4c5c9deaabc1a71944554aec58b8_5_1622778983384; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; __jda=122270672.16209731728481737821774.1620973173.1622775046.1622777850.11; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM; shshshsID=f0ae4c5c9deaabc1a71944554aec58b8_7_1622779090006; __jdb=122270672.7.16209731728481737821774|11.1622777850'
]
Cooie = random.choice(Cooies) # random.choice(),���б��������ȡһ������
return Cooie
def cooies1():
Cooies1 = [
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; __jda=122270672.16209731728481737821774.1620973173.1622777850.1622782324.12; cid=NWFUODEyNm1RMjU2N21BMzM2OGlTMTkyMWJSNjEyMnNZNzUwM21VMzMyNHRXOTUy; pinId=vmLHykXuR7Jda1uwTvLGhQ; pin=jd_gdBmmQrDBNpO; unick=jd_gdBmmQrDBNpO; ceshi3.com=000; _tp=j5vCl/5DdZ70knnLqHsrJg==; _pst=jd_gdBmmQrDBNpO; wlfstk_smdl=igy91ijvru0m48037r08goppj8d4zz5h; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM; TrackID=1Xf9gcx5rGAg4VsmSJAWk56caScGUV-Z_HiaeasuoE5iKHM_aCvdKuY8ESYRpYaiHDM0WdrppWQ9TMEQHCYKnWy4i2ILJomEujZCljvqQP6g; thor=748339BAFDC247E8E4BFE6D58B2193271AE6DE7571B518D1B300E3475933E43DF0F63035A206454054CDF143EBD9AD07F9197C1F6C174E66730A3C80F66908FC5C541FCE5E9C1A4FAE7A8345FE91BDF2567DF459921420F357EA931715B7B25B5A37AB91FFA1AAA417236FAD8CC7DB2469C19BE19568C44B232E1A3B7DC493AB220F570C581EA243D809AF549A644B3E39DE782CCEE1875646D47BBAFDBC41AA; shshshsID=a0a959aaa42d08cc581138cbd300992e_8_1622782746141; __jdb=122270672.18.16209731728481737821774|12.1622782324',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; __jda=122270672.16209731728481737821774.1620973173.1622777850.1622782324.12; cid=NWFUODEyNm1RMjU2N21BMzM2OGlTMTkyMWJSNjEyMnNZNzUwM21VMzMyNHRXOTUy; pinId=vmLHykXuR7Jda1uwTvLGhQ; pin=jd_gdBmmQrDBNpO; unick=jd_gdBmmQrDBNpO; ceshi3.com=000; _tp=j5vCl/5DdZ70knnLqHsrJg==; _pst=jd_gdBmmQrDBNpO; wlfstk_smdl=igy91ijvru0m48037r08goppj8d4zz5h; TrackID=1Xf9gcx5rGAg4VsmSJAWk56caScGUV-Z_HiaeasuoE5iKHM_aCvdKuY8ESYRpYaiHDM0WdrppWQ9TMEQHCYKnWy4i2ILJomEujZCljvqQP6g; thor=748339BAFDC247E8E4BFE6D58B2193271AE6DE7571B518D1B300E3475933E43DF0F63035A206454054CDF143EBD9AD07F9197C1F6C174E66730A3C80F66908FC5C541FCE5E9C1A4FAE7A8345FE91BDF2567DF459921420F357EA931715B7B25B5A37AB91FFA1AAA417236FAD8CC7DB2469C19BE19568C44B232E1A3B7DC493AB220F570C581EA243D809AF549A644B3E39DE782CCEE1875646D47BBAFDBC41AA; shshshsID=a0a959aaa42d08cc581138cbd300992e_9_1622782751868; __jdb=122270672.19.16209731728481737821774|12.1622782324; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; __jda=122270672.16209731728481737821774.1620973173.1622777850.1622782324.12; cid=NWFUODEyNm1RMjU2N21BMzM2OGlTMTkyMWJSNjEyMnNZNzUwM21VMzMyNHRXOTUy; pinId=vmLHykXuR7Jda1uwTvLGhQ; pin=jd_gdBmmQrDBNpO; unick=jd_gdBmmQrDBNpO; ceshi3.com=000; _tp=j5vCl/5DdZ70knnLqHsrJg==; _pst=jd_gdBmmQrDBNpO; wlfstk_smdl=igy91ijvru0m48037r08goppj8d4zz5h; TrackID=1Xf9gcx5rGAg4VsmSJAWk56caScGUV-Z_HiaeasuoE5iKHM_aCvdKuY8ESYRpYaiHDM0WdrppWQ9TMEQHCYKnWy4i2ILJomEujZCljvqQP6g; thor=748339BAFDC247E8E4BFE6D58B2193271AE6DE7571B518D1B300E3475933E43DF0F63035A206454054CDF143EBD9AD07F9197C1F6C174E66730A3C80F66908FC5C541FCE5E9C1A4FAE7A8345FE91BDF2567DF459921420F357EA931715B7B25B5A37AB91FFA1AAA417236FAD8CC7DB2469C19BE19568C44B232E1A3B7DC493AB220F570C581EA243D809AF549A644B3E39DE782CCEE1875646D47BBAFDBC41AA; shshshsID=a0a959aaa42d08cc581138cbd300992e_10_1622782798241; __jdb=122270672.20.16209731728481737821774|12.1622782324; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; __jda=122270672.16209731728481737821774.1620973173.1622777850.1622782324.12; cid=NWFUODEyNm1RMjU2N21BMzM2OGlTMTkyMWJSNjEyMnNZNzUwM21VMzMyNHRXOTUy; pinId=vmLHykXuR7Jda1uwTvLGhQ; pin=jd_gdBmmQrDBNpO; unick=jd_gdBmmQrDBNpO; ceshi3.com=000; _tp=j5vCl/5DdZ70knnLqHsrJg==; _pst=jd_gdBmmQrDBNpO; wlfstk_smdl=igy91ijvru0m48037r08goppj8d4zz5h; TrackID=1Xf9gcx5rGAg4VsmSJAWk56caScGUV-Z_HiaeasuoE5iKHM_aCvdKuY8ESYRpYaiHDM0WdrppWQ9TMEQHCYKnWy4i2ILJomEujZCljvqQP6g; thor=748339BAFDC247E8E4BFE6D58B2193271AE6DE7571B518D1B300E3475933E43DF0F63035A206454054CDF143EBD9AD07F9197C1F6C174E66730A3C80F66908FC5C541FCE5E9C1A4FAE7A8345FE91BDF2567DF459921420F357EA931715B7B25B5A37AB91FFA1AAA417236FAD8CC7DB2469C19BE19568C44B232E1A3B7DC493AB220F570C581EA243D809AF549A644B3E39DE782CCEE1875646D47BBAFDBC41AA; __jdb=122270672.21.16209731728481737821774|12.1622782324; shshshsID=a0a959aaa42d08cc581138cbd300992e_11_1622782844277; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; __jda=122270672.16209731728481737821774.1620973173.1622777850.1622782324.12; cid=NWFUODEyNm1RMjU2N21BMzM2OGlTMTkyMWJSNjEyMnNZNzUwM21VMzMyNHRXOTUy; pinId=vmLHykXuR7Jda1uwTvLGhQ; pin=jd_gdBmmQrDBNpO; unick=jd_gdBmmQrDBNpO; ceshi3.com=000; _tp=j5vCl/5DdZ70knnLqHsrJg==; _pst=jd_gdBmmQrDBNpO; wlfstk_smdl=igy91ijvru0m48037r08goppj8d4zz5h; TrackID=1Xf9gcx5rGAg4VsmSJAWk56caScGUV-Z_HiaeasuoE5iKHM_aCvdKuY8ESYRpYaiHDM0WdrppWQ9TMEQHCYKnWy4i2ILJomEujZCljvqQP6g; shshshsID=a0a959aaa42d08cc581138cbd300992e_12_1622782885405; __jdb=122270672.22.16209731728481737821774|12.1622782324; thor=748339BAFDC247E8E4BFE6D58B2193271AE6DE7571B518D1B300E3475933E43DF0F63035A206454054CDF143EBD9AD07B2D73B11E95D14A16C6092E36CE28397F928BB7057AA86F72EC9D8CF18916B885037DEF707B8940F65E78893CF1D8783F36488934D953D39C4FC72FDA43F312FE3A03D5F3D5D5BC237C7B2969F0146A1D1AF5D8104E8DBFFDD8150A9ECFB07EAB1D64F51AC807B92B411750436F951C6; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM',
'shshshfpa=0bd1b430-d00b-ffa1-522f-1dd01f5c990d-1620973172; __jdu=16209731728481737821774; shshshfpb=kEbSjelNOiy8smVKegvpgEA==; areaId=1; ipLoc-djd=1-2800-55811-0; unpl=V2_ZzNtbRYFERImCkBWc05fDGICQVUSAkYSdlgTXSgbDAw3C0IJclRCFnUUR1NnGF4UZwcZX0FcQxNFCEdkeBBVAWMDE1VGZxBFLV0CFSNGF1wjU00zQwBBQHcJFF0uSgwDYgcaDhFTQEJ2XBVQL0oMDDdRFAhyZ0AVRQhHZHseXwRvBRBdRFRKEHwIQFZ9EF8FYQUXbXJQcyVFAE9RfxlYNWYzE20AAx8cdwtEVn1UXAJkAhpbQFdFFnwNT1R9G1oMZAMUW0dnQiV2; __jdv=76161171|baidu-pinzhuan|t_288551095_baidupinzhuan|cpc|0f3d30c8dba7459bb52f2eb5eba8ac7d_0_ecc6b3739f2840b9ad462ad8b3a8a9ae|1622705537861; shshshfp=0674ab9706f98172ae9804359b80b89a; __jdc=122270672; cid=NWFUODEyNm1RMjU2N21BMzM2OGlTMTkyMWJSNjEyMnNZNzUwM21VMzMyNHRXOTUy; pinId=vmLHykXuR7Jda1uwTvLGhQ; pin=jd_gdBmmQrDBNpO; unick=jd_gdBmmQrDBNpO; ceshi3.com=000; _tp=j5vCl/5DdZ70knnLqHsrJg==; _pst=jd_gdBmmQrDBNpO; wlfstk_smdl=igy91ijvru0m48037r08goppj8d4zz5h; TrackID=1Xf9gcx5rGAg4VsmSJAWk56caScGUV-Z_HiaeasuoE5iKHM_aCvdKuY8ESYRpYaiHDM0WdrppWQ9TMEQHCYKnWy4i2ILJomEujZCljvqQP6g; __jda=122270672.16209731728481737821774.1620973173.1622782324.1622786547.13; shshshsID=6740081950235ceb826720ce8b827e0e_2_1622787836873; __jdb=122270672.2.16209731728481737821774|13.1622786547; thor=748339BAFDC247E8E4BFE6D58B2193271AE6DE7571B518D1B300E3475933E43DF0F63035A206454054CDF143EBD9AD07671CD47CFB3C8EE26877DAAFBFF78989B2B9E0711D7B5E288C54F612975E6074644B982E0B9BA6AEC9B7A37247DFB7445B875B3EC23BA5296BD8FA56D02295A00346B5F03FF2125A0DE5C4B0B4EE81B8AABA5F52178E114E3614E0314DE7ADEC21FCD5999C2E06901A156CC5F405F04F; 3AB9D23F7A4B3C9B=URAEOQZ7XGTYBQ2RX4KSEKLCIH4273TL6LKK4UA3LRFZAL6SFUK4LLPIVLTJPL46QOWOHEOMJEY4NQXXKYYIOWZVSM'
]
Cooie1 = random.choice(Cooies1) # random.choice(),���б��������ȡһ������
return Cooie1
class JD():
def __init__(self):
self.headers = {
# "user-agent": UserAgent().random,
"user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36",
'Cookie': cooies1()
}
# 创建表
wbook = xw.Workbook('写入模板.xlsx')
wsheet1 = wbook.add_worksheet('Sheet1') # 创建工作表
wsheet1.activate() # 激活表
title = ['内容', '评论时间', '用户名', 'id', '星评', '产品名', '购买类型'] # 设置表头
wsheet1.write_row('A1', title) # 从A1单元格写入表头
i = 2 # 从第二行写入数据
for j in range(3):
url = f'https://club.jd.com/comment/productPageComments.action?callback=fetchJSON_comment98&productId=100021710696&score=0&sortType=5&page=0&pageSize=10&isShadowSku=0&fold={j}'
header = {
'User-Agent': "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36",
# 'Cookie': cooies1()
}
t = requests.get(url, headers=header).text
# json1 = re.findall(r'fetchJSON_comment98\((.*?)}\)', html1)[0]+"}"
# t = re.search(r'(?<=fetchJSON_comment98\().*(?=\);)', t).group(0)
t = re.findall(r'fetchJSON_comment98\((.*?)}\)', t)[0] + "}"
print(t)
j = json.loads(t)
commentSummary = j['comments']
for comment in commentSummary:
list1 = []
c_content = comment['content']
list1.append(c_content)
c_time = comment['creationTime']
list1.append(c_time)
c_name = comment['nickname']
list1.append(c_name)
c_id = comment['id']
list1.append(c_id)
c_xing = comment['score']
list1.append(c_xing)
c_referenceName = comment['referenceName']
list1.append(c_referenceName)
c_productColor = comment['productColor']
list1.append(c_productColor)
print(list1)
row = 'A' + str(i)
# print(f'行：{row}')
wsheet1.write_row(row, list1)
i += 1
print("第", i - 1, "页")
wbook.close()
if __name__ == '__main__':
j = JD()
