adamerose / adamerose/PandasGUI

Pivot Values only accepting single column

Abierto
#216 0 comentarios 0 reacciones 0 asignados Ver en GitHub
bug
Lenguaje dominante
Python
Estrellas
3.3k
Forks
239
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

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
```

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.