Created
January 26, 2018 14:55
-
-
Save kurozumi/6e0f14fd3d55f2f1e508e6689525974c 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>1.312163</td>\n", | |
" <td>1.005007</td>\n", | |
" <td>-0.809235</td>\n", | |
" <td>0.130603</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-02</th>\n", | |
" <td>0.822625</td>\n", | |
" <td>0.622604</td>\n", | |
" <td>1.951516</td>\n", | |
" <td>-0.941157</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-03</th>\n", | |
" <td>-0.385865</td>\n", | |
" <td>0.362374</td>\n", | |
" <td>1.060811</td>\n", | |
" <td>-0.660205</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-04</th>\n", | |
" <td>-2.134609</td>\n", | |
" <td>-1.120589</td>\n", | |
" <td>-0.413001</td>\n", | |
" <td>-0.517769</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-05</th>\n", | |
" <td>0.721890</td>\n", | |
" <td>0.980838</td>\n", | |
" <td>-0.449469</td>\n", | |
" <td>2.000011</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-06</th>\n", | |
" <td>2.046184</td>\n", | |
" <td>0.041131</td>\n", | |
" <td>-0.405716</td>\n", | |
" <td>0.624973</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-07</th>\n", | |
" <td>1.287008</td>\n", | |
" <td>-0.746969</td>\n", | |
" <td>2.964660</td>\n", | |
" <td>-0.068059</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-08</th>\n", | |
" <td>0.679277</td>\n", | |
" <td>-0.489561</td>\n", | |
" <td>0.703974</td>\n", | |
" <td>0.483894</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-09</th>\n", | |
" <td>-1.227798</td>\n", | |
" <td>-0.139707</td>\n", | |
" <td>0.615293</td>\n", | |
" <td>-2.123351</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-10</th>\n", | |
" <td>-0.084955</td>\n", | |
" <td>0.527356</td>\n", | |
" <td>1.100032</td>\n", | |
" <td>1.527765</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" 1 A C B\n", | |
"2018-01-01 1.312163 1.005007 -0.809235 0.130603\n", | |
"2018-01-02 0.822625 0.622604 1.951516 -0.941157\n", | |
"2018-01-03 -0.385865 0.362374 1.060811 -0.660205\n", | |
"2018-01-04 -2.134609 -1.120589 -0.413001 -0.517769\n", | |
"2018-01-05 0.721890 0.980838 -0.449469 2.000011\n", | |
"2018-01-06 2.046184 0.041131 -0.405716 0.624973\n", | |
"2018-01-07 1.287008 -0.746969 2.964660 -0.068059\n", | |
"2018-01-08 0.679277 -0.489561 0.703974 0.483894\n", | |
"2018-01-09 -1.227798 -0.139707 0.615293 -2.123351\n", | |
"2018-01-10 -0.084955 0.527356 1.100032 1.527765" | |
] | |
}, | |
"execution_count": 4, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"# データフレーム表示\n", | |
"df" | |
] | |
}, | |
{ | |
"cell_type": "code", | |
"execution_count": 5, | |
"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>C</th>\n", | |
" <th>B</th>\n", | |
" <th>A</th>\n", | |
" <th>1</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>2018-01-01</th>\n", | |
" <td>-0.809235</td>\n", | |
" <td>0.130603</td>\n", | |
" <td>1.005007</td>\n", | |
" <td>1.312163</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-02</th>\n", | |
" <td>1.951516</td>\n", | |
" <td>-0.941157</td>\n", | |
" <td>0.622604</td>\n", | |
" <td>0.822625</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-03</th>\n", | |
" <td>1.060811</td>\n", | |
" <td>-0.660205</td>\n", | |
" <td>0.362374</td>\n", | |
" <td>-0.385865</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-04</th>\n", | |
" <td>-0.413001</td>\n", | |
" <td>-0.517769</td>\n", | |
" <td>-1.120589</td>\n", | |
" <td>-2.134609</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-05</th>\n", | |
" <td>-0.449469</td>\n", | |
" <td>2.000011</td>\n", | |
" <td>0.980838</td>\n", | |
" <td>0.721890</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-06</th>\n", | |
" <td>-0.405716</td>\n", | |
" <td>0.624973</td>\n", | |
" <td>0.041131</td>\n", | |
" <td>2.046184</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-07</th>\n", | |
" <td>2.964660</td>\n", | |
" <td>-0.068059</td>\n", | |
" <td>-0.746969</td>\n", | |
" <td>1.287008</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-08</th>\n", | |
" <td>0.703974</td>\n", | |
" <td>0.483894</td>\n", | |
" <td>-0.489561</td>\n", | |
" <td>0.679277</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-09</th>\n", | |
" <td>0.615293</td>\n", | |
" <td>-2.123351</td>\n", | |
" <td>-0.139707</td>\n", | |
" <td>-1.227798</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-10</th>\n", | |
" <td>1.100032</td>\n", | |
" <td>1.527765</td>\n", | |
" <td>0.527356</td>\n", | |
" <td>-0.084955</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" C B A 1\n", | |
"2018-01-01 -0.809235 0.130603 1.005007 1.312163\n", | |
"2018-01-02 1.951516 -0.941157 0.622604 0.822625\n", | |
"2018-01-03 1.060811 -0.660205 0.362374 -0.385865\n", | |
"2018-01-04 -0.413001 -0.517769 -1.120589 -2.134609\n", | |
"2018-01-05 -0.449469 2.000011 0.980838 0.721890\n", | |
"2018-01-06 -0.405716 0.624973 0.041131 2.046184\n", | |
"2018-01-07 2.964660 -0.068059 -0.746969 1.287008\n", | |
"2018-01-08 0.703974 0.483894 -0.489561 0.679277\n", | |
"2018-01-09 0.615293 -2.123351 -0.139707 -1.227798\n", | |
"2018-01-10 1.100032 1.527765 0.527356 -0.084955" | |
] | |
}, | |
"execution_count": 5, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"# カラム名でソートする\n", | |
"df.sort_index(axis=1, ascending=False)" | |
] | |
} | |
], | |
"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