Skip to content

Instantly share code, notes, and snippets.

@kurozumi

kurozumi/末尾3件取得.ipynb

Last active January 26, 2018 13:49
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/a7f41c5ece72333b1b9c819948abf6c1 to your computer and use it in GitHub Desktop.
Save kurozumi/a7f41c5ece72333b1b9c819948abf6c1 to your computer and use it in GitHub Desktop.
Download ZIP
行列のデータフレームの末尾3件を取得
Display the source blob
Display the rendered blob
Raw
末尾3件取得.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(\"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