{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"from pandas import DataFrame"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"
\n",
" \n",
" \n",
" | \n",
" altitude | \n",
" city | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 3158 | \n",
" Alma | \n",
"
\n",
" \n",
" 1 | \n",
" 3000 | \n",
" Brian Head | \n",
"
\n",
" \n",
" 2 | \n",
" 2762 | \n",
" Fox Park | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" altitude city\n",
"0 3158 Alma\n",
"1 3000 Brian Head\n",
"2 2762 Fox Park"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# 簡単なDataFrameを作ります。\n",
"dframe = DataFrame({'city':['Alma','Brian Head','Fox Park'],\n",
" 'altitude':[3158,3000,2762]})\n",
"dframe"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"# マッピングを使うと、簡単に列を追加できます。\n",
"state_map={'Alma':'Colorado','Brian Head':'Utah','Fox Park':'Wyoming'}"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"# mapメソッドを使います。\n",
"dframe['state'] = dframe['city'].map(state_map)"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" altitude | \n",
" city | \n",
" state | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 3158 | \n",
" Alma | \n",
" Colorado | \n",
"
\n",
" \n",
" 1 | \n",
" 3000 | \n",
" Brian Head | \n",
" Utah | \n",
"
\n",
" \n",
" 2 | \n",
" 2762 | \n",
" Fox Park | \n",
" Wyoming | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" altitude city state\n",
"0 3158 Alma Colorado\n",
"1 3000 Brian Head Utah\n",
"2 2762 Fox Park Wyoming"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dframe"
]
}
],
"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.4.3"
}
},
"nbformat": 4,
"nbformat_minor": 0
}