Skip to content

Data Explorer: Pandas summary statistics formatting #3210

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
jthomasmock opened this issue May 21, 2024 · 1 comment
Closed

Data Explorer: Pandas summary statistics formatting #3210

jthomasmock opened this issue May 21, 2024 · 1 comment
Assignees
@wesm
Labels
area: data explorer Issues related to Data Explorer category. enhancement New feature or request lang: python
Milestone
Public Beta 2024 Q2

Comments

@jthomasmock
Copy link
Contributor

Prettier printing of pandas summaries: part of #2339
@jthomasmock jthomasmock added enhancement New feature or request area: data explorer Issues related to Data Explorer category. lang: python labels May 21, 2024
@jthomasmock jthomasmock added this to the Public Beta 2024 Q2 milestone May 21, 2024
@wesm wesm mentioned this issue May 29, 2024
Merged
wesm added a commit that referenced this issue May 30, 2024
@wesm
Data Explorer: Add preliminary customizable float formatting options …
3660fa8 
…for data values, summary stats (#3310)

Partly addresses #2339 and #3210, and #3314. Adds a format_options parameter in the get_data_values and get_column_profiles backend methods to allow customized formatting of large, small, and medium-sized numbers. If the value threshold is above or below limits implied by the parameters, scientific notation is used. We've talked about dynamically trimming zero padding from the end of numbers (e.g. if all the floats displayed are integral, then we can trim the trailing zeros off all of them), but this will be a frontend-only change that can be done after.
@wesm wesm mentioned this issue May 30, 2024
Open
@testlabauto
Copy link
Contributor

Verified Fixed

Positron Version(s) : 2024.05.0-1345
OS Version          : OSX

Test scenario(s)

Tested with:

import pandas as pd
data_dict = {'a': ['p1', 'p2', 'p3', 'p4', 'p5', 'p6'],
             'b': [0.001, 0.00002, 0.0000006, 0.000000008, 0.00000000009, 20],
             'c': [1.0003, 1.0000006, 1.00000000012, 98, 92, 95],
             'd': [90.000005, 100, 91, 92.0000000000012, 98, 9589077780000000],
             'e': [93.1, 89000000000000, 99.000004, 92, 94, 92978987987777]
             }
             
             
df = pd.DataFrame(data_dict)

Link(s) to TestRail test cases run or created:

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Aug 13, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@wesm wesm

Labels
area: data explorer Issues related to Data Explorer category. enhancement New feature or request lang: python
Projects
None yet
Milestone
Public Beta 2024 Q2
Development

No branches or pull requests
3 participants
@wesm @jthomasmock @testlabauto