python csv模組,pythoncsv

來源:互聯網
上載者:User

python csv模組,pythoncsv

  1 import csv  # Comma Separated Value  2   3 # class Dialect  4 #     delimiter = None           # 分隔字元  5 #     doublequote = None         # 元素是引用符,雙倍的引用符。預設是true,如果改為false就需要設定分隔字元,否則報錯。  6 #     escapechar = None          # 轉義符  7 #     lineterminator = None      # 行終止符  8 #     quotechar = None           # 引用符  9 #     quoting = None             # 引用方式 10 #     skipinitialspace = None    # 忽略分割後面的空格,預設是flase 11 # 12 # 13 # QUOTE_ALL = 1         # 全加引號 14 # QUOTE_MINIMAL = 0     # 分隔字元和引用符號加雙引號 15 # QUOTE_NONE = 3        # 全部不加雙引號,分隔字元要加轉義符 16 # QUOTE_NONNUMERIC = 2  # 數字不加引號 17 # 18 # csv.QUOTE_MINIMAL means only when required, for example, when a field contains either the quotechar or the delimiter 19 # csv.QUOTE_ALL means that quotes are always placed around fields. 20 # csv.QUOTE_NONNUMERIC means that quotes are always placed around fields which do not parse as integers or floating point numbers. 21 # csv.QUOTE_NONE means that quotes are never placed around fields. 22  23  24 # 1、寫一個csv檔案  quoting=csv.QUOTE_ALL 25 with open("1.csv", "w", newline="") as f: 26     # dialect為開啟csv檔案的方式,預設是excel,delimiter="\t"參數指寫入的時候的分隔字元 27     # csv_writer = csv.writer(f, dialect="excel-tab") 28     # csv_writer = csv.writer(f, dialect="excel", delimiter="\t") 29     csv_writer = csv.writer(f, dialect="excel", quoting=csv.QUOTE_ALL) 30     # csv檔案插入一行資料,把下面列表中的每一項放入一個儲存格(可以用迴圈插入多行) 31     csv_writer.writerow(["A", "B", ",", 5]) 32     csv_writer.writerow(["E", "F", '"', 6]) 33  34 with open("1.csv", "rb") as f: 35     print(f.read()) 36     # b'"A","B",",","5"\r\n"E","F","""","6"\r\n' 37  38 with open("1.csv", "r") as f: 39     print(f.read()) 40     # "A","B",",","5" 41     # "E 42  43 # 2、寫一個csv檔案  quoting=csv.QUOTE_MINIMAL 44 with open("2.csv", "w", newline="") as f: 45     # dialect為開啟csv檔案的方式,預設是excel,delimiter="\t"參數指寫入的時候的分隔字元 46     # csv_writer = csv.writer(f, dialect="excel-tab") 47     # csv_writer = csv.writer(f, dialect="excel", delimiter="\t") 48     csv_writer = csv.writer(f, dialect="excel", quoting=csv.QUOTE_MINIMAL) 49     # csv檔案插入一行資料,把下面列表中的每一項放入一個儲存格(可以用迴圈插入多行) 50     csv_writer.writerow(["A", "B", ",", 5]) 51     csv_writer.writerow(["E", "F", '"', 6]) 52  53 with open("2.csv", "rb") as f: 54     print(f.read()) 55     # b'A,B,",",5\r\nE,F,"""",6\r\n' 56  57 with open("2.csv", "r") as f: 58     print(f.read()) 59     # A,B,",",5 60     # E,F,"""",6 61  62  63 # 3、寫一個csv檔案  quoting=csv.QUOTE_NONE 64 with open("3.csv", "w", newline="") as f: 65     # dialect為開啟csv檔案的方式,預設是excel,delimiter="\t"參數指寫入的時候的分隔字元 66     # csv_writer = csv.writer(f, dialect="excel-tab") 67     # csv_writer = csv.writer(f, dialect="excel", delimiter="\t") 68     csv_writer = csv.writer(f, dialect="excel", quoting=csv.QUOTE_NONE, escapechar='\\')  # 這種方式需要設定轉義符 69     # csv檔案插入一行資料,把下面列表中的每一項放入一個儲存格(可以用迴圈插入多行) 70     csv_writer.writerow(["A", "B", ",", 5]) 71     csv_writer.writerow(["E", "F", '"', 6]) 72  73 with open("3.csv", "rb") as f: 74     print(f.read()) 75     # b'A,B,\\,,5\r\nE,F,\\",6\r\n' 76  77 with open("3.csv", "r") as f: 78     print(f.read()) 79     # A,B,\,,5 80     # E,F,\",6 81  82  83 # 4、寫一個csv檔案  quoting=csv.QUOTE_NONNUMERIC 84 with open("4.csv", "w", newline="") as f: 85     # dialect為開啟csv檔案的方式,預設是excel,delimiter="\t"參數指寫入的時候的分隔字元 86     # csv_writer = csv.writer(f, dialect="excel-tab") 87     # csv_writer = csv.writer(f, dialect="excel", delimiter="\t") 88     csv_writer = csv.writer(f, dialect="excel", quoting=csv.QUOTE_NONNUMERIC) 89     # csv檔案插入一行資料,把下面列表中的每一項放入一個儲存格(可以用迴圈插入多行) 90     csv_writer.writerow(["A", "B", ",", 5]) 91     csv_writer.writerow(["E", "F", '"', 6]) 92  93 with open("4.csv", "rb") as f: 94     print(f.read()) 95     # b'"A","B",",",5\r\n"E","F","""",6\r\n' 96  97 with open("4.csv", "r") as f: 98     print(f.read()) 99     # "A","B",",",5100     # "E","F","""",6101 102 103 # 5、寫一個csv檔案  quoting=預設 (quoting=csv.QUOTE_MINIMAL)104 with open("5.csv", "w", newline="") as f:105     # dialect為開啟csv檔案的方式,預設是excel,delimiter="\t"參數指寫入的時候的分隔字元106     # csv_writer = csv.writer(f, dialect="excel-tab")107     # csv_writer = csv.writer(f, dialect="excel", delimiter="\t")108     csv_writer = csv.writer(f, dialect="excel")109     # csv檔案插入一行資料,把下面列表中的每一項放入一個儲存格(可以用迴圈插入多行)110     csv_writer.writerow(["A", "B", ",", 5])111     csv_writer.writerow(["E", "F", '"', 6])112 113 with open("5.csv", "rb") as f:114     print(f.read())115     # b'A,B,",",5\r\nE,F,"""",6\r\n'116 117 with open("5.csv", "r") as f:118     print(f.read())119     # A,B,",",5120     # E,F,"""",6121 122 123 # 6、寫一個csv檔案124 with open("6.csv", "w", newline="") as f:125     # dialect為開啟csv檔案的方式,預設是excel,delimiter="\t"參數指寫入的時候的分隔字元126     # csv_writer = csv.writer(f, dialect="excel-tab")127     # csv_writer = csv.writer(f, dialect="excel", delimiter="\t")128     csv_writer = csv.writer(f)129     # csv檔案插入一行資料,把下面列表中的每一項放入一個儲存格(可以用迴圈插入多行)130     csv_writer.writerow(["A", "B", ",", 5])131     csv_writer.writerow(["E", "F", '"', 6])132 133 with open("6.csv", "rb") as f:134     print(f.read())135     # b'A,B,",",5\r\nE,F,"""",6\r\n'136 137 with open("6.csv", "r") as f:138     print(f.read())139     # A,B,",",5140     # E,F,"""",6141 142 143 # 7、註冊風格144 csv.register_dialect('mystyle', delimiter=',', quoting=csv.QUOTE_MINIMAL)145 with open("7.csv", "w", newline="") as f:146     # dialect為開啟csv檔案的方式,預設是excel,delimiter="\t"參數指寫入的時候的分隔字元147     # csv_writer = csv.writer(f, dialect="excel-tab")148     # csv_writer = csv.writer(f, dialect="excel", delimiter="\t")149     csv_writer = csv.writer(f, dialect="mystyle")150     # csv檔案插入一行資料,把下面列表中的每一項放入一個儲存格(可以用迴圈插入多行)151     csv_writer.writerow(["A", "B", ",", 5])152     csv_writer.writerow(["E", "F", '"""', 6])153 154 with open("7.csv", "rb") as f:155     print(f.read())156     # b'A,B,",",5\r\nE,F,"""""""",6\r\n'157 158 with open("7.csv", "r") as f:159     print(f.read())160     # A,B,",",5161     # E,F,"""""""",6162 163 164 # 8、讀取csv檔案165 csv.register_dialect('mystyle', delimiter=',', quoting=csv.QUOTE_MINIMAL)166 with open('7.csv', newline='') as f:167     reader = csv.reader(f, 'mystyle')168     for r in reader:169         print(r, type(r))170         # ['A', 'B', ',', '5'] <class 'list'>171         # ['E', 'F', '"', '6'] <class 'list'>172 173 174 # 9、讀取csv檔案175 for row in csv.reader(['one, two, three', 'one, two, three'], skipinitialspace=True):  # skipinitialspace忽略空格176     print(row, type(row))177     # ['one', 'two', 'three'] <class 'list'>178     # ['one', 'two', 'three'] <class 'list'>179 180 181 # 10、DictWriter182 with open('8.csv', 'w', newline='') as csv_file:183     fieldnames = ['first_name', 'last_name']184     writer = csv.DictWriter(csv_file, fieldnames=fieldnames)185 186     writer.writeheader()187     writer.writerow({'first_name': 'Baked', 'last_name': 'Beans'})188     writer.writerow({'first_name': 'Lovely', 'last_name': 'Spam'})189     writer.writerow({'first_name': 'Wonderful', 'last_name': 'Spam'})190     writer.writerows([{'first_name': 'Wonderful', 'last_name': 'Spam'}, {'first_name': 'Wonderful', 'last_name': 'Spam'}])191 192 # 11、DictReader193 with open('8.csv', newline='') as csv_file:194     reader = csv.DictReader(csv_file)195     for row in reader:196         print(row)  # OrderedDict([('first_name', 'Baked'), ('last_name', 'Beans')])197         print(row['first_name'], row['last_name'])

 

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.