{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "31c41c7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "sns.set()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "73ace5dc",
   "metadata": {},
   "outputs": [],
   "source": [
    "base_path = '../../../data_folder'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "d20d1d54",
   "metadata": {},
   "outputs": [
    {
     "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>Tag ID</th>\n",
       "      <th>Tag Name</th>\n",
       "      <th>Site</th>\n",
       "      <th>Plant</th>\n",
       "      <th>Line</th>\n",
       "      <th>Equipment</th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_371$equipment_4115$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.Plant.Plant.Perform...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Performance Ratio</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_371$equipment_4115$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.Plant.Plant.Average...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Average Power Factor</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_371$equipment_4115$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.Plant.Plant.Operati...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Operation Time</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_371$equipment_4115$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.Plant.Plant.Tilt Ir...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Tilt Irradiance</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_371$equipment_4115$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.Plant.Plant.Today E...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Plant</td>\n",
       "      <td>Today Export</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Tag ID  \\\n",
       "0  site_107$dept_140$line_371$equipment_4115$tag_...   \n",
       "1  site_107$dept_140$line_371$equipment_4115$tag_...   \n",
       "2  site_107$dept_140$line_371$equipment_4115$tag_...   \n",
       "3  site_107$dept_140$line_371$equipment_4115$tag_...   \n",
       "4  site_107$dept_140$line_371$equipment_4115$tag_...   \n",
       "\n",
       "                                            Tag Name            Site  \\\n",
       "0  Ariyalur Plant.Solar 11 MW.Plant.Plant.Perform...  Ariyalur Plant   \n",
       "1  Ariyalur Plant.Solar 11 MW.Plant.Plant.Average...  Ariyalur Plant   \n",
       "2  Ariyalur Plant.Solar 11 MW.Plant.Plant.Operati...  Ariyalur Plant   \n",
       "3  Ariyalur Plant.Solar 11 MW.Plant.Plant.Tilt Ir...  Ariyalur Plant   \n",
       "4  Ariyalur Plant.Solar 11 MW.Plant.Plant.Today E...  Ariyalur Plant   \n",
       "\n",
       "         Plant   Line Equipment        Parameter Name  Tag  \n",
       "0  Solar 11 MW  Plant     Plant     Performance Ratio  NaN  \n",
       "1  Solar 11 MW  Plant     Plant  Average Power Factor  NaN  \n",
       "2  Solar 11 MW  Plant     Plant        Operation Time  NaN  \n",
       "3  Solar 11 MW  Plant     Plant       Tilt Irradiance  NaN  \n",
       "4  Solar 11 MW  Plant     Plant          Today Export  NaN  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags = pd.read_excel(f'{base_path}/tags_download.xlsx')\n",
    "df_tags.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "482ddcdb",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Performance Ratio', 'Average Power Factor', 'Operation Time',\n",
       "       'Tilt Irradiance', 'Today Export', 'Active Power', 'Efficiency',\n",
       "       'Loss Percentage', 'Active Power_AC', 'Inverter Temp',\n",
       "       'Inverter Run Status', 'Frequency', 'Peak Active Power',\n",
       "       'Current MPPT 1', 'Runtime MM', 'Runtime HH',\n",
       "       'Cumulative Rain Fall', 'Cumulative GII-1', 'Efficiency d',\n",
       "       'Today Target Export', 'Average PF', 'LT-1 Active Power DC',\n",
       "       'LT-2 Active Power DC', 'LT-2 Active Power AC',\n",
       "       'LT-1 Active Power AC', 'Efficiency MPPT 1', 'Efficiency MPPT 2',\n",
       "       'Efficiency MPPT 3', 'Efficiency MPPT 4', 'Efficiency MPPT 5',\n",
       "       'Efficiency MPPT 6', 'Efficiency MPPT 7', 'Efficiency MPPT 8',\n",
       "       'Efficiency MPPT 9', 'Efficiency MPPT 10', 'Efficiency MPPT 11',\n",
       "       'Efficiency MPPT 12', 'Efficiency MPPT 13', 'Efficiency MPPT 14',\n",
       "       'TodayTarget Irradiance', 'Today Target Performance Ratio', 'CUF',\n",
       "       'Today Generation', 'Total Generation', 'Reactive Power',\n",
       "       'Current R', 'Current Y', 'Current B', 'Voltage B-R',\n",
       "       'Voltage R-Y', 'Voltage Y-B', 'Yesterday Generation',\n",
       "       'Monthly Generation', 'Active Power DC', 'Apparent Power',\n",
       "       'Start Time', 'Stop Time', 'Yearly Generation',\n",
       "       'Last Month Generation', 'Last Year Generation', 'Voltage MPPT 1',\n",
       "       'Voltage MPPT 2', 'Current MPPT 2', 'Current MPPT 3',\n",
       "       'Voltage MPPT 3', 'Current MPPT 4', 'Voltage MPPT 4',\n",
       "       'Current MPPT 5', 'Voltage MPPT 5', 'Current MPPT 6',\n",
       "       'Voltage MPPT 6', 'Current MPPT 7', 'Voltage MPPT 7',\n",
       "       'Current MPPT 8', 'Voltage MPPT 8', 'Current MPPT 9',\n",
       "       'Current MPPT 10', 'Voltage MPPT 9', 'Current MPPT 11',\n",
       "       'Voltage MPPT 10', 'Current MPPT 12', 'Voltage MPPT 11',\n",
       "       'Current MPPT 13', 'Current MPPT 14', 'Voltage MPPT 12',\n",
       "       'Voltage MPPT 13', 'Voltage MPPT 14', 'Oil Temperature',\n",
       "       'LV-1 Temperature', 'LV-2 Temperature', 'HV Temperature',\n",
       "       'Peak Ambient Temperature', 'Peak Module Temperature',\n",
       "       'Module Temperature', 'Ambient Temperature', 'Active MFM',\n",
       "       'Total CUF', 'Radiation GII', 'Today Import', 'Yesterday Export',\n",
       "       'Yesterday Import', 'Active Energy Export', 'Active Energy Import',\n",
       "       'Plant Peak Power', 'Today Energy', 'Yesterday Energy',\n",
       "       'Total Energy', 'DC-AC loss kw', 'PR Percentage', 'Wind Speed',\n",
       "       'Active Inverters', 'Today Energy-Inverters',\n",
       "       'Yesterday Energy-Inverters', 'Total Energy-Inverters',\n",
       "       'Active Power-Inverters', 'Wind direction', 'Relative Humidity',\n",
       "       'Dew Point', 'Plant CO2', 'Atmospheric Pressure',\n",
       "       'Module Temperature 2', 'Module Temperature 3', 'GHI-1', 'GHI-2',\n",
       "       'GII', 'Cumulative GHI-1', 'Cumulative GHI-2', 'Cumulative GII-2',\n",
       "       'GII-2', 'Plant Start Time', 'Plant Stop Time',\n",
       "       'Horizontal Irradiance', 'Module Temp', 'Forecasted Irradiance',\n",
       "       'Forecasted Module Temp', 'Forecasted energy',\n",
       "       'Total Forecasted Energy', 'Previous Day Energy Forecasting',\n",
       "       'Commulative Upper Band degradation in Energy',\n",
       "       'Commulative Lower Band degradation in Energy',\n",
       "       'Commulative Upper Band percentage degradation in Energy',\n",
       "       'Commulative Lower Band percentage degradation in Energy',\n",
       "       'Forecasted Ambient Temperature', 'Forecasted Relative Humidity',\n",
       "       'Forecasted Wind Speed', 'Generation MTD', 'Generation YTD',\n",
       "       'Generation Yesterday', 'Cum GII Yesterday', 'Cum GII MTD',\n",
       "       'Cum GII YTD', 'PR Yesterday', 'PR MTD', 'PR YTD', 'CUF Yesterday',\n",
       "       'CUF MTD', 'CUF YTD', 'On_Off_Mntc', 'DC CAPACITY MW',\n",
       "       'Instantaneous Export', 'DC-AC loss kwh', 'AC CAPACITY MW',\n",
       "       'Module Wattage', 'Modules per table',\n",
       "       'No of Strings per Inverter', 'Total No of Inverters', 'Anomaly',\n",
       "       'Anomaly Description', 'Soiling', 'Distribution Losses',\n",
       "       'Recovered Money', 'INR per MW', 'Total Investment',\n",
       "       'Percentage of Recovered Money', 'Balance Recovery',\n",
       "       'Avg Gen per Day', 'Remaining Days to recover money',\n",
       "       'Recovered INR per Day', 'Gen till date at EOD', 'No of Days',\n",
       "       '15 min Energy', 'LT-1 Total Generation', 'LT-2 Total Generation',\n",
       "       'Active Power_DC', 'Co2 Emission', 'Data Status',\n",
       "       'Remaining Days for cleaning', 'Raining Status', 'Cleaning Status',\n",
       "       'Raining Start Time', 'Cleaning Start Time', 'Cleaning Stop Time',\n",
       "       'Raining Stop Time', 'Raining Time Difference',\n",
       "       'Cleaning Time Difference', 'Target gen', 'Today MWH Export',\n",
       "       'No of trees per KWH', 'Moving Average', 'Deemed Energy loss',\n",
       "       'Potential power loss', 'Deemed Energy', 'Solar Irradiance',\n",
       "       'No of Active Inverters', 'MP201 Status', 'RX Status',\n",
       "       'Percentage Deemed', 'Downtime'], dtype=object)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags['Parameter Name'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "0bc50857",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Current MPPT 1',\n",
       " 'Efficiency MPPT 1',\n",
       " 'Efficiency MPPT 2',\n",
       " 'Efficiency MPPT 3',\n",
       " 'Efficiency MPPT 4',\n",
       " 'Efficiency MPPT 5',\n",
       " 'Efficiency MPPT 6',\n",
       " 'Efficiency MPPT 7',\n",
       " 'Efficiency MPPT 8',\n",
       " 'Efficiency MPPT 9',\n",
       " 'Efficiency MPPT 10',\n",
       " 'Efficiency MPPT 11',\n",
       " 'Efficiency MPPT 12',\n",
       " 'Efficiency MPPT 13',\n",
       " 'Efficiency MPPT 14',\n",
       " 'Efficiency MPPT 1',\n",
       " 'Efficiency MPPT 2',\n",
       " 'Efficiency MPPT 3',\n",
       " 'Efficiency MPPT 4',\n",
       " 'Efficiency MPPT 5',\n",
       " 'Efficiency MPPT 6',\n",
       " 'Efficiency MPPT 7',\n",
       " 'Efficiency MPPT 8',\n",
       " 'Efficiency MPPT 9',\n",
       " 'Efficiency MPPT 10',\n",
       " 'Efficiency MPPT 11',\n",
       " 'Efficiency MPPT 12',\n",
       " 'Efficiency MPPT 13',\n",
       " 'Efficiency MPPT 14',\n",
       " 'Efficiency MPPT 1',\n",
       " 'Efficiency MPPT 2',\n",
       " 'Efficiency MPPT 3',\n",
       " 'Efficiency MPPT 4',\n",
       " 'Efficiency MPPT 5',\n",
       " 'Efficiency MPPT 6',\n",
       " 'Efficiency MPPT 7',\n",
       " 'Efficiency MPPT 8',\n",
       " 'Efficiency MPPT 9',\n",
       " 'Efficiency MPPT 10',\n",
       " 'Efficiency MPPT 11',\n",
       " 'Efficiency MPPT 12',\n",
       " 'Efficiency MPPT 13',\n",
       " 'Efficiency MPPT 14',\n",
       " 'Efficiency MPPT 1',\n",
       " 'Efficiency MPPT 2',\n",
       " 'Efficiency MPPT 3',\n",
       " 'Efficiency MPPT 4',\n",
       " 'Efficiency MPPT 5',\n",
       " 'Efficiency MPPT 6',\n",
       " 'Efficiency MPPT 7',\n",
       " 'Efficiency MPPT 8',\n",
       " 'Efficiency MPPT 9',\n",
       " 'Efficiency MPPT 10',\n",
       " 'Efficiency MPPT 11',\n",
       " 'Efficiency MPPT 12',\n",
       " 'Efficiency MPPT 13',\n",
       " 'Efficiency MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " ...]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mppt_substring = 'MPPT'\n",
    "mppt_paarmeters = [data for data in df_tags['Parameter Name'] if mppt_substring in data]\n",
    "mppt_paarmeters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "df4f1764",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Current MPPT 1',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " 'Voltage MPPT 10',\n",
       " 'Current MPPT 12',\n",
       " 'Voltage MPPT 11',\n",
       " 'Current MPPT 13',\n",
       " 'Current MPPT 14',\n",
       " 'Voltage MPPT 12',\n",
       " 'Voltage MPPT 13',\n",
       " 'Voltage MPPT 14',\n",
       " 'Voltage MPPT 1',\n",
       " 'Current MPPT 1',\n",
       " 'Voltage MPPT 2',\n",
       " 'Current MPPT 2',\n",
       " 'Current MPPT 3',\n",
       " 'Voltage MPPT 3',\n",
       " 'Current MPPT 4',\n",
       " 'Voltage MPPT 4',\n",
       " 'Current MPPT 5',\n",
       " 'Voltage MPPT 5',\n",
       " 'Current MPPT 6',\n",
       " 'Voltage MPPT 6',\n",
       " 'Current MPPT 7',\n",
       " 'Voltage MPPT 7',\n",
       " 'Current MPPT 8',\n",
       " 'Voltage MPPT 8',\n",
       " 'Current MPPT 9',\n",
       " 'Current MPPT 10',\n",
       " 'Voltage MPPT 9',\n",
       " 'Current MPPT 11',\n",
       " ...]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "current_voltage_mppt = [data for data in mppt_paarmeters if 'Efficiency' not in data]\n",
    "current_voltage_mppt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "359d6cbe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1176"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(current_voltage_mppt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7d765c39",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_mppt = df_tags.loc[df_tags['Parameter Name'].isin(current_voltage_mppt)]\n",
    "df_mppt.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "19ca5d0b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1176, 8)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "106cb93f",
   "metadata": {},
   "outputs": [
    {
     "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>Tag ID</th>\n",
       "      <th>Tag Name</th>\n",
       "      <th>Site</th>\n",
       "      <th>Plant</th>\n",
       "      <th>Line</th>\n",
       "      <th>Equipment</th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5577$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>LT Panel 1</td>\n",
       "      <td>INV 8</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>LT Panel 1</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>LT Panel 1</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>LT Panel 1</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>Ariyalur Plant</td>\n",
       "      <td>Solar 11 MW</td>\n",
       "      <td>LT Panel 1</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Tag ID  \\\n",
       "0  site_107$dept_140$line_415$equipment_5577$tag_...   \n",
       "1  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "\n",
       "                                            Tag Name            Site  \\\n",
       "0  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...  Ariyalur Plant   \n",
       "1  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...  Ariyalur Plant   \n",
       "2  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...  Ariyalur Plant   \n",
       "3  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...  Ariyalur Plant   \n",
       "4  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...  Ariyalur Plant   \n",
       "\n",
       "         Plant        Line Equipment  Parameter Name  Tag  \n",
       "0  Solar 11 MW  LT Panel 1     INV 8  Current MPPT 1  NaN  \n",
       "1  Solar 11 MW  LT Panel 1     INV 1  Voltage MPPT 1  NaN  \n",
       "2  Solar 11 MW  LT Panel 1     INV 1  Current MPPT 1  NaN  \n",
       "3  Solar 11 MW  LT Panel 1     INV 1  Voltage MPPT 2  NaN  \n",
       "4  Solar 11 MW  LT Panel 1     INV 1  Current MPPT 2  NaN  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b7681e14",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\aakash.bedi\\AppData\\Local\\Temp\\ipykernel_47792\\3931198265.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df_mppt.drop(['Site', 'Plant', 'Line'], axis=1, inplace=True)\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>Tag ID</th>\n",
       "      <th>Tag Name</th>\n",
       "      <th>Equipment</th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5577$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...</td>\n",
       "      <td>INV 8</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Tag ID  \\\n",
       "0  site_107$dept_140$line_415$equipment_5577$tag_...   \n",
       "1  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "\n",
       "                                            Tag Name Equipment  \\\n",
       "0  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...     INV 8   \n",
       "1  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "2  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "3  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "4  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "\n",
       "   Parameter Name  Tag  \n",
       "0  Current MPPT 1  NaN  \n",
       "1  Voltage MPPT 1  NaN  \n",
       "2  Current MPPT 1  NaN  \n",
       "3  Voltage MPPT 2  NaN  \n",
       "4  Current MPPT 2  NaN  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt.drop(['Site', 'Plant', 'Line', 'Tag'], axis=1, inplace=True)\n",
    "df_mppt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "94346f27",
   "metadata": {},
   "outputs": [
    {
     "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>Tag ID</th>\n",
       "      <th>Tag Name</th>\n",
       "      <th>Equipment</th>\n",
       "      <th>Parameter Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5577$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...</td>\n",
       "      <td>INV 8</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Tag ID  \\\n",
       "0  site_107$dept_140$line_415$equipment_5577$tag_...   \n",
       "1  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "\n",
       "                                            Tag Name Equipment  Parameter Name  \n",
       "0  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...     INV 8  Current MPPT 1  \n",
       "1  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1  Voltage MPPT 1  \n",
       "2  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1  Current MPPT 1  \n",
       "3  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1  Voltage MPPT 2  \n",
       "4  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1  Current MPPT 2  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "8dad3577",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\aakash.bedi\\AppData\\Local\\Temp\\ipykernel_47792\\2695636300.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df_mppt.rename(columns={'Tag ID': 'tag_id', 'Tag Name': 'tag_name',\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>tag_id</th>\n",
       "      <th>tag_name</th>\n",
       "      <th>equipment</th>\n",
       "      <th>parameter_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5577$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...</td>\n",
       "      <td>INV 8</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              tag_id  \\\n",
       "0  site_107$dept_140$line_415$equipment_5577$tag_...   \n",
       "1  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "\n",
       "                                            tag_name equipment  parameter_name  \n",
       "0  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...     INV 8  Current MPPT 1  \n",
       "1  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1  Voltage MPPT 1  \n",
       "2  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1  Current MPPT 1  \n",
       "3  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1  Voltage MPPT 2  \n",
       "4  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1  Current MPPT 2  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt.rename(columns={'Tag ID': 'tag_id', 'Tag Name': 'tag_name', \n",
    "                        'Equipment': 'equipment', 'Parameter Name': 'parameter_name'}, inplace=True)\n",
    "df_mppt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "a6b0afab",
   "metadata": {},
   "outputs": [
    {
     "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>tag_id</th>\n",
       "      <th>tag_name</th>\n",
       "      <th>equipment</th>\n",
       "      <th>parameter_name</th>\n",
       "      <th>mppt_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5577$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...</td>\n",
       "      <td>INV 8</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              tag_id  \\\n",
       "0  site_107$dept_140$line_415$equipment_5577$tag_...   \n",
       "1  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "\n",
       "                                            tag_name equipment  \\\n",
       "0  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...     INV 8   \n",
       "1  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "2  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "3  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "4  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "\n",
       "   parameter_name         mppt_id  \n",
       "0  Current MPPT 1  Current MPPT 1  \n",
       "1  Voltage MPPT 1  Voltage MPPT 1  \n",
       "2  Current MPPT 1  Current MPPT 1  \n",
       "3  Voltage MPPT 2  Voltage MPPT 2  \n",
       "4  Current MPPT 2  Current MPPT 2  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt['mppt_id'] = df_mppt['parameter_name'].copy()\n",
    "df_mppt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "52755065",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['mppt_1', 'mppt_2', 'mppt_3', 'mppt_4', 'mppt_5', 'mppt_6',\n",
       "       'mppt_7', 'mppt_8', 'mppt_9', 'mppt_10', 'mppt_11', 'mppt_12',\n",
       "       'mppt_13', 'mppt_14'], dtype=object)"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt['mppt_id'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "8e90325e",
   "metadata": {},
   "outputs": [
    {
     "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>tag_id</th>\n",
       "      <th>tag_name</th>\n",
       "      <th>equipment</th>\n",
       "      <th>parameter_name</th>\n",
       "      <th>mppt_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5577$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...</td>\n",
       "      <td>INV 8</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "      <td>mppt_2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "      <td>mppt_2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              tag_id  \\\n",
       "0  site_107$dept_140$line_415$equipment_5577$tag_...   \n",
       "1  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "\n",
       "                                            tag_name equipment  \\\n",
       "0  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 8.Cu...     INV 8   \n",
       "1  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "2  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "3  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "4  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "\n",
       "   parameter_name mppt_id  \n",
       "0  Current MPPT 1  mppt_1  \n",
       "1  Voltage MPPT 1  mppt_1  \n",
       "2  Current MPPT 1  mppt_1  \n",
       "3  Voltage MPPT 2  mppt_2  \n",
       "4  Current MPPT 2  mppt_2  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mppt['mppt_id'] = df_mppt['mppt_id'].str.replace('Current MPPT ', 'mppt_')\n",
    "df_mppt['mppt_id'] = df_mppt['mppt_id'].str.replace('Voltage MPPT ', 'mppt_')\n",
    "df_mppt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "4e2ad737",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>tag_id</th>\n",
       "      <th>tag_name</th>\n",
       "      <th>equipment</th>\n",
       "      <th>parameter_name</th>\n",
       "      <th>mppt_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 10</td>\n",
       "      <td>mppt_10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 10</td>\n",
       "      <td>mppt_10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 11</td>\n",
       "      <td>mppt_11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              tag_id  \\\n",
       "0  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "1  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "\n",
       "                                            tag_name equipment  \\\n",
       "0  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "1  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "2  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "3  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "4  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "\n",
       "    parameter_name  mppt_id  \n",
       "0   Voltage MPPT 1   mppt_1  \n",
       "1   Current MPPT 1   mppt_1  \n",
       "2  Current MPPT 10  mppt_10  \n",
       "3  Voltage MPPT 10  mppt_10  \n",
       "4  Current MPPT 11  mppt_11  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags_sort = df_mppt.sort_values(['equipment', 'mppt_id'])\n",
    "df_tags_sort.reset_index(drop=True, inplace=True)\n",
    "df_tags_sort.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "017b9779",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>tag_id</th>\n",
       "      <th>tag_name</th>\n",
       "      <th>equipment</th>\n",
       "      <th>parameter_name</th>\n",
       "      <th>mppt_id</th>\n",
       "      <th>mppt_id_with_equipment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 10</td>\n",
       "      <td>mppt_10</td>\n",
       "      <td>mppt_10_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 10</td>\n",
       "      <td>mppt_10</td>\n",
       "      <td>mppt_10_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 11</td>\n",
       "      <td>mppt_11</td>\n",
       "      <td>mppt_11_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 11</td>\n",
       "      <td>mppt_11</td>\n",
       "      <td>mppt_11_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 12</td>\n",
       "      <td>mppt_12</td>\n",
       "      <td>mppt_12_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 12</td>\n",
       "      <td>mppt_12</td>\n",
       "      <td>mppt_12_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 13</td>\n",
       "      <td>mppt_13</td>\n",
       "      <td>mppt_13_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 13</td>\n",
       "      <td>mppt_13</td>\n",
       "      <td>mppt_13_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 14</td>\n",
       "      <td>mppt_14</td>\n",
       "      <td>mppt_14_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 14</td>\n",
       "      <td>mppt_14</td>\n",
       "      <td>mppt_14_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "      <td>mppt_2</td>\n",
       "      <td>mppt_2_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "      <td>mppt_2</td>\n",
       "      <td>mppt_2_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 3</td>\n",
       "      <td>mppt_3</td>\n",
       "      <td>mppt_3_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 3</td>\n",
       "      <td>mppt_3</td>\n",
       "      <td>mppt_3_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 4</td>\n",
       "      <td>mppt_4</td>\n",
       "      <td>mppt_4_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 4</td>\n",
       "      <td>mppt_4</td>\n",
       "      <td>mppt_4_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 5</td>\n",
       "      <td>mppt_5</td>\n",
       "      <td>mppt_5_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 5</td>\n",
       "      <td>mppt_5</td>\n",
       "      <td>mppt_5_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 6</td>\n",
       "      <td>mppt_6</td>\n",
       "      <td>mppt_6_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 6</td>\n",
       "      <td>mppt_6</td>\n",
       "      <td>mppt_6_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 7</td>\n",
       "      <td>mppt_7</td>\n",
       "      <td>mppt_7_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 7</td>\n",
       "      <td>mppt_7</td>\n",
       "      <td>mppt_7_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 8</td>\n",
       "      <td>mppt_8</td>\n",
       "      <td>mppt_8_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 8</td>\n",
       "      <td>mppt_8</td>\n",
       "      <td>mppt_8_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 9</td>\n",
       "      <td>mppt_9</td>\n",
       "      <td>mppt_9_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 9</td>\n",
       "      <td>mppt_9</td>\n",
       "      <td>mppt_9_INV 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5579$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.V...</td>\n",
       "      <td>INV 10</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_INV 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5579$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.C...</td>\n",
       "      <td>INV 10</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_INV 10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               tag_id  \\\n",
       "0   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "1   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "5   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "6   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "7   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "8   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "9   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "10  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "11  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "12  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "13  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "14  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "15  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "16  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "17  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "18  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "19  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "20  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "21  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "22  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "23  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "24  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "25  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "26  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "27  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "28  site_107$dept_140$line_415$equipment_5579$tag_...   \n",
       "29  site_107$dept_140$line_415$equipment_5579$tag_...   \n",
       "\n",
       "                                             tag_name equipment  \\\n",
       "0   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "1   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "2   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "3   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "4   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "5   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "6   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "7   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "8   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "9   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "10  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "11  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "12  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "13  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "14  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "15  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "16  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "17  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "18  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "19  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "20  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "21  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "22  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "23  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "24  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "25  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "26  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "27  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "28  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.V...    INV 10   \n",
       "29  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.C...    INV 10   \n",
       "\n",
       "     parameter_name  mppt_id mppt_id_with_equipment  \n",
       "0    Voltage MPPT 1   mppt_1           mppt_1_INV 1  \n",
       "1    Current MPPT 1   mppt_1           mppt_1_INV 1  \n",
       "2   Current MPPT 10  mppt_10          mppt_10_INV 1  \n",
       "3   Voltage MPPT 10  mppt_10          mppt_10_INV 1  \n",
       "4   Current MPPT 11  mppt_11          mppt_11_INV 1  \n",
       "5   Voltage MPPT 11  mppt_11          mppt_11_INV 1  \n",
       "6   Current MPPT 12  mppt_12          mppt_12_INV 1  \n",
       "7   Voltage MPPT 12  mppt_12          mppt_12_INV 1  \n",
       "8   Current MPPT 13  mppt_13          mppt_13_INV 1  \n",
       "9   Voltage MPPT 13  mppt_13          mppt_13_INV 1  \n",
       "10  Current MPPT 14  mppt_14          mppt_14_INV 1  \n",
       "11  Voltage MPPT 14  mppt_14          mppt_14_INV 1  \n",
       "12   Voltage MPPT 2   mppt_2           mppt_2_INV 1  \n",
       "13   Current MPPT 2   mppt_2           mppt_2_INV 1  \n",
       "14   Current MPPT 3   mppt_3           mppt_3_INV 1  \n",
       "15   Voltage MPPT 3   mppt_3           mppt_3_INV 1  \n",
       "16   Current MPPT 4   mppt_4           mppt_4_INV 1  \n",
       "17   Voltage MPPT 4   mppt_4           mppt_4_INV 1  \n",
       "18   Current MPPT 5   mppt_5           mppt_5_INV 1  \n",
       "19   Voltage MPPT 5   mppt_5           mppt_5_INV 1  \n",
       "20   Current MPPT 6   mppt_6           mppt_6_INV 1  \n",
       "21   Voltage MPPT 6   mppt_6           mppt_6_INV 1  \n",
       "22   Current MPPT 7   mppt_7           mppt_7_INV 1  \n",
       "23   Voltage MPPT 7   mppt_7           mppt_7_INV 1  \n",
       "24   Current MPPT 8   mppt_8           mppt_8_INV 1  \n",
       "25   Voltage MPPT 8   mppt_8           mppt_8_INV 1  \n",
       "26   Current MPPT 9   mppt_9           mppt_9_INV 1  \n",
       "27   Voltage MPPT 9   mppt_9           mppt_9_INV 1  \n",
       "28   Voltage MPPT 1   mppt_1          mppt_1_INV 10  \n",
       "29   Current MPPT 1   mppt_1          mppt_1_INV 10  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags_sort['mppt_id_with_equipment'] = df_tags_sort['mppt_id'] + '_' + df_tags_sort['equipment']\n",
    "df_tags_sort.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "dfe25e21",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>tag_id</th>\n",
       "      <th>tag_name</th>\n",
       "      <th>equipment</th>\n",
       "      <th>parameter_name</th>\n",
       "      <th>mppt_id</th>\n",
       "      <th>mppt_id_with_equipment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 10</td>\n",
       "      <td>mppt_10</td>\n",
       "      <td>mppt_10_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 10</td>\n",
       "      <td>mppt_10</td>\n",
       "      <td>mppt_10_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 11</td>\n",
       "      <td>mppt_11</td>\n",
       "      <td>mppt_11_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 11</td>\n",
       "      <td>mppt_11</td>\n",
       "      <td>mppt_11_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 12</td>\n",
       "      <td>mppt_12</td>\n",
       "      <td>mppt_12_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 12</td>\n",
       "      <td>mppt_12</td>\n",
       "      <td>mppt_12_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 13</td>\n",
       "      <td>mppt_13</td>\n",
       "      <td>mppt_13_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 13</td>\n",
       "      <td>mppt_13</td>\n",
       "      <td>mppt_13_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 14</td>\n",
       "      <td>mppt_14</td>\n",
       "      <td>mppt_14_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 14</td>\n",
       "      <td>mppt_14</td>\n",
       "      <td>mppt_14_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 2</td>\n",
       "      <td>mppt_2</td>\n",
       "      <td>mppt_2_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 2</td>\n",
       "      <td>mppt_2</td>\n",
       "      <td>mppt_2_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 3</td>\n",
       "      <td>mppt_3</td>\n",
       "      <td>mppt_3_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 3</td>\n",
       "      <td>mppt_3</td>\n",
       "      <td>mppt_3_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 4</td>\n",
       "      <td>mppt_4</td>\n",
       "      <td>mppt_4_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 4</td>\n",
       "      <td>mppt_4</td>\n",
       "      <td>mppt_4_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 5</td>\n",
       "      <td>mppt_5</td>\n",
       "      <td>mppt_5_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 5</td>\n",
       "      <td>mppt_5</td>\n",
       "      <td>mppt_5_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 6</td>\n",
       "      <td>mppt_6</td>\n",
       "      <td>mppt_6_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 6</td>\n",
       "      <td>mppt_6</td>\n",
       "      <td>mppt_6_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 7</td>\n",
       "      <td>mppt_7</td>\n",
       "      <td>mppt_7_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 7</td>\n",
       "      <td>mppt_7</td>\n",
       "      <td>mppt_7_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 8</td>\n",
       "      <td>mppt_8</td>\n",
       "      <td>mppt_8_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 8</td>\n",
       "      <td>mppt_8</td>\n",
       "      <td>mppt_8_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Current MPPT 9</td>\n",
       "      <td>mppt_9</td>\n",
       "      <td>mppt_9_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5570$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...</td>\n",
       "      <td>INV 1</td>\n",
       "      <td>Voltage MPPT 9</td>\n",
       "      <td>mppt_9</td>\n",
       "      <td>mppt_9_inv_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5579$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.V...</td>\n",
       "      <td>INV 10</td>\n",
       "      <td>Voltage MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_inv_10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>site_107$dept_140$line_415$equipment_5579$tag_...</td>\n",
       "      <td>Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.C...</td>\n",
       "      <td>INV 10</td>\n",
       "      <td>Current MPPT 1</td>\n",
       "      <td>mppt_1</td>\n",
       "      <td>mppt_1_inv_10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               tag_id  \\\n",
       "0   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "1   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "2   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "3   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "4   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "5   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "6   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "7   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "8   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "9   site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "10  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "11  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "12  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "13  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "14  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "15  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "16  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "17  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "18  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "19  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "20  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "21  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "22  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "23  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "24  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "25  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "26  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "27  site_107$dept_140$line_415$equipment_5570$tag_...   \n",
       "28  site_107$dept_140$line_415$equipment_5579$tag_...   \n",
       "29  site_107$dept_140$line_415$equipment_5579$tag_...   \n",
       "\n",
       "                                             tag_name equipment  \\\n",
       "0   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "1   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "2   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "3   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "4   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "5   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "6   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "7   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "8   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "9   Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "10  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "11  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "12  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "13  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "14  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "15  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "16  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "17  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "18  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "19  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "20  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "21  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "22  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "23  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "24  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "25  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "26  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Cu...     INV 1   \n",
       "27  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 1.Vo...     INV 1   \n",
       "28  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.V...    INV 10   \n",
       "29  Ariyalur Plant.Solar 11 MW.LT Panel 1.INV 10.C...    INV 10   \n",
       "\n",
       "     parameter_name  mppt_id mppt_id_with_equipment  \n",
       "0    Voltage MPPT 1   mppt_1           mppt_1_inv_1  \n",
       "1    Current MPPT 1   mppt_1           mppt_1_inv_1  \n",
       "2   Current MPPT 10  mppt_10          mppt_10_inv_1  \n",
       "3   Voltage MPPT 10  mppt_10          mppt_10_inv_1  \n",
       "4   Current MPPT 11  mppt_11          mppt_11_inv_1  \n",
       "5   Voltage MPPT 11  mppt_11          mppt_11_inv_1  \n",
       "6   Current MPPT 12  mppt_12          mppt_12_inv_1  \n",
       "7   Voltage MPPT 12  mppt_12          mppt_12_inv_1  \n",
       "8   Current MPPT 13  mppt_13          mppt_13_inv_1  \n",
       "9   Voltage MPPT 13  mppt_13          mppt_13_inv_1  \n",
       "10  Current MPPT 14  mppt_14          mppt_14_inv_1  \n",
       "11  Voltage MPPT 14  mppt_14          mppt_14_inv_1  \n",
       "12   Voltage MPPT 2   mppt_2           mppt_2_inv_1  \n",
       "13   Current MPPT 2   mppt_2           mppt_2_inv_1  \n",
       "14   Current MPPT 3   mppt_3           mppt_3_inv_1  \n",
       "15   Voltage MPPT 3   mppt_3           mppt_3_inv_1  \n",
       "16   Current MPPT 4   mppt_4           mppt_4_inv_1  \n",
       "17   Voltage MPPT 4   mppt_4           mppt_4_inv_1  \n",
       "18   Current MPPT 5   mppt_5           mppt_5_inv_1  \n",
       "19   Voltage MPPT 5   mppt_5           mppt_5_inv_1  \n",
       "20   Current MPPT 6   mppt_6           mppt_6_inv_1  \n",
       "21   Voltage MPPT 6   mppt_6           mppt_6_inv_1  \n",
       "22   Current MPPT 7   mppt_7           mppt_7_inv_1  \n",
       "23   Voltage MPPT 7   mppt_7           mppt_7_inv_1  \n",
       "24   Current MPPT 8   mppt_8           mppt_8_inv_1  \n",
       "25   Voltage MPPT 8   mppt_8           mppt_8_inv_1  \n",
       "26   Current MPPT 9   mppt_9           mppt_9_inv_1  \n",
       "27   Voltage MPPT 9   mppt_9           mppt_9_inv_1  \n",
       "28   Voltage MPPT 1   mppt_1          mppt_1_inv_10  \n",
       "29   Current MPPT 1   mppt_1          mppt_1_inv_10  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags_sort['mppt_id_with_equipment'] = df_tags_sort['mppt_id_with_equipment'].str.replace('INV ', 'inv_')\n",
    "df_tags_sort.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "5ed0ec22",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['INV 1', 'INV 10', 'INV 11', 'INV 12', 'INV 13', 'INV 14',\n",
       "       'INV 15', 'INV 16', 'INV 17', 'INV 18', 'INV 19', 'INV 2',\n",
       "       'INV 20', 'INV 21', 'INV 22', 'INV 23', 'INV 24', 'INV 25',\n",
       "       'INV 26', 'INV 27', 'INV 28', 'INV 29', 'INV 3', 'INV 30',\n",
       "       'INV 31', 'INV 32', 'INV 33', 'INV 34', 'INV 35', 'INV 36',\n",
       "       'INV 37', 'INV 38', 'INV 39', 'INV 4', 'INV 40', 'INV 41',\n",
       "       'INV 42', 'INV 5', 'INV 6', 'INV 7', 'INV 8', 'INV 9'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags_sort['equipment'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "ce758bff",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "42"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tags_sort['equipment'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bf22c910",
   "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
