{"id":2826,"date":"2023-07-20T12:20:35","date_gmt":"2023-07-20T12:20:35","guid":{"rendered":"https:\/\/statorials.org\/ja\/%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e3%81%ae%e3%83%aa%e3%83%8f%e3%82%99%e3%83%bc%e3%82%b9%e3%82%ab%e3%83%a0%e3%82%b5%e3%83%a0\/"},"modified":"2023-07-20T12:20:35","modified_gmt":"2023-07-20T12:20:35","slug":"%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e3%81%ae%e3%83%aa%e3%83%8f%e3%82%99%e3%83%bc%e3%82%b9%e3%82%ab%e3%83%a0%e3%82%b5%e3%83%a0","status":"publish","type":"post","link":"https:\/\/statorials.org\/ja\/%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e3%81%ae%e3%83%aa%e3%83%8f%e3%82%99%e3%83%bc%e3%82%b9%e3%82%ab%e3%83%a0%e3%82%b5%e3%83%a0\/","title":{"rendered":"\u30d1\u30f3\u30c0\u3067\u9006\u7d2f\u7a4d\u548c\u3092\u8a08\u7b97\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

<\/p>\n

\n

Cumsum()<\/a>\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001pandas DataFrame \u306e\u5217\u306e\u5024\u306e\u7d2f\u7a4d\u5408\u8a08\u3092\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

\u6b21\u306e\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001\u5217\u5185\u306e\u5024\u306e\u9006\u7d2f\u7a4d\u5408\u8a08<\/strong>\u3092\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

 df[' cumsum_reverse<\/span> '] = df. loc<\/span> [:: -1<\/span> , ' my_column<\/span> ']. cumsum<\/span> ()[:: -1<\/span> ]<\/strong><\/pre>\n
\u3053\u306e\u7279\u5b9a\u306e\u69cb\u6587\u306f\u3001 my_column<\/strong>\u3068\u3044\u3046\u30e9\u30d9\u30eb\u306e\u4ed8\u3044\u305f\u5217\u306e\u5024\u306e\u9006\u7d2f\u7a4d\u5408\u8a08\u3092\u8868\u793a\u3059\u308b\u3001 cumsum_reverse<\/strong>\u3068\u3044\u3046\u65b0\u3057\u3044\u5217\u3092 pandas DataFrame \u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/span><\/p>\n
\u6b21\u306e\u4f8b\u306f\u3001\u3053\u306e\u69cb\u6587\u3092\u5b9f\u969b\u306b\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n
\u4f8b: pandas \u3067\u9006\u7d2f\u7a4d\u548c\u3092\u8a08\u7b97\u3059\u308b<\/strong><\/span><\/h3>\n
\u9023\u7d9a 10 \u65e5\u9593\u306e\u5e97\u8217\u306e\u7dcf\u58f2\u4e0a\u9ad8\u3092\u793a\u3059\u6b21\u306e\u30d1\u30f3\u30c0 \u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' day<\/span> ': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10],\n                   ' sales<\/span> ': [3, 6, 0, 2, 4, 1, 0, 1, 4, 7]})\n\n#view DataFrame\n<\/span>df\n\n      day sales\n0 1 3\n1 2 6\n2 3 0\n3 4 2\n4 5 4\n5 6 1\n6 7 0\n7 8 1\n8 9 4\n9 10 7\n<\/strong><\/pre>\n
\u6b21\u306e\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001\u58f2\u4e0a\u5217\u306e\u9006\u7d2f\u8a08<\/strong>\u3092\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n
 #add new column that shows reverse cumulative sum of sales\ndf[' cumsum_reverse_sales<\/span> '] = df. loc<\/span> [:: -1<\/span> , ' sales<\/span> ']. cumsum<\/span> ()[:: -1<\/span> ]\n<\/span>\n#view updated DataFrame\ndf\n<\/span>\nday sales cumsum_reverse_sales\n0 1 3 28\n1 2 6 25\n2 3 0 19\n3 4 2 19\n4 5 4 17\n5 6 1 13\n6 7 0 12\n7 8 1 12\n8 9 4 11\n9 10 7 7<\/span><\/span><\/strong><\/pre>\n
 Cumsum_reverse_sales<\/strong>\u3068\u3044\u3046\u30bf\u30a4\u30c8\u30eb\u306e\u65b0\u3057\u3044\u5217\u306b\u306f\u3001\u6700\u5f8c\u306e\u884c\u304b\u3089\u306e<\/em>\u7d2f\u7a4d\u58f2\u4e0a\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/span><\/p>\n
 Cumsum_reverse_sales<\/strong>\u5217\u306e\u5024\u3092\u89e3\u91c8\u3059\u308b\u65b9\u6cd5\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/span><\/p>\n