{ "cells": [ { "metadata": {}, "cell_type": "markdown", "source": "# Tutorial 13 - add_power", "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-13T20:50:17.805661200Z", "start_time": "2026-06-13T20:50:17.286949300Z" } }, "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-13T20:50:17.824546800Z", "start_time": "2026-06-13T20:50:17.814925100Z" } }, "cell_type": "code", "source": "eet.set_logging_style(\"ERROR\")", "id": "9edef9d707e9392f", "outputs": [], "execution_count": 2 }, { "metadata": { "ExecuteTime": { "end_time": "2026-06-13T20:50:22.924328100Z", "start_time": "2026-06-13T20:50:17.825735400Z" } }, "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-13T20:50:22.945532800Z", "start_time": "2026-06-13T20:50:22.934727900Z" } }, "cell_type": "code", "source": "eet.BatteryConfig.DEFAULT", "id": "9186effcd32669ee", "outputs": [ { "data": { "text/plain": [ "_BatteryConfigClass(cell_name='Default', c_ref=None, 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=1, 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_power", "id": "3ce5298b8a8f6a8e" }, { "cell_type": "code", "source": [ "df = eet.add_power(\n", " df=standardized_data,\n", " verbose=True,\n", ")" ], "id": "7670108f21833e18", "metadata": { "ExecuteTime": { "end_time": "2026-06-13T20:50:22.963837400Z", "start_time": "2026-06-13T20:50:22.945532800Z" } }, "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_13", "metadata": { "ExecuteTime": { "end_time": "2026-06-13T20:50:22.969504100Z", "start_time": "2026-06-13T20:50:22.963837400Z" } }, "outputs": [ { "data": { "text/plain": [ "['Power[W]']" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 6 }, { "cell_type": "code", "source": "df.head(6)", "id": "head_13", "metadata": { "ExecuteTime": { "end_time": "2026-06-13T20:50:22.985716600Z", "start_time": "2026-06-13T20:50:22.970116100Z" } }, "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] \n", "0.0 5.070977 \n", "1.0 5.080622 \n", "2.0 5.082912 \n", "3.0 5.084208 \n", "4.0 5.085713 \n", "5.0 5.086865 " ], "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", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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", "
| 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", "
| 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", "
| 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", "
| 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", "
| 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", "