{"id":5456,"date":"2013-08-14T16:33:52","date_gmt":"2013-08-14T08:33:52","guid":{"rendered":"http:\/\/jpuyy.com\/?p=5456"},"modified":"2016-06-21T18:25:49","modified_gmt":"2016-06-21T10:25:49","slug":"python-csv-reader-and-csv-writer","status":"publish","type":"post","link":"https:\/\/jpuyy.com\/?p=5456","title":{"rendered":"\u6574\u7406python\u7684csv.reader\u548ccsv.writer"},"content":{"rendered":"<p>\u4ee5\u4e0b\u811a\u672c\u662f\u8bfb\u53d6\u4ee5\u7a7a\u683c\u5206\u5f00\u7684\u5b57\u6bb5(weight.txt)\u53d8\u6210\u4ee5\u9017\u53f7\u5206\u9694(weight.csv)<\/p>\n<pre>#!\/usr\/bin\/env python\r\n#-*- coding:utf-8 -*-\r\n# author jpuyy.com\r\nimport csv\r\nreader = csv.reader(open('weight.txt', 'rb'), delimiter=' ', quoting=csv.QUOTE_NONE)\r\nwriter = csv.writer(open('weight.csv', 'wb'))\r\n    for row in reader:\r\n    writer.writerow(row)<\/pre>\n<p>\u89e3\u51b3 csv \u7528 excel \u6253\u5f00\u4e71\u7801\u95ee\u9898<\/p>\n<pre>\r\nimport codecs\r\n\r\nfile_obj = open(csv_name, \"wb+\")\r\nfile_obj.write(codecs.BOM_UTF8)\r\nf = csv.writer(file_obj)\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u811a\u672c\u662f\u8bfb\u53d6\u4ee5\u7a7a\u683c\u5206\u5f00\u7684\u5b57\u6bb5(weight.txt)\u53d8\u6210\u4ee5\u9017\u53f7\u5206\u9694(weight.csv) #!\/usr\/bin\/env python #-*- coding:utf-8 -*- # author jpuyy.com import csv reader = csv.reader(open(&#8216;weight.txt&#8217;, &#8216;rb&#8217;), delimiter=&#8217; &#8216;, quoting=csv.QUOTE_NONE) writer = csv.writer(open(&#8216;weight.csv&#8217;, &#8216;wb&#8217;)) for row in reader: writer.writerow(row) \u89e3\u51b3 csv \u7528 excel \u6253\u5f00\u4e71\u7801\u95ee\u9898 import codecs file_obj = open(csv_name, &#8220;wb+&#8221;) file_obj.write(codecs.BOM_UTF8) f = csv.writer(file_obj)<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,76],"tags":[],"class_list":["post-5456","post","type-post","status-publish","format-standard","hentry","category-life","category-python"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/5456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5456"}],"version-history":[{"count":4,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/5456\/revisions"}],"predecessor-version":[{"id":7804,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/5456\/revisions\/7804"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}