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.

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

Add ability to build new basic columns #61

Closed
phillipdupuis opened this issue Feb 13, 2020 · 1 comment
Closed

Add ability to build new basic columns #61

phillipdupuis opened this issue Feb 13, 2020 · 1 comment

Comments

@phillipdupuis
Copy link
Contributor

phillipdupuis commented Feb 13, 2020

It would be nice if the menu had a "Build Column" option so that users could quickly & easily modify the underlying data.

The basic idea would be that the 'Build column' interface would prompt users to enter:

  1. The new column's name (freetext w/ verification that it's valid)
  2. The type of column (picklist)
  3. The source column(s), i.e. the ones used to drive the calculations (picklist)
  4. Any additional options dependent on column type

The types of columns could be:

  1. Sum
    Prompt the user to pick two numeric columns

  2. Difference
    Prompt the user to pick two numeric columns

  3. Bins (evenly spaced)
    Prompt the user to pick one column.
    Additional options: Number of bins, bin labels.
    Use pd.cut

  4. Bins (evenly sized)
    Prompt the user to pick one column.
    Additional options: number of bins, and bin labels)
    Use pd.qcut

  5. Datetime property
    Prompt the user to pick one datetime column
    Additional options: property (one of the Series.dt.__ properties like time, year, month, etc.)

  6. (Maybe?) String function
    Prompt the user to pick one string column
    Additional options: function (Series.str.__ such as endswith, startswith, len, etc.) and value

And possibly more, will update this over time...

aschonfeld pushed a commit that referenced this issue Feb 18, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 19, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 20, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
@aschonfeld aschonfeld mentioned this issue Feb 20, 2020
aschonfeld pushed a commit that referenced this issue Feb 20, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
aschonfeld pushed a commit that referenced this issue Feb 20, 2020
 - fix for #63, periods in column names
 - added json_loader CLI options
 - updated moving/locking of columns to be persisted to back-end as well as front-end
 - added the ability to show/hide columns
 - added column builder popup (#61)
@aschonfeld
Copy link
Collaborator

Added in v1.7.5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants