Python 从 URL 读取 CSV 文件，每行开头存在 b' 会使 DictReader 感到困惑

发布于03月30日

我正在try 从URL中读取CSV文件，该URL的每行开头似乎都有b‘.

因此，当我使用csv.DictReader时，它似乎不工作，因为我假设它需要一个文本文件？

import urllib.request
import csv

target_url = 'https://raw.githubusercontent.com/vaastav/Fantasy-Premier-League/master/data/2022-23/gws/gw1.csv'

with urllib.request.urlopen(target_url) as csv_file:
    csv_reader = csv.DictReader(csv_file)
    players = []
    for row in csv_reader:
        players.append(dict(row))

print(players)

产生的错误: _csv.Error:迭代器应返回字符串，而不是字节(文件应以文本模式打开)

有什么 idea 吗？

推荐答案

try :

import csv
import urllib.request
from io import StringIO

target_url = 'https://raw.githubusercontent.com/vaastav/Fantasy-Premier-League/master/data/2022-23/gws/gw1.csv'

with urllib.request.urlopen(target_url) as csv_file:
    data = StringIO(csv_file.read().decode('utf-8'))
    csv_reader = csv.DictReader(data)
    players = list(csv_reader)

print(players)

打印:

[
  {'name': 'Nathan Redmond', 'position': 'MID', 'team': 'Southampton', 'xP': '1.5', 'assists': '0', 'bonus': '0', 'bps': '3', 'clean_sheets': '0', 'creativity': '0.0', 'element': '403', 'expected_assists': '0.00000', 'expected_goal_involvements': '0.00000', 'expected_goals': '0.00000', 'expected_goals_conceded': '0.00000', 'fixture': '8', 'goals_conceded': '0', 'goals_scored': '0', 'ict_index': '0.0', 'influence': '0.0', 'kickoff_time': '2022-08-06T14:00:00Z', 'minutes': '1', 'opponent_team': '18', 'own_goals': '0', 'penalties_missed': '0', 'penalties_saved': '0', 'red_cards': '0', 'round': '1', 'saves': '0', 'selected': '5871', 'starts': '0', 'team_a_score': '1', 'team_h_score': '4', 'threat': '0.0', 'total_points': '1', 'transfers_balance': '0', 'transfers_in': '0', 'transfers_out': '0', 'value': '55', 'was_home': 'False', 'yellow_cards': '0'}, 

...