Last active
January 26, 2018 13:49
-
-
Save kurozumi/a7f41c5ece72333b1b9c819948abf6c1 to your computer and use it in GitHub Desktop.
行列のデータフレームの末尾3件を取得
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(\"ABCD\"))" | |
] | |
}, | |
{ | |
"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>A</th>\n", | |
" <th>B</th>\n", | |
" <th>C</th>\n", | |
" <th>D</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>2018-01-01</th>\n", | |
" <td>0.062009</td>\n", | |
" <td>1.222085</td>\n", | |
" <td>0.559426</td>\n", | |
" <td>-1.809076</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-02</th>\n", | |
" <td>0.393914</td>\n", | |
" <td>-0.083653</td>\n", | |
" <td>0.285802</td>\n", | |
" <td>-1.211543</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-03</th>\n", | |
" <td>0.927525</td>\n", | |
" <td>0.822686</td>\n", | |
" <td>0.548677</td>\n", | |
" <td>-1.012553</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-04</th>\n", | |
" <td>0.440544</td>\n", | |
" <td>1.452782</td>\n", | |
" <td>2.589600</td>\n", | |
" <td>-0.857695</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-05</th>\n", | |
" <td>0.667614</td>\n", | |
" <td>0.876755</td>\n", | |
" <td>-0.451620</td>\n", | |
" <td>-1.393519</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-06</th>\n", | |
" <td>-0.463145</td>\n", | |
" <td>0.261588</td>\n", | |
" <td>-0.546962</td>\n", | |
" <td>-0.047444</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-07</th>\n", | |
" <td>0.672490</td>\n", | |
" <td>-0.196664</td>\n", | |
" <td>1.303628</td>\n", | |
" <td>-0.069886</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-08</th>\n", | |
" <td>-0.487551</td>\n", | |
" <td>0.306425</td>\n", | |
" <td>0.797411</td>\n", | |
" <td>-0.834169</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-09</th>\n", | |
" <td>-1.413734</td>\n", | |
" <td>0.325359</td>\n", | |
" <td>-1.059299</td>\n", | |
" <td>0.848504</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-10</th>\n", | |
" <td>-0.973909</td>\n", | |
" <td>1.408018</td>\n", | |
" <td>-0.514767</td>\n", | |
" <td>1.039045</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" A B C D\n", | |
"2018-01-01 0.062009 1.222085 0.559426 -1.809076\n", | |
"2018-01-02 0.393914 -0.083653 0.285802 -1.211543\n", | |
"2018-01-03 0.927525 0.822686 0.548677 -1.012553\n", | |
"2018-01-04 0.440544 1.452782 2.589600 -0.857695\n", | |
"2018-01-05 0.667614 0.876755 -0.451620 -1.393519\n", | |
"2018-01-06 -0.463145 0.261588 -0.546962 -0.047444\n", | |
"2018-01-07 0.672490 -0.196664 1.303628 -0.069886\n", | |
"2018-01-08 -0.487551 0.306425 0.797411 -0.834169\n", | |
"2018-01-09 -1.413734 0.325359 -1.059299 0.848504\n", | |
"2018-01-10 -0.973909 1.408018 -0.514767 1.039045" | |
] | |
}, | |
"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>A</th>\n", | |
" <th>B</th>\n", | |
" <th>C</th>\n", | |
" <th>D</th>\n", | |
" </tr>\n", | |
" </thead>\n", | |
" <tbody>\n", | |
" <tr>\n", | |
" <th>2018-01-08</th>\n", | |
" <td>-0.487551</td>\n", | |
" <td>0.306425</td>\n", | |
" <td>0.797411</td>\n", | |
" <td>-0.834169</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-09</th>\n", | |
" <td>-1.413734</td>\n", | |
" <td>0.325359</td>\n", | |
" <td>-1.059299</td>\n", | |
" <td>0.848504</td>\n", | |
" </tr>\n", | |
" <tr>\n", | |
" <th>2018-01-10</th>\n", | |
" <td>-0.973909</td>\n", | |
" <td>1.408018</td>\n", | |
" <td>-0.514767</td>\n", | |
" <td>1.039045</td>\n", | |
" </tr>\n", | |
" </tbody>\n", | |
"</table>\n", | |
"</div>" | |
], | |
"text/plain": [ | |
" A B C D\n", | |
"2018-01-08 -0.487551 0.306425 0.797411 -0.834169\n", | |
"2018-01-09 -1.413734 0.325359 -1.059299 0.848504\n", | |
"2018-01-10 -0.973909 1.408018 -0.514767 1.039045" | |
] | |
}, | |
"execution_count": 5, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
], | |
"source": [ | |
"# 末尾の3件取得\n", | |
"df.tail(3)" | |
] | |
} | |
], | |
"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