Created
January 27, 2018 01:22
-
-
Save kurozumi/65acf967e58b79aa98ee8a2d67ecf3cf to your computer and use it in GitHub Desktop.
ラベルで特定の値を変更する
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"cells": [ | |
{ | |
"cell_type": "code", | |
"execution_count": 1, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"import pandas as pd\n", | |
"import numpy as np" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 2, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"# index作成\n", | |
"dates = pd.date_range('20180101', periods=10)" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 3, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"# 行列のデータフレーム作成\n", | |
"df = pd.DataFrame(np.random.randn(10,4), index=dates, columns=list(\"1ACB\"))" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 4, | |
"metadata": {}, | |
"outputs": [ | |
{ | |
"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>1</th>\n", | |
" <th>A</th>\n", | |
" <th>C</th>\n", | |
" <th>B</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>2018-01-01</th>\n", | |
" <td>0.343787</td>\n", | |
" <td>0.730620</td>\n", | |
" <td>0.971314</td>\n", | |
" <td>0.110791</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-02</th>\n", | |
" <td>-2.184073</td>\n", | |
" <td>0.050702</td>\n", | |
" <td>-1.320158</td>\n", | |
" <td>0.568659</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-03</th>\n", | |
" <td>-0.783584</td>\n", | |
" <td>-0.190158</td>\n", | |
" <td>-0.843137</td>\n", | |
" <td>-0.084990</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-04</th>\n", | |
" <td>0.553377</td>\n", | |
" <td>-1.059913</td>\n", | |
" <td>0.120512</td>\n", | |
" <td>0.228676</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-05</th>\n", | |
" <td>-0.032170</td>\n", | |
" <td>2.273963</td>\n", | |
" <td>-1.762723</td>\n", | |
" <td>1.214359</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-06</th>\n", | |
" <td>1.295869</td>\n", | |
" <td>-0.072868</td>\n", | |
" <td>-0.609897</td>\n", | |
" <td>0.985460</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-07</th>\n", | |
" <td>0.789622</td>\n", | |
" <td>-0.211940</td>\n", | |
" <td>-0.355315</td>\n", | |
" <td>-0.987213</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-08</th>\n", | |
" <td>1.265053</td>\n", | |
" <td>-2.096299</td>\n", | |
" <td>-1.813753</td>\n", | |
" <td>0.661746</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-09</th>\n", | |
" <td>-0.902311</td>\n", | |
" <td>-1.825924</td>\n", | |
" <td>0.684127</td>\n", | |
" <td>0.973658</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-10</th>\n", | |
" <td>0.477821</td>\n", | |
" <td>-0.300853</td>\n", | |
" <td>-0.937487</td>\n", | |
" <td>1.056285</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" 1 A C B\n", | |
"2018-01-01 0.343787 0.730620 0.971314 0.110791\n", | |
"2018-01-02 -2.184073 0.050702 -1.320158 0.568659\n", | |
"2018-01-03 -0.783584 -0.190158 -0.843137 -0.084990\n", | |
"2018-01-04 0.553377 -1.059913 0.120512 0.228676\n", | |
"2018-01-05 -0.032170 2.273963 -1.762723 1.214359\n", | |
"2018-01-06 1.295869 -0.072868 -0.609897 0.985460\n", | |
"2018-01-07 0.789622 -0.211940 -0.355315 -0.987213\n", | |
"2018-01-08 1.265053 -2.096299 -1.813753 0.661746\n", | |
"2018-01-09 -0.902311 -1.825924 0.684127 0.973658\n", | |
"2018-01-10 0.477821 -0.300853 -0.937487 1.056285" | |
] | |
}, | |
"execution_count": 4, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"# データフレーム表示\n", | |
"df" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 5, | |
"metadata": {}, | |
"outputs": [], | |
"source": [ | |
"# A列の2018-01-01の値を0にする\n", | |
"df.at[\"2018-01-01\",\"A\"]=0" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 6, | |
"metadata": {}, | |
"outputs": [ | |
{ | |
"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>1</th>\n", | |
" <th>A</th>\n", | |
" <th>C</th>\n", | |
" <th>B</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>2018-01-01</th>\n", | |
" <td>0.343787</td>\n", | |
" <td>0.000000</td>\n", | |
" <td>0.971314</td>\n", | |
" <td>0.110791</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-02</th>\n", | |
" <td>-2.184073</td>\n", | |
" <td>0.050702</td>\n", | |
" <td>-1.320158</td>\n", | |
" <td>0.568659</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-03</th>\n", | |
" <td>-0.783584</td>\n", | |
" <td>-0.190158</td>\n", | |
" <td>-0.843137</td>\n", | |
" <td>-0.084990</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-04</th>\n", | |
" <td>0.553377</td>\n", | |
" <td>-1.059913</td>\n", | |
" <td>0.120512</td>\n", | |
" <td>0.228676</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-05</th>\n", | |
" <td>-0.032170</td>\n", | |
" <td>2.273963</td>\n", | |
" <td>-1.762723</td>\n", | |
" <td>1.214359</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-06</th>\n", | |
" <td>1.295869</td>\n", | |
" <td>-0.072868</td>\n", | |
" <td>-0.609897</td>\n", | |
" <td>0.985460</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-07</th>\n", | |
" <td>0.789622</td>\n", | |
" <td>-0.211940</td>\n", | |
" <td>-0.355315</td>\n", | |
" <td>-0.987213</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-08</th>\n", | |
" <td>1.265053</td>\n", | |
" <td>-2.096299</td>\n", | |
" <td>-1.813753</td>\n", | |
" <td>0.661746</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-09</th>\n", | |
" <td>-0.902311</td>\n", | |
" <td>-1.825924</td>\n", | |
" <td>0.684127</td>\n", | |
" <td>0.973658</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-10</th>\n", | |
" <td>0.477821</td>\n", | |
" <td>-0.300853</td>\n", | |
" <td>-0.937487</td>\n", | |
" <td>1.056285</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" 1 A C B\n", | |
"2018-01-01 0.343787 0.000000 0.971314 0.110791\n", | |
"2018-01-02 -2.184073 0.050702 -1.320158 0.568659\n", | |
"2018-01-03 -0.783584 -0.190158 -0.843137 -0.084990\n", | |
"2018-01-04 0.553377 -1.059913 0.120512 0.228676\n", | |
"2018-01-05 -0.032170 2.273963 -1.762723 1.214359\n", | |
"2018-01-06 1.295869 -0.072868 -0.609897 0.985460\n", | |
"2018-01-07 0.789622 -0.211940 -0.355315 -0.987213\n", | |
"2018-01-08 1.265053 -2.096299 -1.813753 0.661746\n", | |
"2018-01-09 -0.902311 -1.825924 0.684127 0.973658\n", | |
"2018-01-10 0.477821 -0.300853 -0.937487 1.056285" | |
] | |
}, | |
"execution_count": 6, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"df" | |
] | |
} | |
], | |
"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.2" | |
} | |
}, | |
"nbformat": 4, | |
"nbformat_minor": 2 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment