{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "da341276", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import pdb, os\n", "from tqdm import tqdm" ] }, { "cell_type": "code", "execution_count": 2, "id": "38b48ab2", "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
level_0TimestamptypePIDkeydatarangeindexLeft_Gaze_XLeft_Gaze_Y...clientYconditionparttaskIDbuttonisCurrentlyPastinglorem_formatlorem_textruleslabel
event
undefined2222000000...0222000022
Align centerAlign498498498498000000...04984984980000498498
Align leftAlign52525252000000...052525200005252
Align rightAlign436436436436000000...04364364360000436436
Bold (CTRL+B)Bold338338338338000000...03383383380000338338
Font FamilyFont3058305830583058000000...0305830583058000030583058
Font SizeFont1558155815581558000000...0155815581558000015581558
Italic (CTRL+I)Italic349349349349000000...03493493490000349349
Underline (CTRL+U)Underline396396396396000000...03963963960000396396
\n", "

9 rows × 27 columns

\n", "
" ], "text/plain": [ " level_0 Timestamp type PID key data range \\\n", "event \n", " undefined 2 2 2 2 0 0 0 \n", "Align centerAlign 498 498 498 498 0 0 0 \n", "Align leftAlign 52 52 52 52 0 0 0 \n", "Align rightAlign 436 436 436 436 0 0 0 \n", "Bold (CTRL+B)Bold 338 338 338 338 0 0 0 \n", "Font FamilyFont 3058 3058 3058 3058 0 0 0 \n", "Font SizeFont 1558 1558 1558 1558 0 0 0 \n", "Italic (CTRL+I)Italic 349 349 349 349 0 0 0 \n", "Underline (CTRL+U)Underline 396 396 396 396 0 0 0 \n", "\n", " index Left_Gaze_X Left_Gaze_Y ... clientY \\\n", "event ... \n", " undefined 0 0 0 ... 0 \n", "Align centerAlign 0 0 0 ... 0 \n", "Align leftAlign 0 0 0 ... 0 \n", "Align rightAlign 0 0 0 ... 0 \n", "Bold (CTRL+B)Bold 0 0 0 ... 0 \n", "Font FamilyFont 0 0 0 ... 0 \n", "Font SizeFont 0 0 0 ... 0 \n", "Italic (CTRL+I)Italic 0 0 0 ... 0 \n", "Underline (CTRL+U)Underline 0 0 0 ... 0 \n", "\n", " condition part taskID button \\\n", "event \n", " undefined 2 2 2 0 \n", "Align centerAlign 498 498 498 0 \n", "Align leftAlign 52 52 52 0 \n", "Align rightAlign 436 436 436 0 \n", "Bold (CTRL+B)Bold 338 338 338 0 \n", "Font FamilyFont 3058 3058 3058 0 \n", "Font SizeFont 1558 1558 1558 0 \n", "Italic (CTRL+I)Italic 349 349 349 0 \n", "Underline (CTRL+U)Underline 396 396 396 0 \n", "\n", " isCurrentlyPasting lorem_format lorem_text \\\n", "event \n", " undefined 0 0 0 \n", "Align centerAlign 0 0 0 \n", "Align leftAlign 0 0 0 \n", "Align rightAlign 0 0 0 \n", "Bold (CTRL+B)Bold 0 0 0 \n", "Font FamilyFont 0 0 0 \n", "Font SizeFont 0 0 0 \n", "Italic (CTRL+I)Italic 0 0 0 \n", "Underline (CTRL+U)Underline 0 0 0 \n", "\n", " rules label \n", "event \n", " undefined 2 2 \n", "Align centerAlign 498 498 \n", "Align leftAlign 52 52 \n", "Align rightAlign 436 436 \n", "Bold (CTRL+B)Bold 338 338 \n", "Font FamilyFont 3058 3058 \n", "Font SizeFont 1558 1558 \n", "Italic (CTRL+I)Italic 349 349 \n", "Underline (CTRL+U)Underline 396 396 \n", "\n", "[9 rows x 27 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#study_data_path = '../IntentData/'\n", "#data = pd.read_pickle(study_data_path + \"/Preprocessing_data/filtered_data.pkl\")\n", "data = pd.read_pickle(\"filtered_data.pkl\")\n", "\n", "# Nine events (1 underdefined included)\n", "data[(data.type == \"toolbar\")].groupby([\"event\"]).count()" ] }, { "cell_type": "code", "execution_count": 3, "id": "41e16153", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "array(['Tab', 'Ctrl+I', 'Ctrl+Z', 'Esc', 'Italic (CTRL+I)Italic',\n", " 'Font FamilyFont', 'Ctrl+B', 'Align centerAlign', 'Font SizeFont',\n", " 'Align rightAlign', 'Underline (CTRL+U)Underline', nan, 'Ctrl+C',\n", " 'Shift+Tab', 'Bold (CTRL+B)Bold', ' undefined', 'Ctrl+A',\n", " 'Align leftAlign', 'Ctrl+N', 'Ctrl+V', 'Ctrl+H', 'Ctrl+Y',\n", " 'Ctrl+S', 'Ctrl+Tab', 'Ctrl+7'], dtype=object)" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Remove samples where rules=None\n", "data = data[(data.rules != 'None')]\n", "\n", "action_array = data[(data.type == \"commands\") | (data.type == \"toolbar\")].event.unique()\n", "action_array" ] }, { "cell_type": "code", "execution_count": 4, "id": "46d239fc", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'Tab': 8,\n", " 'Ctrl+I': 1,\n", " 'Ctrl+Z': 9,\n", " 'Esc': 10,\n", " 'Italic (CTRL+I)Italic': 1,\n", " 'Font FamilyFont': 4,\n", " 'Ctrl+B': 0,\n", " 'Align centerAlign': 5,\n", " 'Font SizeFont': 3,\n", " 'Align rightAlign': 6,\n", " 'Underline (CTRL+U)Underline': 2,\n", " nan: 12,\n", " 'Ctrl+C': 11,\n", " 'Shift+Tab': 8,\n", " 'Bold (CTRL+B)Bold': 0,\n", " ' undefined': 12}" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "toolbar_list = ['Bold (CTRL+B)Bold',\n", " 'Italic (CTRL+I)Italic',\n", " 'Underline (CTRL+U)Underline',\n", " 'Font SizeFont',\n", " 'Font FamilyFont',\n", " 'Align leftAlign',\n", " 'Align centerAlign',\n", " 'Align rightAlign',\n", " 'undefined']\n", "''''command_list = ['Ctrl+B',\n", " 'Ctrl+I',\n", " 'Tab',\n", " 'Shift+Tab',\n", " 'Ctrl+C',\n", " 'Ctrl+V',\n", " 'Ctrl+Z']'''\n", "allowed_command_list = ['Ctrl+B',\n", " 'Ctrl+I',\n", " 'Tab',\n", " 'Shift+Tab',\n", " 'Ctrl+U'] # As written in the paper, only allowed these shortcuts\n", "action_list = ['Bold', \n", " 'Italic', \n", " 'Underline',\n", " 'FontSize',\n", " 'FontFamily',\n", " 'AlignmentLeft',\n", " 'AlignmentCenter',\n", " 'AlignmentRight',\n", " 'Indent']\n", "# Map the keyboard shortcuts and operations on the toolbar to actions\n", "# 'Bold' 0\n", "# 'Italic' 1\n", "# 'Underline' 2\n", "# 'Font Size' 3\n", "# 'Font Family' 4\n", "# 'Alignment center' 5\n", "# 'Alignment right' 6\n", "# 'Alignment left' 7\n", "# 'Indent' 8\n", "# 'Revert' 9 \n", "# 'Next Task' 10\n", "# 'Copy' 11 \n", "# 'nan/undefined' 12\n", "action_numbers = [8, 1, 9, 10, 1, 4, 0, 5, 3, 6, 2, 12, 11, 8, 0, 12]\n", "action_dict = dict(zip(action_array, action_numbers))\n", "action_dict" ] }, { "cell_type": "code", "execution_count": 5, "id": "14829521", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "array(['commands', 'key', 'selection', 'toolbar', 'eye', 'pos', 'click',\n", " 'start', 'end', 'lorem'], dtype=object)" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data.type.unique()" ] }, { "cell_type": "code", "execution_count": 6, "id": "a77cebd0", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "keys: 34407 \n", "eyes: 8106054 \n", "mouse: 1947827 \n", "cmd: 3459 \n", "toolbar: 6859\n" ] } ], "source": [ "# Take out dataframes\n", "df_keys = data[data.type == \"key\"]\n", "df_eyes = data[data.type == \"eye\"]\n", "df_mouse_pos = data[data.type == \"pos\"]\n", "df_mouse_click = data[data.type == \"click\"]\n", "df_mouses = pd.concat([df_mouse_pos, df_mouse_click])\n", "df_cmds = data[data.type == \"commands\"]\n", "df_toolbars = data[data.type == \"toolbar\"]\n", "print(\"keys:\", len(df_keys), \"\\neyes:\", len(df_eyes), \"\\nmouse:\", len(df_mouses), \"\\ncmd:\",len(df_cmds), \"\\ntoolbar:\",len(df_toolbars))" ] }, { "cell_type": "code", "execution_count": 7, "id": "6418e565", "metadata": {}, "outputs": [], "source": [ "# Only take needed columns\n", "df_key = pd.DataFrame({\"Timestamp\": df_keys.Timestamp, \n", " \"Event\": df_keys.event, \n", " \"Key\": df_keys.key,\n", " \"TaskID\": df_keys.taskID,\n", " \"Part\": df_keys.part, \n", " \"PID\": df_keys.PID,\n", " \"TextRule\": df_keys.rules,\n", " \"Rule\": df_keys.label})\n", "df_eye = pd.DataFrame({\"Timestamp\": df_eyes.Timestamp, \n", " \"Gaze_X\": df_eyes.Gaze_X, \n", " \"Gaze_Y\": df_eyes.Gaze_Y, \n", " \"TaskID\": df_eyes.taskID,\n", " \"Part\": df_eyes.part, \n", " \"PID\": df_eyes.PID,\n", " \"TextRule\": df_eyes.rules,\n", " \"Rule\": df_eyes.label})\n", "df_mouse = pd.DataFrame({\"Timestamp\": df_mouses.Timestamp, \n", " \"X\": df_mouses.clientX, \n", " \"Y\": df_mouses.clientY,\n", " \"Type\": df_mouses.type, \n", " \"TaskID\": df_mouses.taskID,\n", " \"Part\": df_mouses.part, \n", " \"PID\": df_mouses.PID,\n", " \"TextRule\": df_mouses.rules,\n", " \"Event\": df_mouses.event,\n", " \"Rule\": df_mouses.label})\n", "df_mousePos = pd.DataFrame({\"Timestamp\": df_mouse_pos.Timestamp, \n", " \"X\": df_mouse_pos.clientX, \n", " \"Y\": df_mouse_pos.clientY,\n", " \"Type\": df_mouse_pos.type, \n", " \"TaskID\": df_mouse_pos.taskID,\n", " \"Part\": df_mouse_pos.part, \n", " \"PID\": df_mouse_pos.PID,\n", " \"TextRule\": df_mouse_pos.rules,\n", " \"Rule\": df_mouse_pos.label})\n", "df_cmd = pd.DataFrame({\"Timestamp\": df_cmds.Timestamp, \n", " \"Event\": df_cmds.event, \n", " \"TaskID\": df_cmds.taskID,\n", " \"Part\": df_cmds.part, \n", " \"PID\": df_cmds.PID,\n", " \"TextRule\": df_cmds.rules,\n", " \"Rule\": df_cmds.label})\n", "df_toolbar = pd.DataFrame({\"Timestamp\": df_toolbars.Timestamp, \n", " \"Event\": df_toolbars.event, \n", " \"TaskID\": df_toolbars.taskID,\n", " \"Part\": df_toolbars.part, \n", " \"PID\": df_toolbars.PID,\n", " \"TextRule\": df_toolbars.rules,\n", " \"Rule\": df_toolbars.label})\n", "# Keep PID, Part, TaskID, TextRule and Rule. Add Gaze and Pos\n", "df_label = df_eye.groupby([\"PID\",\"Part\",\"TaskID\"]).count().reset_index().drop([\"Timestamp\", \"Gaze_X\", \"Gaze_Y\"], axis=1)\n", "df_label[\"Gaze\"] = 0\n", "df_label[\"Pos\"] = 0\n", "#print(df_label)\n", "\n", "# Change keyboard values to uppercase\n", "df_key.Key = df_key.Key.apply(lambda x: x.upper())" ] }, { "cell_type": "code", "execution_count": 8, "id": "bcc70e36", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
TimestampEventKeyTaskIDPartPIDTextRuleRule
911575388456995keydownESCAPE011{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
1158941575388801164keydownESCAPE511{'Title': ['Size', 'Big', 'and', 'Underline'],...1
1350361575388888708keydownESCAPE611{'Title': ['Font', 'Family', 'Consolas', 'and'...6
3031981575389414398keydownESCAPE621{'Title': ['Font', 'Family', 'Consolas', 'and'...6
3710581575389612671keydownESCAPE231{'Title': ['Alignment', 'Center', 'and', 'Unde...0
3886041575389680615keydownESCAPE331{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
4340691575389811028keydownESCAPE531{'Title': ['Size', 'Big', 'and', 'Underline'],...1
1483031575983493827keydownESCAPE612{'Title': ['Bold', 'and', 'Underline'], 'Subti...2
2096861575983764051keydownESCAPE222{'Title': ['Font', 'Family', 'Consolas', 'and'...6
2351551575983852406keydownESCAPE322{'Title': ['Size', 'Big', 'and', 'Underline'],...1
2616591575983923344keydownESCAPE422{'Title': ['Alignment', 'Center', 'and', 'Unde...0
3184271575984168751keydownESCAPE032{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
3394701575984281075keydownESCAPE132{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
3721641575984373613keydownESCAPE232{'Title': ['Font', 'Family', 'Consolas', 'and'...6
3967791575984444888keydownESCAPE332{'Title': ['Size', 'Big', 'and', 'Underline'],...1
4188121575984507738keydownESCAPE432{'Title': ['Alignment', 'Center', 'and', 'Unde...0
4563871575984630149keydownESCAPE632{'Title': ['Bold', 'and', 'Underline'], 'Subti...2
5222491575984892276keydownESCAPE242{'Title': ['Font', 'Family', 'Consolas', 'and'...6
6143901575985243792keydownESCAPE052{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
6504741575985354507keydownESCAPE252{'Title': ['Font', 'Family', 'Consolas', 'and'...6
6662611575985448687keydownESCAPE352{'Title': ['Size', 'Big', 'and', 'Underline'],...1
6942491575985497666keydownESCAPE452{'Title': ['Alignment', 'Center', 'and', 'Unde...0
7082791575985549757keydownESCAPE552{'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub...4
871576500820142keydownESCAPE013{'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub...4
186301576500895888keydownESCAPE113{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
1179341576501236105keydownESCAPE613{'Title': ['Font', 'Family', 'Consolas', 'and'...6
1377681576501303236keydownESCAPE023{'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub...4
1746301576501417687keydownESCAPE223{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
3283711576501894917keydownESCAPE433{'Title': ['Alignment', 'Center', 'and', 'Unde...0
3448821576501949469keydownESCAPE533{'Title': ['Size', 'Big', 'and', 'Underline'],...1
4786071576502364010keydownESCAPE643{'Title': ['Font', 'Family', 'Consolas', 'and'...6
5316421576502533703keydownESCAPE253{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
5856771576502711019keydownESCAPE553{'Title': ['Size', 'Big', 'and', 'Underline'],...1
528621576508583224keydownESCAPE214{'Title': ['Bold', 'and', 'Underline'], 'Subti...2
761821576508676858keydownESCAPE314{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
1147751576508829687keydownESCAPE514{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
1308201576508910256keydownESCAPE614{'Title': ['Font', 'Family', 'Consolas', 'and'...6
2087431576509229027keydownESCAPE324{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
2243671576509290491keydownESCAPE424{'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub...4
2717601576509510395keydownESCAPE034{'Title': ['Alignment', 'Center', 'and', 'Unde...0
2846621576509692400keydownESCAPE334{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
2886001576509746972keydownESCAPE434{'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub...4
2931061576509806032keydownESCAPE534{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
2990941576509876765keydownESCAPE634{'Title': ['Font', 'Family', 'Consolas', 'and'...6
3199721576510098343keydownESCAPE244{'Title': ['Bold', 'and', 'Underline'], 'Subti...2
3996721576510384286keydownESCAPE644{'Title': ['Font', 'Family', 'Consolas', 'and'...6
4735641576510632190keydownESCAPE354{'Title': ['1', 'Indent', 'and', 'Italic'], 'S...3
5112571576510763377keydownESCAPE554{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
2571602506765679keydownESCAPE015{'Title': ['Bold', 'and', 'Underline'], 'Subti...2
1045901603451016010keydownESCAPE5112{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
2461741603451554880keydownESCAPE5212{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
3840721603452064761keydownESCAPE5312{'Title': ['Size', 'Big'], 'Subtitle': ['Bold'...5
5043471603460189671keydownESCAPE5413{'Title': ['Bold', 'and', 'Underline'], 'Subti...2
5161491603889725164keydownESCAPE6415{'Title': ['Font', 'Family', 'Consolas', 'and'...6
2591891603895855723keydownESCAPE4216{'Title': ['Alignment', 'Center', 'and', 'Unde...0
\n", "
" ], "text/plain": [ " Timestamp Event Key TaskID Part PID \\\n", "91 1575388456995 keydown ESCAPE 0 1 1 \n", "115894 1575388801164 keydown ESCAPE 5 1 1 \n", "135036 1575388888708 keydown ESCAPE 6 1 1 \n", "303198 1575389414398 keydown ESCAPE 6 2 1 \n", "371058 1575389612671 keydown ESCAPE 2 3 1 \n", "388604 1575389680615 keydown ESCAPE 3 3 1 \n", "434069 1575389811028 keydown ESCAPE 5 3 1 \n", "148303 1575983493827 keydown ESCAPE 6 1 2 \n", "209686 1575983764051 keydown ESCAPE 2 2 2 \n", "235155 1575983852406 keydown ESCAPE 3 2 2 \n", "261659 1575983923344 keydown ESCAPE 4 2 2 \n", "318427 1575984168751 keydown ESCAPE 0 3 2 \n", "339470 1575984281075 keydown ESCAPE 1 3 2 \n", "372164 1575984373613 keydown ESCAPE 2 3 2 \n", "396779 1575984444888 keydown ESCAPE 3 3 2 \n", "418812 1575984507738 keydown ESCAPE 4 3 2 \n", "456387 1575984630149 keydown ESCAPE 6 3 2 \n", "522249 1575984892276 keydown ESCAPE 2 4 2 \n", "614390 1575985243792 keydown ESCAPE 0 5 2 \n", "650474 1575985354507 keydown ESCAPE 2 5 2 \n", "666261 1575985448687 keydown ESCAPE 3 5 2 \n", "694249 1575985497666 keydown ESCAPE 4 5 2 \n", "708279 1575985549757 keydown ESCAPE 5 5 2 \n", "87 1576500820142 keydown ESCAPE 0 1 3 \n", "18630 1576500895888 keydown ESCAPE 1 1 3 \n", "117934 1576501236105 keydown ESCAPE 6 1 3 \n", "137768 1576501303236 keydown ESCAPE 0 2 3 \n", "174630 1576501417687 keydown ESCAPE 2 2 3 \n", "328371 1576501894917 keydown ESCAPE 4 3 3 \n", "344882 1576501949469 keydown ESCAPE 5 3 3 \n", "478607 1576502364010 keydown ESCAPE 6 4 3 \n", "531642 1576502533703 keydown ESCAPE 2 5 3 \n", "585677 1576502711019 keydown ESCAPE 5 5 3 \n", "52862 1576508583224 keydown ESCAPE 2 1 4 \n", "76182 1576508676858 keydown ESCAPE 3 1 4 \n", "114775 1576508829687 keydown ESCAPE 5 1 4 \n", "130820 1576508910256 keydown ESCAPE 6 1 4 \n", "208743 1576509229027 keydown ESCAPE 3 2 4 \n", "224367 1576509290491 keydown ESCAPE 4 2 4 \n", "271760 1576509510395 keydown ESCAPE 0 3 4 \n", "284662 1576509692400 keydown ESCAPE 3 3 4 \n", "288600 1576509746972 keydown ESCAPE 4 3 4 \n", "293106 1576509806032 keydown ESCAPE 5 3 4 \n", "299094 1576509876765 keydown ESCAPE 6 3 4 \n", "319972 1576510098343 keydown ESCAPE 2 4 4 \n", "399672 1576510384286 keydown ESCAPE 6 4 4 \n", "473564 1576510632190 keydown ESCAPE 3 5 4 \n", "511257 1576510763377 keydown ESCAPE 5 5 4 \n", "257 1602506765679 keydown ESCAPE 0 1 5 \n", "104590 1603451016010 keydown ESCAPE 5 1 12 \n", "246174 1603451554880 keydown ESCAPE 5 2 12 \n", "384072 1603452064761 keydown ESCAPE 5 3 12 \n", "504347 1603460189671 keydown ESCAPE 5 4 13 \n", "516149 1603889725164 keydown ESCAPE 6 4 15 \n", "259189 1603895855723 keydown ESCAPE 4 2 16 \n", "\n", " TextRule Rule \n", "91 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "115894 {'Title': ['Size', 'Big', 'and', 'Underline'],... 1 \n", "135036 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "303198 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "371058 {'Title': ['Alignment', 'Center', 'and', 'Unde... 0 \n", "388604 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "434069 {'Title': ['Size', 'Big', 'and', 'Underline'],... 1 \n", "148303 {'Title': ['Bold', 'and', 'Underline'], 'Subti... 2 \n", "209686 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "235155 {'Title': ['Size', 'Big', 'and', 'Underline'],... 1 \n", "261659 {'Title': ['Alignment', 'Center', 'and', 'Unde... 0 \n", "318427 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "339470 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "372164 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "396779 {'Title': ['Size', 'Big', 'and', 'Underline'],... 1 \n", "418812 {'Title': ['Alignment', 'Center', 'and', 'Unde... 0 \n", "456387 {'Title': ['Bold', 'and', 'Underline'], 'Subti... 2 \n", "522249 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "614390 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "650474 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "666261 {'Title': ['Size', 'Big', 'and', 'Underline'],... 1 \n", "694249 {'Title': ['Alignment', 'Center', 'and', 'Unde... 0 \n", "708279 {'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub... 4 \n", "87 {'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub... 4 \n", "18630 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "117934 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "137768 {'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub... 4 \n", "174630 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "328371 {'Title': ['Alignment', 'Center', 'and', 'Unde... 0 \n", "344882 {'Title': ['Size', 'Big', 'and', 'Underline'],... 1 \n", "478607 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "531642 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "585677 {'Title': ['Size', 'Big', 'and', 'Underline'],... 1 \n", "52862 {'Title': ['Bold', 'and', 'Underline'], 'Subti... 2 \n", "76182 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "114775 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "130820 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "208743 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "224367 {'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub... 4 \n", "271760 {'Title': ['Alignment', 'Center', 'and', 'Unde... 0 \n", "284662 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "288600 {'Title': ['Size', 'Big', 'and', 'Bold'], 'Sub... 4 \n", "293106 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "299094 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "319972 {'Title': ['Bold', 'and', 'Underline'], 'Subti... 2 \n", "399672 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "473564 {'Title': ['1', 'Indent', 'and', 'Italic'], 'S... 3 \n", "511257 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "257 {'Title': ['Bold', 'and', 'Underline'], 'Subti... 2 \n", "104590 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "246174 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "384072 {'Title': ['Size', 'Big'], 'Subtitle': ['Bold'... 5 \n", "504347 {'Title': ['Bold', 'and', 'Underline'], 'Subti... 2 \n", "516149 {'Title': ['Font', 'Family', 'Consolas', 'and'... 6 \n", "259189 {'Title': ['Alignment', 'Center', 'and', 'Unde... 0 " ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# All events for 'ESCAPE' are keydown !!!!!!\n", "df_key[df_key.Key=='ESCAPE']" ] }, { "cell_type": "code", "execution_count": 9, "id": "a2934358", "metadata": { "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "ENTER keydown pre: 12480\n", "ENTER keydown post: 12480\n", "ENTER keyup pre: 12480\n", "ENTER keyup post: 12480\n", "TAB keydown pre: 2738\n", "TAB keydown post: 2738\n", "TAB keyup pre: 2738\n", "TAB keyup post: 2738\n", "CONTROL keydown pre: 8256\n", "CONTROL keydown post: 5716\n", "CONTROL keyup pre: 5716\n", "CONTROL keyup post: 5712\n", "I keydown pre: 1770\n", "I keydown post: 1770\n", "I keyup pre: 1770\n", "I keyup post: 1770\n", "Z keydown pre: 210\n", "Z keydown post: 210\n", "Z keyup pre: 210\n", "Z keyup post: 210\n", "CAPSLOCK keydown pre: 20\n", "CAPSLOCK keydown post: 20\n", "CAPSLOCK keyup pre: 20\n", "CAPSLOCK keyup post: 20\n", "SHIFT keydown pre: 394\n", "SHIFT keydown post: 222\n", "SHIFT keyup pre: 222\n", "SHIFT keyup post: 222\n", "ARROWRIGHT keydown pre: 642\n", "ARROWRIGHT keydown post: 616\n", "ARROWRIGHT keyup pre: 616\n", "ARROWRIGHT keyup post: 616\n", "ESCAPE keydown pre: 55\n", "ESCAPE keydown post: 1\n", "ESCAPE keyup pre: 1\n", "ESCAPE keyup post: 1\n", "B keydown pre: 1982\n", "B keydown post: 1982\n", "B keyup pre: 1982\n", "B keyup post: 1982\n", "U keydown pre: 1722\n", "U keydown post: 1722\n", "U keyup pre: 1722\n", "U keyup post: 1722\n", "ARROWLEFT keydown pre: 158\n", "ARROWLEFT keydown post: 158\n", "ARROWLEFT keyup pre: 158\n", "ARROWLEFT keyup post: 158\n", "UNIDENTIFIED keydown pre: 11\n", "UNIDENTIFIED keydown post: 10\n", "UNIDENTIFIED keyup pre: 10\n", "UNIDENTIFIED keyup post: 10\n", "Q keydown pre: 4\n", "Q keydown post: 4\n", "Q keyup pre: 4\n", "Q keyup post: 4\n", "BACKSPACE keydown pre: 3400\n", "BACKSPACE keydown post: 3400\n", "BACKSPACE keyup pre: 3400\n", "BACKSPACE keyup post: 3400\n", "HOME keydown pre: 30\n", "HOME keydown post: 30\n", "HOME keyup pre: 30\n", "HOME keyup post: 30\n", "DELETE keydown pre: 104\n", "DELETE keydown post: 104\n", "DELETE keyup pre: 104\n", "DELETE keyup post: 104\n", "ARROWUP keydown pre: 83\n", "ARROWUP keydown post: 72\n", "ARROWUP keyup pre: 72\n", "ARROWUP keyup post: 72\n", "C keydown pre: 6\n", "C keydown post: 6\n", "C keyup pre: 6\n", "C keyup post: 6\n", "+ keydown pre: 2\n", "+ keydown post: 2\n", "+ keyup pre: 2\n", "+ keyup post: 2\n", "ARROWDOWN keydown pre: 110\n", "ARROWDOWN keydown post: 110\n", "ARROWDOWN keyup pre: 110\n", "ARROWDOWN keyup post: 110\n", "END keydown pre: 8\n", "END keydown post: 8\n", "END keyup pre: 8\n", "END keyup post: 8\n", "A keydown pre: 20\n", "A keydown post: 20\n", "A keyup pre: 20\n", "A keyup post: 20\n", "N keydown pre: 4\n", "N keydown post: 4\n", "N keyup pre: 4\n", "N keyup post: 4\n", "V keydown pre: 18\n", "V keydown post: 18\n", "V keyup pre: 18\n", "V keyup post: 18\n", " keydown pre: 9\n", " keydown post: 8\n", " keyup pre: 8\n", " keyup post: 8\n", ". keydown pre: 32\n", ". keydown post: 32\n", ". keyup pre: 32\n", ". keyup post: 32\n", "S keydown pre: 10\n", "S keydown post: 10\n", "S keyup pre: 10\n", "S keyup post: 10\n", "ALT keydown pre: 29\n", "ALT keydown post: 2\n", "ALT keyup pre: 2\n", "ALT keyup post: 2\n", "D keydown pre: 8\n", "D keydown post: 8\n", "D keyup pre: 8\n", "D keyup post: 8\n", "E keydown pre: 2\n", "E keydown post: 2\n", "E keyup pre: 2\n", "E keyup post: 2\n", "DEAD keydown pre: 14\n", "DEAD keydown post: 14\n", "DEAD keyup pre: 14\n", "DEAD keyup post: 14\n", "H keydown pre: 4\n", "H keydown post: 4\n", "H keyup pre: 4\n", "H keyup post: 4\n", "Y keydown pre: 64\n", "Y keydown post: 64\n", "Y keyup pre: 64\n", "Y keyup post: 64\n", "; keydown pre: 2\n", "; keydown post: 2\n", "; keyup pre: 2\n", "; keyup post: 2\n", "Ö keydown pre: 4\n", "Ö keydown post: 4\n", "Ö keyup pre: 4\n", "Ö keyup post: 4\n", "7 keydown pre: 2\n", "7 keydown post: 2\n", "7 keyup pre: 2\n", "7 keyup post: 2\n" ] } ], "source": [ "# Consecutive multiple key up and down events -> only keep the first one\n", "def detect_duplicate(row, dup, direction):\n", " v = 1 if (row.Key == dup) & (row.Event == direction) else 0\n", " return v\n", "for dup in df_key.Key.unique():\n", " for direction in [\"keydown\", \"keyup\"]:\n", " df_key[\"Error_detection\"] = 0\n", " df_key[\"Error_detection_id\"] = 0\n", " # Mark all samples with dup as the value of key\n", " df_key.loc[df_key.Key == dup, \"Error_detection\"] = df_key.loc[df_key.Key == dup].apply(lambda row: detect_duplicate(row, dup, direction), axis=1)\n", " # Mark all samples after the first one in a consecutive segment\n", " df_key.loc[df_key.Key == dup, \"Error_detection_id\"] = df_key.loc[df_key.Key == dup, \"Error_detection\"].diff()\n", " # And remove them\n", " print(dup , direction, \"pre: \", len(df_key.loc[df_key.Key == dup]))\n", " df_key = df_key[~((df_key.Key == dup) & (df_key.Event == direction) & ( df_key.Error_detection_id == 0))]\n", " print(dup , direction, \"post: \", len(df_key.loc[df_key.Key == dup]))" ] }, { "cell_type": "code", "execution_count": 10, "id": "20699e03", "metadata": { "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "ENTER down: 6240\n", "ENTER up: 6240\n", "ENTER\n", "TAB down: 1369\n", "TAB up: 1369\n", "TAB\n", "CONTROL down: 2856\n", "CONTROL up: 2856\n", "CONTROL\n", "I down: 885\n", "I up: 885\n", "I\n", "Z down: 105\n", "Z up: 105\n", "Z\n", "CAPSLOCK down: 10\n", "CAPSLOCK up: 10\n", "CAPSLOCK\n", "SHIFT down: 111\n", "SHIFT up: 111\n", "SHIFT\n", "ARROWRIGHT down: 308\n", "ARROWRIGHT up: 308\n", "ARROWRIGHT\n", "ESCAPE down: 1\n", "ESCAPE up: 0\n", "B down: 991\n", "B up: 991\n", "B\n", "U down: 861\n", "U up: 861\n", "U\n", "ARROWLEFT down: 79\n", "ARROWLEFT up: 79\n", "ARROWLEFT\n", "UNIDENTIFIED down: 5\n", "UNIDENTIFIED up: 5\n", "UNIDENTIFIED\n", "Q down: 2\n", "Q up: 2\n", "Q\n", "BACKSPACE down: 1700\n", "BACKSPACE up: 1700\n", "BACKSPACE\n", "HOME down: 15\n", "HOME up: 15\n", "HOME\n", "DELETE down: 52\n", "DELETE up: 52\n", "DELETE\n", "ARROWUP down: 36\n", "ARROWUP up: 36\n", "ARROWUP\n", "C down: 3\n", "C up: 3\n", "C\n", "+ down: 1\n", "+ up: 1\n", "+\n", "ARROWDOWN down: 55\n", "ARROWDOWN up: 55\n", "ARROWDOWN\n", "END down: 4\n", "END up: 4\n", "END\n", "A down: 10\n", "A up: 10\n", "A\n", "N down: 2\n", "N up: 2\n", "N\n", "V down: 9\n", "V up: 9\n", "V\n", " down: 4\n", " up: 4\n", " \n", ". down: 16\n", ". up: 16\n", ".\n", "S down: 5\n", "S up: 5\n", "S\n", "ALT down: 1\n", "ALT up: 1\n", "ALT\n", "D down: 4\n", "D up: 4\n", "D\n", "E down: 1\n", "E up: 1\n", "E\n", "DEAD down: 7\n", "DEAD up: 7\n", "DEAD\n", "H down: 2\n", "H up: 2\n", "H\n", "Y down: 32\n", "Y up: 32\n", "Y\n", "; down: 1\n", "; up: 1\n", ";\n", "Ö down: 2\n", "Ö up: 2\n", "Ö\n", "7 down: 1\n", "7 up: 1\n", "7\n" ] } ], "source": [ "df_key.reset_index(drop=True, inplace=True)\n", "\n", "for k in df_key.Key.unique():\n", " k_downs = df_key[(df_key.Key == k) & (df_key.Event == \"keydown\")].index.tolist()\n", " k_ups = df_key[(df_key.Key == k) & (df_key.Event == \"keyup\")].index.tolist()\n", " print(k, \"down: \" ,len(k_downs))\n", " print(k, \"up: \",len(k_ups))\n", " if k!='ESCAPE':\n", " print(k)\n", " assert len(k_downs)==len(k_ups)" ] }, { "cell_type": "code", "execution_count": 11, "id": "62a1ca46", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:16: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True)\n", "/tmp/ipykernel_625665/1936093847.py:17: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n", " df_cmd = df_cmd.append(df_cmd_u)\n" ] } ], "source": [ "# append ctrl+u to df_cmd as it is not registered\n", "Ctrl_downs = df_key[(df_key.Key == \"CONTROL\") & (df_key.Event == \"keydown\")].index.tolist()\n", "Ctrl_ups = df_key[(df_key.Key == \"CONTROL\") & (df_key.Event == \"keyup\")].index.tolist()\n", "df_cmd_u = pd.DataFrame()\n", "for s,e in zip(Ctrl_downs, Ctrl_ups):\n", " tmp = df_key.loc[s:e]\n", " tmp = tmp[(tmp.Event == \"keydown\") & (tmp.Key == \"U\")]\n", " if (len(tmp) > 0):\n", " tmp_dict = {\"Timestamp\": tmp.Timestamp.iloc[0], \n", " \"Event\": \"Ctrl+U\", \n", " \"TaskID\": tmp.TaskID.iloc[0], \n", " \"Part\": tmp.Part.iloc[0], \n", " \"PID\":tmp.PID.iloc[0], \n", " \"TextRule\":tmp.TextRule.iloc[0], \n", " \"Rule\":tmp.Rule.iloc[0]}\n", " df_cmd_u = df_cmd_u.append(tmp_dict, ignore_index=True) \n", "df_cmd = df_cmd.append(df_cmd_u)" ] }, { "cell_type": "code", "execution_count": 12, "id": "a84563ae", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
TimestampTaskIDPartPIDTextRuleRule
Event
Ctrl+7111111
Ctrl+A888888
Ctrl+B991991991991991991
Ctrl+C111111
Ctrl+H222222
Ctrl+I884884884884884884
Ctrl+N111111
Ctrl+S222222
Ctrl+Tab111111
Ctrl+U854854854854854854
Ctrl+V777777
Ctrl+Y323232323232
Ctrl+Z104104104104104104
Esc575757575757
Shift+Tab151515151515
Tab135313531353135313531353
\n", "
" ], "text/plain": [ " Timestamp TaskID Part PID TextRule Rule\n", "Event \n", "Ctrl+7 1 1 1 1 1 1\n", "Ctrl+A 8 8 8 8 8 8\n", "Ctrl+B 991 991 991 991 991 991\n", "Ctrl+C 1 1 1 1 1 1\n", "Ctrl+H 2 2 2 2 2 2\n", "Ctrl+I 884 884 884 884 884 884\n", "Ctrl+N 1 1 1 1 1 1\n", "Ctrl+S 2 2 2 2 2 2\n", "Ctrl+Tab 1 1 1 1 1 1\n", "Ctrl+U 854 854 854 854 854 854\n", "Ctrl+V 7 7 7 7 7 7\n", "Ctrl+Y 32 32 32 32 32 32\n", "Ctrl+Z 104 104 104 104 104 104\n", "Esc 57 57 57 57 57 57\n", "Shift+Tab 15 15 15 15 15 15\n", "Tab 1353 1353 1353 1353 1353 1353" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_cmd.groupby([\"Event\"]).count()" ] }, { "cell_type": "code", "execution_count": 13, "id": "ee86dcb7", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "array(['Tab', 'Ctrl+I', 'Ctrl+Z', 'Esc', 'Ctrl+B', 'Ctrl+C', 'Shift+Tab',\n", " 'Ctrl+A', 'Ctrl+N', 'Ctrl+V', 'Ctrl+H', 'Ctrl+Y', 'Ctrl+S',\n", " 'Ctrl+Tab', 'Ctrl+7', 'Ctrl+U'], dtype=object)" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_cmd.Event.unique()" ] }, { "cell_type": "code", "execution_count": 14, "id": "109e2046", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[' undefined',\n", " 'Align centerAlign',\n", " 'Align leftAlign',\n", " 'Align rightAlign',\n", " 'Bold (CTRL+B)Bold',\n", " 'Font FamilyFont',\n", " 'Font SizeFont',\n", " 'Italic (CTRL+I)Italic',\n", " 'Underline (CTRL+U)Underline']" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_toolbar = df_toolbar[~df_toolbar.Event.isna()]\n", "toolbar_array = sorted(df_toolbar.Event.unique())\n", "toolbar_array" ] }, { "cell_type": "code", "execution_count": 15, "id": "5155e937", "metadata": { "scrolled": true }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|████████████████████████████████████████████| 3058/3058 [20:03<00:00, 2.55it/s]\n" ] } ], "source": [ "#if not os.path.exists(\"../ReRun/df_mouse.pkl\"):\n", "if not os.path.exists(\"df_mouse.pkl\"):\n", " df_mouse[\"Keep\"] = 0\n", " df_toolbar[\"X\"] = 0\n", " df_toolbar[\"Y\"] = 0\n", " # Font Family: all timestamps of event FamilyFont should have ONE corresponding (within 20ms) mouse click event\n", " for time in tqdm(df_toolbar[df_toolbar.Event == \"Font FamilyFont\"].Timestamp.values):\n", " assert len(df_mouse[(df_mouse.Event == \"up\") & (df_mouse.Type == \"click\") & (df_mouse.Timestamp <= time + 20) & (df_mouse.Timestamp >= time - 20)]) == 1 \n", " df_toolbar.loc[(df_toolbar.Timestamp == time) & (df_toolbar.Event == \"Font FamilyFont\"), \"X\"] = df_mouse[(df_mouse.Event == \"up\") & (df_mouse.Type == \"click\") & (df_mouse.Timestamp <= time + 20) & (df_mouse.Timestamp >= time - 20)].X.iloc[0]\n", " df_toolbar.loc[(df_toolbar.Timestamp == time) & (df_toolbar.Event == \"Font FamilyFont\"), \"Y\"] = df_mouse[(df_mouse.Event == \"up\") & (df_mouse.Type == \"click\") & (df_mouse.Timestamp <= time + 20) & (df_mouse.Timestamp >= time - 20)].Y.iloc[0]\n", " df_mouse.loc[(df_mouse.Event == \"up\") & (df_mouse.Type == \"click\") & (df_mouse.Timestamp <= time + 20) & (df_mouse.Timestamp >= time - 20), \"Keep\"] = 1\n", " #df_mouse.to_pickle(\"../ReRun/df_mouse.pkl\")\n", " #df_toolbar.to_pickle(\"../ReRun/df_toolbar.pkl\")\n", " df_mouse.to_pickle(\"df_mouse.pkl\")\n", " df_toolbar.to_pickle(\"df_toolbar.pkl\")\n", "else:\n", " #df_mouse = pd.read_pickle(\"../ReRun/df_mouse.pkl\")\n", " #df_toolbar = pd.read_pickle(\"../ReRun/df_toolbar.pkl\")\n", " df_mouse = pd.read_pickle(\"df_mouse.pkl\")\n", " df_toolbar = pd.read_pickle(\"df_toolbar.pkl\")" ] }, { "cell_type": "code", "execution_count": 20, "id": "d97268bc", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "\"'found = False\\nindexes = []\\nfor i, l in enumerate(df_toolbar.Event.tolist() + ['ENDE']):\\n #print(i, l, found)\\n if l in 'Font FamilyFont':\\n ind = i\\n found = True\\n elif l not in 'Font FamilyFont' and found:\\n indexes.append(ind)\\n found = False\\n elif l in 'Font FamilyFont' and found:\\n indexes.append(i)\\nprint(indexes)\\nlen(indexes)\"" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_toolbar.reset_index(drop=True, inplace=True)\n", "# Find the last \"Font FamilyFont\" in consecutive multiple \"Font FamilyFont\"s\n", "''''found = False\n", "indexes = []\n", "for i, l in enumerate(df_toolbar.Event.tolist() + ['ENDE']):\n", " #print(i, l, found)\n", " if l in 'Font FamilyFont':\n", " ind = i\n", " found = True\n", " elif l not in 'Font FamilyFont' and found:\n", " indexes.append(ind)\n", " found = False\n", " elif l in 'Font FamilyFont' and found:\n", " indexes.append(i)\n", "print(indexes)\n", "len(indexes)'''" ] }, { "cell_type": "code", "execution_count": 23, "id": "37af6fc7", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "['Ctrl+7', 'Ctrl+A', 'Ctrl+B', 'Ctrl+C', 'Ctrl+H', 'Ctrl+I', 'Ctrl+N', 'Ctrl+S', 'Ctrl+Tab', 'Ctrl+U', 'Ctrl+V', 'Ctrl+Y', 'Ctrl+Z', 'Esc', 'Shift+Tab', 'Tab']\n", "cmd_dict\n", " {'Ctrl+7': 'bold', 'Ctrl+A': 'italic', 'Ctrl+B': 'underline', 'Ctrl+C': 'indent', 'Ctrl+H': 'indent'}\n", "toolbar_dict\n", " {' undefined': 'indent', 'Align centerAlign': 'align', 'Align leftAlign': 'align', 'Align rightAlign': 'align', 'Bold (CTRL+B)Bold': 'bold', 'Font FamilyFont': 'fontFamily', 'Font SizeFont': 'fontSize', 'Italic (CTRL+I)Italic': 'italic', 'Underline (CTRL+U)Underline': 'underline'}\n" ] } ], "source": [ "cmd_array = sorted(df_cmd.Event.unique())\n", "print(cmd_array)\n", "#actions_array = [\"Italic\", \"Bold\", \"Underline\", \"Indent\", \"Align\", \"FontSize\", \"FontFamily\"]\n", "actions_array = [\"italic\", \"bold\", \"underline\", \"indent\", \"align\", \"fontSize\", \"fontFamily\"]\n", "toolbar_actions = [actions_array[3], actions_array[4], actions_array[4], actions_array[4], actions_array[1], actions_array[6], actions_array[5], actions_array[0], actions_array[2]]\n", "cmd_actions = [actions_array[1], actions_array[0], actions_array[2], actions_array[3], actions_array[3]]\n", "cmd_dict = dict(zip(cmd_array, cmd_actions))\n", "toolbar_dict = dict(zip(toolbar_array, toolbar_actions))\n", "print(\"cmd_dict\\n\",cmd_dict)\n", "print(\"toolbar_dict\\n\",toolbar_dict)" ] }, { "cell_type": "code", "execution_count": 24, "id": "69b2b9f5", "metadata": {}, "outputs": [ { "ename": "KeyError", "evalue": "'Italic'", "output_type": "error", "traceback": [ "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[0;31mKeyError\u001b[0m Traceback (most recent call last)", "Cell \u001b[0;32mIn[24], line 1\u001b[0m\n\u001b[0;32m----> 1\u001b[0m df_toolbar\u001b[38;5;241m.\u001b[39mEvent \u001b[38;5;241m=\u001b[39m \u001b[43mdf_toolbar\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mEvent\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mapply\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43;01mlambda\u001b[39;49;00m\u001b[43m \u001b[49m\u001b[43mx\u001b[49m\u001b[43m:\u001b[49m\u001b[43m \u001b[49m\u001b[43mtoolbar_dict\u001b[49m\u001b[43m[\u001b[49m\u001b[43mx\u001b[49m\u001b[43m]\u001b[49m\u001b[43m)\u001b[49m\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/core/series.py:4433\u001b[0m, in \u001b[0;36mSeries.apply\u001b[0;34m(self, func, convert_dtype, args, **kwargs)\u001b[0m\n\u001b[1;32m 4323\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mapply\u001b[39m(\n\u001b[1;32m 4324\u001b[0m \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m 4325\u001b[0m func: AggFuncType,\n\u001b[0;32m (...)\u001b[0m\n\u001b[1;32m 4328\u001b[0m \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs,\n\u001b[1;32m 4329\u001b[0m ) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m DataFrame \u001b[38;5;241m|\u001b[39m Series:\n\u001b[1;32m 4330\u001b[0m \u001b[38;5;124m\"\"\"\u001b[39m\n\u001b[1;32m 4331\u001b[0m \u001b[38;5;124m Invoke function on values of Series.\u001b[39m\n\u001b[1;32m 4332\u001b[0m \n\u001b[0;32m (...)\u001b[0m\n\u001b[1;32m 4431\u001b[0m \u001b[38;5;124m dtype: float64\u001b[39m\n\u001b[1;32m 4432\u001b[0m \u001b[38;5;124m \"\"\"\u001b[39m\n\u001b[0;32m-> 4433\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mSeriesApply\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mfunc\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mconvert_dtype\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mapply\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/core/apply.py:1088\u001b[0m, in \u001b[0;36mSeriesApply.apply\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m 1084\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mf, \u001b[38;5;28mstr\u001b[39m):\n\u001b[1;32m 1085\u001b[0m \u001b[38;5;66m# if we are a string, try to dispatch\u001b[39m\n\u001b[1;32m 1086\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mapply_str()\n\u001b[0;32m-> 1088\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mapply_standard\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/core/apply.py:1143\u001b[0m, in \u001b[0;36mSeriesApply.apply_standard\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m 1137\u001b[0m values \u001b[38;5;241m=\u001b[39m obj\u001b[38;5;241m.\u001b[39mastype(\u001b[38;5;28mobject\u001b[39m)\u001b[38;5;241m.\u001b[39m_values\n\u001b[1;32m 1138\u001b[0m \u001b[38;5;66m# error: Argument 2 to \"map_infer\" has incompatible type\u001b[39m\n\u001b[1;32m 1139\u001b[0m \u001b[38;5;66m# \"Union[Callable[..., Any], str, List[Union[Callable[..., Any], str]],\u001b[39m\n\u001b[1;32m 1140\u001b[0m \u001b[38;5;66m# Dict[Hashable, Union[Union[Callable[..., Any], str],\u001b[39m\n\u001b[1;32m 1141\u001b[0m \u001b[38;5;66m# List[Union[Callable[..., Any], str]]]]]\"; expected\u001b[39m\n\u001b[1;32m 1142\u001b[0m \u001b[38;5;66m# \"Callable[[Any], Any]\"\u001b[39m\n\u001b[0;32m-> 1143\u001b[0m mapped \u001b[38;5;241m=\u001b[39m \u001b[43mlib\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mmap_infer\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m 1144\u001b[0m \u001b[43m \u001b[49m\u001b[43mvalues\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m 1145\u001b[0m \u001b[43m \u001b[49m\u001b[43mf\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;66;43m# type: ignore[arg-type]\u001b[39;49m\n\u001b[1;32m 1146\u001b[0m \u001b[43m \u001b[49m\u001b[43mconvert\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mconvert_dtype\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m 1147\u001b[0m \u001b[43m \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m 1149\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mlen\u001b[39m(mapped) \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(mapped[\u001b[38;5;241m0\u001b[39m], ABCSeries):\n\u001b[1;32m 1150\u001b[0m \u001b[38;5;66m# GH#43986 Need to do list(mapped) in order to get treated as nested\u001b[39m\n\u001b[1;32m 1151\u001b[0m \u001b[38;5;66m# See also GH#25959 regarding EA support\u001b[39m\n\u001b[1;32m 1152\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m obj\u001b[38;5;241m.\u001b[39m_constructor_expanddim(\u001b[38;5;28mlist\u001b[39m(mapped), index\u001b[38;5;241m=\u001b[39mobj\u001b[38;5;241m.\u001b[39mindex)\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/_libs/lib.pyx:2870\u001b[0m, in \u001b[0;36mpandas._libs.lib.map_infer\u001b[0;34m()\u001b[0m\n", "Cell \u001b[0;32mIn[24], line 1\u001b[0m, in \u001b[0;36m\u001b[0;34m(x)\u001b[0m\n\u001b[0;32m----> 1\u001b[0m df_toolbar\u001b[38;5;241m.\u001b[39mEvent \u001b[38;5;241m=\u001b[39m df_toolbar\u001b[38;5;241m.\u001b[39mEvent\u001b[38;5;241m.\u001b[39mapply(\u001b[38;5;28;01mlambda\u001b[39;00m x: \u001b[43mtoolbar_dict\u001b[49m\u001b[43m[\u001b[49m\u001b[43mx\u001b[49m\u001b[43m]\u001b[49m)\n", "\u001b[0;31mKeyError\u001b[0m: 'Italic'" ] } ], "source": [ "df_toolbar.Event = df_toolbar.Event.apply(lambda x: toolbar_dict[x], axis=1)" ] }, { "cell_type": "code", "execution_count": 25, "id": "5fc17226", "metadata": {}, "outputs": [ { "ename": "KeyError", "evalue": "'Tab'", "output_type": "error", "traceback": [ "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[0;31mKeyError\u001b[0m Traceback (most recent call last)", "Cell \u001b[0;32mIn[25], line 1\u001b[0m\n\u001b[0;32m----> 1\u001b[0m df_cmd\u001b[38;5;241m.\u001b[39mEvent \u001b[38;5;241m=\u001b[39m \u001b[43mdf_cmd\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mEvent\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mapply\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43;01mlambda\u001b[39;49;00m\u001b[43m \u001b[49m\u001b[43mx\u001b[49m\u001b[43m:\u001b[49m\u001b[43m \u001b[49m\u001b[43mcmd_dict\u001b[49m\u001b[43m[\u001b[49m\u001b[43mx\u001b[49m\u001b[43m]\u001b[49m\u001b[43m)\u001b[49m\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/core/series.py:4433\u001b[0m, in \u001b[0;36mSeries.apply\u001b[0;34m(self, func, convert_dtype, args, **kwargs)\u001b[0m\n\u001b[1;32m 4323\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mapply\u001b[39m(\n\u001b[1;32m 4324\u001b[0m \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m 4325\u001b[0m func: AggFuncType,\n\u001b[0;32m (...)\u001b[0m\n\u001b[1;32m 4328\u001b[0m \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs,\n\u001b[1;32m 4329\u001b[0m ) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m DataFrame \u001b[38;5;241m|\u001b[39m Series:\n\u001b[1;32m 4330\u001b[0m \u001b[38;5;124m\"\"\"\u001b[39m\n\u001b[1;32m 4331\u001b[0m \u001b[38;5;124m Invoke function on values of Series.\u001b[39m\n\u001b[1;32m 4332\u001b[0m \n\u001b[0;32m (...)\u001b[0m\n\u001b[1;32m 4431\u001b[0m \u001b[38;5;124m dtype: float64\u001b[39m\n\u001b[1;32m 4432\u001b[0m \u001b[38;5;124m \"\"\"\u001b[39m\n\u001b[0;32m-> 4433\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mSeriesApply\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mfunc\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mconvert_dtype\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mapply\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/core/apply.py:1088\u001b[0m, in \u001b[0;36mSeriesApply.apply\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m 1084\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mf, \u001b[38;5;28mstr\u001b[39m):\n\u001b[1;32m 1085\u001b[0m \u001b[38;5;66m# if we are a string, try to dispatch\u001b[39m\n\u001b[1;32m 1086\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mapply_str()\n\u001b[0;32m-> 1088\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mapply_standard\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/core/apply.py:1143\u001b[0m, in \u001b[0;36mSeriesApply.apply_standard\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m 1137\u001b[0m values \u001b[38;5;241m=\u001b[39m obj\u001b[38;5;241m.\u001b[39mastype(\u001b[38;5;28mobject\u001b[39m)\u001b[38;5;241m.\u001b[39m_values\n\u001b[1;32m 1138\u001b[0m \u001b[38;5;66m# error: Argument 2 to \"map_infer\" has incompatible type\u001b[39m\n\u001b[1;32m 1139\u001b[0m \u001b[38;5;66m# \"Union[Callable[..., Any], str, List[Union[Callable[..., Any], str]],\u001b[39m\n\u001b[1;32m 1140\u001b[0m \u001b[38;5;66m# Dict[Hashable, Union[Union[Callable[..., Any], str],\u001b[39m\n\u001b[1;32m 1141\u001b[0m \u001b[38;5;66m# List[Union[Callable[..., Any], str]]]]]\"; expected\u001b[39m\n\u001b[1;32m 1142\u001b[0m \u001b[38;5;66m# \"Callable[[Any], Any]\"\u001b[39m\n\u001b[0;32m-> 1143\u001b[0m mapped \u001b[38;5;241m=\u001b[39m \u001b[43mlib\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mmap_infer\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m 1144\u001b[0m \u001b[43m \u001b[49m\u001b[43mvalues\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m 1145\u001b[0m \u001b[43m \u001b[49m\u001b[43mf\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;66;43m# type: ignore[arg-type]\u001b[39;49m\n\u001b[1;32m 1146\u001b[0m \u001b[43m \u001b[49m\u001b[43mconvert\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mconvert_dtype\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m 1147\u001b[0m \u001b[43m \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m 1149\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mlen\u001b[39m(mapped) \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(mapped[\u001b[38;5;241m0\u001b[39m], ABCSeries):\n\u001b[1;32m 1150\u001b[0m \u001b[38;5;66m# GH#43986 Need to do list(mapped) in order to get treated as nested\u001b[39m\n\u001b[1;32m 1151\u001b[0m \u001b[38;5;66m# See also GH#25959 regarding EA support\u001b[39m\n\u001b[1;32m 1152\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m obj\u001b[38;5;241m.\u001b[39m_constructor_expanddim(\u001b[38;5;28mlist\u001b[39m(mapped), index\u001b[38;5;241m=\u001b[39mobj\u001b[38;5;241m.\u001b[39mindex)\n", "File \u001b[0;32m~/.local/lib/python3.8/site-packages/pandas/_libs/lib.pyx:2870\u001b[0m, in \u001b[0;36mpandas._libs.lib.map_infer\u001b[0;34m()\u001b[0m\n", "Cell \u001b[0;32mIn[25], line 1\u001b[0m, in \u001b[0;36m\u001b[0;34m(x)\u001b[0m\n\u001b[0;32m----> 1\u001b[0m df_cmd\u001b[38;5;241m.\u001b[39mEvent \u001b[38;5;241m=\u001b[39m df_cmd\u001b[38;5;241m.\u001b[39mEvent\u001b[38;5;241m.\u001b[39mapply(\u001b[38;5;28;01mlambda\u001b[39;00m x: \u001b[43mcmd_dict\u001b[49m\u001b[43m[\u001b[49m\u001b[43mx\u001b[49m\u001b[43m]\u001b[49m)\n", "\u001b[0;31mKeyError\u001b[0m: 'Tab'" ] } ], "source": [ "df_cmd.Event = df_cmd.Event.apply(lambda x: cmd_dict[x], axis=1)" ] }, { "cell_type": "code", "execution_count": null, "id": "3506f41b", "metadata": {}, "outputs": [], "source": [ "df_toolbar[\"Type\"] = \"Toolbar\"\n", "df_cmd[\"Type\"] = \"Cmd\"\n", "df_actions = pd.concat([df_toolbar, df_cmd])\n", "df_actions = df_actions.sort_values(by=\"Timestamp\")\n", "df_actions.head()" ] }, { "cell_type": "code", "execution_count": null, "id": "c286b2f0", "metadata": {}, "outputs": [], "source": [ "actions_array_num = np.arange(1,len(actions_array)+1)\n", "action_dict = dict(zip(actions_array,actions_array_num))\n", "action_dict" ] }, { "cell_type": "code", "execution_count": null, "id": "c74aae24", "metadata": {}, "outputs": [], "source": [ "df_actions.Event = df_actions.Event.apply(lambda x: action_dict[x])\n", "#df_actions.reset_index(drop=True).to_pickle(study_data_path + \"../ReRun/clean_data.pkl\")\n", "df_actions.reset_index(drop=True).to_pickle(\"clean_data.pkl\")" ] }, { "cell_type": "code", "execution_count": null, "id": "8fc2f38e", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.10" } }, "nbformat": 4, "nbformat_minor": 5 }