can I use ploty graohs with vaex dataframe ?

[sanaeO]

I wanna use a dataframe vaex with ploty express to make a dash app
I don't know if I can do this

df = dfvx.groupby((dfvx.PRO, dfvx.AGE), agg='count')
scatter = px.scatter(df,
size="PRO, color="AGE",
hover_name="PRO", log_x=True, size_max=50)

the Error :
ValueError: Value of 'size' is not the name of a column in 'data_frame'. Expected one of [0] but received: count

If there is a solution , let Me know
thaaank you

[msbeeman]

Vaex with Dash
Good morning, yes you can use plotly with vaex to make a dash app if you convert the daex df to a pandas df. The co-founder of vaex has written something on making dash dashboards with vaex here: https://medium.com/plotly/interactive-and-scalable-dashboards-with-vaex-and-dash-9b104b2dc9f0

Your error
In Python if you ever see a ValueError raised, it's because you gave the function an invalid argument. If this ever occurs to you in the future start with checking the arguments you're trying to pass into the parameters and compare it to the documentation for the function you're using. In your particular case, it looks like you're missing an ending quote after PRO:

[sanaeO]

thank you so much for your reply
I put the ending quote but show the same error

I'm passing in to the parameters the name of my columns of my dataframe (df) , but doesn't work

[msbeeman]

@sanaeO Could you send sample data for dfvx?

[JovanVeljanoski]

You can't use plotly express directly with a vaex dataframe. This has been discussed elsewhere on these boards. If you'd like plotly express to support vaex dataframes, please raise this on the plotly side. There were some efforts on this.. In the meantime, easiest is to covert the vaex dataframe to pandas (see docs) after the group by operation. In most cases data for viz should be in memory anyway.

…

On Sat, Apr 16, 2022, 20:28 Matt Beeman ***@***.***> wrote: @sanaeO <https://github.com/sanaeO> Could you send sample data for dfvx? — Reply to this email directly, view it on GitHub <#2020 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AENW4Z3OA67B4IQC4GOAUYTVFMBGFANCNFSM5TQZJCTA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[maartenbreddels]

As Jovan said:

px.scatter(vdf.to_pandas_df(), ...)

should work

[maartenbreddels]

If plotly/plotly.py#3387 is merged in the future, this won't be needed anymore.