- Comcast is an American global telecommunication company. The firm had been providing terrible customer service. Performed Exploratory Data Analysis to pin down what was wrong with Comcast's customer service.
- Provided a trend chart for the number of complaints at monthly and daily granularity levels.
- Provided a table with the frequency of complaint types.
- Created a new categorical variable with value as Open and Closed. Open & Pending is categorized as Open and Closed & Solved is to be categorized as Closed.
- Provided state wise status of complaints in a stacked bar chart. Used the categorized variable from the above tasks. Provided insights on:
- state that has the maximum complaints
- state that has the highest percentage of unresolved complaints
- Provided the percentage of complaints resolved till date, which were received through the Internet and customer care calls.