{ "cells": [ { "metadata": {}, "cell_type": "markdown", "source": "# Tutorial 09 - add_charge_throughput", "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:47.637682200Z", "start_time": "2026-06-19T06:35:46.604146200Z" } }, "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:47.650180100Z", "start_time": "2026-06-19T06:35:47.644991100Z" } }, "cell_type": "code", "source": "eet.set_logging_style(\"ERROR\")", "id": "9edef9d707e9392f", "outputs": [], "execution_count": 2 }, { "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:51.534081400Z", "start_time": "2026-06-19T06:35:47.650180100Z" } }, "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": {}, "cell_type": "markdown", "source": "## Step 1: add_charge_throughput", "id": "3ce5298b8a8f6a8e" }, { "cell_type": "code", "source": [ "df = eet.add_charge_throughput(\n", " df=standardized_data,\n", " calculate_tests_individually=False,\n", " verbose=True,\n", ")" ], "id": "7670108f21833e18", "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:51.562871100Z", "start_time": "2026-06-19T06:35:51.540172400Z" } }, "outputs": [], "execution_count": 4 }, { "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_09", "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:51.579137300Z", "start_time": "2026-06-19T06:35:51.566969900Z" } }, "outputs": [ { "data": { "text/plain": [ "['ChargeThroughput[Ah]', 'AbsoluteChargeThroughput[Ah]']" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 5 }, { "cell_type": "code", "source": "df.head(6)", "id": "head_09", "metadata": { "ExecuteTime": { "end_time": "2026-06-19T06:35:51.595859200Z", "start_time": "2026-06-19T06:35:51.584784500Z" } }, "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", " ChargeThroughput[Ah] AbsoluteChargeThroughput[Ah] \n", "0.0 0.0000 0.0000 \n", "1.0 0.0004 0.0004 \n", "2.0 0.0008 0.0008 \n", "3.0 0.0012 0.0012 \n", "4.0 0.0016 0.0016 \n", "5.0 0.0020 0.0020 " ], "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", "ChargeThroughput[Ah] | \n", "AbsoluteChargeThroughput[Ah] | \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", "0.0000 | \n", "0.0000 | \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", "0.0004 | \n", "0.0004 | \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", "0.0008 | \n", "0.0008 | \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", "0.0012 | \n", "0.0012 | \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", "0.0016 | \n", "0.0016 | \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", "0.0020 | \n", "0.0020 | \n", "