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)