In [2]:
from sqlalchemy import create_engine
import pandas as pd
import psycopg2
In [8]:
engine = create_engine('postgresql://sheldon@localhost:5432/sheldon')
df = pd.read_sql("select * from podcasts",engine)
In [32]:
conn = psycopg2.connect("dbname='sheldon' user=sheldon host=localhost")
c = conn.cursor()
c.execute("""select * from podcasts""")
db_request = [dict(index=row[0], episode=row[1], series=row[2]) for row in c.fetchall()]
In [33]:
db_request
Out[33]:
[{'episode': 0L,
'index': 0L,
'series': 'dopequeens040516_cms591992_pod.mp3_translation.txt'},
{'episode': 1L,
'index': 1L,
'series': 'dopequeens040716_cms592303_pod.mp3_translation.txt'},
{'episode': 2L,
'index': 2L,
'series': 'dopequeens041216_cms593915_pod.mp3_translation.txt'},
{'episode': 3L,
'index': 3L,
'series': 'dopequeens041916_cms596223_pod.mp3_translation.txt'},
{'episode': 4L,
'index': 4L,
'series': 'dopequeens042616_cms598229_pod.mp3_translation.txt'},
{'episode': 5L,
'index': 5L,
'series': 'dopequeens050316_cms600651_pod.mp3_translation.txt'},
{'episode': 6L,
'index': 6L,
'series': 'dopequeens051016_cms602605_pod.mp3_translation.txt'},
{'episode': 7L,
'index': 7L,
'series': 'dopequeens051716_cms619373_pod.mp3_translation.txt'},
{'episode': 8L,
'index': 8L,
'series': 'dopequeens052416_cms621397_pod.mp3_translation.txt'},
{'episode': 9L,
'index': 9L,
'series': 'Criminal.Ep14.FifthSuspectFINAL.mp3_translation.txt'},
{'episode': 10L,
'index': 10L,
'series': 'Episode_13__The_Big_Sleep.mp3_translation.txt'},
{'episode': 11L,
'index': 11L,
'series': 'Episode_16_Poster_Boy.mp3_m_reK.tmp_translation.txt'},
{'episode': 12L,
'index': 12L,
'series': 'Episode_21__Bloodlines.mp3_translation.txt'},
{'episode': 13L,
'index': 13L,
'series': 'Episode_23__Triassic_Park.mp3_translation.txt'},
{'episode': 14L,
'index': 14L,
'series': 'Episode_28__P.D.I.D..mp3_translation.txt'},
{'episode': 15L,
'index': 15L,
'series': 'Episode_30__The_Agreement.mp3_translation.txt'},
{'episode': 16L,
'index': 16L,
'series': 'Episode_5__Dropping_Like_Flies.mp3_translation.txt'},
{'episode': 17L,
'index': 17L,
'series': 'freakonomics_mppodcast071012.mp3_translation.txt'},
{'episode': 18L,
'index': 18L,
'series': 'freakonomics_mppodcast100511.mp3_translation.txt'},
{'episode': 19L,
'index': 19L,
'series': 'freakonomics_mppodcast103112.mp3_translation.txt'},
{'episode': 20L,
'index': 20L,
'series': 'freakonomics_mppodcast112812.mp3_translation.txt'},
{'episode': 21L,
'index': 21L,
'series': 'freakonomics_mppodcast121212.mp3_translation.txt'},
{'episode': 22L,
'index': 22L,
'series': 'freakonomics_podcast010213.mp3_translation.txt'},
{'episode': 23L,
'index': 23L,
'series': 'freakonomics_podcast011812.mp3_translation.txt'},
{'episode': 24L,
'index': 24L,
'series': 'freakonomics_podcast022615.mp3_translation.txt'},
{'episode': 25L,
'index': 25L,
'series': 'freakonomics_podcast032713.mp3_translation.txt'},
{'episode': 26L,
'index': 26L,
'series': 'freakonomics_podcast032714.mp3_translation.txt'},
{'episode': 27L,
'index': 27L,
'series': 'freakonomics_podcast061115.mp3_translation.txt'},
{'episode': 28L,
'index': 28L,
'series': 'freakonomics_podcast061715.mp3_translation.txt'},
{'episode': 29L,
'index': 29L,
'series': 'freakonomics_podcast080113.mp3_translation.txt'},
{'episode': 30L,
'index': 30L,
'series': 'freakonomics_podcast103113.mp3_translation.txt'},
{'episode': 31L,
'index': 31L,
'series': 'freakonomics_podcast111115.mp3_translation.txt'},
{'episode': 32L,
'index': 32L,
'series': 'freakonomics_podcast111815.mp3_translation.txt'},
{'episode': 33L,
'index': 33L,
'series': 'freakonomics_podcast121814.mp3_translation.txt'},
{'episode': 34L,
'index': 34L,
'series': 'freakonomics_podcast122514.mp3_translation.txt'},
{'episode': 35L, 'index': 35L, 'series': 'GLT1997277266.mp3_translation.txt'},
{'episode': 36L, 'index': 36L, 'series': 'GLT2399727069.mp3_translation.txt'},
{'episode': 37L, 'index': 37L, 'series': 'GLT3729464097.mp3_translation.txt'},
{'episode': 38L, 'index': 38L, 'series': 'GLT4156421709.mp3_translation.txt'},
{'episode': 39L, 'index': 39L, 'series': 'GLT4372469350.mp3_translation.txt'},
{'episode': 40L, 'index': 40L, 'series': 'GLT4547523086.mp3_translation.txt'},
{'episode': 41L, 'index': 41L, 'series': 'GLT6036164557.mp3_translation.txt'},
{'episode': 42L, 'index': 42L, 'series': 'GLT6431860932.mp3_translation.txt'},
{'episode': 43L, 'index': 43L, 'series': 'GLT7182154429.mp3_translation.txt'},
{'episode': 44L, 'index': 44L, 'series': 'GLT7317894781.mp3_translation.txt'},
{'episode': 45L, 'index': 45L, 'series': 'GLT9813019209.mp3_translation.txt'},
{'episode': 46L,
'index': 46L,
'series': '4019946-1-4-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 47L,
'index': 47L,
'series': '4077439-1-18-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 48L,
'index': 48L,
'series': '4151917-2-5-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 49L,
'index': 49L,
'series': '4205309-2-19-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 50L,
'index': 50L,
'series': '4245343-2-29-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 51L,
'index': 51L,
'series': '4278049-3-8-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 52L,
'index': 52L,
'series': '4351605-3-25-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 53L,
'index': 53L,
'series': '4399611-4-6-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 54L,
'index': 54L,
'series': '4513041-5-2-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 55L,
'index': 55L,
'series': '4574251-5-16-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 56L,
'index': 56L,
'series': '4579716-5-17-16-mark-levin-audio-rewind.mp3_translation.txt'},
{'episode': 57L,
'index': 57L,
'series': '22_Joan_50_Shades_of_Awkward.mp3_translation.txt'},
{'episode': 58L,
'index': 58L,
'series': '23_Retta_The_Academic.mp3_translation.txt'},
{'episode': 59L,
'index': 59L,
'series': '29_Mortifieds_Tribute_to_Neurotic-Teens.mp3_translation.txt'},
{'episode': 60L,
'index': 60L,
'series': '35_Colin_Dont_Tell_Anyone_I_Like_You.mp3_translation.txt'},
{'episode': 61L,
'index': 61L,
'series': '38_Kids_On_The_Campaign_Trail_FINAL.mp3_translation.txt'},
{'episode': 62L,
'index': 62L,
'series': '41_Jackie_How_Not_To_Be_Thankful.mp3_translation.txt'},
{'episode': 63L,
'index': 63L,
'series': '43_Boys_DO_Cry_w_Chvrches.mp3_translation.txt'},
{'episode': 64L,
'index': 64L,
'series': '51-How-Not-To-Win-An-Oscar.mp3_translation.txt'},
{'episode': 65L,
'index': 65L,
'series': '52_The_Period_Piece_FINAL-edited.mp3_translation.txt'},
{'episode': 66L,
'index': 66L,
'series': '54_Dont_F_ck_With_Emiko.mp3_translation.txt'},
{'episode': 67L,
'index': 67L,
'series': '58-Forbidden_Crushes_Part-3_I_Like_A_Girl.mp3_translation.txt'},
{'episode': 68L, 'index': 68L, 'series': 'otm010816pod.mp3_translation.txt'},
{'episode': 69L, 'index': 69L, 'series': 'otm012916pod.mp3_translation.txt'},
{'episode': 70L, 'index': 70L, 'series': 'otm020516pod.mp3_translation.txt'},
{'episode': 71L, 'index': 71L, 'series': 'otm021216pod.mp3_translation.txt'},
{'episode': 72L,
'index': 72L,
'series': 'otm030916podextra.mp3_translation.txt'},
{'episode': 73L, 'index': 73L, 'series': 'otm031816pod.mp3_translation.txt'},
{'episode': 74L,
'index': 74L,
'series': 'otm032416podextra.mp3_translation.txt'},
{'episode': 75L, 'index': 75L, 'series': 'otm032516pod.mp3_translation.txt'},
{'episode': 76L, 'index': 76L, 'series': 'otm042916pod.mp3_translation.txt'},
{'episode': 77L,
'index': 77L,
'series': 'otm052516podextra.mp3_translation.txt'},
{'episode': 78L,
'index': 78L,
'series': 'otm121015podextra.mp3_translation.txt'},
{'episode': 79L,
'index': 79L,
'series': 'Alleged-cult-leader-plays-shell-game-with-US-foreign-aid_PODCAST_master.mp3_translation.txt'},
{'episode': 80L,
'index': 80L,
'series': 'Assault-on-justice-R.mp3_translation.txt'},
{'episode': 81L,
'index': 81L,
'series': 'Confronting-love-and-oppression-in-Afghanistan.mp3_translation.txt'},
{'episode': 82L,
'index': 82L,
'series': 'Disposable-workers-in-Asia.mp3_translation.txt'},
{'episode': 83L,
'index': 83L,
'series': 'Exposing-the-horrors-on-The-Mountain.mp3_translation.txt'},
{'episode': 84L,
'index': 84L,
'series': 'From-detention-to-detainment-in-Virginia.mp3_translation.txt'},
{'episode': 85L,
'index': 85L,
'series': 'Matching-the-lost-and-the-found.mp3_translation.txt'},
{'episode': 86L,
'index': 86L,
'series': 'Pumped-on-Trump_podcast.mp3_translation.txt'},
{'episode': 87L,
'index': 87L,
'series': 'The-long-tale-of-the-short-handled-hoe.mp3_translation.txt'},
{'episode': 88L,
'index': 88L,
'series': 'The-Pentagon-Papers_-Secrets-lies-and-leaks_podcast-v2.mp3_translation.txt'},
{'episode': 89L,
'index': 89L,
'series': 'Water-bills-bleeding-them-dry.mp3_translation.txt'},
{'episode': 90L,
'index': 90L,
'series': 'serial-s01-day02.mp3_translation.txt'},
{'episode': 91L,
'index': 91L,
'series': 'serial-s01-day03.mp3_translation.txt'},
{'episode': 92L,
'index': 92L,
'series': 'serial-s01-e01.mp3_translation.txt'},
{'episode': 93L,
'index': 93L,
'series': 'serial-s01-e03.mp3_translation.txt'},
{'episode': 94L,
'index': 94L,
'series': 'serial-s01-e04.mp3_translation.txt'},
{'episode': 95L,
'index': 95L,
'series': 'serial-s01-e05.mp3_translation.txt'},
{'episode': 96L,
'index': 96L,
'series': 'serial-s01-e12.mp3_translation.txt'},
{'episode': 97L,
'index': 97L,
'series': 'serial-s02-e04.mp3_translation.txt'},
{'episode': 98L,
'index': 98L,
'series': 'serial-s02-e05.mp3_translation.txt'},
{'episode': 99L,
'index': 99L,
'series': 'serial-s02-e09.mp3_translation.txt'},
{'episode': 100L,
'index': 100L,
'series': 'serial-s02-e10.mp3_translation.txt'},
{'episode': 101L,
'index': 101L,
'series': 'Snap505_ThePact.mp3_translation.txt'},
{'episode': 102L,
'index': 102L,
'series': 'Snap618_CampfireTales2.mp3_translation.txt'},
{'episode': 103L,
'index': 103L,
'series': 'Snap_Special_TheStoryteller.mp3_translation.txt'},
{'episode': 104L,
'index': 104L,
'series': 'snapjudgment010716_snap701_highcrimesandmisdemeanors.mp3_translation.txt'},
{'episode': 105L,
'index': 105L,
'series': 'snapjudgment012116_snap702_fullcircle.mp3_translation.txt'},
{'episode': 106L,
'index': 106L,
'series': 'snapjudgment012816_snap607_infamous.mp3_translation.txt'},
{'episode': 107L,
'index': 107L,
'series': 'snapjudgment021816_snap605_simpatico.mp3_translation.txt'},
{'episode': 108L,
'index': 108L,
'series': 'snapjudgment032516_snap606_proof.mp3_translation.txt'},
{'episode': 109L,
'index': 109L,
'series': 'snapjudgment051916_snap714_manofsteel.mp3_translation.txt'},
{'episode': 110L,
'index': 110L,
'series': 'snapjudgment081415_snap621_crashandburnt.mp3_translation.txt'},
{'episode': 111L,
'index': 111L,
'series': 'snapjudgment082715_snap622_unspoken.mp3_translation.txt'},
{'episode': 112L,
'index': 112L,
'series': 'snapjudgment092415_snap624_brassring.mp3_translation.txt'},
{'episode': 113L,
'index': 113L,
'series': '01 Ep. 12_ Judd Apatow.mp3_translation.txt'},
{'episode': 114L,
'index': 114L,
'series': '10115_BSPod-WesleyMorris.mp3_translation.txt'},
{'episode': 115L,
'index': 115L,
'series': '101315_BSPod.mp3_translation.txt'},
{'episode': 116L,
'index': 116L,
'series': 'BS_Pod_111116.mp3_translation.txt'},
{'episode': 117L,
'index': 117L,
'series': 'BS_Pod_111615.mp3_translation.txt'},
{'episode': 118L,
'index': 118L,
'series': 'BS_Pod_111815.mp3_translation.txt'},
{'episode': 119L,
'index': 119L,
'series': 'BS_Pod_112315.mp3_translation.txt'},
{'episode': 120L,
'index': 120L,
'series': 'BS_Pod_12016_WesleyMorrisFinal.mp3_translation.txt'},
{'episode': 121L,
'index': 121L,
'series': 'BS_Pod_121415.mp3_translation.txt'},
{'episode': 122L,
'index': 122L,
'series': 'BSTeaser v01.mp3_translation.txt'},
{'episode': 123L,
'index': 123L,
'series': 'Ep 77 Jim Lampley .mp3_translation.txt'},
{'episode': 124L,
'index': 124L,
'series': 'thepulse20150612.mp3_translation.txt'},
{'episode': 125L,
'index': 125L,
'series': 'thepulse20150703.mp3_translation.txt'},
{'episode': 126L,
'index': 126L,
'series': 'thepulse20150710.mp3_translation.txt'},
{'episode': 127L,
'index': 127L,
'series': 'thepulse20150724.mp3_translation.txt'},
{'episode': 128L,
'index': 128L,
'series': 'thepulse20151016.mp3_translation.txt'},
{'episode': 129L,
'index': 129L,
'series': 'thepulse20151204.mp3_translation.txt'},
{'episode': 130L,
'index': 130L,
'series': 'thepulse20160122.mp3_translation.txt'},
{'episode': 131L,
'index': 131L,
'series': 'thepulse20160318.mp3_translation.txt'},
{'episode': 132L,
'index': 132L,
'series': 'thepulse20160408.mp3_translation.txt'},
{'episode': 133L,
'index': 133L,
'series': 'thepulse20160429.mp3_translation.txt'},
{'episode': 134L,
'index': 134L,
'series': 'thepulse20160513.mp3_translation.txt'},
{'episode': 135L,
'index': 135L,
'series': '05-Tim_Ferriss_Show-Chase_Jarvis_128.mp3_translation.txt'},
{'episode': 136L,
'index': 136L,
'series': 'Ep_39_Maria_Popova.mp3_translation.txt'},
{'episode': 137L,
'index': 137L,
'series': 'Productivity_Hacks_for_Neurotic_and_Crazy_People.mp3_translation.txt'},
{'episode': 138L,
'index': 138L,
'series': 'TFS_M4_Stanley.mp3_translation.txt'},
{'episode': 139L,
'index': 139L,
'series': 'Tim_Ferriss_Show_-_Alain_de_Botton.mp3_translation.txt'},
{'episode': 140L,
'index': 140L,
'series': 'Tim_Ferriss_Show_-_Brene_Brown.mp3_translation.txt'},
{'episode': 141L,
'index': 141L,
'series': 'Tim_Ferriss_Show_-_Daymond_John.mp3_translation.txt'},
{'episode': 142L,
'index': 142L,
'series': 'Tim_Ferriss_Show_-_Dominic_DAgostino.mp3_translation.txt'},
{'episode': 143L,
'index': 143L,
'series': 'Tim_Ferriss_Show_-_Ed_Cooke_Part_1.mp3_translation.txt'},
{'episode': 144L,
'index': 144L,
'series': 'Tim_Ferriss_Show_-_Naval_Ravikant_1.mp3_translation.txt'},
{'episode': 145L,
'index': 145L,
'series': 'TIMFERRISSSHOW019.mp3_translation.txt'},
{'episode': 146L,
'index': 146L,
'series': 'TIMFERRISSSHOW028KELLYpt3.mp3_translation.txt'},
{'episode': 147L, 'index': 147L, 'series': 'WS012516.mp3_translation.txt'},
{'episode': 148L, 'index': 148L, 'series': 'WS030416.mp3_translation.txt'},
{'episode': 149L, 'index': 149L, 'series': 'WS052616.mp3_translation.txt'},
{'episode': 150L, 'index': 150L, 'series': 'WS091715.mp3_translation.txt'}]
In [ ]:
Content source: sheldonsmickley/springboard_capstone
Similar notebooks: