Knowledge baseExam Center
ENEnglish
Choose language13

CKTIS / Python

csv.Dialect

Groups delimiter, quoting and other CSV formatting parameters into a reusable dialect.

Version: Python 3.14; repository image, production runtime not attested

Syntax

class Local(csv.excel):
    delimiter = ';'

Groups delimiter, quoting and other CSV formatting parameters into a reusable dialect.

A delimiter inside a quoted field is literal text when the dialect enables quoting.

Define a reusable CSV format by deriving a dialect, or reuse a registered dialect name. delimiter is one character; quotechar and doublequote govern quoted fields. Local inherits csv.excel and changes only the separator. The semicolon inside quotes remains part of b;c. Per-reader or per-writer keyword parameters override individual dialect settings. Register the dialect using register_dialect(name, dialect), retrieve an immutable object with get_dialect(name) and pass the name to a reader or writer.

import csv
class Local(csv.excel):
    delimiter = ";"
assert next(csv.reader(['a;"b;c"'], dialect=Local)) == ["a", "b;c"]
assert next(csv.reader(["a|b"], dialect=Local, delimiter="|")) == ["a", "b"]
csv.register_dialect("group_local", Local)
try:
    assert next(csv.reader(["a;b"], "group_local")) == ["a", "b"]
    d = csv.get_dialect("group_local")
    try:
        d.delimiter = "|"
    except AttributeError:
        pass
    else:
        raise AssertionError
finally:
    csv.unregister_dialect("group_local")

Examples

import csv
class Local(csv.excel):
    delimiter = ";"

print(issubclass(Local, csv.Dialect))
print(next(csv.reader(['a;"b;c"'], dialect=Local)))

Result

True
['a', 'b;c']

Define a reusable CSV format by deriving a dialect, or reuse a registered dialect name. delimiter is one character; quotechar and doublequote govern quoted fields. Local inherits csv.excel and changes only the separator. The semicolon inside quotes remains part of b;c. Per-reader or per-writer keyword parameters override individual dialect settings. Register the dialect using register_dialect(name, dialect), retrieve an immutable object with get_dialect(name) and pass the name to a reader or writer.

Sources