CMWSSB Complaint Analytics

Street	Depot	Complaints	People
Venkatarangam Pillai Street	DEP 116	4	4
Dr. Besant Road	DEP 116	3	3
Sunguwar Street	DEP 116	3	3
Nagoji Street	DEP 116	2	1
Quide - Millath Salai	DEP 116	2	1
Raja Hanumandha Lala Street	DEP 116	2	1
Singarachari Street	DEP 116	2	2
Aarimuthu Mesthri Street	DEP 116	1	1
Arimuthu Achari Street	DEP 116	1	1
Chengalvarayan Mudali Street	DEP 116	1	1
Eswaradass Lala Street	DEP 116	1	1
Ganapathi Mudali Street	DEP 116	1	1

🛠 Sewer Complaints (main block · house block · overflow)

CSV PDF

Street	Depot	Sewer	People
Sivaraman Street	116	40	8
Venkatarangam Pillai Street	116	40	21
Quaide Millath Road (Triplicane Highroad)	116	38	20
Dr. Besant Road	116	36	22
Neeli Veerasamy Chetty 1St Lane	116	25	6
Nagoji Street	116	18	12
Old Fire Wood Street	116	18	5
Thulasinga Perumal Koil Street	116	18	17
Nallathambi Mudali Street	116	16	10
Parthasarathy Street	116	16	4

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

CSV PDF

Street	Depot	Water	People
Dr. Besant Road	116	11	9
Nallathambi Mudali Street	116	11	7
Chengalvarayan Mudali Street	116	7	4
Thulasinga Perumal Koil Street	116	7	4
Sunguwar Street	116	6	4
Sivarajapuram Slum Area	116	5	3
Bharathi Road (Pycrafts Road)	116	4	3
Quaide Millath Road (Triplicane Highroad)	116	3	2
Kamarajar Salai	116	2	2
Muthu Kalathy Street	116	2	2

💧 Water Pollution (pollution complaints)

CSV PDF

Street	Depot	Pollut.	People
Dr. Besant Road	116	10	8
Bandalu Venugopal Naidu Street	116	7	1
Theradi Street (Car Street)	116	7	6
Palani Amman Koil 6Th Street	116	5	4
Muthu Kalathy Street	116	3	1
Old Fire Wood Street	116	2	1
Quaide Millath Road (Triplicane Highroad)	116	2	1
Singarachari Street	116	2	2
Sunguwar Street	116	2	2
Veeraraghava Street (Big Street)	116	2	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
Others	Venkatarangam Pillai Street	116	4	279	93	0.43

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
Others vital	34	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		1	5		6
Tue		2	3	2	7
Wed		3	1	1	5
Thu	1	2	1	2	6
Fri		1		2	3
Sat		1	1		2
Sun	1	2	2		5
Total	2	12	13	7	34

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.