File size: 4,572 Bytes
34bc9ce
 
 
 
 
 
 
 
 
 
 
51dcbf7
34bc9ce
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
75d0459
34bc9ce
 
75d0459
 
34bc9ce
 
 
 
 
 
 
 
 
75d0459
34bc9ce
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
75d0459
34bc9ce
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ca8bb53
34bc9ce
ca8bb53
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
import streamlit as st
import pandas as pd
from datetime import timedelta

def get_frequency(datasets, columns, load_options):
        freq_options = _frequency_options(datasets["data"], columns)
        frequency = st.selectbox("", freq_options, label_visibility="collapsed", index=1)
        
        #frequency settings
        if frequency == "Daily":
            freq = "D"
            freq_label = "days"
        elif frequency == "Hourly":
            freq = "H" 
            freq_label = "hours"
        elif frequency == "Weekly":
            freq = "W"
            freq_label = "weeks"
            
        load_options["frequency"] = frequency
        load_options["freq"] = freq
        load_options["freq_label"] = freq_label
        
        return load_options

def tmp_renaming_columns(datasets, columns, load_options):
    #renaming columns
    datasets["data"].rename(columns={columns["date_column"]: 'date'}, inplace=True)
    datasets["data"] = datasets["data"].sort_values(by='date', ascending=True)
    
    if load_options["two_files"]:
        datasets["data"]['food_amount'] = datasets["data"][columns["quantity_column"]] * datasets["data"][columns["quantity_per_item_column"]]
    else:    
        datasets["data"].rename(columns={columns["quantity_column"]: 'food_amount'}, inplace=True)
    
# returns frequency options available for forecast
def _frequency_options(data, columns):
    contains_hours = (data[columns['date_column']].dt.hour != 0).any()
    contains_minutes = (data[columns['date_column']].dt.minute != 0).any()
    contains_seconds = (data[columns['date_column']].dt.second != 0).any()
    
    if contains_hours or contains_minutes or contains_seconds:
        return ["Hourly", "Daily", "Weekly"]
    elif columns["time_column"] != "<None>":
        return ["Hourly", "Daily", "Weekly"]
    
    return ["Daily", "Weekly"]

def get_dates(food_df):
    dates = dict()
    
    # Calculate initial_split_date as a Python datetime object
    initial_split_date = (food_df['date'].iloc[-1] - pd.DateOffset(weeks=4)).to_pydatetime()

    # Convert the Timestamp objects to Python datetime objects
    min_date = food_df['date'].min().to_pydatetime()
    max_date = food_df['date'].max().to_pydatetime()

    # Use Python datetime objects in the st.slider
    training_slider = st.slider(
        "Select the training data range:",
        value=(food_df['date'].iloc[0].to_pydatetime(), initial_split_date),
        min_value=min_date,
        max_value=max_date - timedelta(days=1)
    )
    
    dates["train_start"], dates["train_end"] = training_slider
    
    # How many points in the future to predict
    test_intitial = dates["train_end"] + timedelta(days=1)
    testing_slider = st.slider(
        "Select the testing data range:",
        value=(test_intitial, max_date),
        min_value=test_intitial,
        max_value=max_date
    )
    
    dates["test_start"], dates["test_end"] = testing_slider
    
    return dates

def split_dataset(food_df, dates):
    # splitting data
    train_df = food_df[(food_df["date"] >= dates["train_start"]) & (food_df["date"] <= dates["train_end"])].copy()
    test_df = food_df[(food_df["date"] >= dates["test_start"]) & (food_df["date"] <= dates["test_end"])].copy()
    _display_dates(train_df, test_df)
    
    return train_df, test_df
    
# display number of days in each split
def _display_dates(train_df, test_df):
    training_duration = train_df['date'].max() - train_df['date'].min()
    training_days = training_duration.days
    
    testing_duration = test_df['date'].max() - test_df['date'].min()
    testing_days = testing_duration.days
    
    st.success(f'''
               Training Period: {training_days} days  
               Testing Period:   {testing_days} days
               ''')
    
def get_forecast_dates(food_df, load_options):
    duration = st.number_input(f"Forecast length in {load_options['freq_label']}",
                                min_value=1, max_value= 100, value=5)
    
    load_options["duration"] = duration
    
    min_date = food_df['date'].min().to_pydatetime()
    max_date = food_df['date'].max().to_pydatetime()
    
    forecast_slider = st.slider(
        "Select forecast training data range:",
        value=(food_df['date'].iloc[0].to_pydatetime(), max_date),
        min_value=min_date,
        max_value=max_date
    )
    
    train_start, train_end = forecast_slider
    
    forecast_df = food_df[(food_df["date"] >= train_start) & (food_df["date"] <= train_end)].copy()
    
    return forecast_df, load_options