search

rpbouman / huey

A UI for DuckDB
MIT License
182 stars 14 forks source link

Would be nice to have a way to bucket numerical attributes #109

Open rpbouman opened 1 month ago

rpbouman commented 1 month ago

Would be cool if we could have some way to bucket numerical attributes.

For example, suppose we want to know how many rides there are for different distances, Right now, putting trip distance on the axis and count in the cells won't reveal much because there are many different mileages, each with only one or few rides.

making buckets like 0-1, 1-2, 2-3 etc would make much more sense.

rpbouman commented 1 month ago

Checkout https://stats.stackexchange.com/questions/798/calculating-optimal-number-of-bins-in-a-histogram#:~:text=The%20Freedman%2DDiaconis%20rule%20is,min%20is%20the%20minimum%20value.