{"id":74,"date":"2022-11-04T15:34:07","date_gmt":"2022-11-04T06:34:07","guid":{"rendered":"http:\/\/www.kaguramps.xyz\/wordpress\/?p=74"},"modified":"2022-11-16T16:58:40","modified_gmt":"2022-11-16T07:58:40","slug":"post-74","status":"publish","type":"post","link":"http:\/\/www.kaguramps.xyz\/wordpress\/post-74\/","title":{"rendered":"\u30c6\u30b9\u30c8\u30da\u30fc\u30b8"},"content":{"rendered":"\n<h2 id=\"outline__1\" class=\"wp-block-heading\">TEST\u898b\u51fa\u3057<\/h2>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-python\" data-file=\"hisutoguramu\" data-lang=\"Python\"><code># hist_sales.py\nfrom pathlib import Path\nimport math\nimport openpyxl\nfrom matplotlib import pyplot\n\njp_font = &quot;Yu Gothic&quot; # \u65e5\u672c\u8a9e\u30d5\u30a9\u30f3\u30c8\npyplot.style.use(&quot;seaborn&quot;) # \u30b0\u30e9\u30d5\u30b9\u30bf\u30a4\u30eb\n\n# \u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\ndef xl_read(xl_path, cell_range, col_idx):\n    lst = []\n    wb = openpyxl.load_workbook(xl_path)\n    ws = wb[&quot;Sheet1&quot;]\n\n    for r in ws[cell_range]:\n        lst.append(r[col_idx].value)\n\n    return lst\n\n\n# \u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u4f5c\u6210\uff08\u58f2\u4e0a\uff09\ndef draw_hist_sales(sales_list, bin_edges):\n    pyplot.hist(sales_list, bins=bin_edges, edgecolor=&quot;black&quot;, linewidth=1.0)\n    pyplot.xlabel(&quot;\u58f2\u4e0a\/\u65e5 \uff08\u5343\u5186\uff09&quot;, fontname = jp_font)\n    pyplot.ylabel(&quot;\u5ea6\u6570&quot;, fontname = jp_font)\n\n\n# \u30c7\u30fc\u30bf\u8aad\u307f\u8fbc\u307f\nfile_path = Path(&quot;.\/Files\/\u65b0\u5bbf\u5e97_201907.xlsx&quot;)\ndata_list = xl_read(file_path, &quot;B2:B32&quot;, 0)\n\n# \u6700\u5927\u5024\u3001\u6700\u5c0f\u5024\u3001\u500b\u6570\u306e\u51fa\u529b\ndata_max, data_min, data_n = max(data_list), min(data_list), len(data_list)\nprint(&quot;\u6700\u5927\u5024\uff1a&quot;, data_max)\nprint(&quot;\u6700\u5c0f\u5024\uff1a&quot;, data_min)\nprint(&quot;\u500b\u6570\uff1a&quot;, data_n)\nprint()\n\n# \u7bc4\u56f2\u3001\u30b9\u30bf\u30fc\u30b8\u30a7\u30b9\nprint(&quot;\u7bc4\u56f2\uff1a&quot;, data_max - data_min)\nprint(&quot;\u30b9\u30bf\u30fc\u30b8\u30a7\u30b9\uff1a&quot;, 1 + math.log2(data_n))\nprint()\n\n# \u968e\u7d1a\u306e\u5165\u529b\nbin_min = int(input(&quot;\u968e\u7d1a\u306e\u4e0b\u9650\u5024\uff1d&quot;))\nbin_max = int(input(&quot;\u968e\u7d1a\u306e\u4e0a\u9650\u5024\uff1d&quot;))\nbin_w = int(input(&quot;\u968e\u7d1a\u306e\u5e45\uff1d&quot;))\n\n# \u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u4f5c\u6210\nedges = range(bin_min, bin_max + bin_w, bin_w)\ndraw_hist_sales(data_list, edges)\n\n# \u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u51fa\u529b\npyplot.show()<\/code><\/pre><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u4f5c\u6210\u30d7\u30ed\u30b0\u30e9\u30e0Python\nTEST\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>TEST\u898b\u51fa\u3057 \u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u4f5c\u6210\u30d7\u30ed\u30b0\u30e9\u30e0Python TEST<\/p>\n","protected":false},"author":1,"featured_media":231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/posts\/74"}],"collection":[{"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/comments?post=74"}],"version-history":[{"count":4,"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/posts\/74\/revisions"}],"predecessor-version":[{"id":234,"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/posts\/74\/revisions\/234"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/media\/231"}],"wp:attachment":[{"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/media?parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/categories?post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.kaguramps.xyz\/wordpress\/wp-json\/wp\/v2\/tags?post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}