File size: 910 Bytes
bf83b34 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 | import pandas as pd
import streamlit as st
import altair as alt
import duckdb
con = duckdb.connect(database='Job.db', read_only=True)
# Countries
query="""
SELECT *
FROM job
"""
Countries=list(con.execute(query).df().columns)[2:]
st.subheader('Investingation')
col1, col2 = st.columns(2)
with col1:
query="""
SELECT
DISTINCT variable
From job
ORDER BY variable
"""
kinds=con.execute(query).df()
kind = st.selectbox('Kind of Statistics',kinds)
with col2:
country = st.selectbox('Country',Countries)
result_df = con.execute("""
SELECT
*
FROM Job
WHERE variable=?
""", [kind]).df()
chart = alt.Chart(result_df).mark_circle().encode(
x = 'date',
y = country,
#color = 'carrier'
).interactive()
st.altair_chart(chart, theme="streamlit", use_container_width=True) |