Skip to content

Instantly share code, notes, and snippets.

@kurozumi

kurozumi/ラベルで特定の値を変更する.ipynb

Created January 27, 2018 01:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kurozumi/65acf967e58b79aa98ee8a2d67ecf3cf to your computer and use it in GitHub Desktop.
Save kurozumi/65acf967e58b79aa98ee8a2d67ecf3cf to your computer and use it in GitHub Desktop.
Download ZIP
ラベルで特定の値を変更する
Display the source blob
Display the rendered blob
Raw
ラベルで特定の値を変更する.ipynb
{
"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