- 1.csv模块介绍
我们使用import语句导入csv模块,然后用dir()函数看看它里面有什么东西:
import csv
# dir()函数会得到一个列表,用for循环一行行打印列表比较直观
for i in dir(csv):
print(i)
结果显示:
bash:162$ python ~/classroom/apps-1-id-5cd9766619bbcf00015547c7/162/main.py
Dialect
DictReader
DictWriter
Error
OrderedDict
QUOTE_ALL
QUOTE_MINIMAL
QUOTE_NONE
QUOTE_NONNUMERIC
Sniffer
StringIO
_Dialect
__all__
__builtins__
__cached__
__doc__
__file__
__loader__
__name__
__package__
__spec__
__version__
excel
excel_tab
field_size_limit
get_dialect
list_dialects
re
reader
register_dialect
unix_dialect
unregister_dialect
writer
csv模块的官方英文教程:
https://docs.python.org/3.6/library/csv.html
中文教程:https://yiyibooks.cn/xx/python_352/library/csv.html#module-csv
- 2.读取csv文件
例子:
import csv
with open('test.csv', newline = '', encoding = 'utf-8') as f:
reader = csv.reader(f)
#使用csv的reader()方法,创建一个reader对象
for row in reader:
#遍历reader对象的每一行
print(row)
print("读取完毕!")
#参数encoding = 'utf-8'防止出现乱码
输出结果为:
bash:177$ python ~/classroom/apps-1-id-5cd9766619bbcf00y['商品编号', '商品名称', '单价', '库存', '销量']
['1', '猫零食', '12', '3133', '5164']
['2', '普通猫粮', '33', '5055', '2231']
['3', '猫粮四合一', '187', '212', '334']
读取完毕!
- 3.如何往csv格式文件写入数据
import csv
with open('test.csv','a', newline='',encoding='utf-8') as f:
writer = csv.writer(f)
writer.writerow(['4', '猫砂', '25', '1022', '886'])
writer.writerow(['5', '猫罐头', '18', '2234', '3121'])