{ "cells": [ { "metadata": {}, "cell_type": "markdown", "source": "# Tutorial 10 - add_cumulative_energy", "id": "3227661c7ad98a63" }, { "metadata": {}, "cell_type": "markdown", "source": "## Step 0: Setup the project and prepare the data", "id": "55bbc37fc6a453b4" }, { "cell_type": "code", "id": "initial_id", "metadata": { "collapsed": true, "ExecuteTime": { "end_time": "2026-06-19T06:35:50.791027800Z", "start_time": "2026-06-19T06:35:50.310297200Z" } }, "source": [ "from pathlib import Path\n", "\n", "import pydpeet as eet" ], "outputs": [], "execution_count": 1 }, { "metadata": {}, "cell_type": "markdown", "source": "We will use \"ERROR\" as the logging style for better readability of the notebook", "id": "c44394f08aac949e" }, { "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:50.820448300Z", "start_time": "2026-06-19T06:35:50.811464800Z" } }, "cell_type": "code", "source": "eet.set_logging_style(\"ERROR\")", "id": "9edef9d707e9392f", "outputs": [], "execution_count": 2 }, { "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:54.681532100Z", "start_time": "2026-06-19T06:35:50.821505600Z" } }, "cell_type": "code", "source": [ "standardized_data = eet.read(\n", " input_path=str(Path.cwd().parent.parent / \"res\" / \"raw_data_from_cyclers\" / \"Cal_Ageing_Checkup1.xlsx\"),\n", " config=eet.ReadConfig.Neware_8_0_0_516,\n", ")" ], "id": "f07e60bdeabfbc23", "outputs": [], "execution_count": 3 }, { "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:54.699598Z", "start_time": "2026-06-19T06:35:54.687810100Z" } }, "cell_type": "code", "source": "eet.BatteryConfig.DEFAULT", "id": "9186effcd32669ee", "outputs": [ { "data": { "text/plain": [ "_BatteryConfigClass(cell_name='Default', c_ref=4.8, soc_start=0, max_voltage=4.2, min_voltage=2.5, threshold_current=0.075, voltage_intervall=0.01, minimal_current_for_capacity=-1.2, maximal_current_for_capacity=-0.8, min_current_diff=0.5, max_time_diff=0.5, min_voltage_diff=0, ignore_negative_resistance_values=False)" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 4 }, { "metadata": {}, "cell_type": "markdown", "source": "## Step 1: add_cumulative_energy", "id": "3ce5298b8a8f6a8e" }, { "cell_type": "code", "source": [ "df = eet.add_cumulative_energy(\n", " df=standardized_data,\n", " config=eet.BatteryConfig.DEFAULT,\n", " verbose=True,\n", ")" ], "id": "7670108f21833e18", "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:54.722761300Z", "start_time": "2026-06-19T06:35:54.700604100Z" } }, "outputs": [], "execution_count": 5 }, { "cell_type": "code", "source": [ "added_cols = [c for c in df.columns if c not in standardized_data.columns]\n", "added_cols" ], "id": "added_cols_10", "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:54.736189500Z", "start_time": "2026-06-19T06:35:54.724835600Z" } }, "outputs": [ { "data": { "text/plain": [ "['Power[W]', 'CumulativeEnergy[Wh]', 'AbsoluteCumulativeEnergy[Wh]']" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 6 }, { "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:54.762190600Z", "start_time": "2026-06-19T06:35:54.741300200Z" } }, "cell_type": "code", "source": "df.head(6)", "id": "cc43297765646095", "outputs": [ { "data": { "text/plain": [ " Meta_Data Step_Count \\\n", "0.0 20240201100904-CheckUp-3-7-AM23NMC00009.xlsx U... 0 \n", "1.0 None 0 \n", "2.0 None 0 \n", "3.0 None 0 \n", "4.0 None 0 \n", "5.0 None 0 \n", "\n", " Voltage[V] Current[A] Temperature[°C] Test_Time[s] \\\n", "0.0 3.5269 1.4378 27.8 0.0 \n", "1.0 3.5287 1.4398 27.8 1.0 \n", "2.0 3.5298 1.4400 27.8 2.0 \n", "3.0 3.5307 1.4400 27.8 3.0 \n", "4.0 3.5315 1.4401 27.8 4.0 \n", "5.0 3.5323 1.4401 27.8 5.0 \n", "\n", " Date_Time EIS_f[Hz] EIS_Z_Real[Ohm] EIS_Z_Imag[Ohm] EIS_DC[A] \\\n", "0.0 2024-02-01 10:09:04 None None None None \n", "1.0 2024-02-01 10:09:05 None None None None \n", "2.0 2024-02-01 10:09:06 None None None None \n", "3.0 2024-02-01 10:09:07 None None None None \n", "4.0 2024-02-01 10:09:08 None None None None \n", "5.0 2024-02-01 10:09:09 None None None None \n", "\n", " Power[W] CumulativeEnergy[Wh] AbsoluteCumulativeEnergy[Wh] \n", "0.0 5.070977 0.000000 0.000000 \n", "1.0 5.080622 0.001410 0.001410 \n", "2.0 5.082912 0.002822 0.002822 \n", "3.0 5.084208 0.004234 0.004234 \n", "4.0 5.085713 0.005646 0.005646 \n", "5.0 5.086865 0.007059 0.007059 " ], "text/html": [ "
| \n", " | Meta_Data | \n", "Step_Count | \n", "Voltage[V] | \n", "Current[A] | \n", "Temperature[°C] | \n", "Test_Time[s] | \n", "Date_Time | \n", "EIS_f[Hz] | \n", "EIS_Z_Real[Ohm] | \n", "EIS_Z_Imag[Ohm] | \n", "EIS_DC[A] | \n", "Power[W] | \n", "CumulativeEnergy[Wh] | \n", "AbsoluteCumulativeEnergy[Wh] | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.0 | \n", "20240201100904-CheckUp-3-7-AM23NMC00009.xlsx U... | \n", "0 | \n", "3.5269 | \n", "1.4378 | \n", "27.8 | \n", "0.0 | \n", "2024-02-01 10:09:04 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "5.070977 | \n", "0.000000 | \n", "0.000000 | \n", "
| 1.0 | \n", "None | \n", "0 | \n", "3.5287 | \n", "1.4398 | \n", "27.8 | \n", "1.0 | \n", "2024-02-01 10:09:05 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "5.080622 | \n", "0.001410 | \n", "0.001410 | \n", "
| 2.0 | \n", "None | \n", "0 | \n", "3.5298 | \n", "1.4400 | \n", "27.8 | \n", "2.0 | \n", "2024-02-01 10:09:06 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "5.082912 | \n", "0.002822 | \n", "0.002822 | \n", "
| 3.0 | \n", "None | \n", "0 | \n", "3.5307 | \n", "1.4400 | \n", "27.8 | \n", "3.0 | \n", "2024-02-01 10:09:07 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "5.084208 | \n", "0.004234 | \n", "0.004234 | \n", "
| 4.0 | \n", "None | \n", "0 | \n", "3.5315 | \n", "1.4401 | \n", "27.8 | \n", "4.0 | \n", "2024-02-01 10:09:08 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "5.085713 | \n", "0.005646 | \n", "0.005646 | \n", "
| 5.0 | \n", "None | \n", "0 | \n", "3.5323 | \n", "1.4401 | \n", "27.8 | \n", "5.0 | \n", "2024-02-01 10:09:09 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "5.086865 | \n", "0.007059 | \n", "0.007059 | \n", "