Breaking News: Grepper is joining You.com. Read the official announcement!

Exemplos de leitura de arquivos csv em python

pupygreen answered on May 30, 2023 Popularity 1/10 Helpfulness 1/10

answer Exemplos de leitura de arquivos csv em python

Exemplos de leitura de arquivos csv em python

Comment

import csv

# 1
The simplest example of reading a CSV file:

with open('some.csv', newline='') as f:
    reader = csv.reader(f)
    for row in reader:
        print(row)
        
# 2
Reading a file with an alternate format:

import csv
with open('passwd', newline='') as f:
    reader = csv.reader(f, delimiter=':', quoting=csv.QUOTE_NONE)
    for row in reader:
        print(row)
        
# 3
The corresponding simplest possible writing example is:

import csv
with open('some.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerows(someiterable)
    
# 4
Since open() is used to open a CSV file for reading, the file will by default be decoded into unicode using the system default encoding (see locale.getencoding()). To decode a file using a different encoding, use the encoding argument of open:

import csv
with open('some.csv', newline='', encoding='utf-8') as f:
    reader = csv.reader(f)
    for row in reader:
        print(row)
        
# 5
The same applies to writing in something other than the system default encoding: specify the encoding argument when opening the output file.

Registering a new dialect:

import csv
csv.register_dialect('unixpwd', delimiter=':', quoting=csv.QUOTE_NONE)
with open('passwd', newline='') as f:
    reader = csv.reader(f, 'unixpwd')
    
# 6
A slightly more advanced use of the reader — catching and reporting errors:

import csv, sys
filename = 'some.csv'
with open(filename, newline='') as f:
    reader = csv.reader(f)
    try:
        for row in reader:
            print(row)
    except csv.Error as e:
        sys.exit('file {}, line {}: {}'.format(filename, reader.line_num, e))
        
# 7
And while the module doesn’t directly support parsing strings, it can easily be done:

import csv
for row in csv.reader(['one,two,three']):
    print(row)

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: docs.python.org

Tags: csv python whatever

Link to this answer
Share Copy Link

Contributed on May 30 2023

pupygreen

0 Answers Avg Quality 2/10

Exemplos de leitura de arquivos csv em python

Contents

More Related Answers

Exemplos de leitura de arquivos csv em python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.