Skip to content

Instantly share code, notes, and snippets.

@jshirius

jshirius/One_hot_doc.ipynb

Created October 23, 2019 14:39
Show Gist options
  • Save jshirius/51a5137692f5b2301ffe51e6a4351951 to your computer and use it in GitHub Desktop.
Save jshirius/51a5137692f5b2301ffe51e6a4351951 to your computer and use it in GitHub Desktop.
Download ZIP
one-hot source
Display the source blob
Display the rendered blob
Raw
One_hot_doc.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"-----one hot表現する前------\n"
]
},
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>会員ID</th>\n",
" <th>買った回数</th>\n",
" <th>買い物の総合計</th>\n",
" <th>支払い種別</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>600</td>\n",
" <td>cash</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>1000</td>\n",
" <td>card1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>4</td>\n",
" <td>2000</td>\n",
" <td>card1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>2400</td>\n",
" <td>card2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>7</td>\n",
" <td>900</td>\n",
" <td>card3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>6</td>\n",
" <td>8</td>\n",
" <td>2200</td>\n",
" <td>card3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 会員ID 買った回数 買い物の総合計 支払い種別\n",
"0 1 3 600 cash\n",
"1 2 4 1000 card1\n",
"2 3 4 2000 card1\n",
"3 4 1 2400 card2\n",
"4 5 7 900 card3\n",
"5 6 8 2200 card3"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"-----one hot表現後------\n"
]
},
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>会員ID</th>\n",
" <th>買った回数</th>\n",
" <th>買い物の総合計</th>\n",
" <th>支払い種別_card1</th>\n",
" <th>支払い種別_card2</th>\n",
" <th>支払い種別_card3</th>\n",
" <th>支払い種別_cash</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>600</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>1000</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>4</td>\n",
" <td>2000</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>2400</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>7</td>\n",
" <td>900</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>6</td>\n",
" <td>8</td>\n",
" <td>2200</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 会員ID 買った回数 買い物の総合計 支払い種別_card1 支払い種別_card2 支払い種別_card3 支払い種別_cash\n",
"0 1 3 600 0 0 0 1\n",
"1 2 4 1000 1 0 0 0\n",
"2 3 4 2000 1 0 0 0\n",
"3 4 1 2400 0 1 0 0\n",
"4 5 7 900 0 0 1 0\n",
"5 6 8 2200 0 0 1 0"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"from IPython.core.display import display\n",
"\n",
"\n",
"df = pd.read_csv('one_hot' + '.csv', header=0) \n",
"\n",
"print(\"-----one hot表現する前------\")\n",
"display(df)\n",
"\n",
"one_hot = pd.get_dummies(df)\n",
"#one_hot = pd.get_dummies(df['支払い種別'])\n",
"print(\"-----one hot表現後------\")\n",
"display(one_hot)"
]
}
],
"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.6.8"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment