adamerose / adamerose/PandasGUI

Pivot Values only accepting single column

Aberta
#216 0 comentários 0 reações 0 responsáveis Ver no GitHub
bug
Linguagem predominante
Python
Estrelas
3.3k
Forks
239
Métricas de merge de PRs
Nenhum PR com merge em 30d

Descrição

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

Guia de contribuição

Nenhum guia de contribuição indexado para este repositório

Avaliação

Esta issue ainda não foi avaliada.

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.