positron icon indicating copy to clipboard operation
positron copied to clipboard

Epic: Data Explorer Summary Panel statistics

Open jthomasmock opened this issue 1 year ago • 13 comments

When the Summary Panel is expanded, it will dynamically calculate and then reveal additional summary statistics for that specific column. This is a lazy operation in the backend as it would otherwise be costly for long/wide datasets.

Summary stats will be right aligned at the decimal place:

NA:           15
Median:       14
Mean:         15.7
SD:            2.1
Min:           1.2
Max:          20.3

Completed:

  • [x] Numeric in R
  • [x] Numeric in Python
  • [x] String in R
  • [x] String in Python
  • [x] Date in R
  • [x] Date in Python
  • [x] Datetime in R
  • [x] Datetime in Python
  • [x] Boolean in R
  • [x] Boolean in Python
  • [ ] Unknown in R
  • [ ] Unknown in Python

Parent Categorical: https://github.com/posit-dev/positron/issues/3417

  • [ ] Factor/Categorical in R
  • [ ] Factor/Categorical in Python

Number

  • Median
  • Mean
  • Standard Deviation (SD)
  • Min
  • Max

Boolean

  • TRUE N (%)
  • FALSE N (%)

String

  • Empty: N ( this is equivalent to a "" string - implicit missing)
  • Unique (Number of unique strings)

String sub-category: Categorical/Factor

  • Levels - Ordered/Not Ordered + number

Date or Datetime or time

  • Number of unique
  • Mean
  • Median
  • Min
  • Max
  • If time, timezone

Array -- holding off for now

  • Number of unique

Struct -- holding off for now

  • Number of unique

Unknown -- holding off for now

  • Number of unique

jthomasmock avatar Jan 30 '24 04:01 jthomasmock