- About The Project
- Objective
- Data Dictionary
- Analysis
- Summary
- Author
- Contributing
- Support
- License
- Acknowledgements
Comcast is an American global telecommunication company. The firm has been providing terrible customer service. They continue to fall short despite repeated promises to improve. Only last month (October 2016) the authority fined them a $2.3 million, after receiving over 1000 consumer complaints.
A project is to make a simple Exploratory Data Analysis to find an insight Comcast is an American global telecommunication company.
The existing database will serve as a repository of public customer complaints filed against Comcast.
- Ticket #: Ticket number assigned to each complaint
- Customer Complaint: Description of complaint
- Date: Date of complaint
- Time: Time of complaint
- Received Via: Mode of communication of the complaint
- City: Customer city
- State: Customer state
- Zipcode: Customer zip
- Status: Status of complaint
- Filing on behalf of someone
A trend chart for the number of complaints at monthly granularity levels.
A trend chart for the number of complaints at daily granularity levels.
The most complaint types like around internet, network issues, or across any other domains.
Topic modeling to find the most frequently discussed issues in the customer complaints.
-
There was total of 2224 Tickets from which 77% are closed and there are still 23% open tickets.
-
The highest ticket was recorded in July 2015, generally there was a high ticket recorded form April to July.
-
Most of the issue are related to Internet Speed, Data, Service and Billings.
-
Georgia has high number of ticket and Iowa has very Low ticket.
👤 SABOYE
Contributions, issues and feature requests are welcome!
Feel free to check issues page.
Give a ⭐️ if this project helped you!
Copyright © 2021 saboye.
This project is MIT licensed.