Comparison of street lights power usage and cost (02.2014-09.2014)

Based on this dataset, the most expensive lights by month are:

Feb'14

SLCB 0823
3.538 $/kWh
SLCB 0164
2.000 $/kWh
SLCB 0043
1.800 $/kWh
SLCB 0568
1.800 $/kWh
SLCB 0365
1.429 $/kWh

Mar'14

SLCB 1332
2.144 $/kWh
SLCB 0043
2.000 $/kWh
SLCB 1144
2.000 $/kWh
SLCB 0510
1.333 $/kWh
SLCB 0568
1.333 $/kWh

Apr'14

SLCB 1142
2.250 $/kWh
SLCB 0510
1.800 $/kWh
SLCB 1332
1.343 $/kWh
SLCB 0365
1.286 $/kWh
SLCB 0568
1.286 $/kWh

May'14

SLCB 0164
2.000 $/kWh
SLCB 1256
2.000 $/kWh
SLCB 0568
1.500 $/kWh
SLCB 1142
1.500 $/kWh
SLCB 0510
1.333 $/kWh

Jun'14

SLCB 0568
2.000 $/kWh
SLCB 0365
1.000 $/kWh
SLCB 0510
0.750 $/kWh
SLCB 1757
0.700 $/kWh
SLCB 0984
0.559 $/kWh

Jul'14

SLCB 0568
1.800 $/kWh
SLCB 0365
1.125 $/kWh
SLCB 1332
0.912 $/kWh
SLCB 0510
0.900 $/kWh
SLCB 0515
0.900 $/kWh

Aug'14

SLCB 0568
2.000 $/kWh
SLCB 0365
1.286 $/kWh
SLCB 1332
1.121 $/kWh
SLCB 0510
1.000 $/kWh
SLCB 0984
0.691 $/kWh

Sep'14

SLCB 0568
2.000 $/kWh
SLCB 0616
2.000 $/kWh
SLCB 0365
1.286 $/kWh
SLCB 0510
0.900 $/kWh
SLCB 1726
0.333 $/kWh

With the exception of February 2014, SLCB 0510 was consistenly among the top 5 most consuming lights each month, while SLCB 0568 was the most expensive illuminating light from June to September.

If we try to cluster the lights into different categories, based on their energy consumption, and we choose to have twelve clusters, then 547 lights will have cluster 0 assigned, 189 lights will have cluster 3, and 132 lights will be in cluster 11. Since the clusters with fewer lights may be more informative, we may view the rest. Lights, which belong to rare clusters may be signaling that something is wrong.

District 9 Yard
8
Irr J Kelly Br
8
SLCB 0020
8
SLCB 0034
10
SLCB 0043
2
SLCB 0170
8
SLCB 0197
8
SLCB 0283
8
SLCB 0309
10
SLCB 0365
1
SLCB 0500
8
SLCB 0515
9
SLCB 0565
8
SLCB 0568
6
SLCB 0811
8
SLCB 0822
8
SLCB 0823
5
SLCB 0984
7
SLCB 1044
8
SLCB 1142
4
SLCB 1431
8
SLCB 1509
8
SLCB 1704
8
SLCB 1726
8
TRASHCOMP
8