How Much Does Your State Complain?
This visualization communicates how frequently residents of each state filed consumer complaints in 2015. First and foremost, I cleaned the data and sorted it according to state. Once that was done, I was able to calculate total counts for each state from the individual complaint records. Those counts were then paired with the states population values and ultimately used to calculate our key metric: Consumer Complaints per Resident (%).
- Language: Python
- Environment: Tableau, Jupyter Notebook
- Date Completed: July 2016
- Techniques Used: Data Cleaning
- Data Source: Consumer Complaint Database & 2015 Census Survey