How to visualize dataframe from CSV through file upload

🚀 Support (Q&A)
1

I made a FileField where people can upload a CSV file.

With this file I want to visualize a dataframe.

image
image882×652 61 KB

It is not working. What is the right way to call the CSV file and visualize its dataframe?

2

Hi Anne,

Welcome to the forum, thanks for posting!

You’re quite far along already with your use-case but there’s still a couple of things that are going wrong. Firstly, you’re using a PlotlyAndDataView but not returning a PlotlyAndDataResult but I assume this is because you simplified the example for this post, so I will handle you use-case as if it were just a DataView.

Another issue is the way you call the do_something_with_csv method. You need to call it as a separate method from the Controller class. Moreover you are entering file as an argument to that method while it requires the params. So that would then become:

def do_something_with_csv(self, params, **kwargs):
    upload_file = params.file.file
    data_file = BytesIO(upload_file.getvalue_binary())
    df = pd.read_csv(data_file)
    return df

@DataView("Dataframe", duration_guess=1)
def visualize_data(self, params, **kwargs):
    data = self.do_something_with_csv(params)

Finally, and I think this is your main issue, the DataResult (or PlotlyAndDataResult for that matter) require a DataGroup object which in turn consists of DataItem objects. So you can’t simply pass your dataframe in there. So you have two choices:

  1. write a simple function looping through your dataframe and writing all lines to DataItem objects. See the docs on DataItem to see how these are structured.
  2. present your dataframe in a Plotly table instead, Plotly accepts dataframes a little easier but I don’t know how this would fit in your design.

Let me know if this information helps you out, or if you have any other questions!

3

Beste Daniel,

Thankyou for your reponse. Right now the app does not try to visualize anything.

Ive tried this, but it does not work.

image
image822×797 71.5 KB

Thankyou!

4

Hi Anne,

As seen in the documentation the DataItem needs at minimum a label and a value. So depending on the contents of your csv you should adjust the input accordingly.

5

Hi @AnneHeijbroek, I stumbled across your topic and was wondering: would you by any chance be helped by using the TableView shown in this topic: Snippet Wednesday - My own TableView! 🌐 It takes a dataframe directly and visualises it as a table.

Just thought it might be relevant for you.

6

Thankyou, I think that is super helpful and relevant! I will try it out.

7

Thankyou, I will try it out!

9

Hi it worked, I can display a table of 5 or more rows.

It does give an error when I want to visualize too many rows (like 3000 rows)
Can I do anything to fix that?

And another question. I would like to visualize to tables in one ‘tab’.
Is this possible?