{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "8e82214d-6c64-433d-800f-2dde5f4a18bc",
   "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>_id</th>\n",
       "      <th>temperature10</th>\n",
       "      <th>temperature190</th>\n",
       "      <th>direction160</th>\n",
       "      <th>direction40</th>\n",
       "      <th>temperature110</th>\n",
       "      <th>direction80</th>\n",
       "      <th>speed60</th>\n",
       "      <th>globalr-1</th>\n",
       "      <th>mcc</th>\n",
       "      <th>dq</th>\n",
       "      <th>temperature150</th>\n",
       "      <th>speed20</th>\n",
       "      <th>speed110</th>\n",
       "      <th>direction120</th>\n",
       "      <th>speed190</th>\n",
       "      <th>solarZenith</th>\n",
       "      <th>temperature90</th>\n",
       "      <th>direction200</th>\n",
       "      <th>speed150</th>\n",
       "      <th>temperature50</th>\n",
       "      <th>direction30</th>\n",
       "      <th>temperature160</th>\n",
       "      <th>direction170</th>\n",
       "      <th>temperature20</th>\n",
       "      <th>direction70</th>\n",
       "      <th>direction130</th>\n",
       "      <th>temperature200</th>\n",
       "      <th>speed70</th>\n",
       "      <th>temperature120</th>\n",
       "      <th>speed30</th>\n",
       "      <th>speed100</th>\n",
       "      <th>speed80</th>\n",
       "      <th>speed180</th>\n",
       "      <th>dniCalcd</th>\n",
       "      <th>speed140</th>\n",
       "      <th>temperature60</th>\n",
       "      <th>dateTime</th>\n",
       "      <th>temperature30</th>\n",
       "      <th>temperature170</th>\n",
       "      <th>direction20</th>\n",
       "      <th>humidity2</th>\n",
       "      <th>reportCdq-0</th>\n",
       "      <th>direction180</th>\n",
       "      <th>realPowerAvg</th>\n",
       "      <th>direction60</th>\n",
       "      <th>direction140</th>\n",
       "      <th>speed40</th>\n",
       "      <th>hcc</th>\n",
       "      <th>clearskyGhi</th>\n",
       "      <th>temperature130</th>\n",
       "      <th>lcc</th>\n",
       "      <th>updater</th>\n",
       "      <th>speed90</th>\n",
       "      <th>temperature2</th>\n",
       "      <th>tcc</th>\n",
       "      <th>direction100</th>\n",
       "      <th>speed170</th>\n",
       "      <th>temperature70</th>\n",
       "      <th>speed130</th>\n",
       "      <th>direction190</th>\n",
       "      <th>openCapacity</th>\n",
       "      <th>temperature40</th>\n",
       "      <th>creator</th>\n",
       "      <th>direction10</th>\n",
       "      <th>temperature180</th>\n",
       "      <th>direction150</th>\n",
       "      <th>direction50</th>\n",
       "      <th>speed50</th>\n",
       "      <th>updateTime</th>\n",
       "      <th>direction90</th>\n",
       "      <th>farmId</th>\n",
       "      <th>temperature100</th>\n",
       "      <th>speed10</th>\n",
       "      <th>temperature140</th>\n",
       "      <th>speed120</th>\n",
       "      <th>reportDq-avg</th>\n",
       "      <th>deleted</th>\n",
       "      <th>speed200</th>\n",
       "      <th>realPower</th>\n",
       "      <th>createTime</th>\n",
       "      <th>radiation</th>\n",
       "      <th>surfacePressure</th>\n",
       "      <th>tpr</th>\n",
       "      <th>direction110</th>\n",
       "      <th>time</th>\n",
       "      <th>speed160</th>\n",
       "      <th>temperature80</th>\n",
       "      <th>reportMid-E395</th>\n",
       "      <th>reportDq-E1</th>\n",
       "      <th>reportCdq-16</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>673db4f849572921ef42cba8</td>\n",
       "      <td>27.7109</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>83.1655</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>83.4782</td>\n",
       "      <td>7.1173</td>\n",
       "      <td>424.13</td>\n",
       "      <td>21.9464</td>\n",
       "      <td>87.89</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>6.7773</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>3.73</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>27.3009</td>\n",
       "      <td>83.1655</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>27.4945</td>\n",
       "      <td>83.4382</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>7.3400</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>6.7773</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>7.4282</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>671.91</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>27.2864</td>\n",
       "      <td>2024-05-09 12:45:00</td>\n",
       "      <td>27.3936</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>83.1655</td>\n",
       "      <td>74.7145</td>\n",
       "      <td>54.76</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>53.94</td>\n",
       "      <td>83.3364</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>6.7773</td>\n",
       "      <td>48.9836</td>\n",
       "      <td>967.31</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>33.2100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.4945</td>\n",
       "      <td>28.0282</td>\n",
       "      <td>64.0664</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>\"100\"</td>\n",
       "      <td>27.3282</td>\n",
       "      <td>xxl-nwp</td>\n",
       "      <td>82.7745</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>83.3364</td>\n",
       "      <td>7.1173</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.5209</td>\n",
       "      <td>J00629</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>6.0600</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>-0.99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>26.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>817.38</td>\n",
       "      <td>1011.2582</td>\n",
       "      <td>3.6418</td>\n",
       "      <td>83.8900</td>\n",
       "      <td>1.715230e+12</td>\n",
       "      <td>7.6555</td>\n",
       "      <td>27.2327</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>673db4f849572921ef42cba9</td>\n",
       "      <td>24.8673</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>156.4900</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>157.9882</td>\n",
       "      <td>7.2227</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.4409</td>\n",
       "      <td>37.79</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>6.6982</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>62.65</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>24.5636</td>\n",
       "      <td>156.4900</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>24.7055</td>\n",
       "      <td>157.7882</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>7.5791</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>6.6982</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>7.7209</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>578.63</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>24.5482</td>\n",
       "      <td>2024-03-15 16:45:00</td>\n",
       "      <td>24.6318</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>156.4900</td>\n",
       "      <td>79.4464</td>\n",
       "      <td>25.06</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>30.98</td>\n",
       "      <td>157.2818</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>6.6982</td>\n",
       "      <td>22.3345</td>\n",
       "      <td>405.80</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>20.4445</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.8382</td>\n",
       "      <td>25.1018</td>\n",
       "      <td>42.8709</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>\"100\"</td>\n",
       "      <td>24.5827</td>\n",
       "      <td>xxl-nwp</td>\n",
       "      <td>154.7436</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>157.2818</td>\n",
       "      <td>7.2227</td>\n",
       "      <td>NaN</td>\n",
       "      <td>158.1727</td>\n",
       "      <td>J00629</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>5.5973</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>34.86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>343.47</td>\n",
       "      <td>1011.1018</td>\n",
       "      <td>0.0227</td>\n",
       "      <td>159.0355</td>\n",
       "      <td>1.710492e+12</td>\n",
       "      <td>8.0836</td>\n",
       "      <td>24.5118</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>673db4f849572921ef42cbaa</td>\n",
       "      <td>27.8864</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>191.0036</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>192.5145</td>\n",
       "      <td>5.6836</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.3218</td>\n",
       "      <td>0.00</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>5.2318</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>91.77</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>27.5873</td>\n",
       "      <td>191.0036</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>27.7291</td>\n",
       "      <td>192.3100</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>5.9927</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>5.2318</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>6.1155</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>27.5745</td>\n",
       "      <td>2024-07-11 06:00:00</td>\n",
       "      <td>27.6564</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>191.0036</td>\n",
       "      <td>86.4000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>191.7955</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>5.2318</td>\n",
       "      <td>8.0936</td>\n",
       "      <td>0.00</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>4.1973</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.2218</td>\n",
       "      <td>28.1164</td>\n",
       "      <td>12.6736</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>\"100\"</td>\n",
       "      <td>27.6055</td>\n",
       "      <td>xxl-nwp</td>\n",
       "      <td>189.2900</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>191.7955</td>\n",
       "      <td>5.6836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>192.7009</td>\n",
       "      <td>J00629</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>4.3000</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1004.3500</td>\n",
       "      <td>0.3109</td>\n",
       "      <td>193.5809</td>\n",
       "      <td>1.720649e+12</td>\n",
       "      <td>6.4600</td>\n",
       "      <td>27.5400</td>\n",
       "      <td>-0.99</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>673db4f849572921ef42cbab</td>\n",
       "      <td>26.2082</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>170.0482</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>171.3245</td>\n",
       "      <td>9.5318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6045</td>\n",
       "      <td>0.00</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>8.7836</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>96.27</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>25.9418</td>\n",
       "      <td>170.0482</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>26.0682</td>\n",
       "      <td>171.1555</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>10.0455</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>8.7836</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>10.2473</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>25.9264</td>\n",
       "      <td>2024-04-05 19:15:00</td>\n",
       "      <td>26.0018</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>170.0482</td>\n",
       "      <td>80.6709</td>\n",
       "      <td>NaN</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170.7291</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>8.7836</td>\n",
       "      <td>-2.7355</td>\n",
       "      <td>0.00</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>8.4118</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.4173</td>\n",
       "      <td>26.4127</td>\n",
       "      <td>6.3491</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>\"100\"</td>\n",
       "      <td>25.9600</td>\n",
       "      <td>xxl-nwp</td>\n",
       "      <td>168.5218</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>170.7291</td>\n",
       "      <td>9.5318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171.4736</td>\n",
       "      <td>J00629</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>7.2236</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1006.1800</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>172.3518</td>\n",
       "      <td>1.712316e+12</td>\n",
       "      <td>10.7827</td>\n",
       "      <td>25.8855</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>673db4f849572921ef42cbac</td>\n",
       "      <td>29.5800</td>\n",
       "      <td>28.7800</td>\n",
       "      <td>53.7400</td>\n",
       "      <td>54.8200</td>\n",
       "      <td>29.1400</td>\n",
       "      <td>54.3100</td>\n",
       "      <td>2.7700</td>\n",
       "      <td>477.2</td>\n",
       "      <td>2.1000</td>\n",
       "      <td>43.77</td>\n",
       "      <td>28.9600</td>\n",
       "      <td>2.5500</td>\n",
       "      <td>2.8800</td>\n",
       "      <td>54.2400</td>\n",
       "      <td>3.2200</td>\n",
       "      <td>58.05</td>\n",
       "      <td>29.2000</td>\n",
       "      <td>53.2400</td>\n",
       "      <td>3.0500</td>\n",
       "      <td>29.3000</td>\n",
       "      <td>54.9800</td>\n",
       "      <td>28.9200</td>\n",
       "      <td>53.6200</td>\n",
       "      <td>29.4900</td>\n",
       "      <td>54.4000</td>\n",
       "      <td>54.1200</td>\n",
       "      <td>28.7400</td>\n",
       "      <td>2.8000</td>\n",
       "      <td>29.1000</td>\n",
       "      <td>2.6500</td>\n",
       "      <td>2.8600</td>\n",
       "      <td>2.8200</td>\n",
       "      <td>3.1800</td>\n",
       "      <td>556.88</td>\n",
       "      <td>3.0100</td>\n",
       "      <td>29.2700</td>\n",
       "      <td>2024-09-03 16:30:00</td>\n",
       "      <td>29.3900</td>\n",
       "      <td>28.8700</td>\n",
       "      <td>55.3000</td>\n",
       "      <td>75.4700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.4900</td>\n",
       "      <td>59.27</td>\n",
       "      <td>54.5300</td>\n",
       "      <td>53.9900</td>\n",
       "      <td>2.6900</td>\n",
       "      <td>31.5700</td>\n",
       "      <td>439.67</td>\n",
       "      <td>29.0500</td>\n",
       "      <td>10.1800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.8400</td>\n",
       "      <td>29.8700</td>\n",
       "      <td>38.5400</td>\n",
       "      <td>54.3100</td>\n",
       "      <td>3.1400</td>\n",
       "      <td>29.2400</td>\n",
       "      <td>2.9600</td>\n",
       "      <td>53.3700</td>\n",
       "      <td>\"100\"</td>\n",
       "      <td>29.3400</td>\n",
       "      <td>xxl-nwp</td>\n",
       "      <td>55.6200</td>\n",
       "      <td>28.8300</td>\n",
       "      <td>53.8700</td>\n",
       "      <td>54.6500</td>\n",
       "      <td>2.7400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>54.2500</td>\n",
       "      <td>J00629</td>\n",
       "      <td>29.1700</td>\n",
       "      <td>2.4400</td>\n",
       "      <td>29.0100</td>\n",
       "      <td>2.9200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.2700</td>\n",
       "      <td>56.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>408.00</td>\n",
       "      <td>1003.1300</td>\n",
       "      <td>4.6700</td>\n",
       "      <td>54.3700</td>\n",
       "      <td>1.725352e+12</td>\n",
       "      <td>3.0900</td>\n",
       "      <td>29.2100</td>\n",
       "      <td>-0.99</td>\n",
       "      <td>29.67</td>\n",
       "      <td>50.64</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        _id  temperature10  temperature190  direction160  \\\n",
       "0  673db4f849572921ef42cba8        27.7109         27.2327       83.8900   \n",
       "1  673db4f849572921ef42cba9        24.8673         24.5118      159.0355   \n",
       "2  673db4f849572921ef42cbaa        27.8864         27.5400      193.5809   \n",
       "3  673db4f849572921ef42cbab        26.2082         25.8855      172.3518   \n",
       "4  673db4f849572921ef42cbac        29.5800         28.7800       53.7400   \n",
       "\n",
       "   direction40  temperature110  direction80  speed60 globalr-1      mcc  \\\n",
       "0      83.1655         27.2327      83.4782   7.1173    424.13  21.9464   \n",
       "1     156.4900         24.5118     157.9882   7.2227       NaN   5.4409   \n",
       "2     191.0036         27.5400     192.5145   5.6836       0.0   3.3218   \n",
       "3     170.0482         25.8855     171.3245   9.5318       NaN   0.6045   \n",
       "4      54.8200         29.1400      54.3100   2.7700     477.2   2.1000   \n",
       "\n",
       "      dq  temperature150  speed20  speed110  direction120  speed190  \\\n",
       "0  87.89         27.2327   6.7773    7.6555       83.8900    7.6555   \n",
       "1  37.79         24.5118   6.6982    8.0836      159.0355    8.0836   \n",
       "2   0.00         27.5400   5.2318    6.4600      193.5809    6.4600   \n",
       "3   0.00         25.8855   8.7836   10.7827      172.3518   10.7827   \n",
       "4  43.77         28.9600   2.5500    2.8800       54.2400    3.2200   \n",
       "\n",
       "   solarZenith  temperature90  direction200  speed150  temperature50  \\\n",
       "0         3.73        27.2327       83.8900    7.6555        27.3009   \n",
       "1        62.65        24.5118      159.0355    8.0836        24.5636   \n",
       "2        91.77        27.5400      193.5809    6.4600        27.5873   \n",
       "3        96.27        25.8855      172.3518   10.7827        25.9418   \n",
       "4        58.05        29.2000       53.2400    3.0500        29.3000   \n",
       "\n",
       "   direction30  temperature160  direction170  temperature20  direction70  \\\n",
       "0      83.1655         27.2327       83.8900        27.4945      83.4382   \n",
       "1     156.4900         24.5118      159.0355        24.7055     157.7882   \n",
       "2     191.0036         27.5400      193.5809        27.7291     192.3100   \n",
       "3     170.0482         25.8855      172.3518        26.0682     171.1555   \n",
       "4      54.9800         28.9200       53.6200        29.4900      54.4000   \n",
       "\n",
       "   direction130  temperature200  speed70  temperature120  speed30  speed100  \\\n",
       "0       83.8900         27.2327   7.3400         27.2327   6.7773    7.6555   \n",
       "1      159.0355         24.5118   7.5791         24.5118   6.6982    8.0836   \n",
       "2      193.5809         27.5400   5.9927         27.5400   5.2318    6.4600   \n",
       "3      172.3518         25.8855  10.0455         25.8855   8.7836   10.7827   \n",
       "4       54.1200         28.7400   2.8000         29.1000   2.6500    2.8600   \n",
       "\n",
       "   speed80  speed180  dniCalcd  speed140  temperature60             dateTime  \\\n",
       "0   7.4282    7.6555    671.91    7.6555        27.2864  2024-05-09 12:45:00   \n",
       "1   7.7209    8.0836    578.63    8.0836        24.5482  2024-03-15 16:45:00   \n",
       "2   6.1155    6.4600      0.00    6.4600        27.5745  2024-07-11 06:00:00   \n",
       "3  10.2473   10.7827      0.00   10.7827        25.9264  2024-04-05 19:15:00   \n",
       "4   2.8200    3.1800    556.88    3.0100        29.2700  2024-09-03 16:30:00   \n",
       "\n",
       "   temperature30  temperature170  direction20  humidity2 reportCdq-0  \\\n",
       "0        27.3936         27.2327      83.1655    74.7145       54.76   \n",
       "1        24.6318         24.5118     156.4900    79.4464       25.06   \n",
       "2        27.6564         27.5400     191.0036    86.4000         0.0   \n",
       "3        26.0018         25.8855     170.0482    80.6709         NaN   \n",
       "4        29.3900         28.8700      55.3000    75.4700         NaN   \n",
       "\n",
       "   direction180 realPowerAvg  direction60  direction140  speed40      hcc  \\\n",
       "0       83.8900        53.94      83.3364       83.8900   6.7773  48.9836   \n",
       "1      159.0355        30.98     157.2818      159.0355   6.6982  22.3345   \n",
       "2      193.5809          0.0     191.7955      193.5809   5.2318   8.0936   \n",
       "3      172.3518          0.0     170.7291      172.3518   8.7836  -2.7355   \n",
       "4       53.4900        59.27      54.5300       53.9900   2.6900  31.5700   \n",
       "\n",
       "   clearskyGhi  temperature130      lcc  updater  speed90  temperature2  \\\n",
       "0       967.31         27.2327  33.2100      NaN   7.4945       28.0282   \n",
       "1       405.80         24.5118  20.4445      NaN   7.8382       25.1018   \n",
       "2         0.00         27.5400   4.1973      NaN   6.2218       28.1164   \n",
       "3         0.00         25.8855   8.4118      NaN  10.4173       26.4127   \n",
       "4       439.67         29.0500  10.1800      NaN   2.8400       29.8700   \n",
       "\n",
       "       tcc  direction100  speed170  temperature70  speed130  direction190  \\\n",
       "0  64.0664       83.8900    7.6555        27.2327    7.6555       83.8900   \n",
       "1  42.8709      159.0355    8.0836        24.5118    8.0836      159.0355   \n",
       "2  12.6736      193.5809    6.4600        27.5400    6.4600      193.5809   \n",
       "3   6.3491      172.3518   10.7827        25.8855   10.7827      172.3518   \n",
       "4  38.5400       54.3100    3.1400        29.2400    2.9600       53.3700   \n",
       "\n",
       "  openCapacity  temperature40  creator  direction10  temperature180  \\\n",
       "0        \"100\"        27.3282  xxl-nwp      82.7745         27.2327   \n",
       "1        \"100\"        24.5827  xxl-nwp     154.7436         24.5118   \n",
       "2        \"100\"        27.6055  xxl-nwp     189.2900         27.5400   \n",
       "3        \"100\"        25.9600  xxl-nwp     168.5218         25.8855   \n",
       "4        \"100\"        29.3400  xxl-nwp      55.6200         28.8300   \n",
       "\n",
       "   direction150  direction50  speed50  updateTime  direction90  farmId  \\\n",
       "0       83.8900      83.3364   7.1173         NaN      83.5209  J00629   \n",
       "1      159.0355     157.2818   7.2227         NaN     158.1727  J00629   \n",
       "2      193.5809     191.7955   5.6836         NaN     192.7009  J00629   \n",
       "3      172.3518     170.7291   9.5318         NaN     171.4736  J00629   \n",
       "4       53.8700      54.6500   2.7400         NaN      54.2500  J00629   \n",
       "\n",
       "   temperature100  speed10  temperature140  speed120 reportDq-avg  deleted  \\\n",
       "0         27.2327   6.0600         27.2327    7.6555        -0.99      NaN   \n",
       "1         24.5118   5.5973         24.5118    8.0836          NaN      NaN   \n",
       "2         27.5400   4.3000         27.5400    6.4600          NaN      NaN   \n",
       "3         25.8855   7.2236         25.8855   10.7827          NaN      NaN   \n",
       "4         29.1700   2.4400         29.0100    2.9200          NaN      NaN   \n",
       "\n",
       "   speed200 realPower  createTime  radiation  surfacePressure     tpr  \\\n",
       "0    7.6555     26.09         NaN     817.38        1011.2582  3.6418   \n",
       "1    8.0836     34.86         NaN     343.47        1011.1018  0.0227   \n",
       "2    6.4600       0.0         NaN       0.00        1004.3500  0.3109   \n",
       "3   10.7827       0.0         NaN       0.00        1006.1800  0.0100   \n",
       "4    3.2700     56.27         NaN     408.00        1003.1300  4.6700   \n",
       "\n",
       "   direction110          time  speed160  temperature80 reportMid-E395  \\\n",
       "0       83.8900  1.715230e+12    7.6555        27.2327            NaN   \n",
       "1      159.0355  1.710492e+12    8.0836        24.5118            NaN   \n",
       "2      193.5809  1.720649e+12    6.4600        27.5400          -0.99   \n",
       "3      172.3518  1.712316e+12   10.7827        25.8855            NaN   \n",
       "4       54.3700  1.725352e+12    3.0900        29.2100          -0.99   \n",
       "\n",
       "  reportDq-E1 reportCdq-16  \n",
       "0         NaN          NaN  \n",
       "1         NaN          NaN  \n",
       "2         0.0          NaN  \n",
       "3         NaN          NaN  \n",
       "4       29.67        50.64  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pymongo\n",
    "import pandas as pd\n",
    "# 显示所有列\n",
    "pd.set_option('display.max_columns', None)\n",
    "\n",
    "# 显示所有行（可选）\n",
    "pd.set_option('display.max_rows', None)\n",
    "\n",
    "# 连接 MongoDB\n",
    "client = pymongo.MongoClient(\"mongodb://root:sdhjfREWFWEF23e@192.168.1.43:30000/\")  # 替换为你的连接信息\n",
    "db = client['db2']  # 替换为你的数据库名\n",
    "collection = db['j00629_copy_agcavc']  # 替换为你的集合名\n",
    "\n",
    "# 查询数据\n",
    "query = {}  # 空字典表示查询所有数据\n",
    "cursor = collection.find(query)\n",
    "\n",
    "# 将数据转换为 DataFrame\n",
    "df = pd.DataFrame(list(cursor))\n",
    "\n",
    "# 如果有 `_id` 字段，可能需要处理为字符串或删除\n",
    "if '_id' in df.columns:\n",
    "    df['_id'] = df['_id'].astype(str)  # 将 ObjectId 转为字符串\n",
    "    # df.drop('_id', axis=1, inplace=True)  # 或者删除 `_id` 字段\n",
    "client.close()\n",
    "df.head()# 查看数据\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "2d45d74a-1157-4226-9aec-a11e39b1e143",
   "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>dateTime</th>\n",
       "      <th>dq</th>\n",
       "      <th>realPowerAvg</th>\n",
       "      <th>realPower</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7522</th>\n",
       "      <td>2024-06-04 00:00:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10018</th>\n",
       "      <td>2024-06-04 00:15:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7349</th>\n",
       "      <td>2024-06-04 00:30:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4732</th>\n",
       "      <td>2024-06-04 00:45:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6609</th>\n",
       "      <td>2024-06-04 01:00:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4990</th>\n",
       "      <td>2024-06-04 01:15:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7625</th>\n",
       "      <td>2024-06-04 01:30:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10198</th>\n",
       "      <td>2024-06-04 01:45:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9656</th>\n",
       "      <td>2024-06-04 02:00:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8305</th>\n",
       "      <td>2024-06-04 02:15:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4449</th>\n",
       "      <td>2024-06-04 02:30:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7132</th>\n",
       "      <td>2024-06-04 02:45:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12723</th>\n",
       "      <td>2024-06-04 03:00:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6859</th>\n",
       "      <td>2024-06-04 03:15:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9491</th>\n",
       "      <td>2024-06-04 03:30:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6996</th>\n",
       "      <td>2024-06-04 03:45:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1151</th>\n",
       "      <td>2024-06-04 04:00:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11510</th>\n",
       "      <td>2024-06-04 04:15:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11087</th>\n",
       "      <td>2024-06-04 04:30:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2081</th>\n",
       "      <td>2024-06-04 04:45:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15081</th>\n",
       "      <td>2024-06-04 05:00:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12451</th>\n",
       "      <td>2024-06-04 05:15:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14012</th>\n",
       "      <td>2024-06-04 05:30:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4853</th>\n",
       "      <td>2024-06-04 05:45:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16011</th>\n",
       "      <td>2024-06-04 06:00:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14169</th>\n",
       "      <td>2024-06-04 06:15:00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>2024-06-04 06:30:00</td>\n",
       "      <td>0.20</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11367</th>\n",
       "      <td>2024-06-04 06:45:00</td>\n",
       "      <td>2.99</td>\n",
       "      <td>2.8</td>\n",
       "      <td>3.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9002</th>\n",
       "      <td>2024-06-04 07:00:00</td>\n",
       "      <td>6.63</td>\n",
       "      <td>5.12</td>\n",
       "      <td>5.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15876</th>\n",
       "      <td>2024-06-04 07:15:00</td>\n",
       "      <td>10.83</td>\n",
       "      <td>8.6</td>\n",
       "      <td>9.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16374</th>\n",
       "      <td>2024-06-04 07:30:00</td>\n",
       "      <td>15.40</td>\n",
       "      <td>9.61</td>\n",
       "      <td>9.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10189</th>\n",
       "      <td>2024-06-04 07:45:00</td>\n",
       "      <td>20.22</td>\n",
       "      <td>9.04</td>\n",
       "      <td>9.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13892</th>\n",
       "      <td>2024-06-04 08:00:00</td>\n",
       "      <td>25.15</td>\n",
       "      <td>9.59</td>\n",
       "      <td>10.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16253</th>\n",
       "      <td>2024-06-04 08:15:00</td>\n",
       "      <td>30.17</td>\n",
       "      <td>11.53</td>\n",
       "      <td>12.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14956</th>\n",
       "      <td>2024-06-04 08:30:00</td>\n",
       "      <td>35.19</td>\n",
       "      <td>13.5</td>\n",
       "      <td>14.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13222</th>\n",
       "      <td>2024-06-04 08:45:00</td>\n",
       "      <td>40.15</td>\n",
       "      <td>16.07</td>\n",
       "      <td>17.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2344</th>\n",
       "      <td>2024-06-04 09:00:00</td>\n",
       "      <td>45.03</td>\n",
       "      <td>18.76</td>\n",
       "      <td>18.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14543</th>\n",
       "      <td>2024-06-04 09:15:00</td>\n",
       "      <td>49.77</td>\n",
       "      <td>20.09</td>\n",
       "      <td>19.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11911</th>\n",
       "      <td>2024-06-04 09:30:00</td>\n",
       "      <td>54.34</td>\n",
       "      <td>18.4</td>\n",
       "      <td>19.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>2024-06-04 09:45:00</td>\n",
       "      <td>58.16</td>\n",
       "      <td>22.01</td>\n",
       "      <td>22.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>2024-06-04 10:00:00</td>\n",
       "      <td>61.69</td>\n",
       "      <td>27.25</td>\n",
       "      <td>33.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16984</th>\n",
       "      <td>2024-06-04 10:15:00</td>\n",
       "      <td>64.90</td>\n",
       "      <td>36.96</td>\n",
       "      <td>37.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14350</th>\n",
       "      <td>2024-06-04 10:30:00</td>\n",
       "      <td>67.78</td>\n",
       "      <td>39.46</td>\n",
       "      <td>40.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15504</th>\n",
       "      <td>2024-06-04 10:45:00</td>\n",
       "      <td>70.31</td>\n",
       "      <td>41.65</td>\n",
       "      <td>42.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3414</th>\n",
       "      <td>2024-06-04 11:00:00</td>\n",
       "      <td>72.49</td>\n",
       "      <td>44.62</td>\n",
       "      <td>46.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9945</th>\n",
       "      <td>2024-06-04 11:15:00</td>\n",
       "      <td>74.28</td>\n",
       "      <td>45.27</td>\n",
       "      <td>38.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2249</th>\n",
       "      <td>2024-06-04 11:30:00</td>\n",
       "      <td>75.70</td>\n",
       "      <td>39.89</td>\n",
       "      <td>41.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13228</th>\n",
       "      <td>2024-06-04 11:45:00</td>\n",
       "      <td>76.74</td>\n",
       "      <td>42.34</td>\n",
       "      <td>55.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10719</th>\n",
       "      <td>2024-06-04 12:00:00</td>\n",
       "      <td>77.41</td>\n",
       "      <td>64.81</td>\n",
       "      <td>67.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13527</th>\n",
       "      <td>2024-06-04 12:15:00</td>\n",
       "      <td>77.70</td>\n",
       "      <td>65.73</td>\n",
       "      <td>66.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3443</th>\n",
       "      <td>2024-06-04 12:30:00</td>\n",
       "      <td>77.61</td>\n",
       "      <td>71.97</td>\n",
       "      <td>76.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10200</th>\n",
       "      <td>2024-06-04 12:45:00</td>\n",
       "      <td>77.14</td>\n",
       "      <td>73.71</td>\n",
       "      <td>60.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10053</th>\n",
       "      <td>2024-06-04 13:00:00</td>\n",
       "      <td>76.30</td>\n",
       "      <td>71.39</td>\n",
       "      <td>77.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4088</th>\n",
       "      <td>2024-06-04 13:15:00</td>\n",
       "      <td>75.11</td>\n",
       "      <td>74.44</td>\n",
       "      <td>71.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4388</th>\n",
       "      <td>2024-06-04 13:30:00</td>\n",
       "      <td>73.56</td>\n",
       "      <td>72.99</td>\n",
       "      <td>70.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11380</th>\n",
       "      <td>2024-06-04 13:45:00</td>\n",
       "      <td>71.68</td>\n",
       "      <td>54.91</td>\n",
       "      <td>46.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4343</th>\n",
       "      <td>2024-06-04 14:00:00</td>\n",
       "      <td>69.48</td>\n",
       "      <td>45.99</td>\n",
       "      <td>45.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2651</th>\n",
       "      <td>2024-06-04 14:15:00</td>\n",
       "      <td>66.97</td>\n",
       "      <td>51.0</td>\n",
       "      <td>64.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9555</th>\n",
       "      <td>2024-06-04 14:30:00</td>\n",
       "      <td>64.18</td>\n",
       "      <td>57.69</td>\n",
       "      <td>50.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2750</th>\n",
       "      <td>2024-06-04 14:45:00</td>\n",
       "      <td>61.10</td>\n",
       "      <td>50.48</td>\n",
       "      <td>52.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>2024-06-04 15:00:00</td>\n",
       "      <td>57.77</td>\n",
       "      <td>52.93</td>\n",
       "      <td>52.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7278</th>\n",
       "      <td>2024-06-04 15:15:00</td>\n",
       "      <td>54.21</td>\n",
       "      <td>50.11</td>\n",
       "      <td>51.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6507</th>\n",
       "      <td>2024-06-04 15:30:00</td>\n",
       "      <td>50.43</td>\n",
       "      <td>52.03</td>\n",
       "      <td>53.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2039</th>\n",
       "      <td>2024-06-04 15:45:00</td>\n",
       "      <td>46.64</td>\n",
       "      <td>50.35</td>\n",
       "      <td>53.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2237</th>\n",
       "      <td>2024-06-04 16:00:00</td>\n",
       "      <td>42.66</td>\n",
       "      <td>56.25</td>\n",
       "      <td>55.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8207</th>\n",
       "      <td>2024-06-04 16:15:00</td>\n",
       "      <td>38.52</td>\n",
       "      <td>51.52</td>\n",
       "      <td>49.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5581</th>\n",
       "      <td>2024-06-04 16:30:00</td>\n",
       "      <td>34.25</td>\n",
       "      <td>47.22</td>\n",
       "      <td>56.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  dateTime     dq realPowerAvg realPower\n",
       "7522   2024-06-04 00:00:00   0.00          0.0       0.0\n",
       "10018  2024-06-04 00:15:00   0.00          0.0       0.0\n",
       "7349   2024-06-04 00:30:00   0.00          0.0       0.0\n",
       "4732   2024-06-04 00:45:00   0.00          0.0       0.0\n",
       "6609   2024-06-04 01:00:00   0.00          0.0       0.0\n",
       "4990   2024-06-04 01:15:00   0.00          0.0       0.0\n",
       "7625   2024-06-04 01:30:00   0.00          0.0       0.0\n",
       "10198  2024-06-04 01:45:00   0.00          0.0       0.0\n",
       "9656   2024-06-04 02:00:00   0.00          0.0       0.0\n",
       "8305   2024-06-04 02:15:00   0.00          0.0       0.0\n",
       "4449   2024-06-04 02:30:00   0.00          0.0       0.0\n",
       "7132   2024-06-04 02:45:00   0.00          0.0       0.0\n",
       "12723  2024-06-04 03:00:00   0.00          0.0       0.0\n",
       "6859   2024-06-04 03:15:00   0.00          0.0       0.0\n",
       "9491   2024-06-04 03:30:00   0.00          0.0       0.0\n",
       "6996   2024-06-04 03:45:00   0.00          0.0       0.0\n",
       "1151   2024-06-04 04:00:00   0.00          0.0       0.0\n",
       "11510  2024-06-04 04:15:00   0.00          0.0       0.0\n",
       "11087  2024-06-04 04:30:00   0.00          0.0       0.0\n",
       "2081   2024-06-04 04:45:00   0.00          0.0       0.0\n",
       "15081  2024-06-04 05:00:00   0.00          0.0       0.0\n",
       "12451  2024-06-04 05:15:00   0.00          0.0       0.0\n",
       "14012  2024-06-04 05:30:00   0.00          0.0       0.0\n",
       "4853   2024-06-04 05:45:00   0.00          0.0       0.0\n",
       "16011  2024-06-04 06:00:00   0.00          0.0       0.0\n",
       "14169  2024-06-04 06:15:00   0.00         0.18      0.64\n",
       "201    2024-06-04 06:30:00   0.20          1.5      2.31\n",
       "11367  2024-06-04 06:45:00   2.99          2.8      3.84\n",
       "9002   2024-06-04 07:00:00   6.63         5.12      5.68\n",
       "15876  2024-06-04 07:15:00  10.83          8.6      9.49\n",
       "16374  2024-06-04 07:30:00  15.40         9.61      9.49\n",
       "10189  2024-06-04 07:45:00  20.22         9.04      9.03\n",
       "13892  2024-06-04 08:00:00  25.15         9.59     10.55\n",
       "16253  2024-06-04 08:15:00  30.17        11.53     12.53\n",
       "14956  2024-06-04 08:30:00  35.19         13.5     14.52\n",
       "13222  2024-06-04 08:45:00  40.15        16.07     17.58\n",
       "2344   2024-06-04 09:00:00  45.03        18.76      18.8\n",
       "14543  2024-06-04 09:15:00  49.77        20.09     19.41\n",
       "11911  2024-06-04 09:30:00  54.34         18.4     19.72\n",
       "648    2024-06-04 09:45:00  58.16        22.01     22.63\n",
       "102    2024-06-04 10:00:00  61.69        27.25     33.96\n",
       "16984  2024-06-04 10:15:00  64.90        36.96     37.79\n",
       "14350  2024-06-04 10:30:00  67.78        39.46     40.53\n",
       "15504  2024-06-04 10:45:00  70.31        41.65     42.67\n",
       "3414   2024-06-04 11:00:00  72.49        44.62     46.03\n",
       "9945   2024-06-04 11:15:00  74.28        45.27     38.03\n",
       "2249   2024-06-04 11:30:00  75.70        39.89     41.44\n",
       "13228  2024-06-04 11:45:00  76.74        42.34      55.0\n",
       "10719  2024-06-04 12:00:00  77.41        64.81     67.32\n",
       "13527  2024-06-04 12:15:00  77.70        65.73     66.39\n",
       "3443   2024-06-04 12:30:00  77.61        71.97     76.51\n",
       "10200  2024-06-04 12:45:00  77.14        73.71     60.82\n",
       "10053  2024-06-04 13:00:00  76.30        71.39     77.21\n",
       "4088   2024-06-04 13:15:00  75.11        74.44     71.19\n",
       "4388   2024-06-04 13:30:00  73.56        72.99     70.68\n",
       "11380  2024-06-04 13:45:00  71.68        54.91     46.13\n",
       "4343   2024-06-04 14:00:00  69.48        45.99     45.35\n",
       "2651   2024-06-04 14:15:00  66.97         51.0     64.43\n",
       "9555   2024-06-04 14:30:00  64.18        57.69     50.88\n",
       "2750   2024-06-04 14:45:00  61.10        50.48     52.28\n",
       "1300   2024-06-04 15:00:00  57.77        52.93     52.62\n",
       "7278   2024-06-04 15:15:00  54.21        50.11     51.52\n",
       "6507   2024-06-04 15:30:00  50.43        52.03     53.18\n",
       "2039   2024-06-04 15:45:00  46.64        50.35     53.33\n",
       "2237   2024-06-04 16:00:00  42.66        56.25     55.31\n",
       "8207   2024-06-04 16:15:00  38.52        51.52     49.92\n",
       "5581   2024-06-04 16:30:00  34.25        47.22      56.6"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['dateTime'].str.contains('2024-06-04')][['dateTime','dq','realPowerAvg','realPower']].sort_values(by='dateTime')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python (panddlets)",
   "language": "python",
   "name": "panddlets"
  },
  "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.19"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}