Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add plot types to sqlplot #483

Closed
lfunderburk opened this issue May 5, 2023 · 2 comments
Closed

Add plot types to sqlplot #483

lfunderburk opened this issue May 5, 2023 · 2 comments

Comments

@lfunderburk
Copy link

Feedback from community:

It'd be great to have the option to do other kinds of plots with the sqlplot magic:

  • Line chart
  • Scatter plot
  • Bar chart

https://jupysql.ploomber.io/en/latest/api/magic-plot.html

@edublancas
Copy link

bar chart is easy to add, we just need to compute the proportions for each category in the db and then use them to generate the plot.

The other ones are a bit more challenging. The naive approach would be to download all the data and use it to create the line/scatter plot, but this defeats the purpose of using JupySQL, since the idea is to leverage the SQL engine. we might wanna implement something like this: https://datashader.org/

@edublancas
Copy link

closing in favor of #417

@edublancas edublancas closed this as not planned Won't fix, can't repro, duplicate, stale May 23, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants