Connect Data
data = pd.read_csv('https://raw.githubusercontent.com/srini047/Datasets/main/new_york_weather_station_data.csv?token=ATLFTHWEKQTR7E64CL3NNZDBUMSSI')
data
SELECT * FROM data
List of Airport Stations
df_1.columns
data['country'].unique()
Get the Dataset SQL
SELECT distinct(name)
FROM data
WHERE country = 'US' and name like '%AIRPORT%'
input_1
SELECT date, name, temp as min_temp, max as max_temp, gust as max_gust
FROM data
WHERE country = 'US' and name = {{ input_1 }}
AND date > '2015-12-31'
ORDER BY date DESC
Plot Weather Forecast
my_plot = plot_plotly(m, forecast)
my_plot
fig_2 = m.plot_components(forecast)
plot_components_plotly(m, forecast)