You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This project is an ETL (Extract, Transform, Load) Framework powered by DuckDB, designed to seamlessly integrate and process data from diverse sources. It leverages Markdown as a configuration medium, where YAML blocks define metadata for each data source, and embedded SQL blocks specify the extraction, transformation, and loading logic.
The report that we currently export does not calculate figures correctly. The company that we have the program through currently offers no solution to the issue. I created a way to crawl the Excel report and extract the information that was necessary for accurate reporting.
Efficiently process and automate complex reports using Python. This project streamlines data integration, cleaning, and report generation, reducing processing time by 97%.