{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "sys.version_info(major=3, minor=4, micro=3, releaselevel='final', serial=0)" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import sys\n", "sys.version_info" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "'1.1.0.dev0'" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import petl as etl\n", "etl.__version__" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
...
" ], "text/plain": [ "+-----+----------+----------------------+\n", "| foo | bar | baz |\n", "+=====+==========+======================+\n", "| 81 | 'apples' | 0.025010755222666936 |\n", "+-----+----------+----------------------+\n", "| 35 | 'pears' | 0.22321073814882275 |\n", "+-----+----------+----------------------+\n", "| 94 | 'apples' | 0.6766994874229113 |\n", "+-----+----------+----------------------+\n", "| 69 | 'apples' | 0.5904925124490397 |\n", "+-----+----------+----------------------+\n", "| 4 | 'apples' | 0.09369523986159245 |\n", "+-----+----------+----------------------+\n", "..." ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tbl = etl.dummytable(10, seed=42)\n", "tbl" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display(2)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
29 | \n", "apples | \n", "0.561245062938613 | \n", "
91 | \n", "oranges | \n", "0.2204406220406967 | \n", "
75 | \n", "bananas | \n", "0.8094304566778266 | \n", "
0 | \n", "pears | \n", "0.6981393949882269 | \n", "
43 | \n", "bananas | \n", "0.15547949981178155 | \n", "
foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "0|foo | \n", "1|bar | \n", "2|baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display()\n", "tbl.display(index_header=True)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display(caption='example data')" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
example data
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display(epilogue='example data')" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "appl | \n", "0.02 | \n", "
35 | \n", "pear | \n", "0.22 | \n", "
94 | \n", "appl | \n", "0.67 | \n", "
69 | \n", "appl | \n", "0.59 | \n", "
4 | \n", "appl | \n", "0.09 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display(truncate=4)" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display(tr_style=lambda row: 'background-color: %s' % ('#faa' if row.foo > 50 else 'white'))" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "foo | \n", "bar | \n", "baz | \n", "
---|---|---|
81 | \n", "apples | \n", "0.025010755222666936 | \n", "
35 | \n", "pears | \n", "0.22321073814882275 | \n", "
94 | \n", "apples | \n", "0.6766994874229113 | \n", "
69 | \n", "apples | \n", "0.5904925124490397 | \n", "
4 | \n", "apples | \n", "0.09369523986159245 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display(tr_style='font-size: .8em',\n", " td_styles={'bar': 'background-color: yellow',\n", " 'baz': lambda v: 'background-color: %s' % ('#faa' if v > .5 else '#aaf')})" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "(('name', 'id'),\n", " ('Արամ Խաչատրյան', 1),\n", " ('Johann Strauß', 2),\n", " ('Вагиф Сәмәдоғлу', 3),\n", " ('章子怡', 4),\n", " ('Արամ Խաչատրյան', 1),\n", " ('Johann Strauß', 2),\n", " ('Вагиф Сәмәдоғлу', 3),\n", " ('章子怡', 4))" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "t = ((u'name', u'id'),\n", " (u'Արամ Խաչատրյան', 1),\n", " (u'Johann Strauß', 2),\n", " (u'Вагиф Сәмәдоғлу', 3),\n", " (u'章子怡', 4),\n", " (u'Արամ Խաչատրյան', 1),\n", " (u'Johann Strauß', 2),\n", " (u'Вагиф Сәмәдоғлу', 3),\n", " (u'章子怡', 4))\n", "t" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "name | \n", "id | \n", "
---|---|
Արամ Խաչատրյան | \n", "1 | \n", "
Johann Strauß | \n", "2 | \n", "
Вагиф Сәмәдоғлу | \n", "3 | \n", "
章子怡 | \n", "4 | \n", "
Արամ Խաչատրյան | \n", "1 | \n", "
...
" ], "text/plain": [ "+-------------------+----+\n", "| name | id |\n", "+===================+====+\n", "| 'Արամ Խաչատրյան' | 1 |\n", "+-------------------+----+\n", "| 'Johann Strauß' | 2 |\n", "+-------------------+----+\n", "| 'Вагиф Сәмәдоғлу' | 3 |\n", "+-------------------+----+\n", "| '章子怡' | 4 |\n", "+-------------------+----+\n", "| 'Արամ Խաչատրյան' | 1 |\n", "+-------------------+----+\n", "..." ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tbl2 = etl.wrap(t)\n", "tbl2" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "name | \n", "id | \n", "
---|---|
Արամ Խաչատրյան | \n", "1 | \n", "
Johann Strauß | \n", "2 | \n", "
Вагиф Сәмәдоғлу | \n", "3 | \n", "
章子怡 | \n", "4 | \n", "
Արամ Խաչատրյան | \n", "1 | \n", "
...
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl2.display(caption='unicode example')" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false }, "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.4.3+" } }, "nbformat": 4, "nbformat_minor": 0 }