{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "data=pd.read_excel(\"plclog20230613.xlsx\")" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(576000, 112)" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data.shape" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | time | \n", "sn | \n", "steps | \n", "status | \n", "x_v | \n", "y_v | \n", "z_v | \n", "r_v | \n", "pause | \n", "x_s | \n", "... | \n", "lift_code_dist | \n", "deflect2 | \n", "pushrod2_out_time | \n", "pushrod3_out_time | \n", "pushrod2_in_time | \n", "pushrod3_in_time | \n", "pushrod1_out_time | \n", "pushrod4_out_time | \n", "pushrod1_in_time | \n", "pushrod4_in_time | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2023-06-13 00:00:00.086 | \n", "plc | \n", "0 | \n", "1 | \n", "-0.074901 | \n", "0.150925 | \n", "-0.008602 | \n", "0.000000 | \n", "0 | \n", "3.759514e-06 | \n", "... | \n", "-752.316 | \n", "1.898266e-310 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "
1 | \n", "2023-06-13 00:00:00.186 | \n", "plc | \n", "0 | \n", "1 | \n", "0.000000 | \n", "-0.150925 | \n", "0.008602 | \n", "0.000000 | \n", "0 | \n", "-9.218238e-07 | \n", "... | \n", "-752.316 | \n", "1.898266e-310 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "
2 | \n", "2023-06-13 00:00:00.286 | \n", "plc | \n", "0 | \n", "1 | \n", "-0.224704 | \n", "0.226387 | \n", "0.000000 | \n", "-0.019073 | \n", "0 | \n", "-1.028450e-05 | \n", "... | \n", "-752.316 | \n", "1.898266e-310 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "
3 | \n", "2023-06-13 00:00:00.386 | \n", "plc | \n", "0 | \n", "1 | \n", "0.000000 | \n", "0.226387 | \n", "0.000000 | \n", "-0.019073 | \n", "0 | \n", "3.759514e-06 | \n", "... | \n", "-752.316 | \n", "1.898266e-310 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "
4 | \n", "2023-06-13 00:00:00.486 | \n", "plc | \n", "0 | \n", "1 | \n", "0.299606 | \n", "0.075462 | \n", "0.000000 | \n", "-0.019073 | \n", "0 | \n", "1.312219e-05 | \n", "... | \n", "-752.316 | \n", "1.898266e-310 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "5000 | \n", "
5 rows × 112 columns
\n", "\n", " | time | \n", "change_flag | \n", "steps | \n", "pushrod3_retracted | \n", "pushrod3_extended | \n", "time2 | \n", "time_delta | \n", "
---|---|---|---|---|---|---|---|
59 | \n", "2023-06-13 03:10:39.186 | \n", "40 | \n", "8 | \n", "0 | \n", "1 | \n", "2023-06-13 03:10:36.486 | \n", "2.7 | \n", "
80 | \n", "2023-06-13 03:55:48.186 | \n", "54 | \n", "8 | \n", "0 | \n", "1 | \n", "2023-06-13 03:55:45.486 | \n", "2.7 | \n", "
305 | \n", "2023-06-13 11:33:55.186 | \n", "206 | \n", "8 | \n", "0 | \n", "1 | \n", "2023-06-13 11:33:52.386 | \n", "2.8 | \n", "
410 | \n", "2023-06-13 15:50:11.486 | \n", "276 | \n", "8 | \n", "0 | \n", "1 | \n", "2023-06-13 15:50:08.886 | \n", "2.6 | \n", "