Execution of the Shell script
![](https://projectsbasedlearning.com/wp-content/uploads/2020/12/Execution_of_CustomerComplainAnalysis1.png)
![](https://projectsbasedlearning.com/wp-content/uploads/2020/12/Execution_of_CustomerComplainAnalysis2.png)
Output
![](https://projectsbasedlearning.com/wp-content/uploads/2020/12/Output.png)
Chart view in Excel
1. Get the number of complaints filed for each company. (Complains_by_Company.csv)
![](https://projectsbasedlearning.com/wp-content/uploads/2020/12/Output1.png)
2. Get the number of complaints filed under each product. (Complains_by_Product.csv)
![](https://projectsbasedlearning.com/wp-content/uploads/2020/12/Output2.png)
3. Get the total number of complaints filed from a particular location (Complains_by_Location.csv)
![](https://projectsbasedlearning.com/wp-content/uploads/2020/12/Output3.png)
4. Get the list of company grouped by location which has no timely response (Complains_by_Response_No.csv)
![](https://projectsbasedlearning.com/wp-content/uploads/2020/12/Output4.png)
(Note: To generate the below Chart we need to Use PIVOT Chart option in Order to group data)