IP Project

ARALUMMOODU, TVPM.
PROJECT
IN
INFORMATICS PRACTICES (065)

Academic Year 2020-21
ELECTRONICS COMPANY
NAME : …………………………………………………………………………………….
CLASS : …………………………………… ROLL.NO: ……………………………….
REG. NO: : ………………………………….. ACADEMIC YEAR: ……………………

ARALUMMOODU, TVPM.
BONAFIDE CERTIFICATE
This is to certify that this project report entitled

…………………...……………………………………is a bonafide
record of the project work done by ……………………………………
of class ….…… Reg.No …..….…… in the academic year 20… - 20…
The project has been submitted in partial fulfillment of AISSCE for
practical held at Sree Vivekananda Memorial Public School, Aralummoodu
on …………..
Date:…………………………… Teacher in Charge
Internal Examiner External Examiner
PRINCIPAL
ACKNOWLEDGEMENT
I solemnly take the opportunity to thank all the helping hands who
made me to complete this project. First of all I thank the Almighty for keeping me
hale and healthy in order to successfully complete my work.
I wish to express my sincere gratitude to Mr. Jayasankar Prasad,

Principal of Sree Vivekananda Memorial Public School, for permitting me to carry
out the project and for the facilities he has provided for the fulfillment of this
project work.
I am greatly indebted to Mrs. Sudha B V, Teacher in Informatics

Practices who gave me immense support and guidance throughout the completion
of this project.
Last but not the least, I express my heartiest thanks to my lovable parents
and friends for their prayers, suggestions and encouragement for the successful
completion of the project.
Sincerely,
CONTENTS
$ INTRODUCTION
$ HARDWARE & SOFTWARE REQUIREMENTS
$ SOURCE CODE
$ SAMPLE OUTPUT
$ CONCLUSION
$ BIBLIOGRAPHY
INTRODUCTION
Python is an interpreted, high-level, general-purpose
programming language. Created by Guido van Rossum
and first released in 1991,Python’s design philosophy
emphasizes code readability with its notable use of
significant whitespace. Its language constructs and object-
oriented approach aim to help programmers write clear,
logical code for small and large scale objects.
Electronics Company
This project is done using the python programming
language. This is a project containing a python program of
a company named ‘A.C.E Electronics'. It includes details
about the products, departments and the whole company
. The program can be modified and can be used for other
companies. The work interface is very simple and suits any
type of users. To run this program you have to check the
requirements mentioned inside.
Hardware & Software Requirements
RAM : 2 GB (Minimum)
4 GB (Recommended)
Operating System : 32 bit x86(Minimum)
64 bit x64 (Recommended)
Hard Disk : Minimum 250 MB Free memory
Processor. : Dual Core 2.80 GHz or greater
Screen Resolution : 1366 x 768 (Optimal)
Graphics Card : Minimum 64 MB
Platform : Windows 7/8/10 with SP1
Python Version : Python 3.0 or Greater

