{"id":3448,"date":"2024-02-06T02:59:05","date_gmt":"2024-02-05T17:59:05","guid":{"rendered":"https:\/\/www.dogrow.net\/python\/?p=3448"},"modified":"2024-02-06T10:36:41","modified_gmt":"2024-02-06T01:36:41","slug":"blog120","status":"publish","type":"post","link":"https:\/\/www.dogrow.net\/python\/blog120\/","title":{"rendered":"(120) Pandas\u3067CSV\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u5909\u66f4\u3057\u3066CSV\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58"},"content":{"rendered":"<h1 class=\"my_h\">\u30101\u3011\u3084\u308a\u305f\u3044\u3053\u3068<\/h1>\n<link rel=\"stylesheet\" href=\"\/_js\/prism\/prism.css\">\n<script src=\"\/_js\/prism\/prism.js\" defer><\/script><\/p>\n<p>\u4ee5\u4e0b\u306e CSV\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u3002<\/p>\n<pre class=\"my_pre\">\r\n\u7530\u4e2d \u4e00\u90ce,1978\/5\/25,\u795e\u5948\u5ddd\u770c\u4f0a\u52e2\u539f\u5e02\u9234\u5ddd2-5\r\n\u52a0\u85e4 \u6df3\u4e5f,1982\/8\/30,\u5fb3\u5cf6\u770c\u9cf4\u9580\u5e02\u64ab\u990a\u753a\u658e\u7530\u5927\u5824\uff11\uff14\r\n\u4f50\u4f2f \u88d5\u4e8c,1990\/4\/12,\u65b0\u6f5f\u770c\u4e0a\u8d8a\u5e02\u571f\u6a4b\uff11\uff19\uff11\uff14\r\n\u4e32\u672c\u3000\u76f4\u6a39,1976\/5\/11,\u5bae\u5d0e\u770c\u5150\u6e6f\u90e1\u90fd\u8fb2\u753a\u4e0b\u6d5c\uff13\u4e01\u76ee\r\n<\/pre>\n<p>\u3053\u308c\u3092\u3001\u4ee5\u4e0b\u306e\u4ed5\u69d8\u3067\u30c7\u30fc\u30bf\u5909\u63db\u3057\u305f\u3044\u3002<br \/>\n1. \u540d\u5b57\u3060\u3051\u306b\u3059\u308b\u3002<br \/>\n2. \u5e74\u3060\u3051\u306b\u3059\u308b\u3002<br \/>\n3. \u756a\u5730\u4ee5\u964d\u3092\u524a\u9664\u3059\u308b\u3002<\/p>\n<p>\u2193 \u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u305f\u3044\u3002<\/p>\n<pre class=\"my_pre\">\r\n\u7530\u4e2d,1978,\u795e\u5948\u5ddd\u770c\u4f0a\u52e2\u539f\u5e02\u9234\u5ddd\r\n\u52a0\u85e4,1982,\u5fb3\u5cf6\u770c\u9cf4\u9580\u5e02\u64ab\u990a\u753a\u658e\u7530\u5927\u5824\r\n\u4f50\u4f2f,1990,\u65b0\u6f5f\u770c\u4e0a\u8d8a\u5e02\u571f\u6a4b\r\n\u4e32\u672c,1976,\u5bae\u5d0e\u770c\u5150\u6e6f\u90e1\u90fd\u8fb2\u753a\u4e0b\u6d5c\r\n<\/pre>\n<h1 class=\"my_h\">\u30102\u3011\u3084\u3063\u3066\u307f\u308b<\/h1>\n<p>\u4e00\u5148\u305a\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3067\u5b9f\u73fe\u3067\u304d\u305f\u3002<\/p>\n<p>\u4e88\u60f3\u5916\u306e\u52d5\u304d\u3092\u3057\u3066\u304f\u308c\u305f\u306e\u304c <span class=\"my_fc_deeppinkB\">re.sub()<\/span> \u306e\u3068\u3053\u308d\u3060\u3002<br \/>\n\u6b63\u898f\u8868\u73fe\u3067 <span class=\"my_fc_deeppinkB\">\\d.*<\/span> \u3064\u307e\u308a\u6570\u5b57\u304c\u51fa\u73fe\u3057\u305f\u5f8c\u3092\u524a\u9664\u3059\u308b\u3088\u3046\u306b\u6307\u5b9a\u3057\u3066\u3044\u308b\u3068\u3053\u308d\u3060\u3002<\/p>\n<p>\u306a\u3093\u3068\uff01<br \/>\n<span class=\"my_fc_deeppinkBBig\">\u534a\u89d2\u6570\u5b57\u3060\u3051\u3067\u306a\u304f\u3001\u5168\u89d2\u6570\u5b57\u3082\u51e6\u7406\u5bfe\u8c61\u306b\u3057\u3066\u304f\u308c\u3066\u3044\u308b\uff01\uff01<\/span><\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\nimport pandas as pd\r\nimport re\r\n\r\n# CSV\u30d5\u30a1\u30a4\u30eb\u3092\u30ed\u30fc\u30c9\r\nfile_path = 'data.csv'\r\ndf = pd.read_csv(file_path, header=None)\r\n\r\n# \u7b2c1\u5217: \u82d7\u5b57\u3092\u62bd\u51fa\r\ndf&#x5B;0] = df&#x5B;0].str.split().str&#x5B;0]\r\n\r\n# \u7b2c2\u5217: \u5e74\u3092\u62bd\u51fa\r\ndf&#x5B;1] = df&#x5B;1].str.split('\/').str&#x5B;0]\r\n\r\n# \u7b2c3\u5217: \u4f4f\u6240\u306e\u756a\u5730\u4ee5\u964d\u3092\u524a\u9664\r\ndf&#x5B;2] = df&#x5B;2].apply(lambda x: re.sub(r'\\d.*', '', x))\r\n\r\n# CSV\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u51fa\u529b\r\noutput_path = 'data_conv.csv'\r\ndf.to_csv(output_path, index=False, header=False, encoding='utf-8')\r\n<\/pre>\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\u3059\u3079\u3066\u3092 df[n].apply \u3067\u66f8\u304f\u3053\u3068\u3082\u3067\u304d\u308b\u3002<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\n# \u7b2c1\u5217: \u82d7\u5b57\u3092\u62bd\u51fa\r\ndf&#x5B;0] = df&#x5B;0].apply(lambda x: x.split()&#x5B;0])\r\n\r\n# \u7b2c2\u5217: \u5e74\u3092\u62bd\u51fa\r\ndf&#x5B;1] = df&#x5B;1].apply(lambda x: x.split('\/')&#x5B;0])\r\n\r\n# \u7b2c3\u5217: \u4f4f\u6240\u306e\u756a\u5730\u4ee5\u964d\u3092\u524a\u9664\r\ndf&#x5B;2] = df&#x5B;2].apply(lambda x: re.sub(r'\\d.*', '', x))\r\n<\/pre>\n<hr class=\"my_hr_bottom\">\n","protected":false},"excerpt":{"rendered":"<p>\u30101\u3011\u3084\u308a\u305f\u3044\u3053\u3068 \u4ee5\u4e0b\u306e CSV\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u3002 \u7530\u4e2d \u4e00\u90ce,1978\/5\/25,\u795e\u5948\u5ddd\u770c\u4f0a\u52e2\u539f\u5e02\u9234\u5ddd2-5 \u52a0\u85e4 \u6df3\u4e5f,1982\/8\/30,\u5fb3\u5cf6\u770c\u9cf4\u9580\u5e02\u64ab\u990a\u753a\u658e\u7530\u5927\u5824\uff11\uff14 \u4f50\u4f2f \u88d5\u4e8c,1990\/4\/12,\u65b0\u6f5f\u770c\u4e0a\u8d8a\u5e02\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.dogrow.net\/python\/blog120\/\">\u7d9a\u304d\u3092\u8aad\u3080 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,42],"tags":[],"class_list":["post-3448","post","type-post","status-publish","format-standard","hentry","category-csv","category-pandas"],"views":642,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/3448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/comments?post=3448"}],"version-history":[{"count":12,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/3448\/revisions"}],"predecessor-version":[{"id":3460,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/3448\/revisions\/3460"}],"wp:attachment":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/media?parent=3448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/categories?post=3448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/tags?post=3448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}