{"id":308,"date":"2025-07-10T16:25:53","date_gmt":"2025-07-10T07:25:53","guid":{"rendered":"https:\/\/hooper-lab.com\/?p=308"},"modified":"2025-07-15T16:26:43","modified_gmt":"2025-07-15T07:26:43","slug":"308","status":"publish","type":"post","link":"https:\/\/hooper-lab.com\/?p=308","title":{"rendered":"7\uff1a\u4ee3\u8868\u5024\u3092\u8abf\u3079\u3066\u307f\u3088\u3046 \uff08\u5e73\u5747\u30fb\u4e2d\u592e\u5024\u30fb\u6700\u983b\u5024\uff09"},"content":{"rendered":"\n<div class=\"wp-block-buttons is-content-justification-right is-layout-flex wp-container-core-buttons-is-layout-d445cf74 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/hooper-lab.com\/?p=138\">\u524d\u9805\u76ee\u3078<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\">\u6b21\u9805\u76ee\u3078<\/a><\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u4ee3\u8868\u5024\u3063\u3066\u306a\u306b\uff1f<\/strong><\/h4>\n\n\n\n<p>\u30c7\u30fc\u30bf\u3092\u3056\u3063\u304f\u308a\u300c\u3069\u3093\u306a\u50be\u5411\u304b\u300d\u3064\u304b\u3080\u3068\u304d\u306b\u4fbf\u5229\u306a\u306e\u304c\u3001<strong>\u4ee3\u8868\u5024\uff08\u3060\u3044\u3072\u3087\u3046\u3061\uff09<\/strong>\u3067\u3059\u3002<br>\u4e3b\u306b\u6b21\u306e3\u3064\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u540d\u524d<\/th><th>\u610f\u5473<\/th><th>\u4f7f\u3044\u3069\u3053\u308d<\/th><\/tr><\/thead><tbody><tr><td>\u5e73\u5747\uff08mean\uff09<\/td><td>\u5168\u90e8\u306e\u5408\u8a08 \u00f7 \u4ef6\u6570<\/td><td>\u3056\u3063\u304f\u308a\u300c\u3069\u306e\u304f\u3089\u3044\u300d\u304b\u77e5\u308a\u305f\u3044\u3068\u304d<\/td><\/tr><tr><td>\u4e2d\u592e\u5024\uff08median\uff09<\/td><td>\u4e26\u3079\u305f\u3068\u304d\u771f\u3093\u4e2d\u306b\u304f\u308b\u5024<\/td><td>\u5916\u308c\u5024\u306e\u5f71\u97ff\u3092\u53d7\u3051\u306b\u304f\u3044<\/td><\/tr><tr><td>\u6700\u983b\u5024\uff08mode\uff09<\/td><td>\u6700\u3082\u3088\u304f\u51fa\u3066\u304f\u308b\u5024<\/td><td>\u4e00\u756a\u591a\u3044\u50be\u5411\u3092\u77e5\u308a\u305f\u3044\u3068\u304d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Shai Gilgeous-Alexander \u306e\u5b9f\u30c7\u30fc\u30bf\u3067\u4ee3\u8868\u5024\u3092\u6c42\u3081\u3066\u307f\u3088\u3046<\/strong><\/h4>\n\n\n\n<p>2024-2025\u30b7\u30fc\u30ba\u30f3\u306eMVP\u3067\u3042\u308b<strong>Shai Gilgeous-Alexander <\/strong>\uff08\u4ee5\u4e0b\u3001\u30b7\u30a7\u30a4\uff09\u306e\u30ec\u30ae\u30e5\u30e9\u30fc\u30b7\u30fc\u30ba\u30f3\u306e\u30b9\u30bf\u30c3\u30c4\u3092\u4f7f\u7528\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u30c7\u30fc\u30bf\u306e\u6e96\u5099\u3092\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from nba_api.stats.static import players\nfrom nba_api.stats.endpoints import playergamelog\nimport pandas as pd\n\n# \u9078\u624b\u306eID\u3092\u53d6\u5f97\nshai = players.find_players_by_full_name(\"Shai Gilgeous-Alexander\")&#91;0]\nplayer_id = shai&#91;'id'] \n\n# <strong>\u5f15\u6570\uff08\u30d1\u30e9\u30e1\u30fc\u30bf\uff09<\/strong>\u3092\u8a2d\u5b9a\u3057\u3066\u3001<strong>Shai Gilgeous-Alexander<\/strong>\u306e2024-25\u30b7\u30fc\u30ba\u30f3\u306e\u30ec\u30ae\u30e5\u30e9\u30fc\u30b7\u30fc\u30ba\u30f3\u30b9\u30bf\u30c3\u30c4\u3092\u53d6\u5f97\u3002\ngamelog = playergamelog.PlayerGameLog(\n    player_id=player_id,\n    season='2024-25',\n    season_type_all_star='Regular Season'\n)\ndf = gamelog.get_data_frames()&#91;0]\n<\/code><\/pre>\n\n\n\n<p>\u3053\u3053\u3067\u3001<code>playergamelog<\/code> \u3068\u3044\u3046<strong>\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<\/strong>\u304c\u51fa\u3066\u304d\u307e\u3057\u305f\u3002<code>playergamelog<\/code> \u306f\u3001<code>nba_api<\/code> \u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u4e2d\u3067\u3082<strong>\u975e\u5e38\u306b\u3088\u304f\u4f7f\u308f\u308c\u308b\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u3072\u3068\u3064<\/strong>\u3067\u3001\u7279\u5b9a\u306eNBA\u9078\u624b\u306e\u8a66\u5408\u3054\u3068\u306e\u30b9\u30bf\u30c3\u30c4\uff08Game Log\uff09\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u6a5f\u80fd\u3067\u3059\u3002playergamelog.PlayerGameLog\u3067player_id\u306b\u30e2\u30b8\u30e5\u30fc\u30ebstatic\u306eplayers\u3092\u7528\u3044\u3066\u53d6\u5f97\u3057\u305f\u9078\u624b\u306eID\u3092\u4ee3\u5165\u3057\uff08\u30b7\u30a7\u30a4\u306eID\u306f22024\uff09\u3001season\u306b\u53d6\u5f97\u3057\u305f\u3044\u30b7\u30fc\u30ba\u30f3\u3092\u6e21\u3057\u3001season_type_all_star\u306b\u30d7\u30ec\u30a4\u30aa\u30d5\u3084\u30ec\u30ae\u30e5\u30e9\u30fc\u30b7\u30fc\u30ba\u30f3\u306a\u3069\u306e\u60c5\u5831\u3092\u6e21\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><strong>\u2611\ufe0f\u5f15\u6570\uff08\u30d1\u30e9\u30e1\u30fc\u30bf\uff09\u306e\u8a73\u7d30<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u5f15\u6570\u540d<\/th><th>\u4f8b<\/th><th>\u8aac\u660e<\/th><\/tr><\/thead><tbody><tr><td><code>player_id<\/code><\/td><td>22024<\/td><td>\u9078\u624b\u306e\u4e00\u610f\u306eID\uff08<code>players.find_players_by_full_name()<\/code> \u306a\u3069\u3067\u53d6\u5f97\uff09<\/td><\/tr><tr><td><code>season<\/code><\/td><td><code>\"2024-25\"<\/code><\/td><td>\u5bfe\u8c61\u306e\u30b7\u30fc\u30ba\u30f3\u3002NBA API\u3067\u306f <code>\"YYYY-ZZ\"<\/code> \u306e\u5f62\u5f0f\u3092\u4f7f\u7528<\/td><\/tr><tr><td><code>season_type_all_star<\/code><\/td><td><code>\"Regular Season\"<\/code><\/td><td><code>\"Playoffs\"<\/code>\uff08\u30d7\u30ec\u30a4\u30aa\u30d5\uff09\u3084 <code>\"Pre Season\"<\/code>\uff08\u30d7\u30ec\u30b7\u30fc\u30ba\u30f3\uff09\u3082\u53ef<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u6700\u5f8c\u306edf = gamelog.get_data_frames()[0]\u3067\u3001\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u3001pandas\u306eDataFrame\u3068\u3057\u3066\u6574\u5f62\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u3046\u3059\u308b\u3053\u3068\u3067\u3001\u8868\u5f62\u5f0f\u3067\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<br>\u306a\u3093\u3067\u6700\u5f8c\u306b[0]\u3092\u3064\u3051\u308b\u306e\u304b\u7591\u554f\u306b\u601d\u3063\u305f\u65b9\u3082\u3044\u308b\u3067\u3057\u3087\u3046\u304c\u3001<code>nba_api<\/code> \u3067 <code>playergamelog<\/code> \u306a\u3069\u306e<strong> \u30a8\u30f3\u30c9<\/strong>\u30dd\u30a4\u30f3\u30c8\uff08endpoint\uff09 \u3092\u4f7f\u3046\u3068\u3001\u30c7\u30fc\u30bf\u306f HTML\u5f62\u5f0f\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u3067\u53d6\u5f97\u3055\u308c\u3001<code>get_data_frames()<\/code> \u306f \u30ea\u30b9\u30c8\u578b \u3092\u8fd4\u3057\u307e\u3059\u3002[DataFrame1, DataFrame2, \u2026]\u307f\u305f\u3044\u306a\u611f\u3058\u3067\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\uff08pandas\u306eDataFrame\uff09\u304c\u5165\u3063\u305f\u30ea\u30b9\u30c8\u306b\u306a\u308a\u307e\u3059\u3002\u5b9f\u969b\u306b\u6b32\u3057\u3044\u300c\u672c\u4f53\u30c7\u30fc\u30bf\uff08\u30e1\u30a4\u30f3\u306e\u8a66\u5408\u30ed\u30b0\uff09\u300d\u306f\u3001<br>\u3053\u306e\u30ea\u30b9\u30c8\u306e1\u756a\u76ee\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b90\uff09 \u306b\u5165\u3063\u3066\u3044\u308b\u306e\u304c\u4e00\u822c\u7684\u3067\u3059\u3002\u306a\u306e\u3067[0]\u3092\u6700\u5f8c\u306b\u3064\u3051\u3066\u3001\u4e00\u756a\u6700\u521d\u306eDataFrame\u3092\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002\u203bPyhon\u306e\u30ab\u30a6\u30f3\u30c8\u306f0\u304b\u3089\u3067\u3059\u3002<br>\u305d\u308c\u3067\u306f\u4e2d\u8eab\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>print(df.head())<\/code><\/pre>\n\n\n\n<p>\u7d50\u679c\u306f\u4ee5\u4e0b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"597\" src=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-12-1024x597.png\" alt=\"\" class=\"wp-image-151\" srcset=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-12-1024x597.png 1024w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-12-300x175.png 300w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-12-768x448.png 768w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-12.png 1318w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">\u6700\u5f8c\u306b[5 rows x 27 columns]\u3068\u3042\u308a\u307e\u3059\u304c\u300127\u9805\u76ee\u306e\u30c7\u30fc\u30bf\u304c\u898b\u308c\u308b\u3088\u3046\u3067\u3059\u3002GAME_DATE\u3092\u898b\u3066\u307f\u308b\u3068\u3001\u30ec\u30ae\u30e5\u30e9\u30fc\u30b7\u30fc\u30ba\u30f3\u306e\u6700\u7d42\u6226\u306e\u30c7\u30fc\u30bf\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u76f4\u8fd1\u306e\u8a66\u5408\u306e\u30c7\u30fc\u30bf\u304b\u3089\u51fa\u3066\u304f\u308b\u3088\u3046\u3067\u3059\u3002\u3061\u306a\u307f\u306bprint(df.tail())\u3067\u672b\u5c3e\u304b\u3089\uff15\u884c\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<br>\u6b21\u306b\u30c7\u30fc\u30bf\u306e\u6570\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>print(len(df))<\/code><\/pre>\n\n\n\n<p>\u95a2\u6570len()\u3067\u884c\u6570\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002()\u306e\u4e2d\u306bdf\u3092\u5165\u308c\u308b\u3053\u3068\u3067\u3001df\u3068\u3044\u3046\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u884c\u6570\u3092\u53d6\u5f97\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"743\" src=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-13-1024x743.png\" alt=\"\" class=\"wp-image-152\" srcset=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-13-1024x743.png 1024w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-13-300x218.png 300w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-13-768x557.png 768w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-13.png 1310w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u5168\u90e8\u306776\u884c\u3042\u308b\u3068\u51fa\u307e\u3057\u305f\u3002NBA\u306e\u8a66\u5408\u6570\u306f\uff11\u30b7\u30fc\u30ba\u30f382\u8a66\u5408\u6570\u3067\u3059\u304c76\u8a66\u5408\u3068\u51fa\u308b\u306e\u306f\u3001\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8<code>playergamelog<\/code>\u306b\u306f\u51fa\u5834\u8a66\u5408\u306e\u307f\u542b\u307e\u308c\u308b\u304b\u3089\u3067\u3059\u3002\u30b7\u30a7\u30a4\u306f\u4eca\u30b7\u30fc\u30ba\u30f376\u8a66\u5408\u306b\u51fa\u5834\u3057\u30016\u8a66\u5408\u306e\u307f\u6b20\u5834\u3057\u3066\u307e\u3059\u3002<br>\u30b7\u30a7\u30a4\u306e2024-25\u30ec\u30ae\u30e5\u30e9\u30fc\u30b7\u30fc\u30ba\u30f3\u51fa\u5834\u8a66\u540876\u8a66\u5408\u306e\u30b9\u30bf\u30c3\u30c4\u3092\u53d6\u308a\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002\u3067\u306f\u3053\u308c\u3092\u7528\u3044\u3066\u4ee3\u8868\u5024\u3092\u6c42\u3081\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002\u4eca\u56de\u306f\u5f97\u70b9\uff08PTS\uff09\u3092\u4e3b\u306b\u6271\u3063\u3066\u3044\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u5e73\u5747\uff08mean\uff09<\/strong><\/h4>\n\n\n\n<p>\u5e73\u5747\u306f\u3001<strong>\u5168\u90e8\u306e\u5408\u8a08 \u00f7 \u4ef6\u6570<\/strong>\u3067\u3057\u305f\u3002\u4f8b\u3048\u30701\u8a66\u5408\u306e\u5e73\u5747\u5f97\u70b9\u3092\u6c42\u3081\u305f\u3044\u3068\u601d\u3063\u305f\u3089\u3001\u30b7\u30fc\u30ba\u30f3\u306e\u5408\u8a08\u5f97\u70b9 \u00f7 \u51fa\u5834\u8a66\u5408\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PTS_mean = df&#91;'PTS'].sum() \/ len(df)\nprint(round(PTS_mean,1))<\/code><\/pre>\n\n\n\n<p>\u4ee5\u4e0a\u3092\u5b9f\u884c\u3059\u308b\u3068\u300c32.7\u300d\u3068\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\u30b7\u30a7\u30a4\u306f\u5e73\u574732.7\u5f97\u70b9\u3067\u30b7\u30fc\u30ba\u30f3\u5f97\u70b9\u738b\u306b\u8f1d\u3044\u3066\u307e\u3059\u3002<br>df[&#8216;PTS&#8217;].sum() \u3067\u5f97\u70b9(PTS)\u306e\u5217\u3092\u5408\u8a08(sum)\u3059\u308b\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u3002\u305d\u308c\u3092\u30c7\u30fc\u30bf\u6570\uff08\u884c\u6570\uff09\u3067\u5272\u3063\u305f\u6570\u5024\u3092PTS_mean\u306b\u4ee3\u5165\u3057\u3066\u3044\u307e\u3059\u3002round(PTS_mean,1)\u306fPTS_mean\u3092\u5c0f\u6570\u70b9\uff11\u6841\u307e\u3067\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u5c0f\u6570\uff12\u6841\u76ee\u3092\u56db\u6368\u4e94\u5165\u3057\u3066\u3044\u308b\u3068\u601d\u3044\u304c\u3061\u3067\u3059\u304c\u3001round()\u306f\u56db\u6368\u4e94\u5165\u3067\u306f\u306a\u3044\u306e\u3067\u6c17\u306b\u306a\u3063\u305f\u65b9\u306f\u8abf\u3079\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<br>\u305f\u3060\u3001pandas\u3092\u7528\u3044\u308c\u3070\u3053\u306e\u3088\u3046\u306a\u8a08\u7b97\u5f0f\u3092\u66f8\u304b\u306a\u304f\u3066\u3082\u5927\u4e08\u592b\u3067\u3059\u3002pandas\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3053\u306e\u8a08\u7b97\u5f0f\u3092\u7701\u7565\u3067\u304d\u307e\u3059\u3002<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PTS_mean_pandas = df&#91;'PTS'].mean()\nprint(round(PTS_mean_pandas,1))<\/code><\/pre>\n\n\n\n<p><br>pandas\u95a2\u6570\u306e .mean() \u3067\u5e73\u5747\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u5b9f\u884c\u3059\u308b\u3068\u300c32.7\u300d\u306b\u306a\u308a\u3001\u5148\u307b\u3069\u306e\u8a08\u7b97\u5f0f\u3067\u6c42\u3081\u305f\u6570\u5024\u3068\u5408\u3063\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u4e2d\u592e\u5024\uff08median\uff09<\/strong><\/h4>\n\n\n\n<p>\u4e2d\u592e\u5024\u306f\u30c7\u30fc\u30bf\u3092<strong>\u5c0f\u3055\u3044\u9806\u306b\u4e26\u3079\u305f\u3068\u304d\u306e\u771f\u3093\u4e2d\u306e\u5024<\/strong>\u3067\u3057\u305f\u3002\u307e\u305a\u306f\u5f97\u70b9\u3092\u5c0f\u3055\u3044\u9806\u304b\u3089\u9806\u756a\u306b\u4e26\u3079\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sorted_df = df.sort_values(by = 'PTS', ascending = True).reset_index(drop=True)\nprint(sorted_df.head())<\/code><\/pre>\n\n\n\n<p>\u4e26\u3073\u66ff\u3048\u306b\u3064\u3044\u3066\u306f\u3001\u524d\u56de\u306e<a href=\"https:\/\/hooper-lab.com\/6%ef%bc%9apandas%e3%81%ae%e5%9f%ba%e7%a4%8e%e2%91%a1%ef%bc%9a%e4%b8%a6%e3%81%b9%e6%9b%bf%e3%81%88%e3%80%81%e6%8a%bd%e5%87%ba%e3%80%81%e9%9b%86%e8%a8%88\/\" data-type=\"post\" data-id=\"138\">6\uff1apandas\u306e\u57fa\u790e\u2461\uff1a\u4e26\u3079\u66ff\u3048\u3001\u62bd\u51fa\u3001\u96c6\u8a08<\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002.reset_index(drop=True)\u306fpandas\u306eSeries\u3084DataFrame\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08\u884c\u756a\u53f7\uff09\u3092\u632f\u308a\u76f4\u3059\u305f\u3081\u306e\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u53e4\u3044\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3082\u6b8b\u308a\u307e\u3059\u304c\u3001drop=True\u3068\u3059\u308b\u3053\u3068\u3067\u53e4\u3044\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u524a\u9664\u3057\u307e\u3059\u3002<br><br>\u4e2d\u592e\u5024\u306f\u3001\u884c\u6570\u304c\u5947\u6570\u500b\u304b\u5076\u6570\u500b\u304b\u306b\u3088\u3063\u3066\u6c42\u3081\u65b9\u304c\u5909\u308f\u308a\u307e\u3059\u3002<br>\u5947\u6570\u500b\u306a\u3089 \u2192 \u4e2d\u592e1\u500b\u3000\u4f8b\uff1a7\u500b \u2192 4\u756a\u76ee\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9 3\uff09<br>\u5076\u6570\u500b\u306a\u3089 \u2192 \u4e2d\u592e2\u500b\u306e\u5e73\u5747\u3000\u4f8b\uff1a76\u500b \u2192 38\u756a\u76ee\u306839\u756a\u76ee\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9 37\u306838\uff09<br>\u4eca\u56de\u306f76\u884c\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u771f\u3093\u4e2d\u306e\u5024\u306f38\u500b\u76ee\u306839\u500b\u76ee\u306e\u6570\u5024\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9 37\u306838\uff09\u306e\u5e73\u5747\u3067\u3059\u3002<br>DataFrame\u304b\u308938\u500b\u76ee\u306839\u500b\u76ee\u306e\u6570\u5024\u3092\u53d6\u308a\u51fa\u3059\u306e\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>index_38 = sorted_pts&#91;\"PTS\"].loc&#91;37]\nindex_39 = sorted_pts&#91;\"PTS\"].loc&#91;38]\n\nprint(f\"38\u884c\u76ee\uff1a{index_38}\")\nprint(f\"39\u884c\u76ee\uff1a{index_39}\")\n\nmedian = sorted_pts&#91;\"PTS\"].loc&#91;37:38].mean()\nprint(f\"\u4e2d\u592e\u5024\uff1a{median}\")<\/code><\/pre>\n\n\n\n<p>print(f&#8221;\u2026&#8221;)\u306f\u300cf\u6587\u5b57\u5217\uff08f-string\uff09\u300d\u3068\u547c\u3070\u308c\u308b\u66f8\u304d\u65b9\u3067\u3001<strong>Python\u3067\u6587\u5b57\u5217\u306e\u4e2d\u306b\u5909\u6570\u3092\u57cb\u3081\u8fbc\u3080<\/strong>\u3068\u304d\u306b\u4f7f\u3044\u307e\u3059\u3002\u4e0a\u8a18\u306e\u3088\u3046\u306b\u3001print(f&#8221;\u2026&#8221;)\u306e<strong>\u2026<\/strong>\u306e\u90e8\u5206\u3067\u3001{}\u3067\u56f2\u3093\u3060\u5909\u6570\u3092\u5909\u6570\u306e\u51fa\u529b\u3068\u6587\u5b57\u5217\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br><code>.loc[]<\/code> \u306f pandas \u306e <strong>\u30e9\u30d9\u30eb\u30d9\u30fc\u30b9\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30a2\u30af\u30bb\u30b9\u65b9\u6cd5<\/strong>\u3067\u3059\u300237\u306838\u3068\u3044\u3046\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u30e9\u30d9\u30eb\u3092\u6307\u5b9a\u3057\u307e\u3057\u305f\u3002\u4f3c\u305f\u3082\u306e\u3068\u3057\u3066\u3001iloc[]\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u3053\u306e\u4f8b\u3060\u3068\u4f7f\u3044\u5206\u3051\u306e\u8aac\u660e\u304c\u96e3\u3057\u3044\u306e\u3067\u3001\u5225\u306e\u7ae0\u3067\u89e3\u8aac\u3057\u307e\u3059\u3002<br>\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"808\" height=\"126\" src=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-14.png\" alt=\"\" class=\"wp-image-153\" style=\"width:442px;height:auto\" srcset=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-14.png 808w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-14-300x47.png 300w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-14-768x120.png 768w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\" \/><\/figure>\n\n\n\n<p>\u5e73\u5747\u70b9\u3068\u8fd1\u3044\u7d50\u679c\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<br>\u3054\u5bdf\u3057\u306e\u901a\u308a\u3053\u306e\u3088\u3046\u306a\u65b9\u6cd5\u3092\u53d6\u3089\u306a\u304f\u3066\u3082\u3001pandas\u95a2\u6570\u3067\u7c21\u5358\u306b\u51fa\u529b\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PTS_median_pandas = df&#91;'PTS'].median()\nprint(round(PTS_median_pandas,1))<\/code><\/pre>\n\n\n\n<p>pandas\u95a2\u6570\u306e .median() \u3067\u4e2d\u592e\u5024\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u7d50\u679c\u306f32.0\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u6700\u983b\u5024\uff08median\uff09<\/strong><\/h4>\n\n\n\n<p>\u6700\u983b\u5024\u306f\u6700\u3082\u3088\u304f\u51fa\u3066\u304f\u308b\u5024\u3067\u3057\u305f\u3002\u30b7\u30a7\u30a4\u304c\u4eca\u30b7\u30fc\u30ba\u30f3\u6700\u3082\u591a\u304f\u6b8b\u3057\u305f\u5f97\u70b9\u3068\u3082\u8a00\u3048\u307e\u3059\u306d\u3002\u3082\u3061\u308d\u3093pandan\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3059\u3050\u306b\u6c42\u3081\u3089\u308c\u308b\u306e\u3067\u3059\u304c\u3001\u52c9\u5f37\u306e\u305f\u3081\u306bpandas\u95a2\u6570\u3092\u4f7f\u308f\u306a\u3044\u3084\u308a\u65b9\u3067\u3084\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5404\u5f97\u70b9\uff08PTS\uff09\u306e\u8a66\u5408\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u3001DataFrame\u5316\ncount_per_PTS = df.groupby('PTS')&#91;'Game_ID'].count().reset_index()\n\n# \u5217\u540d\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u5909\u66f4\ncount_per_PTS.columns = &#91;'PTS', 'count']\n\n# \u4ef6\u6570\u304c\u591a\u3044\u9806\u306b\u4e26\u3073\u66ff\u3048\nsorted_count_per_PTS = count_per_PTS.sort_values(by='count', ascending=False).reset_index(drop=True)\n\nprint(sorted_count_per_PTS)<\/code><\/pre>\n\n\n\n<p>\u57fa\u672c\u7684\u306b\u4eca\u307e\u3067\u5b66\u7fd2\u3057\u305f\u3082\u306e\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002df.groupby(&#8216;PTS&#8217;)[&#8216;Game_ID&#8217;].count().reset_index()\u3067\u3001reset_index()\u3092\u3064\u3051\u308b\u7406\u7531\u306f\u3001<code>count_per_PTS<\/code> \u306f <strong>Series<\/strong> \u306a\u306e\u3067\u3001[&#8216;PTS&#8217;, &#8216;count&#8217;]\u3068\u3044\u3046\u5217\u540d\u3092\u4ed8\u3051\u3088\u3046\u3068\u3059\u308b\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002Series \u306b\u306f\u8907\u6570\u306e\u5217\u3092\u6301\u305f\u305b\u3089\u308c\u306a\u3044\u304b\u3089\u3067\u3059\u3002\u3088\u3063\u3066\u3001reset_index()\u3092\u3064\u3051\u308b\u3053\u3068\u3067<strong>DataFrame<\/strong>\u306b\u76f4\u3057\u3066\u307e\u3059\u3002\u8a66\u5408\u6570\u306e\u30ab\u30a6\u30f3\u30c8\u306b\u7528\u3044\u308b\u5909\u6570\u3068\u3057\u3066\u3001\u306a\u3093\u3067\u3082\u3044\u3044\u306e\u3067\u3059\u304c\u3053\u3053\u3067\u306f&#8217;Game_ID&#8217;\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<br><code>groupby()<\/code> \u3092\u7528\u3044\u3066\u5f97\u70b9\uff08PTS\uff09\u3054\u3068\u306b\u8a66\u5408\u6570\u3092\u96c6\u8a08\u3057\u3001<code>sort_values()<\/code> \u3092\u4f7f\u3063\u3066\u8a66\u5408\u6570\u304c\u591a\u3044\u9806\u306b\u4e26\u3073\u66ff\u3048\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u4eca\u30b7\u30fc\u30ba\u30f3\u306e\u30b7\u30a7\u30a4\u304c\u300c\u6700\u3082\u983b\u7e41\u306b\u8a18\u9332\u3057\u305f\u5f97\u70b9\u300d\u304b\u3089\u300c\u6700\u3082\u7a00\u306b\u8a18\u9332\u3057\u305f\u5f97\u70b9\u300d\u307e\u3067\u3092\u3001\u9806\u756a\u306b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"374\" height=\"1004\" src=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-15.png\" alt=\"\" class=\"wp-image-154\" style=\"width:162px;height:auto\" srcset=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-15.png 374w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-15-112x300.png 112w\" sizes=\"auto, (max-width: 374px) 100vw, 374px\" \/><\/figure>\n\n\n\n<p>\u6700\u983b\u5024\u306f31\u70b9\u306832\u70b9\u3067\u54047\u56de\u305a\u3064\u3067\u3059\u306d\u3002\u3084\u306f\u308a\u5e73\u5747\u3068\u8fd1\u3044\u5024\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u3053\u3046\u898b\u308b\u3068\u300120\u70b9\u672a\u6e80\u306f18\u70b9\u306e1\u56de\u306e\u307f\u3068\u3044\u3046\u7570\u6b21\u5143\u306e\u6d3b\u8e8d\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<br>\u3067\u306f\u3001pandas\u95a2\u6570\u3067\u78ba\u8a8d\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PTS_median_pandas = df&#91;'PTS'].median()\nprint(round(PTS_median_pandas,1))<\/code><\/pre>\n\n\n\n<p>pandas\u95a2\u6570\u306e .mode() \u3067\u6700\u983b\u5024\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u7d50\u679c\u306f\u4ee5\u4e0b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"404\" height=\"112\" src=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-16.png\" alt=\"\" class=\"wp-image-155\" style=\"width:245px;height:auto\" srcset=\"https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-16.png 404w, https:\/\/hooper-lab.com\/wp-content\/uploads\/2025\/07\/image-16-300x83.png 300w\" sizes=\"auto, (max-width: 404px) 100vw, 404px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u307e\u3068\u3081<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u4ee3\u8868\u5024\u306e\u7a2e\u985e<\/th><th>pandas\u95a2\u6570<\/th><th>\u7279\u5fb4<\/th><\/tr><\/thead><tbody><tr><td>\u5e73\u5747<\/td><td><code>.mean()<\/code><\/td><td>\u6700\u3082\u3088\u304f\u4f7f\u308f\u308c\u308b\u6307\u6a19<\/td><\/tr><tr><td>\u4e2d\u592e\u5024<\/td><td><code>.median()<\/code><\/td><td>\u5916\u308c\u5024\u306b\u5f37\u3044\u30fb\u5b9f\u611f\u306b\u8fd1\u3044\u3053\u3068\u3082<\/td><\/tr><tr><td>\u6700\u983b\u5024<\/td><td><code>.mode()<\/code><\/td><td>\u30d1\u30bf\u30fc\u30f3\u304c\u591a\u3044\u6642\u306b\u4f7f\u3048\u308b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><br>\u6b21\u56de\u306f\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u5316\u306b\u3064\u3044\u3066\u5b66\u3093\u3067\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-right is-layout-flex wp-container-core-buttons-is-layout-d445cf74 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/hooper-lab.com\/?p=138\">\u524d\u9805\u76ee\u3078<\/a><\/div>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\">\u6b21\u9805\u76ee\u3078<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee3\u8868\u5024\u3063\u3066\u306a\u306b\uff1f \u30c7\u30fc\u30bf\u3092\u3056\u3063\u304f\u308a\u300c\u3069\u3093\u306a\u50be\u5411\u304b\u300d\u3064\u304b\u3080\u3068\u304d\u306b\u4fbf\u5229\u306a\u306e\u304c\u3001\u4ee3\u8868\u5024\uff08\u3060\u3044\u3072\u3087\u3046\u3061\uff09\u3067\u3059\u3002\u4e3b\u306b\u6b21\u306e3\u3064\u304c\u3042\u308a\u307e\u3059\uff1a \u540d\u524d \u610f\u5473 \u4f7f\u3044\u3069\u3053\u308d \u5e73\u5747\uff08mean\uff09 \u5168\u90e8\u306e\u5408\u8a08 \u00f7 \u4ef6\u6570 \u3056\u3063\u304f\u308a\u300c\u3069\u306e\u304f\u3089\u3044\u300d\u304b\u77e5\u308a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":265,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,4],"tags":[16,8,17,11,9,12],"class_list":["post-308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-10","category-learning","tag-jupyterlab","tag-nba","tag-pandas","tag-python","tag-9","tag-12"],"_links":{"self":[{"href":"https:\/\/hooper-lab.com\/index.php?rest_route=\/wp\/v2\/posts\/308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hooper-lab.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hooper-lab.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hooper-lab.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hooper-lab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=308"}],"version-history":[{"count":2,"href":"https:\/\/hooper-lab.com\/index.php?rest_route=\/wp\/v2\/posts\/308\/revisions"}],"predecessor-version":[{"id":310,"href":"https:\/\/hooper-lab.com\/index.php?rest_route=\/wp\/v2\/posts\/308\/revisions\/310"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hooper-lab.com\/index.php?rest_route=\/wp\/v2\/media\/265"}],"wp:attachment":[{"href":"https:\/\/hooper-lab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hooper-lab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hooper-lab.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}