Displaying dataframe in Web using PyScript
تبليغسؤال
يرجى شرح بإيجاز لمإذا تشعر أنك ينبغي الإبلاغ عن هذا السؤال.
I have created a simple dataframe in pyhton and i want to display it in Web using PyScript.
Below is my script web.py, which works flawlessly when accessing my test data on my Onedrive account.
import pandas as pd
url_xl = “https://onedrive.live.com/download?cid=E29C174708A82470&resid=E29C174708A82470%211239&authkey=AAFSfw2ykxOwRr4”
xl = pd.read_excel(url_xl,sheet_name=’Sheet1′)
print(xl)
web.py – Output:
col1 col2 col3 col4 col5
0 A A A A A
1 B B B B B
2 C C C C C
However, when I incorporated the above script to call it in HTML Script/PyScript.
HTML/PyScript
<html>
<head>
<title> test </title>
<link rel=”stylesheet” href=”https://pyscript.net/alpha/pyscript.css” />
<script defer src=”https://pyscript.net/alpha/pyscript.js”></script>
<py-env>
– pandas
</py-env>
</head>
<body>
<py-script src=’./web.py’>
pyscript.write(‘data’,df.to_html)
</py-script>
</body>
<p id=”data”></p>
</html>
I got this error
JsException(PythonError: Traceback (most recent call last): File “/lib/python3.10/site-packages/_pyodide/_base.py”, line 429, in eval_code .run(globals, locals) File “/lib/python3.10/site-packages/_pyodide/_base.py”, line 300, in run coroutine = eval(self.code, globals, locals) File “”, line 4, in File “/lib/python3.10/site-packages/pandas/util/_decorators.py”, line 311, in wrapper return func(*args, **kwargs) File “/lib/python3.10/site-packages/pandas/io/excel/_base.py”, line 457, in read_excel io = ExcelFile(io, storage_options=storage_options, engine=engine) File “/lib/python3.10/site-packages/pandas/io/excel/_base.py”, line 1376, in __init__ ext = inspect_excel_format( File “/lib/python3.10/site-packages/pandas/io/excel/_base.py”, line 1250, in inspect_excel_format with get_handle( File “/lib/python3.10/site-packages/pandas/io/common.py”, line 670, in get_handle ioargs = _get_filepath_or_buffer( File “/lib/python3.10/site-packages/pandas/io/common.py”, line 339, in _get_filepath_or_buffer with urlopen(req_info) as req: File “/lib/python3.10/site-packages/pandas/io/common.py”, line 239, in urlopen return urllib.request.urlopen(*args, **kwargs) File “/lib/python3.10/urllib/request.py”, line 216, in urlopen return opener.open(url, data, timeout) File “/lib/python3.10/urllib/request.py”, line 519, in open response = self._open(req, data) File “/lib/python3.10/urllib/request.py”, line 541, in _open return self._call_chain(self.handle_open, ‘unknown’, File “/lib/python3.10/urllib/request.py”, line 496, in _call_chain result = func(*args) File “/lib/python3.10/urllib/request.py”, line 1419, in unknown_open raise URLError(‘unknown url type: %s’ % type) urllib.error.URLError: )
using Inspect
Uncaught (in promise) TypeError: Cannot read properties of undefined (reading base.ts:128:79 ‘setAttribute’) at PyScript.evaluate (base.ts:128:79)
أضف إجابة