prajaktawaghmare13/electricity-bill-analysis ? reverse-engineered prompt

Build me a simple electricity bill analysis project that takes monthly data like month, city, units consumed, tariff rate, and electricity bill, then helps me understand spending patterns and usage trends.

I want the raw data cleaned and checked in Excel first, then analyzed in Python in a notebook with clear charts and a few useful insights. Please show monthly averages for usage and bills, and the relationship between units consumed and the final bill. I also want a basic prediction model that can estimate the electricity bill from units consumed, plus a simple clustering step to group customers by similar usage and billing behavior.

Make the notebook easy to follow, with readable charts, short explanations, and results that a non expert can understand. If you need current guidance for the best library usage, feel free to look up the latest docs online.