PYTHON PROGRAM FOR RETAIL SHOP BILLING

Help us create more useful apps! We've already built a screen recorder(availabe in APPS section), and we're planning even more practical and developer-friendly applications.

Donate Us

⋮

Log Out

EXCEL SHEET for below code

from openpyxl import load_workbook
import pandas as pd

def ADMIN():
    excel_file = 'miniproject.xlsx'
    df = pd.read_excel(excel_file)
    data_dict = df.to_dict(orient='records')
    m = 1 
    for record in data_dict:
        print(f"Serial No. {m} ::: {record}")
        m += 1
    file_path = 'miniproject.xlsx'  
    workbook = load_workbook(file_path)
    sheet = workbook.active
    import math
    i = int(input("Enter The Serial No:"))
    i =  i + 1
    i =  "C" + str(i)
    print("Stock(s) available:", sheet[i].value)
    j = int(input("Stock(s) you have added:"))
    sheet[i] = sheet[i].value + j
    workbook.save(file_path)
    print("=" * 80)
    print("      Stocks  updated successfully!")

def USER():
    excel_file = 'miniproject.xlsx'
    df = pd.read_excel(excel_file)
    data_dict = df.to_dict(orient='records')
    cart = []

    customer_name = input("Enter Customer Name:").capitalize()
    customer_mobile = int(input("Customer's mobile number:"))
    while True:
        product = input("Enter product name (or) done to finish:").upper()
        if product == "DONE":
            break
    
        found = False
        for record in data_dict:
            
            item_name = record['ITEM NAME'].strip().upper()
            
            if item_name == product:
                found = True
                qty = int(input(f"Enter quantity for {product}:"))
                price = record['PRICE (INR)']  
                cart.append((product, price, qty))
                break
        
        if not found:
            print("Item not available")

    print("\n" + "=" * 40)
    print('POKECHAN'.center(40))
    print("=" * 40)
    print(f"Customer Name: {customer_name}")
    print(f"Customer Mobile Number: {customer_mobile}")
    print("-" * 40)
    print(f"{'Product':<15}{'Qty':<10}{'Price':<10}{'Total':<10}")
    print("-" * 40)

    total = 0
    for (product, price, qty) in cart:
        line_total = price * qty
        total += line_total
        print(f"{product:<15}{qty:<10}{price:<10}{line_total:<10}")

    print("-" * 40)
    print(f"{'Total Amount:':>35} ₹{total}")
    print("=" * 40)
    print("Thanks for shopping. visit again!".center(40))
    print("=" * 40)
    
    a = input("Did the customer paid(Y/N):")
    a = a.upper()
    if a == 'Y':
       for product, price, qty in cart:  
           for item in data_dict:  
               if item['ITEM NAME'] == product:
                   item['STOCK AVAILABLE'] -= qty  
                   print(f"Stock updated for {product}. {item['STOCK AVAILABLE']} units remaining.")
    else:
       print("Customer has not paid.")

while True:
     a = int(input("Enter the page to be redirected(1 for ADMIN / 2 for USER): "))
     if a ==1 :
       ADMIN()
       break
     elif a==2 :
       USER()
       break
     else:
       print("INVALID input.")
       continue
    

PYTHON PRACTICAL CODES (R-2021)

Help us create more useful apps! We've already built a screen recorder(availabe in APPS section), and we're planning even more practical and developer-friendly applications.

Donate Us

⋮

Log Out

1.A DEVELOPING FLOWCHART FOR ELECTRICITY BILLING

def calculate_total_cost(units):
    if 0 <= units <= 100:
        total_cost = 0
    elif units <= 200:
        total_cost = (units - 100) * 1.5
    elif units <= 500:
        total_cost = (100 * 0) + (100 * 2) + ((units - 200) * 3)
    else:
        total_cost = (100 * 0) + (100 * 3.5) + (300 * 4.60) + ((units - 500) * 6.60)
    print(f"Total Cost: {total_cost}")

units = int(input("Enter the number of units: "))
calculate_total_cost(units)
    

1. B RETAIL SHOP BILLING

        def calculate_amount(n, fixed_price):
            rate = (n * fixed_price) + n
            if rate >= 500:
                amount = rate + (0.02 * rate)
            else:
                amount = rate
            print(f"Amount: {amount}")

        n = int(input("Enter the number of products: "))
        fixed_price = float(input("Enter the fixed price of each product: "))
        calculate_amount(n, fixed_price)
    

1. C SINE SERIES

        def calculate_series(x, terms):
            n = 1
            t = x
            total_sum = x
            while n <= terms:
                t = (t * (-1) * x * x) / (2 * n * (2 * n + 1))
                total_sum += t
                n += 1
            print(f"Sum: {total_sum}")

        x = float(input("Enter the value of x: "))
        terms = int(input("Enter the number of terms: "))
        calculate_series(x, terms)
    

