Skip to content

Instantly share code, notes, and snippets.

@dalejung

dalejung/Untitled0.ipynb

Created March 4, 2014 07:11
Show Gist options
  • Save dalejung/9341665 to your computer and use it in GitHub Desktop.
Save dalejung/9341665 to your computer and use it in GitHub Desktop.
Download ZIP
pandas subclass.ipynb #notebook #pandas
Display the source blob
Display the rendered blob
Raw
Untitled0.ipynb
{
"metadata": {
"gist_id": "9341665",
"name": ""
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd\n",
"import numpy as np\n",
"from pandas_composition import UserFrame\n",
"from pandas.util.testing import makeTimeDataFrame"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1,
"trusted": true
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"class MyDF(UserFrame):\n",
" pass"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2,
"trusted": true
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df = MyDF(makeTimeDataFrame())\n",
"df.bob = 'bob'\n",
"df"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\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>2000-01-03</th>\n",
" <td> 1.615029</td>\n",
" <td> 0.009087</td>\n",
" <td> 0.358457</td>\n",
" <td>-0.463264</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-04</th>\n",
" <td>-1.335554</td>\n",
" <td> 0.370659</td>\n",
" <td> 0.151011</td>\n",
" <td> 0.840928</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-05</th>\n",
" <td> 0.360234</td>\n",
" <td> 0.128044</td>\n",
" <td>-2.653640</td>\n",
" <td>-0.731628</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-06</th>\n",
" <td>-0.118904</td>\n",
" <td> 1.553084</td>\n",
" <td> 0.878501</td>\n",
" <td>-0.634919</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-07</th>\n",
" <td> 0.338586</td>\n",
" <td> 1.381917</td>\n",
" <td>-0.949115</td>\n",
" <td>-0.671998</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-10</th>\n",
" <td> 0.454369</td>\n",
" <td>-0.105907</td>\n",
" <td> 0.019780</td>\n",
" <td> 0.085394</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-11</th>\n",
" <td>-1.714688</td>\n",
" <td> 1.157587</td>\n",
" <td>-2.335567</td>\n",
" <td> 0.815834</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-12</th>\n",
" <td> 0.885415</td>\n",
" <td>-1.120692</td>\n",
" <td> 1.950598</td>\n",
" <td> 0.658885</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-13</th>\n",
" <td> 1.758453</td>\n",
" <td>-2.225660</td>\n",
" <td>-0.141265</td>\n",
" <td>-0.099430</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-14</th>\n",
" <td>-0.715933</td>\n",
" <td> 0.834354</td>\n",
" <td> 0.085394</td>\n",
" <td> 0.579792</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-17</th>\n",
" <td>-0.484428</td>\n",
" <td> 1.378007</td>\n",
" <td>-0.427305</td>\n",
" <td> 0.504311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-18</th>\n",
" <td> 0.777735</td>\n",
" <td> 0.600269</td>\n",
" <td> 0.982017</td>\n",
" <td> 0.062108</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-19</th>\n",
" <td>-0.381019</td>\n",
" <td>-1.166852</td>\n",
" <td>-0.823086</td>\n",
" <td> 0.296946</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-20</th>\n",
" <td>-0.521043</td>\n",
" <td> 0.034916</td>\n",
" <td>-0.227630</td>\n",
" <td>-1.547516</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-21</th>\n",
" <td>-0.418713</td>\n",
" <td> 1.494445</td>\n",
" <td> 1.001609</td>\n",
" <td> 0.595597</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-24</th>\n",
" <td>-1.407347</td>\n",
" <td> 0.515987</td>\n",
" <td>-2.497593</td>\n",
" <td> 1.203336</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-25</th>\n",
" <td> 1.001143</td>\n",
" <td> 1.003524</td>\n",
" <td>-0.435176</td>\n",
" <td> 1.514314</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-26</th>\n",
" <td>-0.750962</td>\n",
" <td> 0.963102</td>\n",
" <td>-0.668792</td>\n",
" <td>-0.915797</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-27</th>\n",
" <td>-0.037863</td>\n",
" <td>-0.812883</td>\n",
" <td>-0.691380</td>\n",
" <td> 0.104202</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-28</th>\n",
" <td>-1.203456</td>\n",
" <td> 1.287130</td>\n",
" <td>-0.437188</td>\n",
" <td> 0.394575</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-01-31</th>\n",
" <td>-0.892800</td>\n",
" <td> 1.109638</td>\n",
" <td> 0.026060</td>\n",
" <td>-1.950588</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-01</th>\n",
" <td>-0.561066</td>\n",
" <td> 0.187243</td>\n",
" <td>-0.034548</td>\n",
" <td> 2.187180</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-02</th>\n",
" <td> 1.616250</td>\n",
" <td>-0.671796</td>\n",
" <td> 1.035332</td>\n",
" <td> 1.765733</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-03</th>\n",
" <td> 1.395126</td>\n",
" <td>-1.288225</td>\n",
" <td>-1.205700</td>\n",
" <td> 0.429969</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-04</th>\n",
" <td> 0.258943</td>\n",
" <td>-0.564847</td>\n",
" <td> 0.482918</td>\n",
" <td> 1.315050</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-07</th>\n",
" <td>-0.256504</td>\n",
" <td> 0.356099</td>\n",
" <td>-1.011129</td>\n",
" <td> 0.843477</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-08</th>\n",
" <td>-0.197410</td>\n",
" <td> 1.352511</td>\n",
" <td>-0.838855</td>\n",
" <td> 3.008582</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-09</th>\n",
" <td> 0.707144</td>\n",
" <td>-0.661041</td>\n",
" <td>-0.146464</td>\n",
" <td> 0.129930</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-10</th>\n",
" <td> 0.536442</td>\n",
" <td> 1.106442</td>\n",
" <td>-0.020321</td>\n",
" <td> 1.636039</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2000-02-11</th>\n",
" <td> 0.698855</td>\n",
" <td>-1.302479</td>\n",
" <td>-0.144498</td>\n",
" <td> 0.073160</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>30 rows \u00d7 4 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 3,
"text": [
" A B C D\n",
"2000-01-03 1.615029 0.009087 0.358457 -0.463264\n",
"2000-01-04 -1.335554 0.370659 0.151011 0.840928\n",
"2000-01-05 0.360234 0.128044 -2.653640 -0.731628\n",
"2000-01-06 -0.118904 1.553084 0.878501 -0.634919\n",
"2000-01-07 0.338586 1.381917 -0.949115 -0.671998\n",
"2000-01-10 0.454369 -0.105907 0.019780 0.085394\n",
"2000-01-11 -1.714688 1.157587 -2.335567 0.815834\n",
"2000-01-12 0.885415 -1.120692 1.950598 0.658885\n",
"2000-01-13 1.758453 -2.225660 -0.141265 -0.099430\n",
"2000-01-14 -0.715933 0.834354 0.085394 0.579792\n",
"2000-01-17 -0.484428 1.378007 -0.427305 0.504311\n",
"2000-01-18 0.777735 0.600269 0.982017 0.062108\n",
"2000-01-19 -0.381019 -1.166852 -0.823086 0.296946\n",
"2000-01-20 -0.521043 0.034916 -0.227630 -1.547516\n",
"2000-01-21 -0.418713 1.494445 1.001609 0.595597\n",
"2000-01-24 -1.407347 0.515987 -2.497593 1.203336\n",
"2000-01-25 1.001143 1.003524 -0.435176 1.514314\n",
"2000-01-26 -0.750962 0.963102 -0.668792 -0.915797\n",
"2000-01-27 -0.037863 -0.812883 -0.691380 0.104202\n",
"2000-01-28 -1.203456 1.287130 -0.437188 0.394575\n",
"2000-01-31 -0.892800 1.109638 0.026060 -1.950588\n",
"2000-02-01 -0.561066 0.187243 -0.034548 2.187180\n",
"2000-02-02 1.616250 -0.671796 1.035332 1.765733\n",
"2000-02-03 1.395126 -1.288225 -1.205700 0.429969\n",
"2000-02-04 0.258943 -0.564847 0.482918 1.315050\n",
"2000-02-07 -0.256504 0.356099 -1.011129 0.843477\n",
"2000-02-08 -0.197410 1.352511 -0.838855 3.008582\n",
"2000-02-09 0.707144 -0.661041 -0.146464 0.129930\n",
"2000-02-10 0.536442 1.106442 -0.020321 1.636039\n",
"2000-02-11 0.698855 -1.302479 -0.144498 0.073160\n",
"\n",
"[30 rows x 4 columns]"
]
}
],
"prompt_number": 3,
"trusted": true
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df['A']"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 17,
"text": [
"2000-01-03 1.366712\n",
"2000-01-04 0.086788\n",
"2000-01-05 0.701502\n",
"2000-01-06 1.397725\n",
"2000-01-07 0.928110\n",
"2000-01-10 -0.512146\n",
"2000-01-11 0.290489\n",
"2000-01-12 0.789864\n",
"2000-01-13 -0.669606\n",
"2000-01-14 -0.601699\n",
"2000-01-17 -0.029730\n",
"2000-01-18 1.171203\n",
"2000-01-19 0.440244\n",
"2000-01-20 -1.013874\n",
"2000-01-21 -0.360401\n",
"2000-01-24 -0.408641\n",
"2000-01-25 -0.928428\n",
"2000-01-26 0.041556\n",
"2000-01-27 2.044523\n",
"2000-01-28 1.533413\n",
"2000-01-31 -0.520551\n",
"2000-02-01 -0.949044\n",
"2000-02-02 -0.563511\n",
"2000-02-03 0.400950\n",
"2000-02-04 0.450674\n",
"2000-02-07 0.410786\n",
"2000-02-08 0.430578\n",
"2000-02-09 0.125044\n",
"2000-02-10 -2.187874\n",
"2000-02-11 -0.898575\n",
"Freq: B, Name: A, dtype: float64"
]
}
],
"prompt_number": 17,
"trusted": false
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment