Skip to content

Instantly share code, notes, and snippets.

@jivens

jivens/pandas_loading_dataframe.ipynb

Created February 7, 2017 19:44
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jivens/8383dcabb71857d1d4605d430aed6e24 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jivens/8383dcabb71857d1d4605d430aed6e24 to your computer and use it in GitHub Desktop.
Download ZIP
New pandas dataframe load
Display the source blob
Display the rendered blob
Raw
pandas_loading_dataframe.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import numpy as np"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/Users/amyfou/anaconda3/envs/ml/lib/python3.6/site-packages/matplotlib/font_manager.py:280: UserWarning: Matplotlib is building the font cache using fc-list. This may take a moment.\n",
" 'Matplotlib is building the font cache using fc-list. '\n"
]
}
],
"source": [
"import matplotlib.pyplot as plt"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data = np.zeros((2,), dtype=[('A', 'i4'),('B', 'f4'),('C', 'a10')])"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"array([(0, 0.0, b''), (0, 0.0, b'')], \n",
" dtype=[('A', '<i4'), ('B', '<f4'), ('C', 'S10')])"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data[:] = [(1,2.,'Hello'), (2,3.,\"World\")]"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"array([(1, 2.0, b'Hello'), (2, 3.0, b'World')], \n",
" dtype=[('A', '<i4'), ('B', '<f4'), ('C', 'S10')])"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [
{
"ename": "AttributeError",
"evalue": "module 'pandas' has no attribute 'dataFrame'",
"output_type": "error",
"traceback": [
"\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
"\u001b[0;31mAttributeError\u001b[0m Traceback (most recent call last)",
"\u001b[0;32m<ipython-input-9-2a28ea12b996>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdataFrame\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[0;31mAttributeError\u001b[0m: module 'pandas' has no attribute 'dataFrame'"
]
}
],
"source": [
"pd.dataFrame(data)"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\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",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>2.0</td>\n",
" <td>b'Hello'</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>3.0</td>\n",
" <td>b'World'</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" A B C\n",
"0 1 2.0 b'Hello'\n",
"1 2 3.0 b'World'"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.DataFrame(data)"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data2 = [{'a': 1, 'b': 2}, {'a': 5, 'b': 10, 'c': 20}]"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"[{'a': 1, 'b': 2}, {'a': 5, 'b': 10, 'c': 20}]"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data2"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\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",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5</td>\n",
" <td>10</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" a b c\n",
"0 1 2 NaN\n",
"1 5 10 20.0"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.DataFrame(data2)"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {
"collapsed": false
},
"outputs": [
{
"ename": "AttributeError",
"evalue": "module 'pandas' has no attribute 'read_tsv'",
"output_type": "error",
"traceback": [
"\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
"\u001b[0;31mAttributeError\u001b[0m Traceback (most recent call last)",
"\u001b[0;32m<ipython-input-14-84545df27fd2>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdata3\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_tsv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'/Users/amyfou/Downloads/path_data.tsv'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[0;31mAttributeError\u001b[0m: module 'pandas' has no attribute 'read_tsv'"
]
}
],
"source": [
"data3 = pd.read_tsv('/Users/amyfou/Downloads/path_data.tsv')"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"data3 = pd.read_table('/Users/amyfou/Downloads/path_data.tsv',sep='\\t')"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Event</th>\n",
" <th>Trigger</th>\n",
" <th>Trigger Tags</th>\n",
" <th>Argument</th>\n",
" <th>Argument Type</th>\n",
" <th>Path</th>\n",
" <th>Path Length</th>\n",
" <th>Pattern Frequency</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Gene_expression</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>382</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Gene_expression</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>201</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Gene_expression</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>122</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>121</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Gene_expression</td>\n",
" <td>trigger = [lemma='production' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>91</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Phosphorylation</td>\n",
" <td>trigger = [lemma='phosphorylation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Phosphorylation</td>\n",
" <td>trigger = [lemma='phosphorylation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Site</td>\n",
" <td>Entity</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='induce' &amp; tag='VBD']</td>\n",
" <td>'VBD'</td>\n",
" <td>Theme</td>\n",
" <td>Gene_expression</td>\n",
" <td>&gt;dobj</td>\n",
" <td>1</td>\n",
" <td>41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='induction' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>39</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='activation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='induction' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>35</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Binding</td>\n",
" <td>trigger = [lemma='binding' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Localization</td>\n",
" <td>trigger = [lemma='secretion' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Gene_expression</td>\n",
" <td>trigger = [lemma='express' &amp; tag='VBN']</td>\n",
" <td>'VBN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nsubjpass</td>\n",
" <td>1</td>\n",
" <td>32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='activation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Regulation</td>\n",
" <td>trigger = [lemma='regulation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Gene_expression</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>31</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Localization</td>\n",
" <td>trigger = [lemma='translocation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>ToLoc</td>\n",
" <td>Entity</td>\n",
" <td>&gt;amod</td>\n",
" <td>1</td>\n",
" <td>30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Phosphorylation</td>\n",
" <td>trigger = [lemma='phosphorylation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='induction' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='activation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Gene_expression</td>\n",
" <td>trigger = [lemma='production' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='induce' &amp; tag='VBD']</td>\n",
" <td>'VBD'</td>\n",
" <td>Cause</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nsubj</td>\n",
" <td>1</td>\n",
" <td>26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Regulation</td>\n",
" <td>trigger = [lemma='regulate' &amp; tag='VBN']</td>\n",
" <td>'VBN'</td>\n",
" <td>Theme</td>\n",
" <td>Gene_expression</td>\n",
" <td>&gt;nsubjpass</td>\n",
" <td>1</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Positive_regulation</td>\n",
" <td>trigger = [lemma='induction' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Gene_expression</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Negative_regulation</td>\n",
" <td>trigger = [lemma='inhibit' &amp; tag='VBD']</td>\n",
" <td>'VBD'</td>\n",
" <td>Theme</td>\n",
" <td>Positive_regulation</td>\n",
" <td>&gt;dobj</td>\n",
" <td>1</td>\n",
" <td>23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Gene_expression</td>\n",
" <td>trigger = [lemma='overexpression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Protein_catabolism</td>\n",
" <td>trigger = [lemma='degradation' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of</td>\n",
" <td>1</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4996</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;dep</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4997</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='mrna' &amp; tag='NN'] [lemma='le...</td>\n",
" <td>'NN' 'NNS'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_for &gt;nn</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4998</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_with &gt;nsubjpass &gt;prep_of &gt;prep_on &gt;nn</td>\n",
" <td>5</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4999</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcriptional' &amp; tag='JJ']...</td>\n",
" <td>'JJ' 'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_at &gt;nsubjpass &gt;dep &gt;nn</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5000</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcriptional' &amp; tag='JJ']</td>\n",
" <td>'JJ'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;amod &gt;appos</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5001</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_of &lt;dobj &lt;xcomp &gt;prep_including &gt;nn</td>\n",
" <td>5</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5002</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='at' &amp; tag='IN'] [lemma='the'...</td>\n",
" <td>'IN' 'DT' 'NN' 'IN' 'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_at &gt;nsubj &gt;nn</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5003</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;dobj &gt;prep_together_with &gt;nn</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5004</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcript' &amp; tag='NN'] [lem...</td>\n",
" <td>'NN' 'NNS'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5005</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='production' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_in &lt;appos &lt;nsubj</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5006</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='production' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;dep &gt;amod &gt;dep</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5007</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;conj_and &gt;amod &gt;prepc_without &gt;xcomp</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5008</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='mrna' &amp; tag='NN'] [lemma='ex...</td>\n",
" <td>'NN' 'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_of &gt;prep_of &gt;appos</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5009</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;appos</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5010</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcript' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;nn &lt;prep_with &gt;nsubjpass</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5011</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcriptional' &amp; tag='JJ']</td>\n",
" <td>'JJ'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;amod &lt;prep_at &gt;prep_on</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5012</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;conj_negcc &gt;nn</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5013</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcript' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;nn</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5014</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;prep_of &gt;dep &gt;appos</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5015</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;dobj &gt;iobj &gt;appos</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5016</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;conj_negcc &gt;prep_of</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5017</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='concentration' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5018</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='transcription' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;conj_and &gt;dep &gt;xcomp</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5019</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='level' &amp; tag='NNS']</td>\n",
" <td>'NNS'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;conj_and</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5020</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN'] [lem...</td>\n",
" <td>'NN' 'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;prep_of &gt;nn</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5021</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_to &gt;nsubj &gt;nn</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5022</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='induction' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;dep</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5023</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='level' &amp; tag='NNS']</td>\n",
" <td>'NNS'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;prep_in &lt;prep_than &lt;amod</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5024</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='expression' &amp; tag='NN']</td>\n",
" <td>'NN'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&lt;nn</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5025</th>\n",
" <td>Transcription</td>\n",
" <td>trigger = [lemma='level' &amp; tag='NNS']</td>\n",
" <td>'NNS'</td>\n",
" <td>Theme</td>\n",
" <td>Protein</td>\n",
" <td>&gt;conj_or &gt;nn</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5026 rows × 8 columns</p>\n",
"</div>"
],
"text/plain": [
" Event Trigger \\\n",
"0 Gene_expression trigger = [lemma='expression' & tag='NN'] \n",
"1 Gene_expression trigger = [lemma='expression' & tag='NN'] \n",
"2 Gene_expression trigger = [lemma='expression' & tag='NN'] \n",
"3 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"4 Gene_expression trigger = [lemma='production' & tag='NN'] \n",
"5 Phosphorylation trigger = [lemma='phosphorylation' & tag='NN'] \n",
"6 Phosphorylation trigger = [lemma='phosphorylation' & tag='NN'] \n",
"7 Positive_regulation trigger = [lemma='induce' & tag='VBD'] \n",
"8 Positive_regulation trigger = [lemma='induction' & tag='NN'] \n",
"9 Positive_regulation trigger = [lemma='activation' & tag='NN'] \n",
"10 Transcription trigger = [lemma='expression' & tag='NN'] \n",
"11 Positive_regulation trigger = [lemma='induction' & tag='NN'] \n",
"12 Binding trigger = [lemma='binding' & tag='NN'] \n",
"13 Localization trigger = [lemma='secretion' & tag='NN'] \n",
"14 Gene_expression trigger = [lemma='express' & tag='VBN'] \n",
"15 Positive_regulation trigger = [lemma='activation' & tag='NN'] \n",
"16 Regulation trigger = [lemma='regulation' & tag='NN'] \n",
"17 Transcription trigger = [lemma='expression' & tag='NN'] \n",
"18 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"19 Localization trigger = [lemma='translocation' & tag='NN'] \n",
"20 Phosphorylation trigger = [lemma='phosphorylation' & tag='NN'] \n",
"21 Positive_regulation trigger = [lemma='induction' & tag='NN'] \n",
"22 Positive_regulation trigger = [lemma='activation' & tag='NN'] \n",
"23 Gene_expression trigger = [lemma='production' & tag='NN'] \n",
"24 Positive_regulation trigger = [lemma='induce' & tag='VBD'] \n",
"25 Regulation trigger = [lemma='regulate' & tag='VBN'] \n",
"26 Positive_regulation trigger = [lemma='induction' & tag='NN'] \n",
"27 Negative_regulation trigger = [lemma='inhibit' & tag='VBD'] \n",
"28 Gene_expression trigger = [lemma='overexpression' & tag='NN'] \n",
"29 Protein_catabolism trigger = [lemma='degradation' & tag='NN'] \n",
"... ... ... \n",
"4996 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"4997 Transcription trigger = [lemma='mrna' & tag='NN'] [lemma='le... \n",
"4998 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"4999 Transcription trigger = [lemma='transcriptional' & tag='JJ']... \n",
"5000 Transcription trigger = [lemma='transcriptional' & tag='JJ'] \n",
"5001 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"5002 Transcription trigger = [lemma='at' & tag='IN'] [lemma='the'... \n",
"5003 Transcription trigger = [lemma='expression' & tag='NN'] \n",
"5004 Transcription trigger = [lemma='transcript' & tag='NN'] [lem... \n",
"5005 Transcription trigger = [lemma='production' & tag='NN'] \n",
"5006 Transcription trigger = [lemma='production' & tag='NN'] \n",
"5007 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"5008 Transcription trigger = [lemma='mrna' & tag='NN'] [lemma='ex... \n",
"5009 Transcription trigger = [lemma='expression' & tag='NN'] \n",
"5010 Transcription trigger = [lemma='transcript' & tag='NN'] \n",
"5011 Transcription trigger = [lemma='transcriptional' & tag='JJ'] \n",
"5012 Transcription trigger = [lemma='expression' & tag='NN'] \n",
"5013 Transcription trigger = [lemma='transcript' & tag='NN'] \n",
"5014 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"5015 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"5016 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"5017 Transcription trigger = [lemma='concentration' & tag='NN'] \n",
"5018 Transcription trigger = [lemma='transcription' & tag='NN'] \n",
"5019 Transcription trigger = [lemma='level' & tag='NNS'] \n",
"5020 Transcription trigger = [lemma='expression' & tag='NN'] [lem... \n",
"5021 Transcription trigger = [lemma='expression' & tag='NN'] \n",
"5022 Transcription trigger = [lemma='induction' & tag='NN'] \n",
"5023 Transcription trigger = [lemma='level' & tag='NNS'] \n",
"5024 Transcription trigger = [lemma='expression' & tag='NN'] \n",
"5025 Transcription trigger = [lemma='level' & tag='NNS'] \n",
"\n",
" Trigger Tags Argument Argument Type \\\n",
"0 'NN' Theme Protein \n",
"1 'NN' Theme Protein \n",
"2 'NN' Theme Protein \n",
"3 'NN' Theme Protein \n",
"4 'NN' Theme Protein \n",
"5 'NN' Theme Protein \n",
"6 'NN' Site Entity \n",
"7 'VBD' Theme Gene_expression \n",
"8 'NN' Theme Protein \n",
"9 'NN' Theme Protein \n",
"10 'NN' Theme Protein \n",
"11 'NN' Theme Protein \n",
"12 'NN' Theme Protein \n",
"13 'NN' Theme Protein \n",
"14 'VBN' Theme Protein \n",
"15 'NN' Theme Protein \n",
"16 'NN' Theme Gene_expression \n",
"17 'NN' Theme Protein \n",
"18 'NN' Theme Protein \n",
"19 'NN' ToLoc Entity \n",
"20 'NN' Theme Protein \n",
"21 'NN' Theme Protein \n",
"22 'NN' Theme Protein \n",
"23 'NN' Theme Protein \n",
"24 'VBD' Cause Protein \n",
"25 'VBN' Theme Gene_expression \n",
"26 'NN' Theme Gene_expression \n",
"27 'VBD' Theme Positive_regulation \n",
"28 'NN' Theme Protein \n",
"29 'NN' Theme Protein \n",
"... ... ... ... \n",
"4996 'NN' Theme Protein \n",
"4997 'NN' 'NNS' Theme Protein \n",
"4998 'NN' Theme Protein \n",
"4999 'JJ' 'NN' Theme Protein \n",
"5000 'JJ' Theme Protein \n",
"5001 'NN' Theme Protein \n",
"5002 'IN' 'DT' 'NN' 'IN' 'NN' Theme Protein \n",
"5003 'NN' Theme Protein \n",
"5004 'NN' 'NNS' Theme Protein \n",
"5005 'NN' Theme Protein \n",
"5006 'NN' Theme Protein \n",
"5007 'NN' Theme Protein \n",
"5008 'NN' 'NN' Theme Protein \n",
"5009 'NN' Theme Protein \n",
"5010 'NN' Theme Protein \n",
"5011 'JJ' Theme Protein \n",
"5012 'NN' Theme Protein \n",
"5013 'NN' Theme Protein \n",
"5014 'NN' Theme Protein \n",
"5015 'NN' Theme Protein \n",
"5016 'NN' Theme Protein \n",
"5017 'NN' Theme Protein \n",
"5018 'NN' Theme Protein \n",
"5019 'NNS' Theme Protein \n",
"5020 'NN' 'NN' Theme Protein \n",
"5021 'NN' Theme Protein \n",
"5022 'NN' Theme Protein \n",
"5023 'NNS' Theme Protein \n",
"5024 'NN' Theme Protein \n",
"5025 'NNS' Theme Protein \n",
"\n",
" Path Path Length \\\n",
"0 >nn 1 \n",
"1 >prep_of 1 \n",
"2 >prep_of >nn 2 \n",
"3 >nn 1 \n",
"4 >nn 1 \n",
"5 >prep_of 1 \n",
"6 >nn 1 \n",
"7 >dobj 1 \n",
"8 >prep_of 1 \n",
"9 >prep_of >nn 2 \n",
"10 >prep_of >nn 2 \n",
"11 >nn 1 \n",
"12 >prep_of 1 \n",
"13 >nn 1 \n",
"14 >nsubjpass 1 \n",
"15 >nn 1 \n",
"16 >prep_of 1 \n",
"17 >nn 1 \n",
"18 >prep_of >nn 2 \n",
"19 >amod 1 \n",
"20 >nn 1 \n",
"21 >prep_of >nn 2 \n",
"22 >prep_of 1 \n",
"23 >prep_of 1 \n",
"24 >nsubj 1 \n",
"25 >nsubjpass 1 \n",
"26 >prep_of 1 \n",
"27 >dobj 1 \n",
"28 >prep_of 1 \n",
"29 >prep_of 1 \n",
"... ... ... \n",
"4996 >prep_of >dep 2 \n",
"4997 >prep_for >nn 2 \n",
"4998 <prep_with >nsubjpass >prep_of >prep_on >nn 5 \n",
"4999 <prep_at >nsubjpass >dep >nn 4 \n",
"5000 <amod >appos 2 \n",
"5001 <prep_of <dobj <xcomp >prep_including >nn 5 \n",
"5002 <prep_at >nsubj >nn 3 \n",
"5003 <dobj >prep_together_with >nn 3 \n",
"5004 >prep_of >nn 2 \n",
"5005 <prep_in <appos <nsubj 3 \n",
"5006 <dep >amod >dep 3 \n",
"5007 <conj_and >amod >prepc_without >xcomp 4 \n",
"5008 <prep_of >prep_of >appos 3 \n",
"5009 <appos 1 \n",
"5010 <nn <prep_with >nsubjpass 3 \n",
"5011 <amod <prep_at >prep_on 3 \n",
"5012 >conj_negcc >nn 2 \n",
"5013 >nn 1 \n",
"5014 >prep_of >prep_of >dep >appos 4 \n",
"5015 <dobj >iobj >appos 3 \n",
"5016 >conj_negcc >prep_of 2 \n",
"5017 >prep_of >nn 2 \n",
"5018 <conj_and >dep >xcomp 3 \n",
"5019 <conj_and 1 \n",
"5020 >prep_of >nn 2 \n",
"5021 <prep_to >nsubj >nn 3 \n",
"5022 <dep 1 \n",
"5023 <prep_in <prep_than <amod 3 \n",
"5024 <nn 1 \n",
"5025 >conj_or >nn 2 \n",
"\n",
" Pattern Frequency \n",
"0 382 \n",
"1 201 \n",
"2 122 \n",
"3 121 \n",
"4 91 \n",
"5 46 \n",
"6 45 \n",
"7 41 \n",
"8 39 \n",
"9 37 \n",
"10 37 \n",
"11 35 \n",
"12 33 \n",
"13 33 \n",
"14 32 \n",
"15 32 \n",
"16 31 \n",
"17 31 \n",
"18 31 \n",
"19 30 \n",
"20 30 \n",
"21 30 \n",
"22 30 \n",
"23 26 \n",
"24 26 \n",
"25 25 \n",
"26 24 \n",
"27 23 \n",
"28 22 \n",
"29 22 \n",
"... ... \n",
"4996 1 \n",
"4997 1 \n",
"4998 1 \n",
"4999 1 \n",
"5000 1 \n",
"5001 1 \n",
"5002 1 \n",
"5003 1 \n",
"5004 1 \n",
"5005 1 \n",
"5006 1 \n",
"5007 1 \n",
"5008 1 \n",
"5009 1 \n",
"5010 1 \n",
"5011 1 \n",
"5012 1 \n",
"5013 1 \n",
"5014 1 \n",
"5015 1 \n",
"5016 1 \n",
"5017 1 \n",
"5018 1 \n",
"5019 1 \n",
"5020 1 \n",
"5021 1 \n",
"5022 1 \n",
"5023 1 \n",
"5024 1 \n",
"5025 1 \n",
"\n",
"[5026 rows x 8 columns]"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data3"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"s1 = pd.Series(np.arange(5,10))"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"0 5\n",
"1 6\n",
"2 7\n",
"3 8\n",
"4 9\n",
"dtype: int64"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s1"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"255"
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s1.dot(s1)"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"midx = pd.MultiIndex(levels=[['one', 'two'], ['x','y']], labels=[[1,1,0,0],[1,0,1,0]])"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"df = pd.DataFrame({'A' : [1, 2, 3, 4], 'B': [5, 6, 7, 8]}, index=midx)"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th></th>\n",
" <th>A</th>\n",
" <th>B</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">two</th>\n",
" <th>y</th>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>x</th>\n",
" <td>2</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">one</th>\n",
" <th>y</th>\n",
" <td>3</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>x</th>\n",
" <td>4</td>\n",
" <td>8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" A B\n",
"two y 1 5\n",
" x 2 6\n",
"one y 3 7\n",
" x 4 8"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"paneldf = df.to_panel()"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"<class 'pandas.core.panel.Panel'>\n",
"Dimensions: 2 (items) x 2 (major_axis) x 2 (minor_axis)\n",
"Items axis: A to B\n",
"Major_axis axis: one to two\n",
"Minor_axis axis: x to y"
]
},
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"paneldf"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>x</th>\n",
" <th>y</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>one</th>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>two</th>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" x y\n",
"one 4 3\n",
"two 2 1"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"paneldf['A']"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"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.0"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment