Pandas Loves Ponies - Speaker Deck

Slide 1

Slide 1 text

PANDAS LOVES PONIES Lex Hider @LexualChocolate github.com/lexual

Slide 2

Slide 2 text

DJANGO PONY

Slide 3

Slide 3 text

PANDAS

Slide 4

Slide 4 text

PANDAS ● Like R, but better ● DataFrame ● In Memory SQL ● Awesome Builds On Numpy/ Scipy Stack

Slide 5

Slide 5 text

PANDAS LOVES PONIES

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

import pandas as pd Like: ● R frame ● In memory SQL ● Excel spreadsheet Does: ● SQL like JOINs in memory ● groupby ● pivot tables ● plotting ● reads csvs, excel, SQL

Slide 8

Slide 8 text

FROM CSV df = pd.read_csv('foo.csv')

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

FROM SQL

Slide 11

Slide 11 text

WHAT ABOUT DJANGO ???

Slide 12

Slide 12 text

FROM DJANGO

Slide 13

Slide 13 text

TO HTML df.to_html() HTML table outputted. {{ df.to_html }}

Slide 14

Slide 14 text

TO CSV df.to_csv('/tmp/foobar.csv')

Slide 15

Slide 15 text

TO DJANGO github.com/lexual/pandas-love-ponies ● 1st Released 2013-02-14 ● Valentine's Day ;)

Slide 16

Slide 16 text

github.com/lexual/pandas-love-ponies import pandas_love_ponies as plp # monkey patch. pd.DataFrame.to_django = plp.to_django df = pd.DataFrame(some_data) df.to_django(MyDjModel) # OR plp.to_django(df, MyDjModel)

Slide 17

Slide 17 text

github.com/lexual/pandas-love-ponies from myapp.models import Sale df = pd.read_csv('sales.csv') df.to_django(Sale) # OR plp.to_django(df, Sale)

Slide 18

Slide 18 text

FROM GOOGLE ANALYTICS (GA)

Slide 19

Slide 19 text

2 LINES FROM WEB SERVICE TO DB

Slide 20

Slide 20 text

FROM ADOBE MARKETING CLOUD ● Adobe's "GA" product. ● aka SiteCatalyst or Omniture ● github.com/lexual/sitecat-py Similar to read_ga() read_sc()

Slide 21

Slide 21 text

No content

Slide 22

Slide 22 text

SECURITY IS OVERRATED ;) COME SEE MY SALT TALK TOMORROW MORNING (There will be jokes)

Slide 23

Slide 23 text

linkd.in/12Kgg5K WE'RE HIRING! ● Django/Python Developer ● Melbourne Work with some cool tech: ● Salt ● Riak (no-SQL db) ● Pandas/Numpy/Scipy ● git ● AWS

Slide 24

Slide 24 text

THE END