Read CSV with Pandas using PyScript
import pandas as pd
import sqlite3 as sql
from pyodide.http import open_url
csv = Element('csv')
table_name = 'entitlement_choices__c'
# read csv using pandas
url_content = open_url("http://van-maanen.com/PyScript/google_stock_price.csv")
diamonds = pd.read_csv(url_content)
csv.write(diamonds.head())
# create a sqllite table
conn = sql.connect("./diamonds.db")
diamonds.to_sql('diamonds', conn)
# read from sql into a pandas dataframe
df = pd.read_sql('SELECT avg(price) as avg_price FROM diamonds', conn)
# print the output back
csv.write(df)
print(df.shape)