explore_rtsp_capture.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "numpy version: 1.23.5\n",
      "pandas version: 2.0.3\n",
      "Python version: 3.8.10 (default, May 26 2023, 14:05:08) \n",
      "[GCC 9.4.0]\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "import sys\n",
    "import glob\n",
    "import datetime\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from pathlib import Path\n",
    "from utils.utils import find_recent_file\n",
    "\n",
    "print(\"numpy version:\", np.__version__)\n",
    "print(\"pandas version:\", pd.__version__)\n",
    "print(\"Python version:\", sys.version)\n",
    "\n",
    "\n",
    "# dir_log = '/tmp/'\n",
    "dir_log = '.'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Load RTSP capture results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Find the latest_file : ./rtsp_capture_tmp.csv\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 23934 entries, 0 to 23933\n",
      "Data columns (total 9 columns):\n",
      " #   Column                  Non-Null Count  Dtype  \n",
      "---  ------                  --------------  -----  \n",
      " 0   frame_time_epoch        23934 non-null  object \n",
      " 1   rtcp_senderssrc         87 non-null     object \n",
      " 2   rtcp_timestamp_ntp_msw  87 non-null     float64\n",
      " 3   rtcp_timestamp_ntp_lsw  87 non-null     float64\n",
      " 4   rtcp_timestamp_rtp      87 non-null     float64\n",
      " 5   rtp_ssrc                23846 non-null  object \n",
      " 6   udp_port                23933 non-null  float64\n",
      " 7   rtp_timestamp           23846 non-null  float64\n",
      " 8   rtp_marker              23846 non-null  float64\n",
      "dtypes: float64(6), object(3)\n",
      "memory usage: 1.6+ MB\n",
      "None\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>frame_time_epoch</th>\n",
       "      <th>rtcp_senderssrc</th>\n",
       "      <th>rtcp_timestamp_ntp_msw</th>\n",
       "      <th>rtcp_timestamp_ntp_lsw</th>\n",
       "      <th>rtcp_timestamp_rtp</th>\n",
       "      <th>rtp_ssrc</th>\n",
       "      <th>udp_port</th>\n",
       "      <th>rtp_timestamp</th>\n",
       "      <th>rtp_marker</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1691977987.156260714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xc3ba1d37</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>3.042407e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1691977987.159705489</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x9e49cf7b</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>2.980748e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1691977987.159907961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xb4f7983d</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>4.070519e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1691977987.168367398</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x8e109adc</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.631582e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1691977987.168905531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x574eae3e</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.952597e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23929</th>\n",
       "      <td>1691978050.860097612</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xb4f7983d</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>4.076240e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23930</th>\n",
       "      <td>1691978050.866726610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x8e109adc</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.637317e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23931</th>\n",
       "      <td>1691978050.866991036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xe4a7a30f</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>2.529527e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23932</th>\n",
       "      <td>1691978050.867415821</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x574eae3e</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.958342e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23933</th>\n",
       "      <td>==============================================...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23934 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        frame_time_epoch rtcp_senderssrc  \\\n",
       "0                                   1691977987.156260714             NaN   \n",
       "1                                   1691977987.159705489             NaN   \n",
       "2                                   1691977987.159907961             NaN   \n",
       "3                                   1691977987.168367398             NaN   \n",
       "4                                   1691977987.168905531             NaN   \n",
       "...                                                  ...             ...   \n",
       "23929                               1691978050.860097612             NaN   \n",
       "23930                               1691978050.866726610             NaN   \n",
       "23931                               1691978050.866991036             NaN   \n",
       "23932                               1691978050.867415821             NaN   \n",
       "23933  ==============================================...             NaN   \n",
       "\n",
       "       rtcp_timestamp_ntp_msw  rtcp_timestamp_ntp_lsw  rtcp_timestamp_rtp  \\\n",
       "0                         NaN                     NaN                 NaN   \n",
       "1                         NaN                     NaN                 NaN   \n",
       "2                         NaN                     NaN                 NaN   \n",
       "3                         NaN                     NaN                 NaN   \n",
       "4                         NaN                     NaN                 NaN   \n",
       "...                       ...                     ...                 ...   \n",
       "23929                     NaN                     NaN                 NaN   \n",
       "23930                     NaN                     NaN                 NaN   \n",
       "23931                     NaN                     NaN                 NaN   \n",
       "23932                     NaN                     NaN                 NaN   \n",
       "23933                     NaN                     NaN                 NaN   \n",
       "\n",
       "         rtp_ssrc  udp_port  rtp_timestamp  rtp_marker  \n",
       "0      0xc3ba1d37    8000.0   3.042407e+09         1.0  \n",
       "1      0x9e49cf7b    8000.0   2.980748e+09         1.0  \n",
       "2      0xb4f7983d    8000.0   4.070519e+09         1.0  \n",
       "3      0x8e109adc    8000.0   1.631582e+09         1.0  \n",
       "4      0x574eae3e    8000.0   1.952597e+09         1.0  \n",
       "...           ...       ...            ...         ...  \n",
       "23929  0xb4f7983d    8000.0   4.076240e+09         1.0  \n",
       "23930  0x8e109adc    8000.0   1.637317e+09         1.0  \n",
       "23931  0xe4a7a30f    8000.0   2.529527e+09         1.0  \n",
       "23932  0x574eae3e    8000.0   1.958342e+09         1.0  \n",
       "23933         NaN       NaN            NaN         NaN  \n",
       "\n",
       "[23934 rows x 9 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path_rtsp_capture = find_recent_file(file_prefix='rtsp_capture_tmp', dir_log=dir_log)\n",
    "df_rtsp = pd.read_csv(path_rtsp_capture)\n",
    "# df_rtsp.dropna(axis=0, how='any', inplace=True)\n",
    "df_rtsp.columns = df_rtsp.columns.str.replace('.', '_')\n",
    "print(df_rtsp.info())\n",
    "df_rtsp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Verify the number of valid streams IDs (sender and receiver SSRC IDs)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ssrc_rtcp : {'0xaa9e335e', '0xb4f7983d', '0x5eb47a89', '0xe4a7a30f', '0xc3ba1d37', '0x8e109adc', '0x9e49cf7b', '0xedd1ee59', '0xf32d99eb', '0x574eae3e', '0x2f9fffb3', '0x8e97e5b6'}\n",
      "ssrc_rtp  : {'0xb4f7983d', '0xaa9e335e', '0x5eb47a89', '0xe4a7a30f', '0xc3ba1d37', '0x8e109adc', '0x9e49cf7b', '0xedd1ee59', '0xf32d99eb', '0x574eae3e', '0x2f9fffb3', '0x8e97e5b6'}\n",
      "Number of valid streams : 12, id : {'0xb4f7983d', '0xaa9e335e', '0x5eb47a89', '0xe4a7a30f', '0xc3ba1d37', '0x8e109adc', '0x9e49cf7b', '0xedd1ee59', '0xf32d99eb', '0x574eae3e', '0x2f9fffb3', '0x8e97e5b6'}\n"
     ]
    }
   ],
   "source": [
    "ssrc_rtcp = set(df_rtsp.rtcp_senderssrc.dropna().unique())\n",
    "ssrc_rtp= set(df_rtsp.rtp_ssrc.dropna().unique())\n",
    "ssrc_uniuque = set(ssrc_rtcp) & set(ssrc_rtp) \n",
    "\n",
    "print(f'ssrc_rtcp : {ssrc_rtcp}')\n",
    "print(f'ssrc_rtp  : {ssrc_rtp }')\n",
    "print(f'Number of valid streams : {len(ssrc_uniuque)}, id : {ssrc_uniuque}')\n",
    " "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RTCP Packets\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>frame_time_epoch</th>\n",
       "      <th>rtcp_senderssrc</th>\n",
       "      <th>rtcp_timestamp_ntp_msw</th>\n",
       "      <th>rtcp_timestamp_ntp_lsw</th>\n",
       "      <th>rtcp_timestamp_rtp</th>\n",
       "      <th>rtp_ssrc</th>\n",
       "      <th>udp_port</th>\n",
       "      <th>rtp_timestamp</th>\n",
       "      <th>rtp_marker</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>1691977924.902784286</td>\n",
       "      <td>0xaa9e335e</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>895773798.0</td>\n",
       "      <td>3.064878e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>1691977925.902755623</td>\n",
       "      <td>0xedd1ee59</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>896103531.0</td>\n",
       "      <td>1.144476e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1081</th>\n",
       "      <td>1691977926.902367204</td>\n",
       "      <td>0x574eae3e</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>895446429.0</td>\n",
       "      <td>1.947176e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>1691977927.906771327</td>\n",
       "      <td>0x8e97e5b6</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>899843374.0</td>\n",
       "      <td>4.071519e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3776</th>\n",
       "      <td>1691977934.384372627</td>\n",
       "      <td>0xc3ba1d37</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>377451472.0</td>\n",
       "      <td>3.037657e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21348</th>\n",
       "      <td>1691978034.903034399</td>\n",
       "      <td>0xaa9e335e</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>895966111.0</td>\n",
       "      <td>3.074778e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21709</th>\n",
       "      <td>1691978035.903142104</td>\n",
       "      <td>0xedd1ee59</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>896036799.0</td>\n",
       "      <td>1.154376e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22069</th>\n",
       "      <td>1691978036.902297164</td>\n",
       "      <td>0x574eae3e</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>895171117.0</td>\n",
       "      <td>1.957076e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22432</th>\n",
       "      <td>1691978037.906564012</td>\n",
       "      <td>0x8e97e5b6</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>899431644.0</td>\n",
       "      <td>4.081420e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23130</th>\n",
       "      <td>1691978044.903546781</td>\n",
       "      <td>0xaa9e335e</td>\n",
       "      <td>3.900967e+09</td>\n",
       "      <td>896427768.0</td>\n",
       "      <td>3.075679e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>87 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           frame_time_epoch rtcp_senderssrc  rtcp_timestamp_ntp_msw  \\\n",
       "360    1691977924.902784286      0xaa9e335e            3.900967e+09   \n",
       "721    1691977925.902755623      0xedd1ee59            3.900967e+09   \n",
       "1081   1691977926.902367204      0x574eae3e            3.900967e+09   \n",
       "1444   1691977927.906771327      0x8e97e5b6            3.900967e+09   \n",
       "3776   1691977934.384372627      0xc3ba1d37            3.900967e+09   \n",
       "...                     ...             ...                     ...   \n",
       "21348  1691978034.903034399      0xaa9e335e            3.900967e+09   \n",
       "21709  1691978035.903142104      0xedd1ee59            3.900967e+09   \n",
       "22069  1691978036.902297164      0x574eae3e            3.900967e+09   \n",
       "22432  1691978037.906564012      0x8e97e5b6            3.900967e+09   \n",
       "23130  1691978044.903546781      0xaa9e335e            3.900967e+09   \n",
       "\n",
       "       rtcp_timestamp_ntp_lsw  rtcp_timestamp_rtp rtp_ssrc  udp_port  \\\n",
       "360               895773798.0        3.064878e+09      NaN    8001.0   \n",
       "721               896103531.0        1.144476e+09      NaN    8001.0   \n",
       "1081              895446429.0        1.947176e+09      NaN    8001.0   \n",
       "1444              899843374.0        4.071519e+09      NaN    8001.0   \n",
       "3776              377451472.0        3.037657e+09      NaN    8001.0   \n",
       "...                       ...                 ...      ...       ...   \n",
       "21348             895966111.0        3.074778e+09      NaN    8001.0   \n",
       "21709             896036799.0        1.154376e+09      NaN    8001.0   \n",
       "22069             895171117.0        1.957076e+09      NaN    8001.0   \n",
       "22432             899431644.0        4.081420e+09      NaN    8001.0   \n",
       "23130             896427768.0        3.075679e+09      NaN    8001.0   \n",
       "\n",
       "       rtp_timestamp  rtp_marker  \n",
       "360              NaN         NaN  \n",
       "721              NaN         NaN  \n",
       "1081             NaN         NaN  \n",
       "1444             NaN         NaN  \n",
       "3776             NaN         NaN  \n",
       "...              ...         ...  \n",
       "21348            NaN         NaN  \n",
       "21709            NaN         NaN  \n",
       "22069            NaN         NaN  \n",
       "22432            NaN         NaN  \n",
       "23130            NaN         NaN  \n",
       "\n",
       "[87 rows x 9 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print('RTCP Packets')\n",
    "df_rtsp.query(\"rtcp_senderssrc.notna()\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RTP Packets\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>frame_time_epoch</th>\n",
       "      <th>rtcp_senderssrc</th>\n",
       "      <th>rtcp_timestamp_ntp_msw</th>\n",
       "      <th>rtcp_timestamp_ntp_lsw</th>\n",
       "      <th>rtcp_timestamp_rtp</th>\n",
       "      <th>rtp_ssrc</th>\n",
       "      <th>udp_port</th>\n",
       "      <th>rtp_timestamp</th>\n",
       "      <th>rtp_marker</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1691977987.156260714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xc3ba1d37</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>3.042407e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1691977987.159705489</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x9e49cf7b</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>2.980748e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1691977987.159907961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xb4f7983d</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>4.070519e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1691977987.168367398</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x8e109adc</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.631582e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1691977987.168905531</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x574eae3e</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.952597e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23929</th>\n",
       "      <td>1691978050.860097612</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xb4f7983d</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>4.076240e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23930</th>\n",
       "      <td>1691978050.866726610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x8e109adc</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.637317e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23931</th>\n",
       "      <td>1691978050.866991036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xe4a7a30f</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>2.529527e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23932</th>\n",
       "      <td>1691978050.867415821</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x574eae3e</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>1.958342e+09</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23933</th>\n",
       "      <td>==============================================...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23847 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        frame_time_epoch rtcp_senderssrc  \\\n",
       "0                                   1691977987.156260714             NaN   \n",
       "1                                   1691977987.159705489             NaN   \n",
       "2                                   1691977987.159907961             NaN   \n",
       "3                                   1691977987.168367398             NaN   \n",
       "4                                   1691977987.168905531             NaN   \n",
       "...                                                  ...             ...   \n",
       "23929                               1691978050.860097612             NaN   \n",
       "23930                               1691978050.866726610             NaN   \n",
       "23931                               1691978050.866991036             NaN   \n",
       "23932                               1691978050.867415821             NaN   \n",
       "23933  ==============================================...             NaN   \n",
       "\n",
       "       rtcp_timestamp_ntp_msw  rtcp_timestamp_ntp_lsw  rtcp_timestamp_rtp  \\\n",
       "0                         NaN                     NaN                 NaN   \n",
       "1                         NaN                     NaN                 NaN   \n",
       "2                         NaN                     NaN                 NaN   \n",
       "3                         NaN                     NaN                 NaN   \n",
       "4                         NaN                     NaN                 NaN   \n",
       "...                       ...                     ...                 ...   \n",
       "23929                     NaN                     NaN                 NaN   \n",
       "23930                     NaN                     NaN                 NaN   \n",
       "23931                     NaN                     NaN                 NaN   \n",
       "23932                     NaN                     NaN                 NaN   \n",
       "23933                     NaN                     NaN                 NaN   \n",
       "\n",
       "         rtp_ssrc  udp_port  rtp_timestamp  rtp_marker  \n",
       "0      0xc3ba1d37    8000.0   3.042407e+09         1.0  \n",
       "1      0x9e49cf7b    8000.0   2.980748e+09         1.0  \n",
       "2      0xb4f7983d    8000.0   4.070519e+09         1.0  \n",
       "3      0x8e109adc    8000.0   1.631582e+09         1.0  \n",
       "4      0x574eae3e    8000.0   1.952597e+09         1.0  \n",
       "...           ...       ...            ...         ...  \n",
       "23929  0xb4f7983d    8000.0   4.076240e+09         1.0  \n",
       "23930  0x8e109adc    8000.0   1.637317e+09         1.0  \n",
       "23931  0xe4a7a30f    8000.0   2.529527e+09         1.0  \n",
       "23932  0x574eae3e    8000.0   1.958342e+09         1.0  \n",
       "23933         NaN       NaN            NaN         NaN  \n",
       "\n",
       "[23847 rows x 9 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print('RTP Packets')\n",
    "df_rtsp.query(\"rtcp_senderssrc.isna()\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}