From 297202178119d269db247bb94f66801a6eafad29 Mon Sep 17 00:00:00 2001 From: jmreddy2106 Date: Thu, 2 Dec 2021 13:31:06 -0500 Subject: time series model --- .vscode/settings.json | 3 +++ dashboard/app.py | 2 +- dashboard/time_serie_model.py | 7 +++++++ 3 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 .vscode/settings.json create mode 100644 dashboard/time_serie_model.py diff --git a/.vscode/settings.json b/.vscode/settings.json new file mode 100644 index 0000000..9f26dfc --- /dev/null +++ b/.vscode/settings.json @@ -0,0 +1,3 @@ +{ + "python.pythonPath": "C:\\Users\\Jagan\\AppData\\Local\\Programs\\Python\\Python38\\python.exe" +} \ No newline at end of file diff --git a/dashboard/app.py b/dashboard/app.py index 4732794..3380dfa 100644 --- a/dashboard/app.py +++ b/dashboard/app.py @@ -19,7 +19,7 @@ def get_list_of_dict(keys, list_of_tuples): return list_of_dict def get_cities_list(): - conn = sql.connect("./database_files/pythonproject.db") + conn = sql.connect("../database_files/pythonproject.db") sql_statement = 'SELECT DISTINCT(City_Name) as City_Name, Lat, Long FROM City_table join Loc_Table on City_Table.City_Id = Loc_table.City_Id' df=pd.read_sql_query(sql_statement, conn).to_records(index=False) return df diff --git a/dashboard/time_serie_model.py b/dashboard/time_serie_model.py new file mode 100644 index 0000000..7db8505 --- /dev/null +++ b/dashboard/time_serie_model.py @@ -0,0 +1,7 @@ +import numpy as np +import pandas as pd +import matplotlib.pyplot as plt +import seaborn as sns +from statsmodels.tsa.arima_model import ARIMA + + -- cgit v1.2.3