SOURCE CODE
import pandas as pd
import numpy as n
import matplotlib.pyplot as plt
srs1=pd.Series({"S.No":"Products",'1':"SmartPhones",'2':"Lap
tops",'3':"TV"})
dict1={"S.No":[1,2,3,4,5,6,7,8,9,10,11,12],"MODEL_NAME":
["Ace X1","Ace X1 Pro","Ace X2",
"Ace X2 Pro","Ace X3","Ace Y1",
"Ace Y1 Pro","Ace Y2","Ace Y2+",
"Ace Y2 Ultra","Ace Note1",
"Ace Note1 Max"],"
RAM&INT.STORAGE":["3GB,32GB","4GB,64GB","4GB,64GB","6GB,128G
B","6GB,64GB","6GB,128GB","8GB,256GB","6GB,128GB","8GB,256GB
","12GB,512GB","6GB,128GB","8GB,256GB"],"PRICE":[8500,12000,
14000,16500,17000,18900,24700,20500,28600,43250,35200,40900]
}
df1=pd.DataFrame(dict1)
df1.set_index("S.No",inplace=True)
dict2={"S.No":[1,2,3,4,5,6,7,8],"MODEL_NAME":["Ace Infinite
R15","Ace Infinite H450",
"Ace Infinite T800","Ace Infinite Y50","Ace Infinite
R65","Ace Infinite H120G",
"Ace Infinite T400R","Ace Infinite Y70"],"
RAM&INT.STORAGE":["4GB,1TB SSD","12GB,2TB HDD",
"8GB,2TB SSD","4GB,512GB SSD","8GB,2TB
HDD","12GB,2TB HDD","8GB,2TB HDD","8GB,512GB HDD"],
"Processor Type":["Intel Core i3 3rd
Gen(1.3Ghz)","AMD Ryzen 5-3600X(3.8Ghz)",
"Intel Core i5 7th Gen(2.2Ghz)","Intel Core i5 5th
Gen(2.3Ghz}","Intel Core i7 5th Gen(2.5Ghz)",
"AMD Ryzen 9-3900X(3.7Ghz)","Intel Core i7 7th
Gen(2.5Ghz)","Intel Core i7 8th Gen(2.3Ghz)"],
"GPU_TYPE":["NVIDIA GTX 4000","AMD Radeon
RX5700","NVIDIA Quadro RTX p2000","NVIDIA Quadro RTX 4000",
"NVIDIA GTX 6000","AMD Radeon 5600XT","NVIDIA Quadro
p4000","NVIDIA Quadro RTX 8000"],"PRICE":[34200,
65400,40800,32200,46800,85700,43600,54900]}
dict3={"S.No":[1,2,3],"MODEL_NAME":["Ace-32X700(2020)","Ace-
55X750(2020)","Ace-77X800(2020)"],
"DISPLAY_SIZE":[32,55,77],"DISPLAY_TYPE":["UHD
OLED","UHD OLED","UHD OLED"],"PRICE":[15990,
45990,330990]}
df4=pd.DataFrame({"D.code":['1','2','3','4','5','6','7'],"De
partment":["Administration",
"Purchase Department","Production Department","Research
and Development","Sales(Marketing & Ads)",
"Human Resource","Accounting &
Finance"],"Manager":["Mohan Pratap","Varun S","Ranjith
RJ","Sherin US",
"Govind D","Anjali P","Prasad
NP"],"Salary":['180000','120000','175000','150000','165000',
'145000',
'160000'],"No.of
Employees/yers":[5,2365,5872,467,2467,73,55]})
df4.set_index("D.code",inplace=True)
x7="c"
while x7=="c":
print("\nA.C.E Electronics Private Lmtd"
"\n------------------------------"
"\nDetails"
"\n-------"
"\nTitles:-"
"\n1.Products"
"\n2.Departments"
"\n3.About"
"\nPassword:'p'")
a=input("\nEnter the number corresponding to the title
you want to view : ")
if a=="1":
print("\n",srs1)
b=input("\nTo edit the products' list,Enter 'e'
or\n"
"To display the products' details,Enter 'd'
or\n"
"To go to main menu,Enter 'm' or\n"
"To exit the program,Enter 'x' :")
if b=='d':
aa=input("\nTo display details of
smartphones,Enter 's' or\n"
"To display details of laptops,Enter
'l' or\n"
"To display details of
televisions,Enter 't' : ")
if aa=="s":
print("\nSmartPhones"
"\n-----------")
print("\n",df1)
bb=input("\nTo display graph,Enter 'g' or\n"
"To exit the program,Enter 'e' : ")
if bb=="g":
df1.plot.bar(color=["r"])
plt.title("Price Comparison of
SmartPhones")
plt.xlabel=["X1","X1 Pro","X2","X2
Pro","X3","Y1","Y1 Pro","Y2","Y2+","Y2 Ultra","Note1","Note1
Max"]
plt.show()
x7=input("\nType as 'c' to continue or
\n"
"Type'e' to exit : ")
if x7=="e":
print("\nPROGRAM STOPPED")
elif x7=="c":
x7="c"
else:
print("\nINVALID INPUT")
x7="c"
elif bb=="m":
x7="c"
elif bb=="e":
break
else:
x7="c"
elif aa=="l":
print("\nLaptops"
"\n-------")
print("\n",df2)
cc=input("\nTo display graph,Enter 'g' or\n"
if cc=="g":
labels=["R15","H450","T800","Y50","R65","H120G","T400R","Y70
"]
size=[342,654,408,322,468,857,436,549]
plt.pie(size,labels=labels)
plt.title("Price Comparison of Laptops")
plt.show()
\n"
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
elif cc=="m":
x7="c"
elif cc=="e":
break
else:
elif aa=="t":
print("\nSmart TVs"
"\n---------")
print("\n",df3)
dd=input("\nTo display graph,Enter 'g' or\n"
if dd=="g":
df3.plot.line()
plt.title("Price Comparison of Smart
TVs")
plt.show()
\n"
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
elif dd=="m":
x7="c"
elif dd=="e":
break
else:
elif b=="e":
d=input("\nTo add a new product,Enter 'a' or\n"
"To remove a product,Enter 'r' : ")
if d=="a":
e=input("\nEnter S.no : ")
f=input("Enter the new product name here :
")
srs1=srs1.append(pd.Series(f,index=[e]))
print("\n",srs1)
print("\nPRODUCT ADDED!")
x7=input("\nType as 'c' to continue or \n"
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
elif d=="r":
g=input("\nEnter the S.no of the product to
remove : ")
if g in (srs1.index):
srs1=srs1.drop(g)
print("\n",srs1)
print("\nPRODUCT REMOVED!")
\n"
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
else:
print("\nPRODUCT NAME NOT FOUND")
else:
elif b=="m":
x7="c"
elif b=="x":
break
else:
elif a=="2":
print("\n",df4)
h=input("\nTo edit, Enter password or\n"
"To continue,Enter 'c' or\n"
if h=="p":
i=input("\nTo change any department's
manager,Type as 'm' or \n"
"To change any manager's salary,Type as
's' : \n"
"To change No.of employees/yers in any
department,Type as 'n' : ")
if i=="m":
j=input("\nEnter D.code of manager(row
number) : ")
k=input("Enter the new manager's name : ")
df4.at[j,"Managers"]=k
print("\n",df4)
print("\nMANAGER OF A DEPT UPDATED!")
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
elif i=="s":
l=input("\nEnter D.code of manager(row
number) : ")
m=input("Enter the new salary amount : ")
df4.at[l,"Salary"]=m
print("\n",df4)
print("\nSALARY OF A MANAGER UPDATED!")
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
elif i=="n":
n=input("\nEnter the D.code of
departments(row number) : ")
o=input("Enter the number of
employees/employers : ")
df4.at[n,"No.of Employees/Employers"]=o
print("\n",df4)
print("\nNO.OF EMPLOYEES/YERS UPDATED!")
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
else:
elif h=="c":
x7="c"
elif h=="e":
break
else:
print("\nINCORRECT PASSWORD/INVALID INPUT")
elif a=="3":
print("\nAbout the Company\n"
"-----------------\n"
"A.C.E Electronics Private Lmtd company was
incorporated in 1990."
"This is a private owned company started by
Dr.Amartya Sen,"
"incorporated in India.The company's
manufacturing units are "
"spread over around 7 countries.Started with
manufacture of "
"only Televisions and now the company is so
popular for its "
"smartphones and laptops.There are over 11000
of employees "
"working and most of the work are done by
machines.The company "
"produces 35 million smarphones,10 million
laptops,7 million "
"televisions in a year.It is aiming to provide
quality products "
"with more and more upcoming features and at a
low price.")
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
else:
print("\nNO DETAILS FOUND")
if x7=="e":
elif x7=="c":
x7="c"
else:
x7="c"
SAMPLE OUTPUT
A.C.E Electronics Private Lmtd
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
Enter the number corresponding to the title you want to view : 1
S.No Products
1 SmartPhones
2 Laptops
3 TV
dtype: object
To edit the products' list,Enter 'e' or
To display the products' details,Enter 'd' or
To go to main menu,Enter 'm' or
To exit the program,Enter 'x' : e
To add a new product,Enter 'a' or
To remove a product,Enter 'r' : a

Enter S.no : 4
Enter the new product name here : Smart Watch
S.No Products
1 SmartPhones
2 Laptops
3 TV
4 Smart Watch
dtype: object
PRODUCT ADDED!
Type as 'c' to continue or
Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
S.No Products
1 SmartPhones
2 Laptops
3 TV
4 Smart Watch
dtype: object
To exit the program,Enter 'x' : e
To add a new product,Enter 'a' or
To remove a product,Enter 'r' : r
Enter the S.no of the product to remove : 3
S.No Products
1 SmartPhones
2 Laptops
4 Smart Watch
dtype: object
PRODUCT REMOVED!
Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
S.No Products
1 SmartPhones
2 Laptops
4 Smart Watch
dtype: object
To exit the program,Enter 'x' : d
To display details of smartphones,Enter 's' or
To display details of laptops,Enter 'l' or
To display details of televisions,Enter 't' : s
SmartPhones
-----------
MODEL_NAME RAM&INT.STORAGE PRICE
S.No
1 Ace X1 3GB,32GB 8500

2 Ace X1 Pro 4GB,64GB 12000
3 Ace X2 4GB,64GB 14000
4 Ace X2 Pro 6GB,128GB 16500
5 Ace X3 6GB,64GB 17000
6 Ace Y1 6GB,128GB 18900
7 Ace Y1 Pro 8GB,256GB 24700
8 Ace Y2 6GB,128GB 20500
9 Ace Y2+ 8GB,256GB 28600
10 Ace Y2 Ultra 12GB,512GB 43250
11 Ace Note1 6GB,128GB 35200
12 Ace Note1 Max 8GB,256GB 40900
To display graph,Enter 'g' or
To exit the program,Enter 'e' : g

Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
S.No Products
1 SmartPhones
2 Laptops
4 Smart Watch
dtype: object
To display details of televisions,Enter 't' : l

Laptops
-------
MODEL_NAME RAM&INT.STORAGE ... GPU_TYPE PRICE
S.No ...
1 Ace Infinite R15 4GB,1TB SSD ... NVIDIA GTX 4000 34200
2 Ace Infinite H450 12GB,2TB HDD ... AMD Radeon RX5700 65400
3 Ace Infinite T800 8GB,2TB SSD ... NVIDIA Quadro RTX p2000 40800
4 Ace Infinite Y50 4GB,512GB SSD ... NVIDIA Quadro RTX 4000 32200
5 Ace Infinite R65 8GB,2TB HDD ... NVIDIA GTX 6000 46800
6 Ace Infinite H120G 12GB,2TB HDD ... AMD Radeon 5600XT 85700
7 Ace Infinite T400R 8GB,2TB HDD ... NVIDIA Quadro p4000 43600
8 Ace Infinite Y70 8GB,512GB HDD ... NVIDIA Quadro RTX 8000 54900
[8 rows x 5 columns]

Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
S.No Products
1 SmartPhones
2 Laptops
4 Smart Watch
dtype: object
To display details of televisions,Enter 't' : t

Smart TVs
---------
MODEL_NAME DISPLAY_SIZE DISPLAY_TYPE PRICE
S.No
1 Ace-32X700(2020) 32 UHD OLED 15990
2 Ace-55X750(2020) 55 UHD OLED 45990
3 Ace-77X800(2020) 77 UHD OLED 330990

Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
Department Manager Salary No.of Employees/yers
D.code
1 Administration Mohan Pratap 180000 5
2 Purchase Department Varun S 120000 2365
3 Production Department Ranjith RJ 175000 5872
4 Research and Development Sherin US 150000 467
5 Sales(Marketing & Ads) Govind D 165000 2467
6 Human Resource Anjali P 145000 73
7 Accounting & Finance Prasad NP. 160000 55
To edit, Enter password or
To continue,Enter 'c' or
To exit the program,Enter 'e' : p

To change any department's manager,Type as 'm' or
To change any manager's salary,Type as 's' :
To change No.of employees/yers in any department,Type as 'n' : m
Enter D.code of manager(row number) : 5
Enter the new manager's name : Deepu M
D.code
5 Sales(Marketing & Ads) Deepu M. 165000 2467
MANAGER OF A DEPT UPDATED!
Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
D.code
5 Sales(Marketing & Ads) Deepu M 165000 2467
To change No.of employees/yers in any department,Type as 'n' : s
Enter D.code of manager(row number) : 3
Enter the new salary amount : 180000
D.code

SALARY OF A MANAGER UPDATED!
Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
D.code

To change No.of employees/yers in any department,Type as 'n' : n
Enter the D.code of departments(row number) : 7
Enter the number of employees/employers : 58
D.code
5 Sales(Marketing & Ads) Govind D 165000 2467
NO.OF EMPLOYEES/YERS UPDATED!

Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
About the Company
-----------------
A.C.E Electronics Private Lmtd company was incorporated in 1990.This is a private owned company
started by Dr.Amartya Sen, incorporated in India.The company's manufacturing units are spread over
around 7 countries.Started with manufacture of only Televisions and now the company is so popular for
its smartphones and laptops.There are over 11000 of employees working and most of the work are done
by machines. The company produces 35 million smarphones,10 million laptops,7 million televisions in a
year. It is aiming to provide quality products with more and more upcoming features and at a low price.
Type'e' to exit : c
------------------------------
Details
-------
Titles:-
1.Products
2.Departments
3.About
Password:'p'
NO DETAILS FOUND
Type'e' to exit : e
PROGRAM STOPPED
-------------------------------------------------------------------------------------------------------------
CONCLUSION
This is a project made with the python programming
language. The program is designed for the data analysis to
an imaginary company (ACE Electronics).This program
contains pandas series, pandas dataframe to store data of
products, departments and these can be edited
(add,delete,update etc) using inputs.This program can be
used for other companies and can be modified to do more
things. Just check out the hardware and software
requirements to run this program.
Thanks to all who helped me to complete this project,
especially our Ip teacher Sudha Ma’am and all of my
friends and family members. Thanks to all the readers.
BIBLIOGRAPHY
Reference Text: Informatics Practices by Sumita
Arora
$ www.google.com
$ www.stackexchange.com
$ www.wikipedia.com
$ www.w3schools.com

IP Project

Uploaded by

Copyright:

Available Formats

IP Project

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

IP Project

Uploaded by

Copyright:

Available Formats

ARALUMMOODU, TVPM.

INFORMATICS PRACTICES (065)

CLASS : …………………………………… ROLL.NO: ……………………………….

REG. NO: : ………………………………….. ACADEMIC YEAR: ……………………

This is to certify that this project report entitled

Date:…………………………… Teacher in Charge

Internal Examiner External Examiner

I wish to express my sincere gratitude to Mr. Jayasankar Prasad,

I am greatly indebted to Mrs. Sudha B V, Teacher in Informatics

$ HARDWARE & SOFTWARE REQUIREMENTS

Hard Disk : Minimum 250 MB Free memory

Processor. : Dual Core 2.80 GHz or greater

Screen Resolution : 1366 x 768 (Optimal)

Graphics Card : Minimum 64 MB

Platform : Windows 7/8/10 with SP1

Python Version : Python 3.0 or Greater

Enter the number corresponding to the title you want to view : 1

To edit the products' list,Enter 'e' or

To display the products' details,Enter 'd' or

To go to main menu,Enter 'm' or

To exit the program,Enter 'x' : e

To add a new product,Enter 'a' or

To remove a product,Enter 'r' : a

Enter the new product name here : Smart Watch

Type as 'c' to continue or

A.C.E Electronics Private Lmtd

Enter the number corresponding to the title you want to view : 1

To edit the products' list,Enter 'e' or

To display the products' details,Enter 'd' or

To go to main menu,Enter 'm' or

To exit the program,Enter 'x' : e

To add a new product,Enter 'a' or

To remove a product,Enter 'r' : r

Enter the S.no of the product to remove : 3

Type as 'c' to continue or

A.C.E Electronics Private Lmtd

Enter the number corresponding to the title you want to view : 1

To edit the products' list,Enter 'e' or

To display the products' details,Enter 'd' or

To go to main menu,Enter 'm' or

To exit the program,Enter 'x' : d

To display details of smartphones,Enter 's' or

To display details of laptops,Enter 'l' or

To display details of televisions,Enter 't' : s

MODEL_NAME RAM&INT.STORAGE PRICE

1 Ace X1 3GB,32GB 8500

3 Ace X2 4GB,64GB 14000

4 Ace X2 Pro 6GB,128GB 16500

5 Ace X3 6GB,64GB 17000

6 Ace Y1 6GB,128GB 18900

7 Ace Y1 Pro 8GB,256GB 24700

8 Ace Y2 6GB,128GB 20500

9 Ace Y2+ 8GB,256GB 28600

10 Ace Y2 Ultra 12GB,512GB 43250

11 Ace Note1 6GB,128GB 35200

12 Ace Note1 Max 8GB,256GB 40900

To display graph,Enter 'g' or

To go to main menu,Enter 'm' or

To exit the program,Enter 'e' : g