1. D WEIGHT OF MOTOR BIKE

def calculate_weight():
    mass = float(input("Enter the mass of the motorbike (in kg): "))
    weight = mass * 9.8
    print(f"Weight of the motorbike: {weight} N")

calculate_weight()
    

1. E WEIGHT OF STEEL BAR

def calculate_steel_bar_weight():
    diameter = float(input("Enter the diameter of the steel bar (in mm): "))
    length = float(input("Enter the length of the steel bar (in meters): "))
    weight = (diameter * diameter * length) / 162
    print(f"Weight of the steel bar: {weight} kg")

calculate_steel_bar_weight()
    

1. F COMPUTE ELECTRICAL CURRENT IN THREE PHASE AC CIRCUIT

import math

def calculate_power():
    pf = float(input("Enter the power factor (pf): "))
    V = float(input("Enter the voltage (V): "))
    I = float(input("Enter the current (I): "))
    power = math.sqrt(3) * pf * V * I
    print(f"Power: {power} W")

calculate_power()
    

2. A EXCHANGE THE VALUE OF TWO VARIABLES

a = int(input("Enter first number: "))
b = int(input("Enter second number: "))
print("Before Swapping")
print("a =", a)
print("b =", b)

# Swap the values of a and b
a, b = b, a

print("After Swapping")
print("a =", a)
print("b =", b)
    

2. B CIRCULATE THE VALUES OF N VARIABLES

def circulate(A, N):
    for i in range(1, N+1):
        B = A[i:] + A[:i]
        print("Circulation", i, "=", B)

A = [91, 92, 93, 94, 95]
N = int(input("Enter n: "))
circulate(A, N)
    

2. C DISTANCE BETWEEN TWO POINTS

import math

x1 = int(input("Enter x1: "))
y1 = int(input("Enter y1: "))
x2 = int(input("Enter x2: "))
y2 = int(input("Enter y2: "))

distance = ((x1 - x2)**2 + (y1 - y2)**2)**0.5
print("Distance =", distance)
    

3. A TO DISPLAY ODD SERIES

n = int(input("Enter the value of n: "))

for i in range(1, n+1, 2):
    print(i)
    

3. B NUMBER PATTERN

N = 5

for i in range(1, N + 1):
    for k in range(N, i, -1):
        print(" ", end="")

    for j in range(1, i + 1):
        print(j, end="")

    for j in range(i - 1, 0, -1):
        print(j, end="")

    print("")
    

3. C PYRAMID PATTERN

n = int(input("Enter the number of rows: "))

for i in range(0, n):
    for j in range(0, n - i - 1):
        print(" ", end="")

    for j in range(0, 2 * i + 1):
        print("*", end="")

    print("")
    

4. A OPERATIONS OF LISTS

List_name = ['Brick', 'Cement', 'Wooden frame', 'gravel', 'tiles']

print('positive index- index 0:', List_name[0])
print('Negative indexing index -5:', List_name[-5])
print('items from index 2 to index 4:', List_name[2:5])

print("Before Append:", List_name)
List_name.append('wires')
print("After Append:", List_name)

List_name1 = ['sand', 'glass']
List_name.extend(List_name1)
print("After Extend:", List_name)

List_name[2] = 'ironframe'
print("changing the third item to ironframe:", List_name)

del List_name[0:2]
print('After deleting first two items:', List_name)

List_name.remove('ironframe')
print('After removing ironframe:', List_name)

print("Total Elements in a list:", len(List_name))
    

4. B OPERATIONS OF TUPLE

Tuple_name = ('gear', 'break', 'power steering', 'AC', 'Tyre')

print('positive index- index 0:', Tuple_name[0])
print('Negative indexing index -5:', Tuple_name[-5])
print('items from index 2 to index 4:', Tuple_name[2:5])

print("Before Append:", Tuple_name)
Tuple_name1 = ('wires', 'wiper')
print("After Append:", Tuple_name + Tuple_name1)

Tuple_name1 = Tuple_name * 2
print('After repeating:', Tuple_name1)

print("Total Elements in a tuple:", len(Tuple_name1))
    

5. A OPERATIONS OF SETS AND DICTIONARIES

language1 = {'C', 'C++', 'JAVA'}
language2 = {'VB', 'PYTHON', 'ORACLE', 'JAVA'}

print(language1)
print(language2)

language1.add('SQL')
print(language1)

language1.remove('SQL')
print(language1)

print(language1 | language2)
print(language2.union(language1))

