Scribd
Upload
27 views28 pages

Data Management System Source Code

The document contains an index listing the contents of a data management system project. It includes sections on the objective to create software to manage company data, input/output requirements including the operating system and Python libraries used, a description of the CSV database file, the source code implementing the data management system using Pandas and Matplotlib for data retrieval and visualization, and a references section.

Uploaded by

best laptop
Copyright
© All Rights Reserved
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
27 views28 pages

Data Management System Source Code

The document contains an index listing the contents of a data management system project. It includes sections on the objective to create software to manage company data, input/output requirements including the operating system and Python libraries used, a description of the CSV database file, the source code implementing the data management system using Pandas and Matplotlib for data retrieval and visualization, and a references section.

Uploaded by

best laptop
Copyright
© All Rights Reserved
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

INDEX

[Link] CONTENT PAGE NO.


1 INDEX 2
2 CERTIFICATE 3
3 ACKNOWLEDGEMENT 4
4 PREFACE 5
5 OBJECTIVE 7
DMSv1.00 V/S
6 8
MANUAL SYSTEM

INPUT/OUTPUT 9
7
REQUIRMENTS
HARDWARE & 10
8 SOFTWARE
REQUIRMENTS 13
9
DATABASE(CSV FILES) 15
10
SOURCE CODE 24
11 OUTPUT 30
12
REFRENCE
ACKNOWLEDGEMENT
APART FROM THE EFFORT OF ME, THE SUCCESS OF ANY PROJECT
DEPENDS ON THE ENCOURAGEMENT AND GUIDELENES OF MANY
OTHERS. I TAKE THIS OPPORTUNITY TO EXPRESS OUT GRATITUDE TO
THE PEOPLE WHO HAVE BEEN INSTRUMENTAL IN THE SUCCESSFUL
COMPLETION OF THIS PROJECT.

I WOULD LIKE TO EXPRESS MY SPECIAL THANKS OF GRATITUDE TO


OUR INFORMATICS PRACTICES TEACHER “Mrs. THUSARA MAM” FOR
THEIR GUIDANCE AND SUPPORT IN COMPLETION OF THIS PROJECT.

I WOULD LIKE TO EXTEND OUR GRATITUDE TO THE PRINCIPAL “Mr.


VAIBHAV KAPOOR” FOR PROVIDING WITH ALL THE FACILITIES THAT
WAS REQUIRED.

DATE: NAME: PRINCE TIWARI

ROLL NO:

CLASS: XII Sc

Preface
AIM: TO DEVELOP “DATA MANAGEMENT SYSTEM”

TITLE: “DATA MANAGEMENT SYSTEM ”

PROBLEM DEFINATION: Develop software named

DATA MANAGEMENT SYSTEM to manage

Information about all the data of different MNCs

(Multinational Companies).

Reason for choosing this topic


 To manage information about the companies

 To keep record of their past performances.

 To compare one company from the others in


different aspects.

 Easy to identify each company with their


different company code.

Objective
 Simple and easy to operate.


Increased efficiency.

 Search, add, update and view company’s


information.

 Customized reports for better management.

 Save time.
How data management
system more beneficial
then manual system?

Data Management System helps to reduce the


manual work to manage information about
companies. This software helps to manage the
entire records of the companies. In addition it
allows streamlined management of fine details
such as company’s name, number of employees
in the companies, net worth, global positioning.
It enables the selector to know anything about
the company instantly. But for safety purpose
the software does not contain company’s private
information.
Input/output requirements
 Operating system

Windows 7 is a major release of the windows


operating system developed by Microsoft. It was
launched on July 22, 2009 and became
generally available on October 22, 2009. It is the
successor to windows vista, released nearly three
years earlier.
Overview of python 3.7

Python is an interpreter, object oriented, high-


level language with dynamic semantics. It was
developed by Guido Van Rossum.

Python is simple, easy to learn syntax


emphasized readability and therefore reduce the
cost of program maintenance. Python supports
modules and packages, which encourage
program modularity and code reuse.
Features of python

 High level

 Object oriented

 Simple

 Interpreted

 Open software

 Expressive language

 GUI programming

 Large standard library


