The streamlit-dashboards from 0xjimm

streamlit-dashboards's People

Contributors

Stargazers

Watchers

Forkers

bd21

streamlit-dashboards's Issues

Pivot table failing due to duplicate TX_IDs

Knowhere Art dashboard is failing with the following error. Looks like a third of the transactions from the api are duplicates.

ValueError: This app has encountered an error. The original error message is redacted to prevent data leaks. Full error details have been recorded in the logs.
Traceback:
File "/home/appuser/venv/lib/python3.7/site-packages/streamlit/script_runner.py", line 354, in _run_script
    exec(code, module.__dict__)
File "/app/streamlit-dashboards/knowhere.py", line 31, in <module>
    index="TX_ID", columns="EVENT_TYPE", values=["EVENT_ATTRIBUTES", "BLOCK_TIMESTAMP"]
File "/home/appuser/venv/lib/python3.7/site-packages/pandas/core/frame.py", line 7788, in pivot
    return pivot(self, index=index, columns=columns, values=values)
File "/home/appuser/venv/lib/python3.7/site-packages/pandas/core/reshape/pivot.py", line 517, in pivot
    return indexed.unstack(columns_listlike)
File "/home/appuser/venv/lib/python3.7/site-packages/pandas/core/frame.py", line 8320, in unstack
    result = unstack(self, level, fill_value)
File "/home/appuser/venv/lib/python3.7/site-packages/pandas/core/reshape/reshape.py", line 447, in unstack
    return _unstack_frame(obj, level, fill_value=fill_value)
File "/home/appuser/venv/lib/python3.7/site-packages/pandas/core/reshape/reshape.py", line 470, in _unstack_frame
    unstacker = _Unstacker(obj.index, level=level)
File "/home/appuser/venv/lib/python3.7/site-packages/pandas/core/reshape/reshape.py", line 133, in __init__
    self._make_selectors()
File "/home/appuser/venv/lib/python3.7/site-packages/pandas/core/reshape/reshape.py", line 185, in _make_selectors
    raise ValueError("Index contains duplicate entries, cannot reshape")```

Recommend Projects