Pinned

1. Forecasting_Electricity_Weather Forecasting_Electricity_Weather Public

   This repository contains three forecasting works related to weather and electricity.

   Jupyter Notebook

2. BigQuery SQL to get the Adjusted Clo... BigQuery SQL to get the Adjusted Closing Price for the Last Trading Day in every Quarter (via dimension date table)

   1

   ### BigQuery SQL to get the Adjusted Closing Price for the Last Trading Day in every Quarter (via dimension date table)

   2

   ```sql

   3

   WITH 

   4

   ASX_DATA AS (

   5

     SELECT 

3. Python (Pandas) function that create... Python (Pandas) function that creates a dimension date with workday flag

   1

   ```python

   2

   import pandas as pd

   3

   import holidays

   4

   5

   def create_dim_date(start_date, end_date):