{ "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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
\n", "

...

" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.display(2)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.09369523986159245
29apples0.561245062938613
91oranges0.2204406220406967
75bananas0.8094304566778266
0pears0.6981393949882269
43bananas0.15547949981178155
\n" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "tbl.displayall()" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.09369523986159245
\n", "

...

" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
0|foo1|bar2|baz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
example data
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81appl0.02
35pear0.22
94appl0.67
69appl0.59
4appl0.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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
foobarbaz
81apples0.025010755222666936
35pears0.22321073814882275
94apples0.6766994874229113
69apples0.5904925124490397
4apples0.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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
nameid
Արամ Խաչատրյան1
Johann Strauß2
Вагиф Сәмәдоғлу3
章子怡4
Արամ Խաչատրյան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": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
unicode example
nameid
Արամ Խաչատրյան1
Johann Strauß2
Вагиф Сәмәдоғлу3
章子怡4
Արամ Խաչատրյան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 }