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.

Sign up for GitHub

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

Jump to bottom

Column filtering #102

Closed
juanfcocontreras opened this issue Mar 8, 2020 · 4 comments
Closed

Column filtering #102

juanfcocontreras opened this issue Mar 8, 2020 · 4 comments

Comments

@juanfcocontreras
Copy link

This is a feature request. Right now, filtering can be done using the df.query method from the main menu. That's great, but often you only need to filter by certain values in a column.

My suggestion would be to add a filtering option in the context menu of the columns, so that the filtering expression would be applied only to that column, saving you from having to type the full name of the column.

Another addition would be that for columns that include discrete values (categories), you could select the values you want to filter on instead of having to write them down.

Both options are implemented at qgrid.
@aschonfeld
Copy link
Collaborator

@juanfcocontreras this will be the next thing I tackle :)

aschonfeld pushed a commit that referenced this issue Mar 22, 2020
1.8.0
e30921e 
 * #102, interactive column filtering for string, date, int, float & bool
 * better handling for y-axis management in charts.  Now able to toggle between default, single & multi axis
 * increased maximum groups to 30 in charts and updated error messaging when it surpasses that for easier filter creation
 * bugfix for date string width calculation
 * updated sort/filter/hidden header so that you can now click values which will trigger a tooltip for removing individual values
 * updated Filter popup to be opened as separate window when needed
@aschonfeld aschonfeld mentioned this issue Mar 22, 2020
Merged
aschonfeld pushed a commit that referenced this issue Mar 22, 2020
@aschonfeld
1.8.0
50baa40 
 * #102, interactive column filtering for string, date, int, float & bool
 * better handling for y-axis management in charts.  Now able to toggle between default, single & multi axis
 * increased maximum groups to 30 in charts and updated error messaging when it surpasses that for easier filter creation
 * bugfix for date string width calculation
 * updated sort/filter/hidden header so that you can now click values which will trigger a tooltip for removing individual values
 * updated Filter popup to be opened as separate window when needed
@aschonfeld
Copy link
Collaborator

@juanfcocontreras just released v1.8.0 which includes support for interactive column filtering! Let me know what you think. Here's a quick video of the functionality: https://www.youtube.com/watch?v=8zo5ZiI1Yzo

@juanfcocontreras
Copy link
Author

@juanfcocontreras just released v1.8.0 which includes support for interactive column filtering! Let me know what you think. Here's a quick video of the functionality: https://www.youtube.com/watch?v=8zo5ZiI1Yzo

I think it's just amazing. Thank you very much for your effort!

@aschonfeld
Copy link
Collaborator

Anytime! Tell your friends 😉

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@juanfcocontreras @aschonfeld