import csv

with open('data.csv', 'r', encoding='utf-8') as file:
    reader = csv.reader(file)
    for row in reader:
        print(row)

姓名,數(shù)學(xué),英語,物理,總分
張三,85,92,78,255
李四,90,88,95,273
王五,76,84,80,240
趙六,95,96,94,285

import csv

def calculate_average():
    total_score = 0
    count = 0
    
    with open('grades.csv', 'r', encoding='utf-8') as file:
        # 創(chuàng)建 reader 對象
        reader = csv.reader(file)
        
        # 跳過第一行（標(biāo)題行）
        header = next(reader)
        print(f"表頭: {header}")
        
        # 遍歷剩余行
        for row in reader:
            name = row[0]
            scores = [float(x) for x in row[1:-1]]  # 數(shù)學(xué)、英語、物理
            total = float(row[-1])  # 總分
            
            avg = sum(scores) / len(scores)
            total_score += total
            count += 1
            
            print(f"{name}: 平均分={avg:.2f}, 總分={total}")
    
    if count > 0:
        overall_avg = total_score / count
        print(f"\n?? 全體學(xué)生平均總分: {overall_avg:.2f}")

calculate_average()

ID;Name;Age;City
1;Alice;25;Berlin
2;Bob;30;Munich
3;Charlie;28;Hamburg

import csv

with open('data_semicolon.csv', 'r', encoding='utf-8') as file:
    # 指定分隔符為分號
    reader = csv.reader(file, delimiter=';')
    
    for row in reader:
        print(row)

ID,Name,Description
1,'John','This is a "test" field'
2,'Jane','She said: "Hello!"'

reader = csv.reader(file, delimiter=',', quotechar="'")

import csv
import requests
from io import StringIO

# 從 WHO 官方獲取數(shù)據(jù)（示例鏈接，實際可用）
url = "https://covid.ourworldindata.org/data/owid-covid-data.csv"

try:
    response = requests.get(url)
    response.raise_for_status()  # 檢查請求是否成功
    
    # 將響應(yīng)內(nèi)容轉(zhuǎn)為字符串流
    data_stream = StringIO(response.text)
    
    # 用 csv.reader 讀取
    reader = csv.reader(data_stream)
    
    # 獲取表頭
    headers = next(reader)
    print("?? 數(shù)據(jù)字段:", headers)
    
    # 查找特定國家的數(shù)據(jù)
    country_name = "China"
    found = False
    
    for row in reader:
        if row[2] == country_name:  # 假設(shè)第3列為國家名
            date = row[3]  # 日期
            new_cases = row[7]  # 新增病例數(shù)
            print(f"?? {date} - {country_name} 新增病例: {new_cases}")
            found = True
            break
    
    if not found:
        print(f"? 未找到 {country_name} 的數(shù)據(jù)")

except Exception as e:
    print(f"?? 讀取失敗: {e}")

import csv

def read_csv_to_dicts(filename):
    data = []
    with open(filename, 'r', encoding='utf-8') as file:
        reader = csv.reader(file)
        headers = next(reader)  # 第一行作為鍵
        
        for row in reader:
            record = {}
            for i, value in enumerate(row):
                record[headers[i]] = value
            data.append(record)
    return data

# 使用
students = read_csv_to_dicts('grades.csv')

for student in students:
    print(f"{student['姓名']} - 數(shù)學(xué): {student['數(shù)學(xué)']}")

with open('data.csv', 'r', encoding='utf-8') as file:
    reader = csv.reader(file)

姓名,數(shù)學(xué),英語
張三,85,92
李四,90,88

for row in reader:
    if not row:  # 跳過空行
        continue
    print(row)

scores = [float(x) for x in row[1:-1]]

def safe_float(value, default=0.0):
    try:
        return float(value) if value.strip() else default
    except (ValueError, TypeError):
        return default

# 使用
scores = [safe_float(x) for x in row[1:-1]]

import csv

with open('grades.csv', 'r', encoding='utf-8') as file:
    reader = csv.DictReader(file)
    for row in reader:
        print(f"{row['姓名']} 的數(shù)學(xué)成績是 {row['數(shù)學(xué)']}")

import csv
from typing import List, Dict, Any

def safe_read_csv(filename: str, expected_cols: int = None, skip_empty: bool = True) -> List[Dict[str, Any]]:
    """
    安全讀取CSV文件，返回字典列表
    :param filename: 文件路徑
    :param expected_cols: 期望列數(shù)，用于校驗
    :param skip_empty: 是否跳過空行
    :return: 數(shù)據(jù)列表
    """
    data = []
    try:
        with open(filename, 'r', encoding='utf-8') as file:
            reader = csv.reader(file)
            headers = next(reader)
            
            if expected_cols and len(headers) != expected_cols:
                raise ValueError(f"列數(shù)不符！期望 {expected_cols}，實際 {len(headers)}")
            
            for line_num, row in enumerate(reader, start=2):
                if skip_empty and not row:
                    continue
                
                if expected_cols and len(row) != expected_cols:
                    print(f"?? 第 {line_num} 行列數(shù)不符，跳過")
                    continue
                
                record = dict(zip(headers, row))
                data.append(record)
                
    except FileNotFoundError:
        print(f"? 文件不存在: {filename}")
    except Exception as e:
        print(f"? 讀取失敗: {e}")
    
    return data

# 使用
records = safe_read_csv('grades.csv', expected_cols=5)
for r in records:
    print(r)