import streamlit as st import pandas as pd import numpy as np astations = [ ["hongkongobservatory","HKO",22.3022566,114.1722662,"Hong Kong Observatory"], ["kingspark","KP",22.3115408,114.1685675,"Observatory Meteorological Station, King's Park"], ] astationcolumns = ['akey','astationcode','alatitude','alongitude','atitle',] acontainer1 = st.empty() acontainer2 = st.empty() acontainer3 = st.empty() def asubmit(aparam): adf2 = aparam["adataframe"] aselecteditem = adf2.loc[adf2["atitle"]==aparam["aselected"], "astationcode"] adf3 = pd.DataFrame( [ [ adf2.loc[adf2["atitle"]==aparam["aselected"], "alatitude"].values()[0], adf2.loc[adf2["atitle"]==aparam["aselected"], "alongitude"].values()[0], ] ], columns=['lat', 'lon'] ) aparam["acontainer"].dataframe(adf3) return abacklogmax = 10 atoday = datetime.date.today() ayear = int(atoday.strftime("%Y"))-0 amonth = int(atoday.strftime("%m")) amonthday = int(atoday.strftime("%d")) csvString = "" csvString += (",").join(mytitles) adf3 = pd.DataFrame(columns=mytitles) for i in range((ayear-abacklogmax),ayear,1): alink = ("https://data.weather.gov.hk/weatherAPI/opendata/opendata.php?dataType=CLMTEMP&year={}&rformat=csv&station={}").format(str(i),aselecteditem.values[0]) adf4 = pd.read_csv(alink, skiprows=[0,1,2], skipfooter=3, engine='python', on_bad_lines='skip') adf4 = df.reset_index() # make sure indexes pair with number of rows for index, row in adf4.iterrows(): if (row[2]!=amonth) or (row[3]!=amonthday): continue adate = ("{:02d}.{:02d}.{} 00:00:00").format(row[3], row[2], row[1]) csvString += '\n'+(",").join([adate,str(row[4]),""]) st.write(row[0],adate) adf3 = adf3.append({"Date Time":adate,"T (degC)":(row[4]),}, ignore_index=True) break adf3 = pd.read_csv(StringIO(csvString), sep=",") aparam["acontainer"].dataframe(adf3) adf = pd.DataFrame( astations, columns=astationcolumns ) aoption = acontainer1.selectbox( 'Which station?', adf['atitle'] ) if acontainer2.button("Submit") == True: asubmit(aparam={"aselected":aoption,"acontainer":acontainer3,"adataframe":adf,})