{"id":3387,"date":"2021-07-23T12:10:54","date_gmt":"2021-07-23T12:10:54","guid":{"rendered":"https:\/\/www.bearloga.space\/?page_id=3387"},"modified":"2021-07-23T12:10:55","modified_gmt":"2021-07-23T12:10:55","slug":"python-pandas-okonnye-funkczii","status":"publish","type":"page","link":"https:\/\/www.bearloga.space\/uk\/python-pandas-okonnye-funkczii\/","title":{"rendered":"Python Pandas \u2014 \u043e\u043a\u043e\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\r\n\u0414\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0447\u0438\u0441\u043b\u043e\u0432\u044b\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 Pandas \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0432\u0430\u0440\u0438\u0430\u043d\u0442\u043e\u0432, \u0442\u0430\u043a\u0438\u0445 \u043a\u0430\u043a \u0441\u043a\u043e\u043b\u044c\u0437\u044f\u0449\u0435\u0435, \u0440\u0430\u0441\u0448\u0438\u0440\u044f\u044e\u0449\u0435\u0435\u0441\u044f \u0438 \u044d\u043a\u0441\u043f\u043e\u043d\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u043e \u043f\u0435\u0440\u0435\u043c\u0435\u0449\u0430\u044e\u0449\u0435\u0435\u0441\u044f \u0432\u0435\u0441\u0430 \u0434\u043b\u044f \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0438 \u043e\u043a\u043d\u0430. \u0421\u0440\u0435\u0434\u0438 \u043d\u0438\u0445 \u0441\u0443\u043c\u043c\u0430, \u0441\u0440\u0435\u0434\u043d\u0435\u0435, \u043c\u0435\u0434\u0438\u0430\u043d\u0430, \u0434\u0438\u0441\u043f\u0435\u0440\u0441\u0438\u044f, \u043a\u043e\u0432\u0430\u0440\u0438\u0430\u0446\u0438\u044f, \u043a\u043e\u0440\u0440\u0435\u043b\u044f\u0446\u0438\u044f \u0438 \u0442. \u0414.\r\n\r\n\u0422\u0435\u043f\u0435\u0440\u044c \u043c\u044b \u0443\u0437\u043d\u0430\u0435\u043c, \u043a\u0430\u043a \u043a\u0430\u0436\u0434\u044b\u0439 \u0438\u0437 \u043d\u0438\u0445 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d \u043a \u043e\u0431\u044a\u0435\u043a\u0442\u0430\u043c DataFrame.\r\n\r\n\u0424\u0443\u043d\u043a\u0446\u0438\u044f .rolling ()\r\n\u042d\u0442\u0430 \u0444\u0443\u043d\u043a\u0446\u0438\u044f \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0430 \u043a \u0441\u0435\u0440\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u0423\u043a\u0430\u0436\u0438\u0442\u0435 \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442 window = n \u0438 \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u0442\u0435 \u043a \u043d\u0435\u043c\u0443 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0443\u044e \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e.\r\n\r\n Live Demo\r\n\r\nimport pandas as pd\r\nimport numpy as np\r\n\r\ndf = pd.DataFrame(np.random.randn(10, 4),\r\n   index = pd.date_range('1\/1\/2000', periods=10),\r\n   columns = &#91;'A', 'B', 'C', 'D'])\r\nprint df.rolling(window=3).mean()\r\n\u0415\u0433\u043e \u0432\u044b\u0432\u043e\u0434 \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u2014\r\n\r\n                    A           B           C           D\r\n2000-01-01        NaN         NaN         NaN         NaN\r\n2000-01-02        NaN         NaN         NaN         NaN\r\n2000-01-03   0.434553   -0.667940   -1.051718   -0.826452\r\n2000-01-04   0.628267   -0.047040   -0.287467   -0.161110\r\n2000-01-05   0.398233    0.003517    0.099126   -0.405565\r\n2000-01-06   0.641798    0.656184   -0.322728    0.428015\r\n2000-01-07   0.188403    0.010913   -0.708645    0.160932\r\n2000-01-08   0.188043   -0.253039   -0.818125   -0.108485\r\n2000-01-09   0.682819   -0.606846   -0.178411   -0.404127\r\n2000-01-10   0.688583    0.127786    0.513832   -1.067156\r\n\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u0435. \u041f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 \u0440\u0430\u0437\u043c\u0435\u0440 \u043e\u043a\u043d\u0430 \u0440\u0430\u0432\u0435\u043d 3, \u0434\u043b\u044f \u043f\u0435\u0440\u0432\u044b\u0445 \u0434\u0432\u0443\u0445 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f NULL, \u0430 \u0434\u043b\u044f \u0442\u0440\u0435\u0442\u044c\u0435\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0431\u0443\u0434\u0435\u0442 \u0441\u0440\u0435\u0434\u043d\u0438\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 n , n-1 \u0438 n-2 . \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c, \u043c\u044b \u0442\u0430\u043a\u0436\u0435 \u043c\u043e\u0436\u0435\u043c \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u0442\u044c \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u043a\u0430\u043a \u0443\u043a\u0430\u0437\u0430\u043d\u043e \u0432\u044b\u0448\u0435.\r\n\r\n\r\n\u0410\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0435 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u043d\u0430 Java\r\n\u0424\u0443\u043d\u043a\u0446\u0438\u044f .expanding ()\r\n\u042d\u0442\u0430 \u0444\u0443\u043d\u043a\u0446\u0438\u044f \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0430 \u043a \u0441\u0435\u0440\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u0423\u043a\u0430\u0436\u0438\u0442\u0435 \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442 min_periods = n \u0438 \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u0442\u0435 \u043a \u043d\u0435\u043c\u0443 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0443\u044e \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e.\r\n\r\n Live Demo\r\n\r\nimport pandas as pd\r\nimport numpy as np\r\n\r\ndf = pd.DataFrame(np.random.randn(10, 4),\r\n   index = pd.date_range('1\/1\/2000', periods=10),\r\n   columns = &#91;'A', 'B', 'C', 'D'])\r\nprint df.expanding(min_periods=3).mean()\r\n\u0415\u0433\u043e \u0432\u044b\u0432\u043e\u0434 \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u2014\r\n\r\n                   A           B           C           D\r\n2000-01-01        NaN         NaN         NaN         NaN\r\n2000-01-02        NaN         NaN         NaN         NaN\r\n2000-01-03   0.434553   -0.667940   -1.051718   -0.826452\r\n2000-01-04   0.743328   -0.198015   -0.852462   -0.262547\r\n2000-01-05   0.614776   -0.205649   -0.583641   -0.303254\r\n2000-01-06   0.538175   -0.005878   -0.687223   -0.199219\r\n2000-01-07   0.505503   -0.108475   -0.790826   -0.081056\r\n2000-01-08   0.454751   -0.223420   -0.671572   -0.230215\r\n2000-01-09   0.586390   -0.206201   -0.517619   -0.267521\r\n2000-01-10   0.560427   -0.037597   -0.399429   -0.376886\r\n\u0424\u0443\u043d\u043a\u0446\u0438\u044f .ewm ()\r\nEWM \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \u043a \u0441\u0435\u0440\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u0423\u043a\u0430\u0436\u0438\u0442\u0435 \u043b\u044e\u0431\u043e\u0439 \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442 com, span, halflife \u0438 \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u0442\u0435 \u043a \u043d\u0435\u043c\u0443 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0443\u044e \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e. \u041e\u043d \u043f\u0440\u0438\u0441\u0432\u0430\u0438\u0432\u0430\u0435\u0442 \u0432\u0435\u0441\u0430 \u044d\u043a\u0441\u043f\u043e\u043d\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u043e.\r\n\r\n Live Demo\r\n\r\nimport pandas as pd\r\nimport numpy as np\r\n \r\ndf = pd.DataFrame(np.random.randn(10, 4),\r\n   index = pd.date_range('1\/1\/2000', periods=10),\r\n   columns = &#91;'A', 'B', 'C', 'D'])\r\nprint df.ewm(com=0.5).mean()\r\n\u0415\u0433\u043e \u0432\u044b\u0432\u043e\u0434 \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u2014\r\n\r\n                    A           B           C           D\r\n2000-01-01   1.088512   -0.650942   -2.547450   -0.566858\r\n2000-01-02   0.865131   -0.453626   -1.137961    0.058747\r\n2000-01-03  -0.132245   -0.807671   -0.308308   -1.491002\r\n2000-01-04   1.084036    0.555444   -0.272119    0.480111\r\n2000-01-05   0.425682    0.025511    0.239162   -0.153290\r\n2000-01-06   0.245094    0.671373   -0.725025    0.163310\r\n2000-01-07   0.288030   -0.259337   -1.183515    0.473191\r\n2000-01-08   0.162317   -0.771884   -0.285564   -0.692001\r\n2000-01-09   1.147156   -0.302900    0.380851   -0.607976\r\n2000-01-10   0.600216    0.885614    0.569808   -1.110113\r\n\u041e\u043a\u043e\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0432 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0434\u043b\u044f \u043d\u0430\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u0442\u0440\u0435\u043d\u0434\u043e\u0432 \u0432 \u0434\u0430\u043d\u043d\u044b\u0445 \u0433\u0440\u0430\u0444\u0438\u0447\u0435\u0441\u043a\u0438 \u043f\u0443\u0442\u0435\u043c \u0441\u0433\u043b\u0430\u0436\u0438\u0432\u0430\u043d\u0438\u044f \u043a\u0440\u0438\u0432\u043e\u0439. \u0415\u0441\u043b\u0438 \u0432 \u043a\u0430\u0436\u0434\u043e\u0434\u043d\u0435\u0432\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u043c\u0435\u0435\u0442\u0441\u044f \u043c\u043d\u043e\u0433\u043e \u0432\u0430\u0440\u0438\u0430\u0446\u0438\u0439 \u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u0442\u043e\u0447\u0435\u043a \u0434\u0430\u043d\u043d\u044b\u0445, \u0442\u043e \u0432\u044b\u0431\u043e\u0440\u043a\u0430 \u0438 \u043f\u043e\u0441\u0442\u0440\u043e\u0435\u043d\u0438\u0435 \u0433\u0440\u0430\u0444\u0438\u043a\u043e\u0432 \u2014 \u044d\u0442\u043e \u043e\u0434\u0438\u043d \u043c\u0435\u0442\u043e\u0434, \u0430 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u043e\u043a\u043e\u043d\u043d\u044b\u0445 \u0432\u044b\u0447\u0438\u0441\u043b\u0435\u043d\u0438\u0439 \u0438 \u043f\u043e\u0441\u0442\u0440\u043e\u0435\u043d\u0438\u0435 \u0433\u0440\u0430\u0444\u0438\u043a\u0430 \u0434\u043b\u044f \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u0432 \u2014 \u0435\u0449\u0435 \u043e\u0434\u0438\u043d \u043c\u0435\u0442\u043e\u0434. \u042d\u0442\u0438\u043c\u0438 \u043c\u0435\u0442\u043e\u0434\u0430\u043c\u0438 \u043c\u044b \u043c\u043e\u0436\u0435\u043c \u0441\u0433\u043b\u0430\u0434\u0438\u0442\u044c \u043a\u0440\u0438\u0432\u0443\u044e \u0438\u043b\u0438 \u0442\u0440\u0435\u043d\u0434.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[109],"tags":[],"class_list":["post-3387","page","type-page","status-publish","hentry","category-python-pandas"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/3387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/comments?post=3387"}],"version-history":[{"count":0,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/3387\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/media?parent=3387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/categories?post=3387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/tags?post=3387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}