Issues with duplication. Im using Pandas as well. I have database with cities and states but i do have duplication with states. Instead of 48 states ( excluding Alaska and Hawaii ) it shows 64 total states. Using csv file.
Also bar charts shows days and months randomly instead of Monday, Tuesday etc. and same with months.
- Streamlit version: (get it with
$ streamlit version)
- Python version: (get it with
$ python --version)
- Using Conda? PipEnv? PyEnv? Pex?
- OS version:
- Browser version:
OS: Arch Linux
Streamlit version 1.26.0
Python 3.11 with virtual environment
System runs localy.
To remove duplicates from a Pandas DataFrame, you can use the
drop_duplicates() method and for the bar chart thing, check if the data in the csv is in the required format
Going to double check again i might missed something.
P.S i forgot to mention - that some duplicates contains info - so lets say i have 2 x IL and one IL contains 6 rows and other IL contains 10 rows ( not exact count but just to make sense )
P.s. where should i add drop_duplicates( ?
Im new to all this awesomnes
Duplication are still here but have not entered drop_duplicates. Im using LIbreOffice Calc for my file and i formated cells to TEXT and checked each row and all looks good… gonna do drop_duplicates to see the result.
Thank You. Sorted. I thought i fixed white spaces but turns out i was wrong, but now its all done.
Figured out day and month order as its alphabetically , now i know what to do to fix it.