adamerose / PandasGUI

A GUI for Pandas DataFrames
MIT No Attribution
3.18k stars 232 forks source link

Pivot Values only accepting single column #216

Open JonMed90 opened 1 year ago

JonMed90 commented 1 year ago

PLEASE FILL OUT THE TEMPLATE

Describe the bug
when using Pivot under Reshaper, I am unable to drag and drop two columns into values section. Only way i am able to get the view i am looking for is by going to kwargs and creating a list of the two fields i want to sum by

For example my table includes product line, item number, revenue, and units. I want to summarize this by product line

Environment OS: (eg. Windows 10) Python: (eg. 3.10.7) IDE: (eg. VS)

Package versions
TO GET ALL RELEVANT PACKAGE VERSIONS, RUN THIS COMMAND IN BASH AND PASTE THE OUTPUT pip freeze | grep -i "pyqt|pandasgui|plotly|ipython|jupyter|notebook"

EXAMPLE OUTPUT

anyio==3.6.2
appdirs==1.4.4
argon2-cffi==21.3.0
argon2-cffi-bindings==21.2.0
astor==0.8.1
asttokens==2.0.8
attrs==22.1.0
backcall==0.2.0
beautifulsoup4==4.11.1
bleach==5.0.1
certifi==2022.9.24
cffi==1.15.1
charset-normalizer==2.1.1
clr-loader==0.1.7
colorama==0.4.5
contourpy==1.0.5
coverage==6.5.0
cryptography==38.0.1
cycler==0.11.0
debugpy==1.6.3
decorator==5.1.1
defusedxml==0.7.1
easygui==0.98.3
entrypoints==0.4
et-xmlfile==1.1.0
exceptiongroup==1.0.4
executing==1.1.0
fastjsonschema==2.16.2
fonttools==4.37.4
greenlet==1.1.3
htmlmin==0.1.12
idna==3.4
ImageHash==4.3.1
iniconfig==1.1.1
install==1.3.5
ipykernel==6.16.0
ipython==8.5.0
ipython-genutils==0.2.0
ipywidgets==8.0.2
jedi==0.18.1
Jinja2==3.1.2
joblib==1.1.1
jsonschema==4.17.0
jupyter-core==4.11.1
jupyter-server==1.23.3
jupyter_client==7.3.5
jupyterlab-pygments==0.2.2
jupyterlab-widgets==3.0.3
kiwisolver==1.4.4
MarkupSafe==2.1.1
matplotlib==3.5.3
matplotlib-inline==0.1.6
missingno==0.5.1
mistune==2.0.4
msal==1.20.0
multimethod==1.8
nbclassic==0.4.8
nbclient==0.7.0
nbconvert==7.2.5
nbformat==5.7.0
nest-asyncio==1.5.5
networkx==2.8.7
notebook==6.5.2
notebook_shim==0.2.2
numpy==1.23.3
Office365-REST-Python-Client==2.3.14
openpyxl==3.0.10
packaging==21.3
pandas==1.4.4
pandas-profiling==3.3.0
pandasgui==0.2.13
pandocfilters==1.5.0
parso==0.8.3
patsy==0.5.3
phik==0.12.2
pickleshare==0.7.5
Pillow==9.2.0
pivottablejs==0.9.0
plotly==5.11.0
pluggy==1.0.0
prometheus-client==0.15.0
prompt-toolkit==3.0.31
psutil==5.9.2
pure-eval==0.2.2
pyarrow==10.0.0
pycparser==2.21
pydantic==1.9.2
Pygments==2.13.0
PyJWT==2.5.0
pynput==1.7.6
pyodbc==4.0.34
pyparsing==3.0.9
PyQt5==5.15.7
PyQt5-Qt5==5.15.2
PyQt5-sip==12.11.0
PyQtWebEngine==5.15.6
PyQtWebEngine-Qt5==5.15.2
pyrsistent==0.19.2
pytest==7.2.0
python-dateutil==2.8.2
python-magic==0.4.6
python-tabular==0.1.2
pythonnet==3.0.0a2
pytz==2022.2.1
PyWavelets==1.4.1
pywin32==304
pywinpty==2.0.9
PyYAML==6.0
pyzmq==24.0.1
qgrid==1.3.1
qtstylish==0.1.5
requests==2.28.1
scipy==1.9.2
seaborn==0.11.2
Send2Trash==1.8.0
six==1.16.0
sniffio==1.3.0
soupsieve==2.3.2.post1
SQLAlchemy==1.4.41
stack-data==0.5.1
statsmodels==0.13.2
tangled-up-in-unicode==0.2.0
tenacity==8.1.0
terminado==0.17.0
tinycss2==1.2.1
tomli==2.0.1
tornado==6.2
tqdm==4.64.1
traitlets==5.4.0
types-cryptography==3.3.23
typing_extensions==4.4.0
urllib3==1.26.12
visions==0.7.5
wcwidth==0.2.5
webencodings==0.5.1
websocket-client==1.4.2
widgetsnbextension==4.0.3
wordcloud==1.8.2.2
XlsxWriter==3.0.3
xmltodict==0.13.0