analyze_data_ranges.py

import pandas as pd
from utils.excel_loader import load_submarine_forecast_data

data = load_submarine_forecast_data('dataset/submarine_forecast.xlsx')

print('1. LOAD:', data['load']['mw'].min(), '-', data['load']['mw'].max(), 'MW')
print('2. TEMP:', data['temp']['MaxTemp'].min(), '-', data['temp']['MaxTemp'].max(), 'C')
print('3. TEPR VALUE:', data['tepr']['VALUE'].min(), '-', data['tepr']['VALUE'].max(), '(mean:', data['tepr']['VALUE'].mean(), ')')
print('4. STRR VALUE:', data['strr']['VALUE'].min(), '-', data['strr']['VALUE'].max(), '(mean:', data['strr']['VALUE'].mean(), ')')