Add "is not nan" to simple filters context menu

man-group / dtale

Visualizer for pandas data structures

http://alphatechadmin.pythonanywhere.com

GNU Lesser General Public License v2.1

4.72k stars 400 forks source link

Add "is not nan" to simple filters context menu #868

Closed Gdsimms closed 3 months ago

Gdsimms commented 3 months ago

I'm trying to filter my dataframe to rows where a particular column is not a "nan" and I can not find an easy way to do this with the filter context menu. I often need to do this for different columns at different times so it would be nice if this was a quick and easy entry in the simple filters list in this menu, called "not empty" or "not nan"

Alternatively, this syntax does not appear to work, though it feels like it should:

aschonfeld commented 3 months ago

@Gdsimms how is this?

https://github.com/man-group/dtale/assets/11547371/08487db7-3047-4d37-bfe7-0e125c2ad7ed

aschonfeld commented 3 months ago

@Gdsimms this feature has been added to the v3.13.0 release. Let me know if you have any issues.

Gdsimms commented 3 months ago

Perfect; thank you. I hope others find this useful, too!