{"id":2483,"date":"2023-07-22T01:51:33","date_gmt":"2023-07-22T01:51:33","guid":{"rendered":"https:\/\/statorials.org\/ja\/%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e5%9b%ba%e6%9c%89%e3%81%ae%e5%90%88%e8%a8%88%e5%88%97\/"},"modified":"2023-07-22T01:51:33","modified_gmt":"2023-07-22T01:51:33","slug":"%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e5%9b%ba%e6%9c%89%e3%81%ae%e5%90%88%e8%a8%88%e5%88%97","status":"publish","type":"post","link":"https:\/\/statorials.org\/ja\/%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e5%9b%ba%e6%9c%89%e3%81%ae%e5%90%88%e8%a8%88%e5%88%97\/","title":{"rendered":"Pandas \u306b\u7279\u5b9a\u306e\u5217\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5 (\u4f8b\u4ed8\u304d)"},"content":{"rendered":"

<\/p>\n

\n

\u6b21\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3001pandas DataFrame \u5185\u306e\u7279\u5b9a\u306e\u5217\u30bb\u30c3\u30c8\u306e\u5408\u8a08\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

\u65b9\u6cd5 1: \u3059\u3079\u3066\u306e\u5217\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b<\/strong><\/span><\/p>\n

 #find sum of all columns<\/span>\ndf[' sum<\/span> '] = df. sum<\/span> (axis= 1<\/span> )\n<\/strong><\/pre>\n
\u65b9\u6cd5 2: \u7279\u5b9a\u306e\u5217\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b<\/strong><\/span><\/p>\n
 #specify the columns to sum\n<\/span>cols = [' col1<\/span> ', ' col4<\/span> ', ' col5<\/span> ']\n\n#find sum of columns specified \n<\/span>df[' sum<\/span> '] = df[cols]. sum<\/span> (axis= 1<\/span> )<\/strong><\/pre>\n
\u6b21\u306e\u4f8b\u306f\u3001\u6b21\u306e pandas DataFrame \u3067\u5404\u30e1\u30bd\u30c3\u30c9\u3092\u5b9f\u969b\u306b\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd<\/span>\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' points<\/span> ': [18, 22, 19, 14, 14, 11, 20, 28],\n                   ' assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n   points assists rebounds\n0 18 5 11\n1 22 7 8\n2 19 7 10\n3 14 9 6\n4 14 12 6\n5 11 9 5\n6 20 9 9\n7 28 4 12\n<\/strong><\/pre>\n
\u4f8b 1: \u3059\u3079\u3066\u306e\u5217\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b<\/strong><\/span><\/h3>\n
\u6b21\u306e\u30b3\u30fc\u30c9\u306f\u3001DataFrame \u306e\u3059\u3079\u3066\u306e\u5217\u306b\u884c\u306e\u5024\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n
 #define new column that contains sum of all columns<\/span>\ndf[' sum_stats<\/span> '] = df. sum<\/span> (axis= 1<\/span> )\n\n#view updated DataFrame\n<\/span>df\n\n\tpoints assists rebounds sum_stats\n0 18 5 11 34\n1 22 7 8 37\n2 19 7 10 36\n3 14 9 6 29\n4 14 12 6 32\n5 11 9 5 25\n6 20 9 9 38\n7 28 4 12 44\n<\/span><\/span><\/strong><\/pre>\n
 sum_stats<\/strong>\u5217\u306b\u306f\u3001\u3059\u3079\u3066\u306e\u5217\u306e\u884c\u5024\u306e\u5408\u8a08\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/span><\/p>\n
\u305f\u3068\u3048\u3070\u3001\u5024\u306e\u8a08\u7b97\u65b9\u6cd5\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/span><\/p>\n