CMWSSB Complaint Analytics

Street	Depot	Sewer	People
Quaide Millath Road	114	54	29
Bells Road	114	39	12
Bangaru Street	114	36	20
C.n.krishnasamy Lane	114	32	7
Lalmohamed Cross Street	114	28	11
Mayor Chitti Babu Street	114	28	9
Dowlath Khan Street	114	27	9
Fakkir Sahib Street	114	27	15
John Mohammed Street	114	26	9
Mohamed Abdulla 1St Street	114	26	8

🚰 Water Complaints (no supply · short supply · leaks)

CSV PDF

Street	Depot	Water	People
Habibullah Shahib Cross Street	114	19	4
Buchi Babu Street	114	18	6
Asudeenkhan Street	114	12	6
Azizudeen Khan Street	114	8	4
Mohamed Abdulla 1St Street	114	7	4
Bharathi Salai (Pycrafs Road)	114	6	5
Mufthi Amirullah Shahib Street	114	5	2
Quaide Millath Road	114	5	4
Akbar Sahib Street	114	4	2
Kithbath Khan Street	114	3	3

💧 Water Pollution (pollution complaints)

CSV PDF

Street	Depot	Pollut.	People
Mufthi Amirullah Shahib Street	114	16	1
Fakkir Sahib Street	114	13	9
Kithbath Khan Street	114	8	4
John Mohammed Street	114	7	4
Parthasarathy Naidu Street	114	6	2
Subathral Street	114	6	3
Thiruvatteeswaran Sanadhi Street	114	6	3
Mohamed Abdulla 1St Street	114	4	2
Pachaiyappan Street	114	4	2
Arumugappa Street	114	3	2

🔁 Recurrence — how often the same issue comes back (same category · same street)

PDF

Category	Street	Depot	Times	Span (days)	Avg gap (days)	Per month
No issue recurred often enough in this scope.

Avg gap = average days between consecutive complaints of that type on that street. Lower gap / higher “per month” = a faster-recurring, unresolved problem.

🔬 Advanced Analysis

Pareto — the vital few (which categories drive most complaints)

Categories ordered by volume with their cumulative share. The highlighted rows are the smallest set that together account for ~80% of all complaints — fix these first.

Category	Count	Share	Cumulative
Booking Issues vital	1	100%	100%

When complaints arrive (weekday × time of day)

Load pattern across the week — darker cells are busier six-hour windows. Useful for staffing and planning proactive checks before the peak.

	Night	Morning	Afternoon	Evening	Total
Mon					0
Tue			1		1
Wed					0
Thu					0
Fri					0
Sat					0
Sun					0
Total	0	0	1	0	1

Linked problems (category pairs that hit the same streets)

Pairs of issue types that recur together on the same street, ranked by the number of streets where both appear. Strong pairs point to a shared root cause worth fixing in one visit.

Problem A	Problem B	Shared streets
Not enough overlapping complaints in this scope.