print(language1 & language2)
print(language1.intersection(language2))

print(language1 - language2)
print(language2.difference(language1))

print(language1 ^ language2)
    

5. B OPERATIONS OF SETS AND DICTIONARIES

components = {"Brake": 2, "Tyre": 4, "Steering": 1}

print(components)

x = components.copy()
print(x)

x = components.get("Tyre")
print(x)

x = components.items()
print(x)

components.update({"color": "White"})
print(components)

x = components.pop("Brake")
print(x)

print(components)

x = components.setdefault("Brake", "Tyre")
print(x)

print(components)

x = components.values()
print(x)

y = 1
thisdict = dict.fromkeys(components, y)
print(thisdict)

x = components.keys()
print(x)

components.clear()
print(components)
    

6. A FACTORIAL OF A NUMBER

def fact(n):
    if n == 0:
        return 1
    else:
        x = n * fact(n - 1)
        return x

n = int(input("Enter a value:"))
y = fact(n)
print(y)
    

6. B LARGEST NUMBER IN A LIST

def max(N):
    max_num = N[0]
    for i in N:
        if i > max_num:
            max_num = i
    return max_num

N = [99, 76, 43, 56, 34]
print("Maximum number =", max(N))
    

6. C FIND AREA OF CIRCLE

def RectangleArea():
    l = int(input("Enter l:"))
    b = int(input("Enter b:"))
    A = l * b
    print("Area of rectangle", A)

def SquareArea():
    a = int(input("Enter a:"))
    A = a * a
    print("Area of square", A)

choice = int(input("Enter a choice:"))
if choice == 1:
    RectangleArea()
elif choice == 2:
    SquareArea()
else:
    print("No shape found")
    

7. A TO REVERSE A STRING

word = input("Enter a word:")
rev_word = word[::-1]
print(rev_word)
    

7. B PALINDROME OR NOT

word = input("Enter a word:")
rev_word = word[::-1]
if word == rev_word:
    print("It is a palindrome")
else:
    print("It is not a palindrome")
    

7. C COUNT CHARACTERS IN STRING

word = input("Enter a word:")
letter = input("Enter the character:")
count = 0
for char in word:
    if char == letter:
        count += 1
print("The letter", letter, "appears", count, "times in the word")
    

7. D REPLACE A CHARACTER IN A STRING

word = ("Enter a word: ")
old_char = ("Enter the character you want to replace: ")
new_char = ("Enter the new character: ")
new_str = ("")

for char in word:
    if char == old_char:
        new_str += new_char
    else:
        new_str += char

print(new_str)
    

8. A PANDAS

import pandas as pd

a = []
b = []

d = int(input('Enter the number of employees:'))
for i in range(0, d):
    y = int(input('Enter employee id:'))
    a.append(y)
    x = input('Enter name of employee: ')
    b.append(x)

e = {'Employee_id': a, 'Employee_name': b}
df1 = pd.DataFrame(e, columns=['Employee_id', 'Employee_name'])
print(df1)
    

8. B NUMPY

import numpy as np

a = np.array([[1, 2], [3, 4]])
b = np.array([[4, 3], [2, 1]])

print("Array sum:\n", a + b)
print("Array multiplication:\n", a * b)
print("Matrix multiplication:\n", a.dot(b))
print("Array division:\n", a / b)
    

8. C MATPLOTLIB

import matplotlib.pyplot as plt
from numpy.random import normal

gaussian_numbers = normal(size=1000)

plt.hist(gaussian_numbers, bins=30)
plt.title("Gaussian Histogram")
plt.xlabel("Value")
plt.ylabel("Frequency")
plt.show()
    

8. D SCIPY

from scipy import special
from scipy import linalg
import numpy as np

cb = special.cbrt([27, 64])
print(cb)

a = special.exp10(3)
print(a)

b = special.exp2(3)
print(b)

c = special.sindg(90)
print(c)

d = special.cosdg(45)
print(d)

two_d_array = np.array([[4, 5], [3, 2]])

determinant = linalg.det(two_d_array)
print("Determinant:", determinant)

inverse = linalg.inv(two_d_array)
print("Inverse:\n", inverse)
    

9. A COPY CHARACTERS FROM ONE FILE TO ANOTHER

print("Enter the name of Source file:")
sFile = input()
print("Enter the name of Target file:")
tFile = input()

fileHandle = open(sFile, "r")
texts = fileHandle.readlines()
fileHandle.close()

fileHandle = open(tFile, "w")
for s in texts:
    fileHandle.write(s)

fileHandle.close()

print("\nFile copied successfully!")
    

9. B WORD COUNT

from collections import Counter

