Oct-26-2022, 07:18 PM
Hello,
I am trying to create a chart from data in xlsx.
I find explanation not very precise:
https://plotly.com/python/line-charts/
Anyone has a better exemple or a solution?
Thank you
I am trying to create a chart from data in xlsx.
1 2 3 4 5 6 7 8 9 10 11 12 |
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