News for hackers. Stuff that matters.
Re:The worst of the two worlds: Excel meets Outlook by slaymaker1907 on Saturday February 13, 2021 @08:24PM (#26128812)
Excel is exceptionally good at telling you what the shape of your data is. I love being able to just turn something into a table and then see the distinct values as a filter.

Sure, SQL and most environments can tell you distinct values of a column and their counts, but they are much slower and more cumbersome to explore with. I often start out with broad filters then go through many more specific ones depending on what I see from the first filter.

Re:The worst of the two worlds: Excel meets Outlook by LaszloKv on Saturday February 13, 2021 @09:49PM (#26129216)
Another great tool for data exploration is visidata! This is a good example of what it can do. https://www.youtube.com/watch?v=N1CBDTgGtOU
Re:The worst of the two worlds: Excel meets Outlook by sam_bristow on Sunday February 14, 2021 @02:06AM (#26130308)
Visidata is great. My main problem is that I use it so infrequently so it's hard to build up the muscle memory to use it really effectively.
Re:The worst of the two worlds: Excel meets Outlook by waheoo on Saturday February 13, 2021 @09:52PM (#26129228)
Isn't all excel data tabular in shape?