Skip to content
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

Highlight columns based on the dtype #84

Closed
reza1615 opened this issue Feb 26, 2020 · 10 comments
Closed

Highlight columns based on the dtype #84

reza1615 opened this issue Feb 26, 2020 · 10 comments

Comments

@reza1615
Copy link

reza1615 commented Feb 26, 2020 •
edited
Loading

It would be perfect to have a setting which user can select it to change the column's back color based on the column dtype
for example

  • Text is white
  • Int is light blue
  • Date is light pink
aschonfeld pushed a commit that referenced this issue Mar 24, 2020
[#84](#84) highlight columns based on dtype
a83adec
@aschonfeld
Copy link
Collaborator

@reza1615 I think I've got this in a good place, going to include it in the next release
image

Current type mappings are:
string -> white
int -> light blue
floats -> light green
bool -> gold
date -> pink

Let me know if you think i'm missing anything

@reza1615
Copy link
Author

reza1615 commented Mar 24, 2020 •
edited
Loading

there is more data types https://pbpython.com/pandas_dtypes.html

timedelta
category

@aschonfeld
Copy link
Collaborator

Any suggestions on colors for those?

@reza1615
Copy link
Author

reza1615 commented Mar 25, 2020 •
edited
Loading

In my opinion lighter colors are better than pure colors may be colors between second to fifth row

@reza1615
Copy link
Author

timedelta --> light red or light orange
categorical --> light violet

@reza1615
Copy link
Author

Screenshot_20200324-234156_Chrome

@aschonfeld
Copy link
Collaborator

I probably should have listed this from the start. Here's the actual mapping I'm using now. Feel free to give me your final suggestion :)

  • float -> #B2DFD8
  • int -> #BBDEF8
  • date -> #F8BBD0
  • object(string) -> none (white)
  • bool -> #FFF59D
  • category -> #E1BEE7
  • timedelta -> #FFCDD2

image

@reza1615
Copy link
Author

timedelta's color is very similar to the date

@aschonfeld
Copy link
Collaborator

Ok, I updated timedelta to #FFCDD2

image

aschonfeld pushed a commit that referenced this issue Mar 28, 2020
1.8.1 bugixes & enhancements:
73dfa70 
* #84, highlight columns based on dtype
* #92, build columns with random values
* #111, code export has syntax error & str() fix for column builder names
* #116, updated styling of github fork link
* #114, added "Export CSV" link
* #113, updates to "Value Counts" chart in "Column Analysis" for number of values and ordinal entry
* #120, allowing for duplicates in bar charts
* #119, fixed bug with queries not being passed to functions
* #114, added the ability to export dataframes to CSV/TSV
* added "category breakdown" in column analysis popup for float columns
* fixed bug where previous "show missing only" selection was not being recognized
aschonfeld pushed a commit that referenced this issue Mar 28, 2020
1.8.1 bugixes & enhancements:
eecbd4e 
* #84, highlight columns based on dtype
* #92, build columns with random values
* #111, code export has syntax error & str() fix for column builder names
* #116, updated styling of github fork link
* #114, added "Export CSV" link
* #113, updates to "Value Counts" chart in "Column Analysis" for number of values and ordinal entry
* #120, allowing for duplicates in bar charts
* #119, fixed bug with queries not being passed to functions
* #114, added the ability to export dataframes to CSV/TSV
* added "category breakdown" in column analysis popup for float columns
* fixed bug where previous "show missing only" selection was not being recognized
@aschonfeld aschonfeld mentioned this issue Mar 28, 2020
Merged
aschonfeld pushed a commit that referenced this issue Mar 28, 2020
1.8.1 bugfixes & enhancements:
530f882 
* #84, highlight columns based on dtype
* #92, build columns with random values
* #111, code export has syntax error & str() fix for column builder names
* #116, updated styling of github fork link
* #114, added "Export CSV" link
* #113, updates to "Value Counts" chart in "Column Analysis" for number of values and ordinal entry
* #120, allowing for duplicates in bar charts
* #119, fixed bug with queries not being passed to functions
* #114, added the ability to export dataframes to CSV/TSV
* added "category breakdown" in column analysis popup for float columns
* fixed bug where previous "show missing only" selection was not being recognized
aschonfeld pushed a commit that referenced this issue Mar 28, 2020
@aschonfeld
1.8.1 bugfixes & enhancements:
ae37d9a 
* #84, highlight columns based on dtype
* #92, build columns with random values
* #111, code export has syntax error & str() fix for column builder names
* #116, updated styling of github fork link
* #114, added "Export CSV" link
* #113, updates to "Value Counts" chart in "Column Analysis" for number of values and ordinal entry
* #120, allowing for duplicates in bar charts
* #119, fixed bug with queries not being passed to functions
* #114, added the ability to export dataframes to CSV/TSV
* added "category breakdown" in column analysis popup for float columns
* fixed bug where previous "show missing only" selection was not being recognized
aschonfeld pushed a commit that referenced this issue Mar 28, 2020
1.8.1 bugfixes & enhancements:
da8c445 
* #84, highlight columns based on dtype
* #92, build columns with random values
* #111, code export has syntax error & str() fix for column builder names
* #116, updated styling of github fork link
* #114, added "Export CSV" link
* #113, updates to "Value Counts" chart in "Column Analysis" for number of values and ordinal entry
* #120, allowing for duplicates in bar charts
* #119, fixed bug with queries not being passed to functions
* #114, added the ability to export dataframes to CSV/TSV
* added "category breakdown" in column analysis popup for float columns
* fixed bug where previous "show missing only" selection was not being recognized
aschonfeld pushed a commit that referenced this issue Mar 28, 2020
1.8.1 bugfixes & enhancements:
0e073eb 
* #84, highlight columns based on dtype
* #92, build columns with random values
* #111, code export has syntax error & str() fix for column builder names
* #116, updated styling of github fork link
* #114, added "Export CSV" link
* #113, updates to "Value Counts" chart in "Column Analysis" for number of values and ordinal entry
* #120, allowing for duplicates in bar charts
* #119, fixed bug with queries not being passed to functions
* #114, added the ability to export dataframes to CSV/TSV
* added "category breakdown" in column analysis popup for float columns
* fixed bug where previous "show missing only" selection was not being recognized
@aschonfeld
Copy link
Collaborator

added in v1.8.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@reza1615 @aschonfeld