text_html_output_1.png
import csv

import pandas as pd

import sqlite3

path = './'
database = path + 'ted-talk-data.sqlite'
conn = sqlite3.connect(database)

create_table = 'CREATE TABLE tedtalk(\n                title TEXT,\n                author TEXT,\n                date DATE,\n                views INTEGER,\n                likes INTEGER,\n                link TEXT);\n                '

cursor = conn.cursor()
cursor.execute(create_table)
file = open('../input/ted-talks/data.csv')
content = list(csv.reader(file))
content = content[1:]
file.close()

sql_test = pd.read_sql('SELECT * FROM tedtalk LIMIT 5', conn)
sql_test