{"id":5356,"date":"2022-04-02T20:31:33","date_gmt":"2022-04-02T12:31:33","guid":{"rendered":"https:\/\/egonlin.com\/?p=5356"},"modified":"2022-04-02T20:31:33","modified_gmt":"2022-04-02T12:31:33","slug":"07-04-%e4%ba%8c%e7%bb%b4%e6%95%b0%e6%8d%ae%e7%9a%84%e6%a0%bc%e5%bc%8f%e5%8c%96%e5%92%8c%e5%a4%84%e7%90%86","status":"publish","type":"post","link":"https:\/\/egonlin.com\/?p=5356","title":{"rendered":"07-04 \u4e8c\u7ef4\u6570\u636e\u7684\u683c\u5f0f\u5316\u548c\u5904\u7406"},"content":{"rendered":"<h1>\u4e00\u3001\u6982\u8ff0<\/h1>\n<ul>\n<li>\u4e8c\u7ef4\u6570\u636e\u7684\u8868\u793a<\/li>\n<li>CSV\u6570\u636e\u5b58\u50a8\u683c\u5f0f<\/li>\n<li>\u4e8c\u7ef4\u6570\u636e\u7684\u5b58\u50a8<\/li>\n<li>\u4e8c\u7ef4\u6570\u636e\u7684\u5904\u7406<\/li>\n<\/ul>\n<h1>\u4e8c\u3001\u4e8c\u7ef4\u6570\u636e\u7684\u8868\u793a<\/h1>\n<h2>2.1 \u4f7f\u7528\u5217\u8868\u7c7b\u578b<\/h2>\n<ul>\n<li>\u5217\u8868\u7c7b\u578b\u53ef\u4ee5\u8868\u8fbe\u4e8c\u7ef4\u6570\u636e<\/li>\n<li>\u4f7f\u7528\u4e8c\u7ef4\u5217\u8868<\/li>\n<\/ul>\n<pre><code class=\"language-python\">[[3.1398, 3.1349, 3.1376], [3.1413, 3.1404, 3.1401]]<\/code><\/pre>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/\u4e8c\u7ef4\u6570\u636e\u7684\u683c\u5f0f\u5316\u548c\u5904\u7406-1.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/\u4e8c\u7ef4\u6570\u636e\u7684\u683c\u5f0f\u5316\u548c\u5904\u7406-1.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<ul>\n<li>\u4f7f\u7528\u4e24\u5c42for\u5faa\u73af\u904d\u5386\u6bcf\u4e2a\u5143\u7d20<\/li>\n<li>\u5916\u5c42\u5217\u8868\u4e2d\u6bcf\u4e2a\u5143\u7d20\u53ef\u4ee5\u5bf9\u5e94\u4e00\u884c\uff0c\u4e5f\u53ef\u4ee5\u5bf9\u5e94\u4e00\u5217<\/li>\n<\/ul>\n<h2>2.2 \u4e00\u4e8c\u7ef4\u6570\u636e\u7684Python\u8868\u793a<\/h2>\n<p>\u6570\u636e\u7ef4\u5ea6\u662f\u6570\u636e\u7684\u7ec4\u7ec7\u5f62\u5f0f<\/p>\n<ul>\n<li>\u4e00\u7ef4\u6570\u636e\uff1a\u5217\u8868\u548c\u96c6\u5408\u7c7b\u578b<\/li>\n<\/ul>\n<pre><code class=\"language-python\">[3.1398, 3.1349, 3.1376]  \u6570\u636e\u95f4\u6709\u5e8f\n{3.1398, 3.1349, 3.1376}  \u6570\u636e\u95f4\u65e0\u5e8f<\/code><\/pre>\n<ul>\n<li>\u4e8c\u7ef4\u6570\u636e\uff1a\u5217\u8868\u7c7b\u578b<\/li>\n<\/ul>\n<pre><code class=\"language-python\">[[3.1398, 3.1349, 3.1376], [3.1413, 3.1404, 3.1401]]<\/code><\/pre>\n<h1>\u4e09\u3001CSV\u683c\u5f0f\u4e0e\u4e8c\u7ef4\u6570\u636e\u5b58\u50a8<\/h1>\n<h2>3.1 CSV\u6570\u636e\u5b58\u50a8\u683c\u5f0f<\/h2>\n<p>CSV: Comma-Separated Values<\/p>\n<ul>\n<li>\u56fd\u9645\u901a\u7528\u7684\u4e00\u4e8c\u7ef4\u6570\u636e\u5b58\u50a8\u683c\u5f0f\uff0c\u4e00\u822c.csv\u6269\u5c55\u540d<\/li>\n<li>\u6bcf\u884c\u4e00\u4e2a\u4e00\u7ef4\u6570\u636e\uff0c\u91c7\u7528\u9017\u53f7\u5206\u9694\uff0c\u65e0\u7a7a\u884c<\/li>\n<li>Excel\u8f6f\u4ef6\u53ef\u8bfb\u5165\u8f93\u51fa\uff0c\u4e00\u822c\u7f16\u8f91\u8f6f\u4ef6\u90fd\u53ef\u4ee5\u4ea7\u751f<\/li>\n<\/ul>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/\u4e8c\u7ef4\u6570\u636e\u7684\u683c\u5f0f\u5316\u548c\u5904\u7406-2.png'><img class=\"lazyload lazyload-style-2\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  data-original=\"https:\/\/egonlin.com\/wp-content\/uploads\/2022\/04\/\u4e8c\u7ef4\u6570\u636e\u7684\u683c\u5f0f\u5316\u548c\u5904\u7406-2.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<ul>\n<li>\u5982\u679c\u67d0\u4e2a\u5143\u7d20\u7f3a\u5931\uff0c\u9017\u53f7\u4ecd\u8981\u4fdd\u7559<\/li>\n<li>\u4e8c\u7ef4\u6570\u636e\u7684\u8868\u5934\u53ef\u4ee5\u4f5c\u4e3a\u6570\u636e\u5b58\u50a8\uff0c\u4e5f\u53ef\u4ee5\u53e6\u884c\u5b58\u50a8<\/li>\n<li>\u9017\u53f7\u4e3a\u82f1\u6587\u534a\u89d2\u9017\u53f7\uff0c\u9017\u53f7\u4e0e\u6570\u636e\u4e4b\u95f4\u65e0\u989d\u5916\u7a7a\u683c<\/li>\n<\/ul>\n<h2>3.2 \u4e8c\u7ef4\u6570\u636e\u7684\u5b58\u50a8<\/h2>\n<p>\u6309\u884c\u5b58\uff1f\u6309\u5217\u5b58\uff1f<\/p>\n<ul>\n<li>\u6309\u884c\u5b58\u6216\u8005\u6309\u5217\u5b58\u90fd\u53ef\u4ee5\uff0c\u5177\u4f53\u7531\u7a0b\u5e8f\u51b3\u5b9a<\/li>\n<li>\u4e00\u822c\u7d22\u5f15\u4e60\u60ef\uff1a<code>ls[row][column]<\/code>\uff0c\u5148\u884c\u540e\u5217<\/li>\n<li>\u6839\u636e\u4e00\u822c\u4e60\u60ef\uff0c\u5916\u5c42\u5217\u8868\u6bcf\u4e2a\u5143\u7d20\u662f\u4e00\u884c\uff0c\u6309\u884c\u5b58<\/li>\n<\/ul>\n<h1>\u56db\u3001\u4e8c\u7ef4\u6570\u636e\u7684\u5904\u7406<\/h1>\n<h2>4.1 \u4e8c\u7ef4\u6570\u636e\u7684\u8bfb\u5165\u5904\u7406<\/h2>\n<p>\u4eceCSV\u683c\u5f0f\u7684\u6587\u4ef6\u4e2d\u8bfb\u5165\u6570\u636e<\/p>\n<pre><code class=\"language-python\">fo = open(fname)\nls = []\nfor line in fo:\nline = line.replace(&quot;\\n&quot;,&quot;&quot;)\nls.append(line.split(&quot;,&quot;))\nfo.close()<\/code><\/pre>\n<h2>\u4e8c\u7ef4\u6570\u636e\u7684\u5199\u5165\u5904\u7406<\/h2>\n<p>\u5c06\u6570\u636e\u5199\u5165CSV\u683c\u5f0f\u7684\u6587\u4ef6<\/p>\n<pre><code class=\"language-python\">ls = [[], [], []] # \u4e8c\u7ef4\u5217\u8868\nf = open(fname, &#039;w&#039;)\nfor item in ls:\n    f.write(&#039;,&#039;.join(item) + &#039;\\n&#039;)\nf.close()<\/code><\/pre>\n<h2>\u4e8c\u7ef4\u6570\u636e\u7684\u9010\u4e00\u5904\u7406<\/h2>\n<p>\u91c7\u7528\u4e8c\u5c42\u5faa\u73af<\/p>\n<pre><code class=\"language-python\">ls = [[], [], []] # \u4e8c\u7ef4\u5217\u8868\nfor row in ls:\n    for column in row:\n        print(ls[row][column])<\/code><\/pre>\n<h1>\u5355\u5143\u5c0f\u7ed3<\/h1>\n<h2>\u4e8c\u7ef4\u6570\u636e\u7684\u683c\u5f0f\u5316\u548c\u5904\u7406<\/h2>\n<ul>\n<li>\u4e8c\u7ef4\u6570\u636e\u7684\u8868\u793a\uff1a\u5217\u8868\u7c7b\u578b\uff0c\u5176\u4e2d\u6bcf\u4e2a\u5143\u7d20\u4e5f\u662f\u4e00\u4e2a\u5217\u8868<\/li>\n<li>CSV\u683c\u5f0f\uff1a\u9017\u53f7\u5206\u9694\u8868\u793a\u4e00\u7ef4\uff0c\u6309\u884c\u5206\u9694\u8868\u793a\u4e8c\u7ef4<\/li>\n<li>\u4e8c\u7ef4\u6570\u636e\u7684\u5904\u7406\uff1afor\u5faa\u73af+.split()\u548c.join()<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u6982\u8ff0 \u4e8c\u7ef4\u6570\u636e\u7684\u8868\u793a CSV\u6570\u636e\u5b58\u50a8\u683c\u5f0f \u4e8c\u7ef4\u6570\u636e\u7684\u5b58\u50a8 \u4e8c\u7ef4\u6570\u636e\u7684\u5904\u7406 \u4e8c\u3001\u4e8c\u7ef4\u6570\u636e\u7684\u8868\u793a 2.1 \u4f7f\u7528 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":5358,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[371,384],"tags":[],"_links":{"self":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/5356"}],"collection":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5356"}],"version-history":[{"count":0,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/posts\/5356\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=\/wp\/v2\/media\/5358"}],"wp:attachment":[{"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/egonlin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}