{"id":1038,"date":"2022-10-23T06:56:40","date_gmt":"2022-10-22T22:56:40","guid":{"rendered":"http:\/\/viplao.com\/?p=1038"},"modified":"2022-10-23T06:56:40","modified_gmt":"2022-10-22T22:56:40","slug":"%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-%e6%95%b0%e6%8d%ae%e6%9e%84%e9%80%a0%e5%ae%9e%e4%be%8b","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2022\/10\/23\/%e8%bf%90%e7%bb%b4%e5%b7%a5%e5%85%b7-%e6%95%b0%e6%8d%ae%e6%9e%84%e9%80%a0%e5%ae%9e%e4%be%8b\/","title":{"rendered":"\u8fd0\u7ef4\u5de5\u5177 &#8211;  \u6570\u636e\u6784\u9020\u5b9e\u4f8b"},"content":{"rendered":"\n<p>\u751f\u6210\u968f\u673a\u6570<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>fruits = &#91;'apple', 'orange', 'apple', 'apple'] * 10\nprint(fruits)\nN = len(fruits)\ndf = pd.DataFrame({'fruit': fruits,\n                   'basket_id': np.arange(N),\n                   'count': np.random.randint(3, 15, size=N),\n                   'weight': np.random.uniform(0, 4, size=N),\n                   'rands': np.random.rand(N)},\n                  columns=&#91;'basket_id', 'fruit', 'count', 'weight', 'rands'])<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"370\" height=\"467\" src=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/10\/image-56.png\" alt=\"\" class=\"wp-image-1040\" srcset=\"http:\/\/viplao.com\/wp-content\/uploads\/2022\/10\/image-56.png 370w, http:\/\/viplao.com\/wp-content\/uploads\/2022\/10\/image-56-238x300.png 238w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u4ecea-zA-Z0-9\u751f\u6210\u6307\u5b9a\u6570\u91cf\u7684\u968f\u673a\u5b57\u7b26<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import random\r\nimport string\r\n\r\nvalue = ''.join(random.sample(string.ascii_letters + string.digits, 8))\r\nprint(value)\n\n\r\nalphabet = 'abcdefghijklmnopqrstuvwxyz!@#$%^&amp;*()'\r\ncharacters = random.sample(alphabet, 5)\r\nprint(characters)\n\ntable = &#91;'\u526a\u5200', '\u77f3\u5934', '\u5e03']\r\nprint(random.choice(table))<\/code><\/pre>\n\n\n\n<p><strong>pd.date_range\u6784\u9020\u65f6\u95f4\u5e8f\u5217<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u6307\u5b9a\u5f00\u59cb\u3001\u7ed3\u675f\u65f6\u95f4\r\nimport pandas as pd\r\n# \u6307\u5b9a\u5f00\u59cb\u3001\u7ed3\u675f\r\npd.date_range(start='20211001', end='20211010')\r\n'''\r\nDatetimeIndex(&#91;'2021-10-01', '2021-10-02', '2021-10-03', '2021-10-04',\r\n               '2021-10-05', '2021-10-06', '2021-10-07', '2021-10-08',\r\n               '2021-10-09', '2021-10-10'],\r\n              dtype='datetime64&#91;ns]', freq='D')\r\n'''\r\n\u6307\u5b9a\u4e2a\u6570\r\n# \u6307\u5b9a\u4e2a\u6570\r\npd.date_range(start='2021-10-01', periods=5)\r\n'''\r\nDatetimeIndex(&#91;'2021-10-01', '2021-10-02', '2021-10-03', '2021-10-04',\r\n               '2021-10-05'],\r\n              dtype='datetime64&#91;ns]', freq='D')\r\n'''\r\n\u6307\u5b9a\u9891\u7387\uff08\u95f4\u9694\uff09\r\nfreq \u53ef\u4ee5\u4f20\u5165\u6240\u6709 Offset Aliases \u3002\r\n\r\n# \u6307\u5b9a\u9891\u7387\uff08\u95f4\u9694\uff09\r\npd.date_range(start='2021-10-01', periods=10, freq='1D')\r\n'''\r\nDatetimeIndex(&#91;'2021-10-01', '2021-10-02', '2021-10-03', '2021-10-04',\r\n               '2021-10-05', '2021-10-06', '2021-10-07', '2021-10-08',\r\n               '2021-10-09', '2021-10-10'],\r\n              dtype='datetime64&#91;ns]', freq='D')\r\n'''\r\npd.date_range(start='2021-10-01', end='2021-10-10', freq='3D')\r\n'''\r\nDatetimeIndex(&#91;'2021-10-01', '2021-10-04', '2021-10-07', '2021-10-10'], dtype='datetime64&#91;ns]', freq='3D')\r\n'''\r\n\r\nimport pandas as pd\r\npd.date_range('20211018', periods=10, freq='5H')\r\n'''\r\nDatetimeIndex(&#91;'2021-10-18 00:00:00', '2021-10-18 05:00:00',\r\n               '2021-10-18 10:00:00', '2021-10-18 15:00:00',\r\n               '2021-10-18 20:00:00', '2021-10-19 01:00:00',\r\n               '2021-10-19 06:00:00', '2021-10-19 11:00:00',\r\n               '2021-10-19 16:00:00', '2021-10-19 21:00:00'],\r\n              dtype='datetime64&#91;ns]', freq='5H')\r\n'''\r\n\r\npd.date_range('20211018', periods=10, freq='3M')\r\n'''\r\nDatetimeIndex(&#91;'2021-10-31', '2022-01-31', '2022-04-30', '2022-07-31',\r\n               '2022-10-31', '2023-01-31', '2023-04-30', '2023-07-31',\r\n               '2023-10-31', '2024-01-31'],\r\n              dtype='datetime64&#91;ns]', freq='3M')\r\n'''\r\nbusiness day\uff08\u5de5\u4f5c\u65e5\uff09\u5b9e\u73b0\r\npd.date_range('20211018', freq='B', periods=10)\r\n'''\r\nDatetimeIndex(&#91;'2021-10-18', '2021-10-19', '2021-10-20', '2021-10-21',\r\n               '2021-10-22', '2021-10-25', '2021-10-26', '2021-10-27',\r\n               '2021-10-28', '2021-10-29'],\r\n              dtype='datetime64&#91;ns]', freq='B')\r\n'''\r\npd.bdate_range('20211018', periods=10) # \u7ed3\u679c\u540c\u4e0a\r\n\u662f\u5426\u6807\u51c6\u5316\u5230\u5348\u591c\u65f6\u95f4\u6233\r\n# \u4ece0\u70b9\u5f00\u59cb\r\npd.date_range(start='2021-10-01 17:23:10', periods=10, freq='s', normalize=True)\r\n'''\r\nDatetimeIndex(&#91;'2021-10-01 00:00:00', '2021-10-01 00:00:01',\r\n               '2021-10-01 00:00:02', '2021-10-01 00:00:03',\r\n               '2021-10-01 00:00:04', '2021-10-01 00:00:05',\r\n               '2021-10-01 00:00:06', '2021-10-01 00:00:07',\r\n               '2021-10-01 00:00:08', '2021-10-01 00:00:09'],\r\n              dtype='datetime64&#91;ns]', freq='S')\r\n'''\r\n\r\n# \u4ece\u6307\u5b9a\u65f6\u95f4\u5f00\u59cb\r\npd.date_range(start='2021-10-01 17:23:10', periods=10, freq='s')\r\n'''\r\nDatetimeIndex(&#91;'2021-10-01 17:23:10', '2021-10-01 17:23:11',\r\n               '2021-10-01 17:23:12', '2021-10-01 17:23:13',\r\n               '2021-10-01 17:23:14', '2021-10-01 17:23:15',\r\n               '2021-10-01 17:23:16', '2021-10-01 17:23:17',\r\n               '2021-10-01 17:23:18', '2021-10-01 17:23:19'],\r\n              dtype='datetime64&#91;ns]', freq='S')\r\n'''\r\n\u5de6\u53f3\u5f00\u533a\u95f4\u3001\u95ed\u533a\u95f4\r\n# \u5de6\u95ed\u53f3\u5f00\r\npd.date_range(start='2021-10-01', end='2021-10-10', freq='3D', closed='left')\r\n# DatetimeIndex(&#91;'2021-10-01', '2021-10-04', '2021-10-07'], dtype='datetime64&#91;ns]', freq='3D')\r\n\r\n# \u53f3\u95ed\u5de6\u5f00\r\npd.date_range(start='2021-10-01', end='2021-10-10', freq='3D', closed='right')\r\n# DatetimeIndex(&#91;'2021-10-04', '2021-10-07', '2021-10-10'], dtype='datetime64&#91;ns]', freq='3D')\r\n\r\n# \u5de6\u95ed\u53f3\u95ed \u9ed8\u8ba4\r\npd.date_range(start='2021-10-01', end='2021-10-10', freq='3D', closed=None)\r\n# DatetimeIndex(&#91;'2021-10-01', '2021-10-04', '2021-10-07', '2021-10-10'], dtype='datetime64&#91;ns]', freq='3D')\r\n\u65f6\u533a\r\npd.date_range(start='20211001', periods=5, tz='Asia\/Tokyo')\r\n'''\r\nDatetimeIndex(&#91;'2021-10-01 00:00:00+09:00', '2021-10-02 00:00:00+09:00',\r\n               '2021-10-03 00:00:00+09:00', '2021-10-04 00:00:00+09:00',\r\n               '2021-10-05 00:00:00+09:00'],\r\n              dtype='datetime64&#91;ns, Asia\/Tokyo]', freq='D')<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u751f\u6210\u968f\u673a\u6570 \u4ecea-zA-Z0-9\u751f\u6210\u6307\u5b9a\u6570\u91cf\u7684\u968f\u673a\u5b57\u7b26 pd.date_range\u6784\u9020\u65f6\u95f4\u5e8f\u5217<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"views":876,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1038"}],"collection":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/comments?post=1038"}],"version-history":[{"count":5,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1038\/revisions"}],"predecessor-version":[{"id":1045,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/1038\/revisions\/1045"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=1038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=1038"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=1038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}