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

Pivot operation allows selection of single column #237

Closed
mswastik opened this issue Aug 9, 2020 · 5 comments
Closed

Pivot operation allows selection of single column #237

mswastik opened this issue Aug 9, 2020 · 5 comments

Comments

@mswastik
Copy link
Contributor

mswastik commented Aug 9, 2020 •
edited
Loading

Pivot operation in summarize data allow selection of single row and column even though pandas pivot_table function allows selection of multiple rows and column.
Why not migrate from pandas pivot function to pivot_table function?
@aschonfeld
Copy link
Collaborator

aschonfeld commented Aug 9, 2020 •
edited
Loading

@mswastik I can't remember a specific reason for why I'm only using pivot_table for when the user selects an aggregation function. I'll gladly update the rows & columns to be multi-selects. I think I'll have some work to do around constructing the column names when multiple columns are selected, but I don't think thats too big a deal.

@mswastik
Copy link
Contributor Author

mswastik commented Aug 9, 2020

Thanks, constructing multiple column names is already there in JavaScript when using group by operation, you just need to extend it for pivot operation also and replace pivot command in python with pivot_table.

@reza1615
Copy link

reza1615 commented Aug 9, 2020 •
edited
Loading

@aschonfeld Also when there is duplicate column or index in the pivot, pandas shows error but pivot_table has aggregations to select just one of them.
In my opinion pivot_table + aggregations is a good enhancement

aschonfeld added a commit that referenced this issue Aug 13, 2020
@aschonfeld
1.13.0
26326bc 
* #231: "Lock Zoom" button on 3D Scatter & Surface charts for locking camera on animations
* global & instance-level flag to turn off cell editing
* added the ability to upload CSVs
* upgraded prismjs
* #234: update to line animations so that you can lock axes and highlight last point
* #233: add candlestick charts
* #241: total counts vs. count (non-nan) in describe
* #240: force convert to float
* #239: converting mixed columns
* #237: updated "Pivot" reshaper to always using pivot_table
* #236: "inplace" & "drop_index" parameters for memory optimization and parquet loader
aschonfeld added a commit that referenced this issue Aug 13, 2020
@aschonfeld
1.13.0
b148a76 
* #231: "Lock Zoom" button on 3D Scatter & Surface charts for locking camera on animations
* global & instance-level flag to turn off cell editing
* added the ability to upload CSVs
* upgraded prismjs
* #234: update to line animations so that you can lock axes and highlight last point
* #233: add candlestick charts
* #241: total counts vs. count (non-nan) in describe
* #240: force convert to float
* #239: converting mixed columns
* #237: updated "Pivot" reshaper to always using pivot_table
* #236: "inplace" & "drop_index" parameters for memory optimization and parquet loader
aschonfeld added a commit that referenced this issue Aug 13, 2020
@aschonfeld
1.13.0
46cdf97 
* #231: "Lock Zoom" button on 3D Scatter & Surface charts for locking camera on animations
* global & instance-level flag to turn off cell editing
* added the ability to upload CSVs
* upgraded prismjs
* #234: update to line animations so that you can lock axes and highlight last point
* #233: add candlestick charts
* #241: total counts vs. count (non-nan) in describe
* #240: force convert to float
* #239: converting mixed columns
* #237: updated "Pivot" reshaper to always using pivot_table
* #236: "inplace" & "drop_index" parameters for memory optimization and parquet loader
aschonfeld added a commit that referenced this issue Aug 13, 2020
@aschonfeld
1.13.0
dc4fa84 
* #231: "Lock Zoom" button on 3D Scatter & Surface charts for locking camera on animations
* global & instance-level flag to turn off cell editing
* added the ability to upload CSVs
* upgraded prismjs
* #234: update to line animations so that you can lock axes and highlight last point
* #233: add candlestick charts
* #241: total counts vs. count (non-nan) in describe
* #240: force convert to float
* #239: converting mixed columns
* #237: updated "Pivot" reshaper to always using pivot_table
* #236: "inplace" & "drop_index" parameters for memory optimization and parquet loader
@aschonfeld aschonfeld mentioned this issue Aug 13, 2020
Merged
aschonfeld added a commit that referenced this issue Aug 13, 2020
@aschonfeld
1.13.0
a3b4067 
* #231: "Lock Zoom" button on 3D Scatter & Surface charts for locking camera on animations
* global & instance-level flag to turn off cell editing
* added the ability to upload CSVs
* upgraded prismjs
* #234: update to line animations so that you can lock axes and highlight last point
* #233: add candlestick charts
* #241: total counts vs. count (non-nan) in describe
* #240: force convert to float
* #239: converting mixed columns
* #237: updated "Pivot" reshaper to always using pivot_table
* #236: "inplace" & "drop_index" parameters for memory optimization and parquet loader
aschonfeld added a commit that referenced this issue Aug 14, 2020
@aschonfeld
Updates & Bugfixes
74d59b6 
* #231: "Lock Zoom" button on 3D Scatter & Surface charts for locking camera on animations
* global & instance-level flag to turn off cell editing
* added the ability to upload CSVs
* upgraded prismjs
* #234: update to line animations so that you can lock axes and highlight last point
* #233: add candlestick charts
* #241: total counts vs. count (non-nan) in describe
* #240: force convert to float
* #239: converting mixed columns
* #237: updated "Pivot" reshaper to always using pivot_table
* #236: "inplace" & "drop_index" parameters for memory optimization and parquet loader
@aschonfeld
Copy link
Collaborator

@mswastik I've just released version 1.13.0 which includes this change. Let me know how it goes 🤞

@mswastik
Copy link
Contributor Author

Yes its working great, thanks a lot!

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
3 participants
@reza1615 @mswastik @aschonfeld