Plotly send pandas.errors.UndefinedVariableError.

[Frankduc]

Hello,

I am trying to create a chart from data in xlsx.

import pandas as pd
import plotly.express as px


dataframe1 = pd.read_excel(r'C:\Users\faceo\Documents\NinjaTrader Grid 2022-10-26 01-30 .xlsx')

print(dataframe1)


df = px.data.gapminder().query("Date=='2022-10-26'")
fig = px.line(df, x="Time", y="Close")
fig.show()

Output:
  Date   Time     Open     High      Low    Close  Volume  Status
0    2022-10-26  13:31  3853.50  3854.50  3853.00  3853.25     874     NaN
1    2022-10-26  13:30  3854.75  3855.00  3853.00  3853.75    2599     NaN
2    2022-10-26  13:29  3854.00  3855.25  3853.00  3855.00    2860     NaN
3    2022-10-26  13:28  3856.50  3856.50  3853.00  3853.75    4586     NaN
4    2022-10-26  13:27  3856.00  3857.00  3854.50  3856.25    4775     NaN
..          ...    ...      ...      ...      ...      ...     ...     ...
806  2022-10-26  00:05  3836.25  3836.50  3835.50  3835.75      54     NaN
807  2022-10-26  00:04  3836.00  3836.75  3836.00  3836.00      31     NaN
808  2022-10-26  00:03  3835.00  3836.00  3835.00  3835.75      61     NaN
809  2022-10-26  00:02  3835.75  3835.75  3835.00  3835.00      62     NaN
810  2022-10-26  00:01  3836.00  3836.00  3835.75  3835.75      35     NaN

[811 rows x 8 columns]

I get this error:

Error:
Traceback (most recent call last):
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\scope.py", line 198, in resolve
    return self.resolvers[key]
  File "C:\Users\faceo\AppData\Local\Programs\Python\Python310\lib\collections\__init__.py", line 986, in __getitem__
    return self.__missing__(key)            # support subclasses that define __missing__
  File "C:\Users\faceo\AppData\Local\Programs\Python\Python310\lib\collections\__init__.py", line 978, in __missing__
    raise KeyError(key)
KeyError: 'Date'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\scope.py", line 209, in resolve
    return self.temps[key]
KeyError: 'Date'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Users\faceo\Documents\AI1\ninjatrader\ninjatrader.py", line 10, in <module>
    df = px.data.gapminder().query("Date=='2022-10-26'")
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\util\_decorators.py", line 331, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\frame.py", line 4463, in query
    res = self.eval(expr, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\util\_decorators.py", line 331, in wrapper
    return func(*args, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\frame.py", line 4601, in eval
    return _eval(expr, inplace=inplace, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\eval.py", line 353, in eval
    parsed_expr = Expr(expr, engine=engine, parser=parser, env=env)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 813, in __init__
    self.terms = self.parse()
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 832, in parse
    return self._visitor.visit(self.expr)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 415, in visit
    return visitor(node, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 421, in visit_Module
    return self.visit(expr, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 415, in visit
    return visitor(node, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 424, in visit_Expr
    return self.visit(node.value, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 415, in visit
    return visitor(node, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 723, in visit_Compare
    return self.visit(binop)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 415, in visit
    return visitor(node, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 536, in visit_BinOp
    op, op_class, left, right = self._maybe_transform_eq_ne(node)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 456, in _maybe_transform_eq_ne
    left = self.visit(node.left, side="left")
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 415, in visit
    return visitor(node, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\expr.py", line 549, in visit_Name
    return self.term_type(node.id, self.env, **kwargs)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\ops.py", line 85, in __init__
    self._value = self._resolve_name()
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\ops.py", line 109, in _resolve_name
    res = self.env.resolve(local_name, is_local=is_local)
  File "C:\Users\faceo\Documents\AI1\ninjatrader\venv\lib\site-packages\pandas\core\computation\scope.py", line 211, in resolve
    raise UndefinedVariableError(key, is_local) from err
pandas.errors.UndefinedVariableError: name 'Date' is not defined

Obviously i am not referring correctly my data to df = px.data.gapminder().query("Date=='2022-10-26'")

I find explanation not very precise:

https://plotly.com/python/line-charts/

Anyone has a better exemple or a solution?

Thank you