25 lines
1.8 KiB
Python
25 lines
1.8 KiB
Python
import pandas as pd
|
|
import requests
|
|
|
|
cookies_str = 'memberSESSIONID=628612b7-606b-48d0-900a-8fb76fd6f1fa; sensorsdata2015jssdkcross={"distinct_id":"10691192243902595917","first_id":"1750b4690af1f6-089dd3a4874eb8-3d634f03-1327104-1750b4690b09d0","props":{"$latest_traffic_source_type":"直接流量","$latest_search_keyword":"未取到值_直接打开","$latest_referrer":""},"$device_id":"1750b4690af1f6-089dd3a4874eb8-3d634f03-1327104-1750b4690b09d0"}; gr_user_id=408fef1a-77ed-4e74-8f1e-31dde3446f2e; prodOrg=10546443563896246051; unp=10546443563896246058; un=10546443563896246058; _up=-NillNN-qyBEJ--t3vnSknvoOFt6yfeJtM4A1Xg3U-FfUvfBopHQjaZJ9Q3d-WrAAGgt60MgQHajHWBHMKKxj0CuWypi1JgKCFP1EPEk-HbrEfoUqYom1gII-vlRv-ZNHu3M-GTZ25y3EXOrq-tWgeIcklLFPhZnrEj95Rm-8c22MyI.; currMenu=客户车辆; sensorsdata2015jssdkcross={"distinct_id":"10546443563896246058","first_id":"1750b4690af1f6-089dd3a4874eb8-3d634f03-1327104-1750b4690b09d0","props":{"$latest_traffic_source_type":"直接流量","$latest_search_keyword":"未取到值_直接打开","$latest_referrer":""},"$device_id":"1750b4690af1f6-089dd3a4874eb8-3d634f03-1327104-1750b4690b09d0"}'
|
|
|
|
cookies_str = cookies_str.encode('utf-8').decode('latin-1')
|
|
|
|
cookie_dict = {item.split('=')[0]: item.split('=')[1]
|
|
for item in cookies_str.split('; ')}
|
|
|
|
headers = {
|
|
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Safari/537.36 Edg/95.0.1020.40',
|
|
"Content-Type": "application/json",
|
|
'origin': 'https://yunxiu.f6car.cn'
|
|
}
|
|
|
|
df = pd.read_excel(r'C:\Users\admin\Desktop\天猫养车手机号匹配.xls')
|
|
df = df.astype('string')
|
|
df.drop_duplicates(subset=['客户id'])
|
|
links = []
|
|
num = 1
|
|
for userID in df['客户id']:
|
|
res = requests.delete(f'https://yunxiu.f6car.cn/member/customer/{userID}',cookies=cookie_dict)
|
|
num = num + 1
|
|
print(num,userID,res.text) |