back home
Read CSV with Pandas using PyScript
import pandas as pd
# import sqlite3 as sql
from pyodide.http import open_url
# read csv using pandas
src_url = input()
if src_url == 'x':
src_url = "/data/data.txt"
url_content = open_url(src_url)
df = pd.read_csv(url_content)
# 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 * FROM diamonds LIMIT 10', conn)
# print the output back
fire = df[df['confidence'] == 100]
csv = Element('csv')
csv.write(fire)
# print(df.shape)