Ошибка при поиске в датафрейме значения из переменно

Добрый день пытаюсь осуществить поиск в датафрейме pandas значения из переменной

 
import datetime

import gspread
import numpy as np
import pandas as pd
from datetime import date as dt
from datetime import datetime
import time

# connect got Google Sheets
gc = gspread.service_account(filename="/home/whitehercog/credentials/lookysymbiot-8bd1d380b0c4.json")
# list all available spreadsheets
sh = gc.open_by_key('1e8byu8VovhBsEc9mG5DRxayywP8zaA2DzpsAcAuboLc')

worksheet = sh.sheet1
worklist = worksheet.get_all_values()

# pandas df
Ddf = pd.DataFrame(worksheet.get_values('A2:E30'),
                   columns=['Worked_date', 'Worker', 'Start_smene', 'End_smene', 'Chat_id_worker'])


Ndf = pd.DataFrame(worksheet.get_values('F2:J30'),
                   columns=['Worked_date', 'Worker', 'Start_smene', 'End_smene', 'Chat_id_worker'])

Ndf['Worked_date'] = pd.to_datetime(Ndf.Worked_date, format='%d.%m.%Y')

# date variable
wdate = time.strftime("%d.%m.%Y")
wtime = time.strftime("%H:%M")

getworker = Ddf.loc(wdate)


print(getworker)

при старте получаю данную ошибку

KeyError: '15.11.2022'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/whitehercog/PycharmProjects/looky_simbiot_monitoring/google_sheets_connect/google_sheets.py", line 32, in <module>
    getworker = Ddf.loc(wdate)
  File "/home/whitehercog/PycharmProjects/looky_simbiot_monitoring/venv/lib/python3.10/site-packages/pandas/core/indexing.py", line 668, in __call__
    axis = self.obj._get_axis_number(axis)
  File "/home/whitehercog/PycharmProjects/looky_simbiot_monitoring/venv/lib/python3.10/site-packages/pandas/core/generic.py", line 556, in _get_axis_number
    raise ValueError(f"No axis named {axis} for object type {cls.__name__}")
ValueError: No axis named 15.11.2022 for object type DataFrame

Ответы (0 шт):