def word_count(fname):
    with open(fname, 'r') as f:
        return Counter(f.read().split())

fname = input('Enter the file name: ')

num_words = 0
with open(fname, 'r') as f:
    for line in f:
        words = line.split()
        num_words += len(words)

print("Number of words:", num_words)
print("Number of each word count in the file:\n", word_count(fname))
    

9. C LONGEST WORD

def longest_words(filename):
    with open(filename, 'r') as infile:
        words = infile.read().split()
        max_len = len(max(words, key=len))
    return [word for word in words if len(word) == max_len]

filename = input('Enter the name of file: ')
print(longest_words(filename))
    

10. A DIVIDE BY ZERO ERROR

x = int(input("Enter the value of x = "))
y = int(input("Enter the value of y = "))

try:
    z = x / y
    print("Result =", z)
except ZeroDivisionError:
    print("Divide by zero Error")
    

10. B VOTER'S AGE VALIDITY

def voter():
    try:
        age = int(input("Enter your age: "))
        if age >= 18:
            print("Eligible to vote")
        else:
            print("Not eligible to vote")
    except ValueError:
        print("Age must be a valid number")
    except IOError:
        print("Enter correct value")
    except:
        print("An error occurred")

voter()
    

10. C STUDENT'S MARK RANGE VALIDATION

try:
    print("Enter marks obtained in 5 subjects:")
    S1 = int(input())
    if S1 < 0 or S1 > 100:
        raise ValueError("The value is out of range")
    S2 = int(input())
    if S2 < 0 or S2 > 100:
        raise ValueError("The value is out of range")
    S3 = int(input())
    if S3 < 0 or S3 > 100:
        raise ValueError("The value is out of range")
    S4 = int(input())
    if S4 < 0 or S4 > 100:
        raise ValueError("The value is out of range")
    S5 = int(input())
    if S5 < 0 or S5 > 100:
        raise ValueError("The value is out of range")

finally:
    print("This is always executed")

tot = S1 + S2 + S3 + S4 + S5
avg = tot / 5

if avg >= 91 and avg <= 100:
    print("Your Grade is A")
elif avg >= 81 and avg < 91:
    print("Your Grade is B")
elif avg >= 71 and avg < 81:
    print("Your Grade is C")
elif avg >= 61 and avg < 71:
    print("Your Grade is D")
else:
    print("Your Grade is F")
    

11 STIMULATE ELLIPTICAL ORBIT USING PYGAME

import pygame
import math
import sys

pygame.init()

screen = pygame.display.set_mode((600, 300))
pygame.display.set_caption("Elliptical orbit")

clock = pygame.time.Clock()

xradius = 250
yradius = 100

while True:
    for event in pygame.event.get():
        if event.type == pygame.QUIT:
            sys.exit()

    screen.fill((0, 0, 0))

    pygame.draw.circle(screen, (255, 69, 0), [300, 150], 40)
    pygame.draw.ellipse(screen, (255, 255, 255), [50, 50, 500, 200], 1)

    for degree in range(0, 360, 10):
        x1 = int(math.cos(degree * 2 * math.pi / 360) * xradius) + 300
        y1 = int(math.sin(degree * 2 * math.pi / 360) * yradius) + 150
        pygame.draw.circle(screen, (0, 255, 0), [x1, y1], 20)

    pygame.display.flip()

    for degree in range(0, 360, 1):
        x1 = int(math.cos(degree * 2 * math.pi / 360) * xradius) + 300
        y1 = int(math.sin(degree * 2 * math.pi / 360) * yradius) + 150

        screen.fill((0, 0, 0))
        pygame.draw.circle(screen, (255, 69, 0), [300, 150], 40)
        pygame.draw.ellipse(screen, (255, 255, 255), [50, 50, 500, 200], 1)
        pygame.draw.circle(screen, (0, 255, 0), [x1, y1], 20)

        pygame.display.flip()

        clock.tick(30)
    

12 BOUNCING BALL

import sys, pygame

pygame.init()

size = width, height = 700, 250
speed = [1, 1]
background = 255, 255, 255
screen = pygame.display.set_mode(size)
pygame.display.set_caption("Bouncing ball")

ball = pygame.image.load("ball.jpg")
ballrect = ball.get_rect()

while True:
    pygame.time.delay(2)

    for event in pygame.event.get():
        if event.type == pygame.QUIT:
            sys.exit()

    ballrect = ballrect.move(speed)

    if ballrect.left < 0 or ballrect.right > width:
        speed[0] = -speed[0]

    if ballrect.top < 0 or ballrect.bottom > height:
        speed[1] = -speed[1]

    screen.fill(background)
    screen.blit(ball, ballrect)

    pygame.display.flip()