Magic Functions for Querying

xxxxxxxxxx

 

1

import sqlite3; import pandas as pd

2

from IPython.display import display

3

from IPython.core.magic import register_line_magic

4

@register_line_magic

5

def get_query(q):

6

    connection=sqlite3.connect('db.db')

7

    cursor=connection.cursor()

8

    url='https://raw.githubusercontent.com/noahgift/'+\

9

        'mma/master/data/ufc_fights_all.csv'

10

    mma=pd.read_csv(url).dropna()

11

    mma.to_sql('mma',con=connection,

12

           if_exists='replace')

13

    pretty_print(html('<p>SQL Queries => UFC Fights</p>'))

14

    q=pd.read_sql_query(q,con=connection)

15

    thp=[('font-size','15px'),('text-align','center'),

16

         ('font-weight','bold'),('padding','5px 5px'),

17

         ('color','white'),('background-color','slategray')]

18

    tdp=[('font-size','14px'),('padding','5px 5px'),

19

         ('text-align','center'),('color','darkblue'),

20

         ('background-color','silver')]

21

    style_dict=[dict(selector='th',props=thp),

22

                dict(selector='td',props=tdp)]

23

    display(q.style.set_table_styles(style_dict))

24

    if connection is not None:

25

        connection.close()

26

    if os.path.exists('db.db'):

27

        os.remove('db.db')

Language: Sage Gap GP HTML Macaulay2 Maxima Octave Python R Singular

---

Messages

xxxxxxxxxx

 

1

%get_query \

2

SELECT method, \

3

       COUNT(*) AS number, \

4

       AVG(round) AS avg_round \

5

FROM mma \

6

GROUP BY method;

Language: Sage Gap GP HTML Macaulay2 Maxima Octave Python R Singular

---

Messages