sqlcmd profile improvements

[idomic]

So the table profiling is a bit unclear on how to read the output and what to do with nan values.
For instance, running on the table below, it could be nan for many reasons, wrong datatypes, db doesn't support the unique functions (STDEV function), confusing values (2.456e+01) etc.

We should improve the guide and the functionality of it, and produce a result that's similar in essence to the pandas profiling report.

@edublancas feel free to add more context.

[edublancas]

I think we should diagnose first why we have some many nans, and then decide what's the best way to replace them. For example, if the table doesn't have the STDEV function, perhaps we can show another string or change the color - this is the only case where the behavior should differ from pandas.

For the other cases, we should look at how pandas handles it.

[edublancas]

hey @yafimvo: did you start working on this? I can assign it to somebody else

[yafimvo]

@edublancas No

[edublancas]

cool. I'll assign it to someone else.

[AnirudhVIyer]

On it!