Refactor optimization configuration and constants integrationβ
haileyhalimj@gmail.com
fa2c20f
- Updated `optimization_config.py` to utilize constants from `constants.py` for better maintainability.
- Added new constants for line counts, maximum parallel workers, and default rates.
- Enhanced session state initialization in `config_page.py` to use values from `DefaultConfig`.
- Improved architecture diagram to reflect changes in optimization flow.
Trying to fix infinite reloading
haileyhalimj@gmail.com
28016d1
add separate function in excel to csv
haileyhalimj@gmail.com
8c95080
ποΈ Remove PostgreSQL database dependencies and related filesβ
haileyhalimj@gmail.com
d45fa12
- Delete docker-compose.yaml (PostgreSQL and pgAdmin services)
- Remove src/preprocess/db.py (database connection file)
- Clean up setup.py: remove psycopg2-binary and SQLAlchemy dependencies
- Remove docker/ directory and initialization files
- Update README.md to reflect simplified structure
- Add Excel processing dependencies (openpyxl, xlrd) to setup.py
- Project now uses CSV files directly without database layer
- Simplified deployment without Docker dependencies
Recover and restore preprocessing improvements from d54de4eβ
haileyhalimj@gmail.com
8504f5a
Restored all preprocessing work that was done today:
- Add data_preprocess.py: Helper functions for data preprocessing
- Improve extract.py: Better data extraction logic (108 lines modified)
- Enhance kit_composition_cleaner.py: Major improvements (260 lines, 361 lines modified)
- Update transform.py: Better transformation logic (36 lines modified)
- Add paths.yaml: Configuration for data paths
Total: 505 lines changed across preprocessing module
This represents a full day's work on improving the preprocessing pipeline.
Restore improved optimizer and simplify demand validationβ
haileyhalimj@gmail.com
acd1110
Major improvements:
- Remove IDLE employee tracking from optimizer_real.py
- Improve variable naming: Z/T/U β Assignment/Hours/Units
- Add new employee tracking system: EMPLOYEE_COUNT and EMPLOYEE_HOURS
- Simplify demand_validation_viz.py (371β270 lines)
- Remove idle employee display from optimization_results.py
Code reorganization:
- Rename src/utils to src/preprocess for better organization
Testing: β Optimization runs successfully with 3 products, β¬419.10 total cost
Update all imports from src.etl to src.preprocess
haileyhalimj@gmail.com
c9c4af4
Rename src/etl to src/preprocess for better code organization