概述
<div class="cnblogs_code">
内容给大家分享一下...#'''CSV(Comma Separated Values),从字面上面理解为:逗号分隔值 举个例子,如:test_csv = 'one,two,three,4,5' 对于test_csv这个变量来说,他里面就存放着这样的值:逗号分隔的值。这样的形式 在导入和导出中非常常见,如python(version:3.3.2)的API中所描述的一样:The so-called <a href="http://docs.python.org/3/library/csv.html"><span style="color: #ff0000;"><strong>CSV</strong></span></a>(Comma Separated Values) format is the most common import and export for spreadsheets and databases. csv模块定义了以下<a href="https://www.jb51.cc/tag/hanshu/" target="_blank" class="keywords">函数</a>: csv.reader(csvfile,dialect = 'excel',**fmtparams) Retuen a reader object which will iterate over lines in the given csvfile. A short usage example: import csv with open('eggs.csv',newline = '') as cf: spamreader = csv.reader(cf,delimiter = ' ',quotechar = '|') for row in spamreader: print(','.join(row)) csv.write(csvfile,**fmtparams) Return a writer object reaponsible for converting the user's data into delimited strings on the given file-like object. A short usage example: import csv with open('eggs.csv','w',newline = '') as cf: spamwrite = csv.writer(cf,quotechar = '|',quoting = csv.QUOTE_MINIMAL) spamwriter.writerow(['Spam'] * 5 + ['Baked Beans']) spamwriter.writerow(['Spam','Lovely Spam','Wonderful Spam'])
<span style="color: #800000;">'''
The so-called <a href="http://docs.python.org/3/library/csv.html"><span style="color: #ff0000;"><strong>CSV</strong></span></a>(Comma Separated Values) format is the most
common import and export for spreadsheets and databases.
csv模块定义了以下<a href="https://www.jb51.cc/tag/hanshu/" target="_blank" class="keywords">函数</a>:
csv.reader(csvfile,dialect = 'excel',**fmtparams)
Retuen a reader object which will iterate over lines
in the given csvfile.
A short usage example:
import csv
with open('eggs.csv',newline = '') as cf:
spamreader = csv.reader(cf,delimiter = ' ',quotechar = '|')
for row in spamreader:
print(','.join(row))
csv.write(csvfile,**fmtparams)
Return a writer object reaponsible for converting the
user's data into delimited strings on the given file-like
object.
A short usage example:
import csv
with open('eggs.csv','w',newline = '') as cf:
spamwrite = csv.writer(cf,quotechar = '|',quoting = csv.QUOTE_MINIMAL)
spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
spamwriter.writerow(['Spam','Lovely Spam','Wonderful Spam'])
<span style="color: #800000;">'''
The so-called <a href="http://docs.python.org/3/library/csv.html"><span style="color: #ff0000;"><strong>CSV</strong></span></a>(Comma Separated Values) format is the most
common import and export for spreadsheets and databases.
csv模块定义了以下<a href="https://www.jb51.cc/tag/hanshu/" target="_blank" class="keywords">函数</a>:
csv.reader(csvfile,dialect = 'excel',**fmtparams)
Retuen a reader object which will iterate over lines
in the given csvfile.
A short usage example:
import csv
with open('eggs.csv',newline = '') as cf:
spamreader = csv.reader(cf,delimiter = ' ',quotechar = '|')
for row in spamreader:
print(','.join(row))
csv.write(csvfile,**fmtparams)
Return a writer object reaponsible for converting the
user's data into delimited strings on the given file-like
object.
A short usage example:
import csv
with open('eggs.csv','w',newline = '') as cf:
spamwrite = csv.writer(cf,quotechar = '|',quoting = csv.QUOTE_MINIMAL)
spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
spamwriter.writerow(['Spam','Lovely Spam','Wonderful Spam'])
<span style="color: #800000;">'''
一下是我做的demo:
效果:
目录下面的情况:
代码部分:
如果您也喜欢它,动动您的小指点个赞吧