您好, 欢迎来到 !    登录 | 注册 | | 设为首页 | 收藏本站

python开发_csv(Comma Separated Values)_逗号分隔值_常用导入导出格式_完整版_博主推荐

5b51 2022/1/14 8:24:19 python 字数 5535 阅读 598 来源 www.jb51.cc/python

python开发_csv(Comma Separated Values)_逗号分隔值_常用导入导出格式_完整版_博主推荐

概述

<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"&gt;<span style="color: #ff0000;"&gt;<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"&gt;<span style="color: #ff0000;"&gt;<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"&gt;<span style="color: #ff0000;"&gt;<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:

效果:

目录下面的情况:

代码部分:


如果您也喜欢它,动动您的小指点个赞吧

除非注明,文章均由 laddyq.com 整理发布,欢迎转载。

转载请注明:
链接:http://laddyq.com
来源:laddyq.com
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。


联系我
置顶