使用Pandas读取URL中的CSV文件时出现URL错误

运行这段代码时出现了URL错误：

import pandas as pd
import matplotlib.pylab as plt

filename = "https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0101EN-SkillsNetwork/labs/Data%20files/auto.csv"

headers = ["symboling","normalized-losses","make","fuel-type","aspiration", "num-of-doors","body-style",
         "drive-wheels","engine-location","wheel-base", "length","width","height","curb-weight","engine-type",
         "num-of-cylinders", "engine-size","fuel-system","bore","stroke","compression-ratio","horsepower",
         "peak-rpm","city-mpg","highway-mpg","price"]

df = pd.read_csv(filename, names = headers)

可以试试这些解决办法：

• 先确认链接有效性：把这个URL复制到浏览器里打开，看看能不能正常下载文件。如果浏览器也打不开，那就是链接失效了，得换个能用的数据源。
• 处理URL编码：原链接里的%20是空格的编码形式，你可以用代码解码后再尝试读取：

  from urllib.parse import unquote
  filename = unquote("https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0101EN-SkillsNetwork/labs/Data%20files/auto.csv")
  df = pd.read_csv(filename, names=headers)
  

• 模拟浏览器请求：有些云存储会拦截非浏览器发起的请求，给read_csv添加请求头试试：

  headers_dict = {
      'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36'
  }
  df = pd.read_csv(filename, names=headers, storage_options={'headers': headers_dict})
  

• 本地读取兜底：要是上面的方法都不行，直接把CSV文件下载到本地，然后用本地路径读取：

  df = pd.read_csv("你保存文件的本地路径/auto.csv", names=headers)
  

内容的提问来源于stack exchange，提问作者Himanshu Agrawal