下载压缩文件并解压为csv

def get_dingdanxiangqing(day,shopid):
    """
    下载保存为gz解压为csv
    """

    headers = {
        'Connection': 'keep-alive',
        'Upgrade-Insecure-Requests': '1',
        'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.62 Safari/537.36',
        'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8',
        'Accept-Encoding': 'gzip, deflate',
        'Accept-Language': 'zh-CN,zh;q=0.9',
    }

    response = requests.get('http://###############/LB1m_cWrBXa.gz', headers=headers,  verify=False)
    fileName= str(shopid)+day+'.gz'
    print(fileName)
    with open(fileName, 'wb') as f:
        f.write(response.content)

    csv_name =un_gz(fileName)

    return csv_name

def un_gz(file_name):
    """
    解压文件并保存为csv格式
    :param file_name:
    :return:
    """
    # 获取文件的名称，去掉后缀名
    f_name = file_name.replace(".gz", "")
    # 开始解压
    g_file = gzip.GzipFile(file_name)
    # 读取解压后的文件，并写入去掉后缀名的同名文件（即得到解压后的文件）
    open(f_name + '.csv', "wb+").write(g_file.read())
    g_file.close()

    return  f_name + '.csv'