Pythonデータ分析入門編11:階層的インデックスの導入

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "531a1da9",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "\n",
    "\n",
    "submissions = pd.read_csv(\"csv/submissions.csv\")\n",
    "submissions.columns = [\"problem_name\", \"bytes\", \"score\", \"language\", \"time\"]\n",
    "submissions = submissions.dropna().sort_values([\"language\", \"problem_name\"])\n",
    "\n",
    "lang_and_name = submissions.loc[:, [\"language\", \"problem_name\"]]\n",
    "lang_submissions = submissions.loc[:, [\"bytes\", \"score\", \"time\"]]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "531a1da9",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "\n",
    "\n",
    "submissions = pd.read_csv(\"csv/submissions.csv\")\n",
    "submissions.columns = [\"problem_name\", \"bytes\", \"score\", \"language\", \"time\"]\n",
    "submissions = submissions.dropna().sort_values([\"language\", \"problem_name\"])\n",
    "\n",
    "lang_and_name = submissions.loc[:, [\"language\", \"problem_name\"]]\n",
    "lang_submissions = submissions.loc[:, [\"bytes\", \"score\", \"time\"]]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}

この動画を見るには

paiza会員登録のうえ

有料会員登録が必要です

演習1

問題ログインすると模範解答や入力を見ることができます

演習課題「階層的インデックスの貼り付け」

右のコードエリアではスキルチェックの提出データが読み込まれ、言語・問題名の順の優先度でソートされています。lang_and_nameを階層的インデックスに変換したものをlang_submissionsにインデックスとして貼り付け、言語・問題名の階層的インデックスを持ったDataFrameを作成し、表示してください。採点の前にはすべてのセルを実行し、ノートブックを保存してください。

Tips

動画へ戻る

次のチャプターへ前のチャプターへ

※有料会員になるとこの動画をご利用いただけます

詳しい説明を読む

＃05:階層的インデックスの導入

このチャプターでは、マージ後のテーブルに階層的インデックスを導入します。

データの読み込みからマージまで

import pandas as pd
import seaborn as sns


problems = pd.read_csv("csv/problems.csv")
submissions = pd.read_csv("csv/submissions.csv")

problems.columns = ["problem_name", "rank", "difficulty"]
submissions.columns = ["problem_name", "bytes", "score", "language", "time"]
submissions = submissions.dropna()

prob_rank = problems.loc[:, ["problem_name", "rank"]]
submissions_with_rank = pd.merge(submissions, prob_rank).sort_values(by=["rank", "problem_name"])

階層的インデックスの作成

rank_and_name = submissions_with_rank.loc[:, ["rank", "problem_name"]]
mind = pd.MultiIndex.from_frame(rank_and_name)

階層的インデックスの貼り付け

ranked_submissions = submissions_with_rank.loc[:, ["bytes", "score", "language", "time"]]
ranked_submissions.index = mind
ranked_submissions

プログラミング学習 > Python3 > Pythonデータ分析入門編 > Pythonデータ分析入門編11: データ分析の実践 > 階層的インデックスの導入