Python Programming Lab Part B

The document contains various programming tasks in Python, including creating classes for Employee and BankAccount, implementing a GUI for compound interest calculation and a simple calculator, and performing database operations with SQLite for student and employee records. It also includes steps for creating and uploading a CSV file and visualizing data using matplotlib. Each section provides code snippets and explanations for the respective functionalities.

Uploaded by

nambratabhat7

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

3 views45 pages

Python Programming Lab Part B

Uploaded by

nambratabhat7

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

Python Programming

Lab - Part B

AKSHAY P.V
Lecturer
BCA
Udupi College of Professional Studies.
1. Program to create a class Employee with empno, name, depname,
designation, age and salary and perform the following function.

i) Accept details of N employees

ii) Search given employee using empno

iii) display employee details in neat format

class Employee:
def __init__(self, empno, name, depname, designation, age, salary):
[Link] = empno
[Link] = name
[Link] = depname
[Link] = designation
[Link] = age
[Link] = salary

def display(self):
print(f"{[Link]:<10}{[Link]:<15}{[Link]:<15}"
f"{[Link]:<15}{[Link]:<5}{[Link]:<10}")
# i) Accept details of N employees
n = int(input("Enter number of employees: "))
emp_list = []
for i in range(n):
print(f"\nEnter details of employee {i+1}")
empno = int(input("Emp No: "))
name = input("Name: ")
depname = input("Department: ")
designation = input("Designation: ")
age = int(input("Age: "))
salary = float(input("Salary: "))
emp = Employee(empno, name, depname, designation, age, salary)
emp_list.append(emp)
# ii) Search employee using empno
search_no = int(input("\nEnter employee number to search: "))
found = False
print("\nEmployee Details")
print("-" * 70)
print(f"{'EmpNo':<10}{'Name':<15}{'Department':<15}"
f"{'Designation':<15}{'Age':<5}{'Salary':<10}")
print("-" * 70)
for emp in emp_list:
if [Link] == search_no:
[Link]()
found = True
break
if not found:
print("Employee not found")
2. Write a program menu-driven to create a BankAccount class, class
should support the following method for

i) Deposit

ii) Withdraw

iii) GetBalance

Create a subclass SavingsAccount class that behaves just like a

BankAccount, but also has an interest rate and a method that
increases the balance by the appropriate amount of interest.
class BankAccount:
def __init__(self, accno, name, balance=0):
[Link] = accno
[Link] = name
[Link] = balance
# Deposit method
def deposit(self, amount):
[Link] += amount
print("Amount deposited successfully.")
# Withdraw method
def withdraw(self, amount):
if amount > [Link]:
print("Insufficient balance.")
else:
[Link] -= amount
print("Amount withdrawn successfully.")
# Get balance method
def getBalance(self):
print("Current Balance:", [Link])
# Subclass
class SavingsAccount(BankAccount):
def __init__(self, accno, name, balance, interest_rate):
super().__init__(accno, name, balance)
self.interest_rate = interest_rate

# Method to add interest

def add_interest(self):
interest = [Link] * self.interest_rate / 100
[Link] += interest
print("Interest added:", interest)
# Main Program (Menu Driven)
accno = int(input("Enter Account Number: "))
name = input("Enter Account Holder Name: ")
balance = float(input("Enter Initial Balance: "))
rate = float(input("Enter Interest Rate (%): "))
account = SavingsAccount(accno, name, balance, rate)
while True:
print("\n--- MENU ---")
print("1. Deposit")
print("2. Withdraw")
print("3. Get Balance")
print("4. Add Interest")
print("5. Exit")
choice = int(input("Enter your choice: "))
if choice == 1:
amt = float(input("Enter amount to deposit: "))
[Link](amt)
elif choice == 2:
amt = float(input("Enter amount to withdraw: "))
[Link](amt)
elif choice == 3:
[Link]()
elif choice == 4:
account.add_interest()
elif choice == 5:
print("Thank you!")
break
else:
print("Invalid choice")
3. Create a GUI to input principal amount, rate of interest and
number of years. Calculate Compound Interest, when button
submit is pressed. Compound interest should be displayed in a
textbox. When clear button is pressed all contents should be
cleared.
import tkinter as tk
# Function to calculate compound interest
def calculate_ci():
p = float(entry_principal.get())
r = float(entry_rate.get())
t = float(entry_years.get())
ci = p * ((1 + r/100) ** t) - p

textbox_result.delete(0, [Link])
textbox_result.insert(0, str(round(ci,2)))
# Function to clear all fields
def clear_all():
entry_principal.delete(0, [Link])
entry_rate.delete(0, [Link])
entry_years.delete(0, [Link])
textbox_result.delete(0, [Link])

# Create window
window = [Link]()
[Link]("Compound Interest Calculator")
[Link]("350x250")
# Labels
[Link](window, text="Principal Amount").pack()
entry_principal = [Link](window)
entry_principal.pack()

[Link](window, text="Rate of Interest (%)").pack()

entry_rate = [Link](window)
entry_rate.pack()

[Link](window, text="Number of Years").pack()

entry_years = [Link](window)
entry_years.pack()
[Link](window, text="Compound Interest").pack()
textbox_result = [Link](window)
textbox_result.pack()

# Buttons
submit_btn = [Link](window, text="Submit", command=calculate_ci)
submit_btn.pack(pady=5)
clear_btn = [Link](window, text="Clear", command=clear_all)
clear_btn.pack()

# Run the GUI

[Link]()
4. Write a GUI program to implement simple calculator?
import tkinter as tk

# Function for addition

def add():

n1 = float([Link]())

n2 = float([Link]())

result = n1 + n2