PyScript Tutorial - Upload CSV in PyScript with Pandas and Panel without JS #9

Learn how to create a PyScript App where you can upload csv file using Pandas and Panel.

PyScript Playlist:

#pyscript #Pythonhtml

[pradipwaghela]

Hi, Can we do that without panel?? latest version of pyscript having error with panel .

[JasonWhittle]

This is fantastic. What would be even more fantastic is if the csv could be stored as a dataframe object? Is that even possible?

Basically I'm trying to upload a csv file, manipulate the dataframe using pandas, then export it. All in the browser without running a local server.

[yashikachauhan]

How can I download the csv file after filtering it?

[kratibhat]

Which is the variable in this wch stores csv contents

[kratibhat]

We use df=pd.read_csv and then e=df['content'].values in python how to use that in py script

[tlabvision]

Hi, I did the same with stlite, do you think there's a trick to load a file inside a local folder?

import io
import pandas as pd
import streamlit as st
import numpy as np

bytes_data = None

uploaded_file = st.file_uploader("Choose an excel", type=['xlsx', 'xls'])
if uploaded_file is not None:
# To read file as bytes:
bytes_data = uploaded_file.getvalue()

if bytes_data is None:
st.stop()

df = pd.read_excel(uploaded_file)
st.write(df.head())

Many thanks

[ProfeDuilio]

Hello, first: congratulations and thanks for all your contribution.
You know, I would like to get the name of the file that I read from the file explorer (when using the UpLoad button) to use as the name of a possible table.
However, it is impossible with the fileInput parameters.
I'm using:
fileinput.filename
fileinput.filename()
fileinput.Filename (with and without parentheses)
fileinput.fileName (with and without parentheses)

and other combinations, but none works.

[tusharnautiyal]

Hi the video was great please also look for how to load pickle files that are in drive or somewhere because we cannot use cloudpickle as its not supported in pyodide we need to use pyfetch but that too is not working. Do create a video if you can find the solution that would be very helpful for all your subscribers.

[muhammadtabish]

Nice video but i want to show a data on graph instead of table. I am using seaborn for plot

[xinchianlim]

how to upload an excel file instead of csv?

[aromaa-kf]

Congrats first to sharing this tutorial..
today I tried it.. and it is not working.. got below error message
JsException(PythonError: Traceback (most recent call last): File "/lib/python3.10/asyncio/futures.py", line 201, in result raise self._exception File "/lib/python3.10/asyncio/tasks.py", line 232, in __step result = coro.send(None) File "/lib/python3.10/site-packages/_pyodide/_base.py", line 500, in eval_code_async await CodeRunner( File "/lib/python3.10/site-packages/_pyodide/_base.py", line 353, in run_async await coroutine File "", line 2, in ModuleNotFoundError: No module named 'panel' )