Comcast Telecom Consumer Complaints

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. The existing database will serve as a repository of public customer complaints filed against Comcast. It will help to pin down what is wrong with Comcast's customer service. Data Dictionary • 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 Analysis Task : • Which complaint types are maximum i.e., around internet, network issues, or across any other domains. • WHICH STATE HAS THE MAXIMUM COMPLAINTS • WHICH STATE HAS THE HIGHEST PERCENTAGE OF UNRESOLVED COMPLAINTS

• PROVIDE THE PERCENTAGE OF COMPLAINTS RESOLVED TILL DATE, WHICH WERE RECEIVED THROUGH THE INTERNET AND CUSTOMER CARE CALLS