python读取excel，批量发送http请求

python读取excel，批量发送http请求

#!/usr/bin/python
# encoding: utf-8

from __future__ import print_function
import os
import pandas as pd
import requests
import numpy as np
import _thread

headers = {
        "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36",
        "app":"ALMS",
        "Content-Type":"application/json;charset=UTF-8",
    }

def request(businessId, headers):
    baseUrl1 = "http://youip:30606/xxxxxx/xxxxx?id="
    img = requests.get(baseUrl1+businessId, headers)
    if img.status_code != 200:
            return "error"
    return img

# 读取excel数据
data = None
def readXls():
    io = r'D:/Python/pythonwork1/xxx/xxx.xlsx'
    data = pd.read_excel(io.replace('\xe2\x80\xaa',''), sheet_name='Sheet2',skiprows=0,keep_default_na=False)
    return data

# imgpath = "http://xxx.oss-cn-shenzhen.aliyuncs.com/xxxxxxxx.jpg"
# downloadImg("http://xxx.oss-cn-shenzhen.aliyuncs.com/xxxxxxx.jpg",headers)
# data.loc[1].doc_name
# data.loc[1].car_business_id

if __name__ == '__main__':
    data = readXls()
    data1 = pd.DataFrame(columns = data.columns)
    for i in data.index:
        if request(data.loc[i].businessid,headers) == "error":
            # 写入读取不到的信息
            data1 = data1.append(data.loc[i])
    # 写如读取不到的信息
    io1 = r'D:/Python/pythonwork1/xxxxx/xxx04.xlsx'
    data1.to_excel(io1,"Sheet1")