diff options
| author | jmreddy2106 <[email protected]> | 2021-12-02 13:31:06 -0500 |
|---|---|---|
| committer | jmreddy2106 <[email protected]> | 2021-12-02 13:31:06 -0500 |
| commit | 297202178119d269db247bb94f66801a6eafad29 (patch) | |
| tree | f67be813bc02953f84777dc40e8c4184a44eb484 | |
| parent | 7dc050e696a388fe8af4f5bf5c40e75f4a7302ee (diff) | |
| download | temp_pred_arima-297202178119d269db247bb94f66801a6eafad29.tar.xz temp_pred_arima-297202178119d269db247bb94f66801a6eafad29.zip | |
time series model
| -rw-r--r-- | .vscode/settings.json | 3 | ||||
| -rw-r--r-- | dashboard/app.py | 2 | ||||
| -rw-r--r-- | dashboard/time_serie_model.py | 7 |
3 files changed, 11 insertions, 1 deletions
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 + + |