Csv writer meaning of quoting

[mg24]

Hi Team,

in below code I want understand what quoting does.

What is the meaning of these, in which situation others to use it.

csv.QUOTE_NONNUMERIC
csv.QUOTE_ALL
csv.QUOTE_MINIMAL

with open(fullpath, "w", newline="") as outfile:
        writer = csv.writer(outfile, delimiter="|", quoting=csv.QUOTE_NONNUMERIC)

[ibreeden]

From the manual:

csv.QUOTE_ALL

Instructs writer objects to quote all fields.

csv.QUOTE_MINIMAL

Instructs writer objects to only quote those fields which contain special characters such as delimiter, quotechar or any of the characters in lineterminator.

csv.QUOTE_NONNUMERIC

Instructs writer objects to quote all non-numeric fields.

Instructs the reader to convert all non-quoted fields to type float.

csv.QUOTE_NONE

Instructs writer objects to never quote fields. When the current delimiter occurs in output data it is preceded by the current escapechar character. If escapechar is not set, the writer will raise Error if any characters that require escaping are encountered.

Instructs reader to perform no special processing of quote characters.

[Gribouillis]

This pymotw3 issue explains a lot too.