highlight back color of outliers/missing values

[reza1615]

It is interesting to see where are the missing values or where are the outliers.
1- It can be like type high lighting for missing pink and for outliers range of colors

• From dark blue to light blue for lower bound
• From light red to dark red for upper bound
  2- For missing values
• Null > Yellow
• Empty or space (one space or multi space > Orange

Some time outliers or missing values are in the very below rows so we need a notifier

3- Render an start to the first of column name when it has outlier
4- Render ! to the first of column name when it has missing value

They can be two separate command

[aschonfeld]

Sorry, just trying to make sense of these requirements. Does this sound right?

1. Outlier Highlighting

• lower bounds will be blue with the opacity going from lighter to darker as you get closer to the lowest value
• upper bounds will be red with the opacity going from lighter to darker as you get closer to the highest value

2. Missing values

• np.nan values will be yellow
• for string columns, empty or consisting entirely of spaces will be orange

3. Put a ⭐ on the front of column names that have outliers
4. Prepend a "!" to any column names that have missing values

[reza1615]

Yes it is correct

[aschonfeld]

Here is the missing highlighting:

Hopefully have outlier highlighting done for a release this weekend.

[reza1615]

1- Does it support numeric columns? (like lat and long columns which have missing but didn't highlight)?
2- would you please use ❗ or ❕ or ❌ instead of !

[aschonfeld]

Ok, here's the final product.

Outliers

Missing

[reza1615]

That is great thanks

[aschonfeld]

added v1.8.10