afa-bd / app.py
Strauss Cunha Carvalho
dev:sqlite
b0f862d
raw
history blame
393 Bytes
import streamlit as st
import sqlite3
import pandas as pd
x = st.slider('Select a value')
st.write(x, 'squared is', x * x)
conn = sqlite3.connect("afa-bd.db")
sql = """SELECT alu_id, alu_nome, alu_uf, alu_cep, progresso_alfabetizacao, idade FROM tb_students
WHERE progresso_alfabetizacao >= 6 LIMIT 100"""
dfp_std = pd.read_sql(sql, conn)
st.dataframe(dfp_std)
#dfp_std.head(4)