Skip to content

Workflow manager for multiple pipelines. Can be used for data fetching, transformation, data warehousing, analysis and machine learning. Extract, Load and Transform methods for two pipelines. Rainfall and stock prediction.

License

Notifications You must be signed in to change notification settings

torchlightwizard/ETL-Pipelines-Python

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

42 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Dashboards

Intro

I built a pipeline class that handles data extraction/fetch, transformation, displaying dashboard for n different pipelines and displays them separately on a dashboard.
Currently two pipelines are included, I can include as many more as I like.

Pipelines Included

  1. I use Open Meteo's weather data to predict if rain falls on the next day or not.
  2. I use Polygon's stock market data to predict the Closing price of a stock for the next day.

TechStack

  1. Plotly Dash
  2. Plotly Express,
  3. Mysql
  4. Pandas,
  5. LSTM,
  6. XGBClassifier

Abstraction

  1. Datalake
  2. Data Warehouse
  3. ETL Functions
  4. Pipeline workflow.

How to run:

  1. Config:
python -m venv .localenv
.localenv\Scripts\python -m pip install -r requirements.txt
  1. Start the workflow:
.localenv\Scripts\python -m src.start newopenmeteo
.localenv\Scripts\python -m src.start newpolygon

You can type newopenmeteo to fetch new data. or oldopenmeteo to get predict using data alreay in the data warehouse. 3. Start the dashboard:

.localenv\Scripts\python -m src.start dashboard
  1. Start multiple at a time:
.localenv\Scripts\python -m src.start newopenmeteo newpolygon dashboard

Datasets

Iather data: https://open-meteo.com/en/docs

Stock market data: https://polygon.io/

Environmet Keys Needed

They need to be stored in the .env file in:

project
    ├─keys
        └─.env
POLYGON_KEY=
DB_USER=
DB_PASS=
DB_HOST=

About

Workflow manager for multiple pipelines. Can be used for data fetching, transformation, data warehousing, analysis and machine learning. Extract, Load and Transform methods for two pipelines. Rainfall and stock prediction.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors