CSV-Dateien

def load_scores(path: str) -> dict[str, int]:
    totals: dict[str, int] = {}
    with open(path, encoding="utf-8") as f:
        next(f)  # skip the header
        for line in f:
            name, points = line.strip().split(",")
            totals[name] = totals.get(name, 0) + int(points)
    return totals


if __name__ == "__main__":
    print(load_scores("scores.csv"))

from main import load_scores


def write(path, text):
    with open(path, "w", newline="", encoding="utf-8") as f:
        f.write(text)


def test_given_file():
    """Die gegebene Datei ergibt 7 Punkte für Ada und 5 für Grace"""
    got = load_scores("scores.csv")
    assert got == {"Lovelace, Ada": 7, "Hopper, Grace": 5}, f"load_scores lieferte {got!r}"


def test_other_column_order():
    """Spalten in anderer Reihenfolge werden über den Namen gelesen"""
    write("t_order.csv", "points,name\n2,Bo\n3,Bo\n")
    got = load_scores("t_order.csv")
    assert got == {"Bo": 5}, f"bei points,name lieferte die Funktion {got!r}"


def test_header_only():
    """Eine Datei nur mit Kopfzeile ergibt {}"""
    write("t_empty.csv", "name,points\n")
    got = load_scores("t_empty.csv")
    assert got == {}, f"bei einer Datei nur mit Kopfzeile lieferte die Funktion {got!r}"

name,points
"Lovelace, Ada",3
"Hopper, Grace",5
"Lovelace, Ada",4

def export_semicolon(src: str, dst: str) -> int:
    with open(src, encoding="utf-8") as f:
        text = f.read()
    with open(dst, "w", encoding="utf-8") as f:
        f.write(text.replace(",", ";"))
    return 0


if __name__ == "__main__":
    with open("people.csv", "w", newline="", encoding="utf-8") as f:
        f.write('name,city\nAda,"Berlin; Mitte"\n')
    print(export_semicolon("people.csv", "people_de.csv"))

import csv

from main import export_semicolon

SOURCE = 'name,city\nAda,"Berlin; Mitte"\nBo,"Köln, Süd"\n'


def export(text):
    with open("t_src.csv", "w", newline="", encoding="utf-8") as f:
        f.write(text)
    count = export_semicolon("t_src.csv", "t_dst.csv")
    with open("t_dst.csv", newline="", encoding="utf-8") as f:
        return count, f.read()


def test_count():
    """Zwei Datenzeilen ergeben 2"""
    count, text = export(SOURCE)
    assert count == 2, f"export_semicolon lieferte {count!r}, erwartet war 2"


def test_round_trip():
    """Mit delimiter=';' zurückgelesen, sind die Zeilen unverändert"""
    count, text = export(SOURCE)
    with open("t_dst.csv", newline="", encoding="utf-8") as f:
        rows = list(csv.reader(f, delimiter=";"))
    want = [["name", "city"], ["Ada", "Berlin; Mitte"], ["Bo", "Köln, Süd"]]
    assert rows == want, f"die neue Datei mit delimiter=';' gelesen ergab {rows!r}"


def test_file_text():
    """Die Datei nutzt ; und \\r\\n und fasst nur das Feld mit ; ein"""
    count, text = export(SOURCE)
    want = 'name;city\r\nAda;"Berlin; Mitte"\r\nBo;Köln, Süd\r\n'
    assert text == want, f"die neue Datei enthält {text!r}"