{"id":1901,"date":"2023-06-09T10:17:41","date_gmt":"2023-06-09T01:17:41","guid":{"rendered":"https:\/\/www.kwonline.org\/memo2\/?p=1901"},"modified":"2023-06-09T10:17:41","modified_gmt":"2023-06-09T01:17:41","slug":"remove-csv-newlines-with-python3","status":"publish","type":"post","link":"https:\/\/www.kwonline.org\/memo2\/2023\/06\/09\/remove-csv-newlines-with-python3\/","title":{"rendered":"Python \u3067 CSV \u30bb\u30eb\u5185\u306e\u6539\u884c\u3092\u9664\u53bb"},"content":{"rendered":"<p>&nbsp;<br \/>\nCSV \u306e\u4e2d\u306b\u6539\u884c\u3092\u542b\u3080\u30bb\u30eb\u304c\u3042\u3063\u3066\u305d\u308c\u3092\u9664\u53bb\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002<br \/>\n\u6539\u884c\u3092\u542b\u3080\u30bb\u30eb\u306f\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u3067\u56f2\u307e\u308c\u3066\u3044\u308b\u3002<\/p>\n<p>Python3 \u3067\u3053\u3046\u3059\u308c\u3070 OK.<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\nimport pandas as pd\r\nimport csv\r\n\r\ncsv.register_dialect('mycsv', delimiter=',', quoting=csv.QUOTE_ALL, doublequote=True)\r\ndf = pd.read_csv('input.csv', dialect='mycsv')\r\ndf.replace('\\n',' ', regex=True).to_csv('output.csv')\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; CSV \u306e\u4e2d\u306b\u6539\u884c\u3092\u542b\u3080\u30bb\u30eb\u304c\u3042\u3063\u3066\u305d\u308c\u3092\u9664\u53bb\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002 \u6539\u884c\u3092\u542b\u3080\u30bb\u30eb\u306f\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u3067\u56f2\u307e\u308c\u3066\u3044\u308b\u3002 Python3 \u3067\u3053\u3046\u3059\u308c\u3070 OK. import pandas as pd import [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,29],"tags":[],"class_list":["post-1901","post","type-post","status-publish","format-standard","hentry","category-data-engineering","category-python"],"_links":{"self":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/comments?post=1901"}],"version-history":[{"count":2,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1901\/revisions"}],"predecessor-version":[{"id":1903,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1901\/revisions\/1903"}],"wp:attachment":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/media?parent=1901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/categories?post=1901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/tags?post=1901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}