{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"'grep' is not recognized as an internal or external command,\n",
"operable program or batch file.\n"
]
}
],
"source": [
"! grep -i capacity fullcap_20230822.txt | awk '{print $7\",\"$13\",\"$15}' | grep ^4 > battery_caps_20230822.txt\n",
"# normally that makes the file, the I manually cleanup and set."
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"from matplotlib import pyplot as plt"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" SN | \n",
" Capacity | \n",
" FullChargeCapacity | \n",
"
\n",
" \n",
" \n",
" \n",
" | 0 | \n",
" 405 | \n",
" 1845 | \n",
" 1845 | \n",
"
\n",
" \n",
" | 1 | \n",
" 408 | \n",
" 2328 | \n",
" 2886 | \n",
"
\n",
" \n",
" | 2 | \n",
" 406 | \n",
" 1914 | \n",
" 2104 | \n",
"
\n",
" \n",
" | 3 | \n",
" 419 | \n",
" 1866 | \n",
" 1980 | \n",
"
\n",
" \n",
" | 4 | \n",
" 408 | \n",
" 2328 | \n",
" 2886 | \n",
"
\n",
" \n",
"
\n",
"
"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"data.hist('FullChargeCapacity', by='SN')"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Capacity | \n",
" FullChargeCapacity | \n",
"
\n",
" \n",
" | SN | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" | 405 | \n",
" 1845.000000 | \n",
" 2260.250000 | \n",
"
\n",
" \n",
" | 406 | \n",
" 1914.000000 | \n",
" 2080.250000 | \n",
"
\n",
" \n",
" | 408 | \n",
" 2337.000000 | \n",
" 2886.000000 | \n",
"
\n",
" \n",
" | 419 | \n",
" 1818.000000 | \n",
" 1950.333333 | \n",
"
\n",
" \n",
" | 437 | \n",
" 1695.666667 | \n",
" 1852.000000 | \n",
"
\n",
" \n",
" | 453 | \n",
" 2355.555556 | \n",
" 3019.000000 | \n",
"
\n",
" \n",
"
\n",
"