{"id":921,"date":"2019-07-05T00:25:02","date_gmt":"2019-07-04T15:25:02","guid":{"rendered":"https:\/\/mindtech.jp\/?p=921"},"modified":"2019-07-05T00:25:02","modified_gmt":"2019-07-04T15:25:02","slug":"post-921","status":"publish","type":"post","link":"https:\/\/mindtech.jp\/?p=921","title":{"rendered":"\u3010Python\u3011\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u3092pandas\u3092\u4f7f\u3063\u3066\u5207\u308a\u51fa\u3059\u65b9\u6cd5\u306e\u30e1\u30e2"},"content":{"rendered":"<p>\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u3092\u6271\u3046\u969b\u306b\u3001\u7279\u5b9a\u306e\u6642\u9593\u5e2f\u306e\u307f\u3092\u5207\u308a\u51fa\u3057\u305f\u3044\u5834\u5408\u3084\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u304c\u5408\u81f4\u3057\u3066\u3044\u308b\u90e8\u5206\u306e\u307f\u3092\u62bd\u51fa\u3057\u305f\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u6771\u4eac\u306e\u30a2\u30e1\u30c0\u30b9\u30c7\u30fc\u30bf\u3092Pandas\u3092\u5229\u7528\u3057\u3066\u62bd\u51fa\u64cd\u4f5c\u3092\u884c\u3046\u969b\u306e\u30e1\u30e2\u3067\u3059\u3002<\/p>\n<p>\u4ee5\u964d\u3001\u30c7\u30fc\u30bf\u306e\u8868\u793a\u306e\u305f\u3081\u306b .head() \u3084 .tail() \u3092\u4ed8\u3051\u3066\u3044\u308b\u7b87\u6240\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u64cd\u4f5c\u3059\u308b\u3060\u3051\u3067\u3042\u308c\u3070\u524a\u9664\u3057\u3066\u69cb\u3044\u307e\u305b\u3093\u3002<\/p>\n<h3>\u30e9\u30a4\u30d6\u30e9\u30ea\u3068\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f<\/h3>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\nimport numpy as np \r\nimport pandas as pd\r\n%matplotlib inline\r\n\r\n# \u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f\r\ndata_tokyo = pd.read_csv('.\/tokyo_amedas.csv', sep=',', index_col='date', parse_dates=&#x5B;'date'], encoding='SHIFT-JIS')\r\ndata_tokyo = data_tokyo.dropna()\r\nprint(type(data_tokyo.index))\r\ndata_tokyo.head()\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-923 size-full\" src=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h01_15.png\" alt=\"\" width=\"558\" height=\"258\" srcset=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h01_15.png 558w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h01_15-300x139.png 300w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h01_15-530x245.png 530w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/p>\n<p>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c&#8221;DateTimeIndex&#8221;\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u306e\u9805\u76ee\u306f\u6c17\u6e29\u3001\u98a8\u901f\u3001\u98a8\u5411\u3001\u6e7f\u5ea6\u3001\u524d1\u6642\u9593\u964d\u6c34\u91cf\u3067\u3059\u3002<\/p>\n<h3>\u65e5\u6642\u3067\u7d5e\u308a\u8fbc\u307f<\/h3>\n<p>between_time()\u3092\u4f7f\u3063\u3066\u3001\u7279\u5b9a\u306e\u6642\u9593\u5e2f\u3060\u3051\u3092\u7d5e\u308a\u8fbc\u3081\u307e\u3059\u3002<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\ndata_tokyo.between_time('2:00', '4:00', include_end=True).head(10)\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-924 size-full\" src=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h05_46.png\" alt=\"\" width=\"544\" height=\"363\" srcset=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h05_46.png 544w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h05_46-300x200.png 300w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h05_46-530x354.png 530w\" sizes=\"auto, (max-width: 544px) 100vw, 544px\" \/><\/p>\n<p>\u6bce\u65e5\u306e2:00, 3:00, 4:00\u306e\u30c7\u30fc\u30bf\u304c\u9078\u629e\u3055\u308c\u3066\u3044\u308b\u4e8b\u304c\u5206\u304b\u308a\u307e\u3059\u3002<\/p>\n<p>.loc \u3092\u4f7f\u3063\u3066\u3001\u6307\u5b9a\u306e\u6708\u3092\u7d5e\u308a\u8fbc\u3081\u307e\u3059\u3002<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\ndata_tokyo.loc&#x5B;'2018-2':'2018-4'].tail()\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-925 size-full\" src=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h08_55.png\" alt=\"\" width=\"541\" height=\"211\" srcset=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h08_55.png 541w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h08_55-300x117.png 300w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h08_55-530x207.png 530w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/p>\n<p>\u3053\u308c\u3089\u3092\u7d44\u307f\u3042\u308f\u305b\u3066\u3001\u6307\u5b9a\u3057\u305f\u6708\u306e\u6307\u5b9a\u6642\u9593\u5e2f\u3092\u7d5e\u308a\u8fbc\u3080\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\ndata_tokyo.loc&#x5B;'2018-2':'2018-4'].between_time('2:00','4:00', include_end=True).tail()\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-926 size-full\" src=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h12_19.png\" alt=\"\" width=\"552\" height=\"208\" srcset=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h12_19.png 552w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h12_19-300x113.png 300w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h12_19-530x200.png 530w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/p>\n<h3>\u5024\u304c\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u5834\u5408\u306e\u7d5e\u308a\u8fbc\u307f<\/h3>\n<p>\u6c17\u6e29\u304c30\u5ea6\u3092\u8d85\u3048\u308b\u590f\u65e5\u306e\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\ndata_tokyo&#x5B; data_tokyo&#x5B;'temperature'] &gt; 30 ].head()\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-927 size-full\" src=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h15_16.png\" alt=\"\" width=\"541\" height=\"210\" srcset=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h15_16.png 541w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h15_16-300x116.png 300w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h15_16-530x206.png 530w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/p>\n<p>.query() \u3092\u4f7f\u3046\u3068\u3001\u8907\u5408\u6761\u4ef6\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\u6c17\u6e29\u304c30\u5ea6\u3092\u8d85\u3048\u3001\u304b\u3064\u6e7f\u5ea6\u304c75\uff05\u3092\u8d85\u3048\u308b\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: python; title: ; notranslate\" title=\"\">\r\ndata_tokyo.query('temperature &gt; 30 and humidity &gt; 75').head()\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-928 size-full\" src=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h17_00.png\" alt=\"\" width=\"543\" height=\"211\" srcset=\"https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h17_00.png 543w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h17_00-300x117.png 300w, https:\/\/mindtech.jp\/wp-content\/uploads\/2019\/07\/2019-07-05_00h17_00-530x206.png 530w\" sizes=\"auto, (max-width: 543px) 100vw, 543px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u3092\u6271\u3046\u969b\u306b\u3001\u7279\u5b9a\u306e\u6642\u9593\u5e2f\u306e\u307f\u3092\u5207\u308a\u51fa\u3057\u305f\u3044\u5834\u5408\u3084\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u304c\u5408\u81f4\u3057\u3066\u3044\u308b\u90e8\u5206\u306e\u307f\u3092\u62bd\u51fa\u3057\u305f\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u6771\u4eac\u306e\u30a2\u30e1\u30c0\u30b9\u30c7\u30fc\u30bf\u3092Pandas\u3092\u5229\u7528\u3057\u3066\u62bd\u51fa\u64cd\u4f5c\u3092\u884c\u3046\u969b\u306e\u30e1\u30e2\u3067\u3059\u3002 \u4ee5\u964d\u3001\u30c7\u30fc\u30bf\u306e\u8868 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[158,34],"class_list":["post-921","post","type-post","status-publish","format-standard","hentry","category-6","tag-pandas","tag-python"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4rHn0-eR","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mindtech.jp\/index.php?rest_route=\/wp\/v2\/posts\/921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mindtech.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mindtech.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mindtech.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mindtech.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=921"}],"version-history":[{"count":3,"href":"https:\/\/mindtech.jp\/index.php?rest_route=\/wp\/v2\/posts\/921\/revisions"}],"predecessor-version":[{"id":930,"href":"https:\/\/mindtech.jp\/index.php?rest_route=\/wp\/v2\/posts\/921\/revisions\/930"}],"wp:attachment":[{"href":"https:\/\/mindtech.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mindtech.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mindtech.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}