Frictionless Data Science w/Python
summary
IPython Notebook wins groundwork credibility (2012 Free Software Award) and runs live cells plus a %sql magic via ipython-sql to pipe results into pandas.DataFrame objects. pandas reads CSVs, transpose and sum with axis=1, pivot tables, drop_duplicates and to_sql/persist to inject processed tables back into Postgres. A quick REST layer comes from sandman and rich query/JSON from htsql; mpld3 and bokeh add interactivity. ddlgenerator and data_dispenser extract messy web tables and create parent/child tables automatically, and the demos prove these pieces actually work end to end.
AI-written summary · about
chapters (13)
- 0:00Frictionless data science
- 1:55IPython Notebook workspace
- 7:17Pandas beyond SQL
- 19:29Pandas to PostgreSQL
- 22:58Quick data import
- 24:43RESTful web services
- 25:46Sandman for APIs
- 27:13HTSQL APIs
- 28:15Matplotlib visualization
- 31:49MPLD3 interactive plots
- 35:00Bokeh visualizations
- 37:49Python data tools
- 38:36Q&A
related talks
01h 04mVisualising Data through Pandas
32mScalable Python and SQL Data Engineering without Migraines
34mPython as a Framework for Analytics and Growth Hacking
40mPyData Stack: Pure Python open source data platforms
01h 16mIntro to Data Analysis with Python Data-table
33mData Science & Data Visualization in Python
01h 38mBasic Python Packages for Science
30mEmpowered by Python - A success story