1
ABOUT PYTHON
PYTHON
Python is a high-level, interpreted, and general-purpose programming language developed by Guido van
Rossum. It is known for its simple syntax and easy readability, which makes it suitable for beginners as
well as professionals. Python supports multiple programming paradigms such as procedural, object-
oriented, and functional programming.
Python is widely used in various fields including web development, data analysis, artificial intelligence,
machine learning, automation, and scientific computing. It has a large standard library and many
external modules that help programmers perform complex tasks easily. Python is platform-independent,
meaning the same program can run on different operating systems.
Due to its simplicity, flexibility, and powerful features, Python has become one of the most popular
programming languages in the world and is extensively used in education, research, and industry.
1|Page
2
Features of python
--------------------------------
Features of Python
1. Simple and Easy to Learn
Python has a clear and readable syntax, which makes it easy for beginners to learn and write
programs.
2. High-Level Language
Python allows programmers to write programs without worrying about low-level details like
memory management.
3. Interpreted Language
Python executes code line by line, which makes debugging easier.
4. Platform Independent
Python programs can run on different operating systems such as Windows, Linux, and macOS
without any changes.
5. Object-Oriented Programming Support
Python supports object-oriented concepts like classes, objects, inheritance, and polymorphism.
6. Large Standard Library
Python provides a rich library with many built-in modules and functions for file handling,
mathematics, data handling, etc.
7. Free and Open Source
Python is freely available and its source code can be modified and distributed.
8. Dynamic Typing
Variables in Python do not need to be declared with a data type; the interpreter assigns the type
automatically.
9. Extensible and Integrable
Python can be integrated with other languages like C, C++, and Java.
2|Page
3
ELECTRICITY BILL
MANAGEMENT SYSTEM
ELECTRICITY BILL MANAGEMENT SYSTEM (PYTHON PROJECT)
ABOUT THE PROJECT
The Electricity Bill Management System is a Python-based application designed to manage electricity
billing records in a systematic and computerized manner. This project has been developed using the
Python programming language along with the Pandas library for data handling and CSV files for data
storage. The system automates the process of calculating electricity bills, storing consumer records,
updating bill payment status, and retrieving consumer information whenever required.
In the traditional billing system, records are maintained manually, which often leads to errors, data loss,
duplication of entries, and difficulty in searching old records. This project overcomes such problems by
using a digital approach, ensuring accuracy, efficiency, and reliability in electricity bill management.
OBJECTIVES OF THE PROJECT
The main objectives of this project are:
• To automate electricity bill calculation based on units consumed.
• To store consumer details in a structured CSV file.
• To provide an easy way to search, update, and delete consumer records.
• To reduce human errors in bill calculation and record keeping.
• To understand the practical application of Python file handling and data manipulation.
3|Page
4
WORKING OF THE PROJECT
The Electricity Bill Management System works on a menu-driven approach, allowing the user to select
different operations through numbered choices. Each operation is performed using predefined Python
functions.
The project calculates electricity bills according to the following slab rates:
• First 100 units → ₹3 per unit
• Next 100 units → ₹5 per unit
• Units above 200 → ₹7 per unit
• A fixed charge of ₹100 is added to every bill
After calculating the bill, the program stores the consumer ID, name, units consumed, total bill amount,
bill generation date, and payment status in a CSV file.
BENEFITS OF THIS SYSTEM
1. Time Saving
The system reduces the time required to calculate electricity bills manually. With automated
calculations, bills are generated instantly based on units consumed, saving both time and effort.
2. Accuracy and Reliability
Manual calculations are prone to errors, especially when dealing with large records. This project ensures
accurate bill calculation using predefined logic and conditions, thus eliminating calculation mistakes.
3. Easy Data Storage and Retrieval
All consumer records are stored in a CSV file, which acts as a permanent database. Users can easily
retrieve consumer details using search functionality without going through multiple registers or files.
4|Page
5
4. Reduction of Paper Work
The system minimizes paperwork by storing all data digitally. This helps in maintaining a clean and
organized record system and is also environment friendly.
5. User-Friendly Interface
The menu-driven interface makes the system easy to use even for beginners. Users can select options by
entering numbers, making it simple and interactive.
6. Data Security
Unlike paper records that can be lost or damaged, digital records stored in CSV files are more secure and
can be backed up easily.
7. Real-Life Application
This project closely resembles real electricity billing systems used by electricity boards. It gives students
practical exposure to how real-world billing software works.
8. Educational Value
The project helps students apply theoretical knowledge of Python into practical implementation. It
improves logical thinking, problem-solving skills, and understanding of file handling concepts.
Conclusion
The Electricity Bill Management System is beneficial not only for organizations but also for students
learning programming. It is efficient, accurate, easy to use, and reduces dependency on manual systems.
5|Page
6
FEATURES OF THIS PROJECT
Key Features of the Project
1. Add Consumer Bill
The system allows the user to add new consumer details such as consumer ID, name, and units
consumed. The bill is calculated automatically and stored in the CSV file along with the bill date and
payment status.
2. Search Consumer Record
Users can search for a consumer’s bill details by entering the consumer name. This feature helps in quick
retrieval of information.
3. Delete Consumer Record
The system provides the option to delete consumer records using consumer ID. This helps in maintaining
updated and clean data.
4. Show All Bills
This feature displays all electricity bill records stored in the CSV file in a tabular format.
5. Bill Payment Status
The project includes a bill payment feature that allows updating the status from Unpaid to Paid. This
makes it easy to track pending bills.
6. Automatic Date Handling
The bill generation date is automatically recorded using Python’s date module, ensuring accurate record
keeping.
6|Page
7
Learning Outcomes
Through this project, students learn:
• Use of functions in Python
• Conditional statements and loops
• File handling using CSV files
• Data manipulation using Pandas
• Practical problem-solving skills
Future Enhancements
• Adding electricity meter number
• Monthly bill reports
• Graphical user interface (GUI)
• Exporting bills to PDF
7|Page
8
PROGRAME:
import pandas as pd
from datetime import date
# File path
bill_file = r"C:/Users/SAKSHAM/OneDrive/Desktop/SCHOOL PROJECT/[Link]"
# ---------------- FUNCTION DEFINITIONS ----------------
def addconsumer():
cid = int(input("Enter consumer id: "))
name = input("Enter consumer name: ")
units = int(input("Enter units consumed: "))
if units <= 100:
amount = units * 3
elif units <= 200:
amount = (100 * 3) + (units - 100) * 5
else:
amount = (100 * 3) + (100 * 5) + (units - 200) * 7
total_bill = amount + 100
bill_date = [Link]()
status = "Unpaid"
df = pd.read_csv(bill_file)
n = df["consumer_id"].count()
8|Page
9
[Link][n] = [cid, name, units, total_bill, bill_date, status]
df.to_csv(bill_file, index=False)
print("Electricity bill added successfully")
print(df)
def searchconsumer():
name = input("Enter consumer name: ")
df = pd.read_csv(bill_file)
rec = [Link][df["consumer_name"] == name]
if [Link]:
print("No record found")
else:
print("Consumer bill details:")
print(rec)
def deleteconsumer():
cid = int(input("Enter consumer id to delete: "))
df = pd.read_csv(bill_file)
df = [Link](df[df["consumer_id"] == cid].index)
df.to_csv(bill_file, index=False)
print("Consumer record deleted")
print(df)
def showbills():
9|Page
10
df = pd.read_csv(bill_file)
print("All Electricity Bill Records:")
print(df)
def paybill():
cid = int(input("Enter consumer id to pay bill: "))
df = pd.read_csv(bill_file)
if cid in df["consumer_id"].values:
[Link][df["consumer_id"] == cid, "status"] = "Paid"
df.to_csv(bill_file, index=False)
print("Bill paid successfully")
else:
print("Consumer ID not found")
print(df)
# ---------------- MAIN MENU ----------------
while True:
print("\n--- ELECTRICITY BILL MANAGEMENT SYSTEM ---")
print("1. Add Consumer Bill")
print("2. Search Consumer Bill")
print("3. Delete Consumer Record")
print("4. Show All Bills")
print("5. Pay Bill")
print("0. Exit")
10 | P a g e
11
ch = int(input("Enter your choice: "))
if ch == 1:
addconsumer()
elif ch == 2:
searchconsumer()
elif ch == 3:
deleteconsumer()
elif ch == 4:
showbills()
elif ch == 5:
paybill()
elif ch == 0:
print("Thank You")
break
else:
print("Select a valid option")
11 | P a g e
12
OUTPUTS:
1 ) AFTER EXECUTION INTEREFACE OF THE
PROGRAME
2)IF A CONSUMER IS ADDED(OUTPUT)
3) TO SEARCH CONSUMER BILL(OUTPUT)
12 | P a g e
13
4)WHEN A CONSUMERIS DELETED (OUTPUT)
5)SHOW ALL BILL (OUTPUT)
6)PAY BILL (OUTPUT)
BILL PAID
13 | P a g e