Python library- python pandas
Pandas is an open-source library that is made mainly for
working with relational or labeled data both easily and
intuitively. It provides various data structures and
operations for manipulating numerical data and time
series. This library is built on top of the NumPy library.
Pandas is fast and it has high performance & productivity
for users.

Python Library-matplotlib
Matplotlib is a cross-platform, data visualization and
graphical plotting library for Python and its numerical
extension NumPy. As such, it offers a viable open source
alternative to MATLAB. Developers can also use matplotlib’s
APIs (Application Programming Interfaces) to embed plots in
GUI applications.

C.s.v file
A CSV (comma-separated values) file is a text file that has a
specific format which allows data to be saved in a table
structured format.
Database csv file
SOURCE CODE

from ast import Break


import [Link] as plt
import pandas as pd
import numpy as np

df1=pd.read_csv("C:\\Users\\lenovo\\Desktop\\companies
[Link]")
print(df1)

s=("Main Menu")
while(True):
print("Main Menu")
print("1. Display records of top MNCs")
print("2. Fetch data")
print("3. Update values")
print("4. Looking for a particular section?")
print("5. Want some comparison?")
print("6. EXIT")
break

Ch=int(input("Enter Choice"))
if Ch==1:
print(df1)
elif Ch==2:
while(True):
print("Database")
print("1. Top 5 Companies")
print("2. Bottom 5 Companies")
print("3. Specific number of companies from the top")
print("4. Specific number of companies form bottom")
print("5. Exit")

Ch2=int(input("Enter Choice"))
if Ch2==1:
print([Link]())
elif Ch2==2:
print([Link]())
elif Ch2==3:
n=int(input("Enter how many companies you want to
display from the top"))
print([Link](n))
elif Ch2==4:
n=int(input("Enter how many companies you want to
display from the bottom"))
print([Link](n))
elif Ch2==5:
break

elif Ch==3:
while(True):
print("Working on columns Menu")
print("1. Insert a new column data")
print("2. Delete a specific column")
print("3. Exit")

Ch3=int(input("Enter Choice Number"))


if Ch3==1:
print("Enter details")
h=input("Enter column name")
det=eval(input("Enter details corresponding to all subjects
: (enclosed in []"))
df1[h]=[Link](data=det,index=[Link])
print(df1)
print("column inserted")
elif Ch3==2:
a=input("Enter column name which need to be deleted ")
[Link]([a],axis=1,inplace=True)
print(df1)
print("column deleted")
elif Ch3==3:
break
elif Ch==4:
while(True):
print("Search Menu")
print("1. Search for details of a specific company")
print("2. Search details for a specific column")
print("3. Exit")

Ch4=int(input("Enter Choice Number"))


if Ch4==1:
st=int(input("Enter index no. of the company whose
details you want to see"))
print([Link][st])
elif Ch4==2:
col=input("Enter column whose detail you want to see")
print(df1[col])
elif Ch4==3:
break
elif Ch==5:
while(True):
print("Data visualization menu")
print("1. Line plot for Employee Comparison")
print("2. Vertical Bar Plot For Net worth Comparison")
print("3. Horizontal Bar plot For Global position
Comparison")
print("4. Exit")

Ch5=int(input("Enter Choice Number"))


if Ch5==1:

Comp=['Microsoft','Meta','Amazon','Google','Tesla','Tata','Relian
ce','Infosys','SpaceX','Netflix']

Emp=[221000,58604,1468000,150028,110000,935000,342982,2
76319,12000,11300]
[Link]("No. of employees in top MNCs")
[Link]("Company name")
[Link]("No. of employees in lakhs")
[Link](Comp,Emp,color='y',)

[Link]()

break

elif Ch5==2:

Comp=['Microsoft','Meta','Amazon','Google','Tesla','Tata','Relian
ce','Infosys','SpaceX','Netflix']
Net=[2135,36,1053.5,1420,710.78,260,229,79.06,2,131.6]
[Link]("Net worth of top MNCs")
[Link](Comp,Net,color='b')
[Link]("COMPANY NAME")
[Link]("NET WORTH IN BILLION DOLLARS")
[Link]()
break
elif Ch5==3:

Comp=['Microsoft','Meta','Amazon','Google','Tesla','Tata','Relian
ce','Infosys','SpaceX','Netflix']
Gpos=[21,27,1,2,103,78,104,50,378,245]
[Link](Comp,Gpos,color='r')
[Link]("Horizontal Bar Graph representing company
information")

[Link]("COMPANY NAME")
[Link]("GLOBAL POSITION")
[Link]()

elif Ch5==4:
break
elif Ch==6:
Break
OUTPUTS
References

Preeti arora

Class notes

Common questions

Powered by AI

Python is suitable for developing a Data Management System due to its high-level, object-oriented properties, and interpreted nature, which facilitate rapid development and ease of maintenance. Its simplicity and readability reduce programming errors. Python’s extensive standard library and support for modular programming with packages like pandas and matplotlib enhance data manipulation capabilities and visualization, making Python a powerful tool for managing and analyzing complex datasets in DMS .

CSV files play a critical role in the Data Management System as they provide a simple, structured format for storing and managing tabular data. They enable easy import and export of datasets, allowing for efficient data manipulation and retrieval using Python libraries like pandas. By storing company data in CSV files, the system ensures flexibility in data handling and compatibility with various data processing tools and environments .

GUI programming is significant in Python-based Data Management Systems as it enhances user experience by providing an intuitive and accessible interface for interacting with the system. It allows users to perform complex data operations, such as searching, updating, and visualizing data, through straightforward graphical controls, reducing the reliance on command-line inputs, and thus improving efficiency and user satisfaction .

The primary objectives of the Data Management System project include simplifying the identification of companies through unique codes, maintaining records of past performances, comparing companies on various aspects, managing information efficiently, saving time, and providing an easy-to-operate platform for adding, updating, and viewing company data. Additionally, it aims to generate customized reports for better management .

Choosing a Data Management System over a manual system provides numerous advantages, including time savings and increased efficiency in managing company information. The DMS easily identifies companies via unique codes, tracks historical performance, and facilitates comparisons. Its automated nature streamlines operations that would otherwise require extensive manual labor, thus enhancing productivity and accuracy in data handling .

Python 3.7 offers several benefits for developing a Data Management System, such as its interpreted and object-oriented nature that supports quick development cycles and ease of use. Its modularity and extensive library support, particularly for data manipulation and visualization, allow developers to build robust and versatile applications. Python's user-friendly syntax also enhances collaborative development and reduces the learning curve for maintaining and upgrading the system .

Matplotlib enhances the Data Management System by providing robust data visualization capabilities. It allows users to create various plots and graphs, such as line and bar charts, to graphically represent and compare data like employee numbers, net worth, and global positions among top MNCs. This visual representation of data aids in better decision-making and simplifies complex data analyses, enabling stakeholders to quickly grasp trends and insights from the data .

Customized reports generated by the Data Management System can improve company management strategies by offering tailored insights specific to managerial needs, enabling strategic decision-making. These reports can focus on different performance metrics, allowing for targeted analysis and comparison across sectors or competitors. By pinpointing strengths, weaknesses, or areas for improvement, managers can develop more effective strategies to enhance operational efficiency and market positioning .

Pandas significantly enhances the functionality of a Data Management System through its ability to handle and manipulate large datasets efficiently. It provides data structures like DataFrames that support varied operations such as sorting, filtering, aggregation, and data transformation. These capabilities allow users to perform detailed data analyses and generate customized reports, thus supporting informed decision-making within the DMS framework .

The Data Management System (DMS) enhances efficiency over manual systems by streamlining data management tasks, significantly reducing the need for manual input and oversight. It enables quick access to detailed company records, such as the number of employees, net worth, and global positioning, while avoiding sensitive private information for security purposes. These automated processes save time, increase productivity, and allow for easy data retrieval and comparison across different aspects of MNCs .

You might also like