app.py

import streamlit as st
import pandas as pd
import numpy as np
#st.makrdown( :smile:)

# this is a comment line
st.title("Project Name : AI Driven UI\n")
st.subheader("Exercise # 1: Maps 🕵️‍♀️ " )
st.subheader(" This app shows the states with the most Covid-19 cases per 100,000 residents in all time ")

st.header(" US map ")

#df= pd.read_excel('./CovidStates-Mehak.xlsx', )
##dataframe({data, lat, lon})
Cstates=pd.DataFrame({'states': ['Alaska', 'Rodhe Island', 'Guam','North Dakota','Kentucky','Tennessee','Florida','West Virginia','South Carolina', 'Utah'],
'lat' :[66.160507,41.742325,13.4667,47.650589,37.839333,35.860119,25.761681,39.000000,33.836082,39.419220],
'Lon' :[-153.369141, -71.742332,144.7833,-100.437012,-84.270020,-86.660156,-80.191788,39.000000,-81.163727,-111.950684]
})

st.map(Cstates)
st.dataframe(Cstates)