Literacy Rate Analysis Project File 1
Literacy Rate Analysis Project File 1
Literacy Rate Analysis Project File 1
AISSCE 2020-2021
Olympic
LiteracyGames Analysis
Rate Analysis
System
System of India
Index
6. Source Code
7. Output
8. Bibliography
1
LITERACY RATE ANALYSIS SYSTEM OF INDIA
CERTIFICATE
This is to certify that project report entitled Literacy
Rate Analysis System of India has been successfully
completed by Roll No. –
Is being submitted for Practical Examination of
Of Class 12 (AISSCE -2020-2021) in Information
Practices(Code-065).
School Logo
School Name
Guided By –
Teacher Name with Designation
AKNOWLEDGEMENT
I would like to express my special thanks of gratitude to
2
LITERACY RATE ANALYSIS SYSTEM OF INDIA
my teacher Mr. / Ms. ____________as well as our
principal Mr/Mrs. ________ who gave me the golden
opportunity to do this wonderful project on the topic
‘Literacy Rate Analysis System of India’,
3
LITERACY RATE ANALYSIS SYSTEM OF INDIA
AIM:To Develop:
Literacy Rate Analysis System of India
Front End:
Python 3.8.2
Back End:
My SQL Server 5.1
Operating System:
Windows 10
Minimum Hardware and Software Requirements:
Operating System:
x86 64-bit CPU (Intel / AMD architecture)
4 GB RAM.
5 GB free disk space.
Open Source Software being used:
1. Python 3.8.2
a. Pandas
b. Matplotlib
4
LITERACY RATE ANALYSIS SYSTEM OF INDIA
Pandas:
Matplotlib:
5
LITERACY RATE ANALYSIS SYSTEM OF INDIA
Literacy Rate Analysis System in India
Introduction
National Literacy Mission (NLM) was set up by
the government of India on 5th May 1988 with an aim to
eradicate illiteracy in the country by imparting functional
literacy to non-literates. Thus, National Literacy Mission
(NLM) was established not only to make everybody just self
reliant in three R's- reading, writing and arithmetic but also
to make them aware of the development issues affecting the
society. The target group of NLM is people between the age
of 15 and 35. National Literate Mission works under the
guidance of National Literacy Mission Authority, an
independent wing of Ministry of Human Resources and
Development.
MAIN MENU
1- Data Visualization
2- Analysis
3- Manipulation
4- Exit
7
LITERACY RATE ANALYSIS SYSTEM OF INDIA
1- Data Visualization
1.1-Line Chart of a Particular Year
1.2-Bar Chart for different Years
1.3-Histogram for a Year
1.4-Pie Chart Average Literacy
1.5-Back to Main Menu
2- Analysis
2.1 Top record
2.2 Bottom records
2. 3 To Display Literacy of a particular year
2. 4 To Display States with Literacy rate is >= n% in a year
2.5 To Display States with Maximun Literacy rate
2.6 To display Average Literacy of India
2.7 To display Complete DataFrame
2.8 To Minimum, Maximum and Average Literacy in a year
2.9 Back to Main Menu'''
3- Manipulation
3.1. Insert a row
3.2. Insert a Column
3.3. Delete a Row
3.4. Delete a column
3.5. Update a cell value
3.6. Back to Main Menu
8
LITERACY RATE ANALYSIS SYSTEM OF INDIA
PYTHON : OVERVIEW
9
LITERACY RATE ANALYSIS SYSTEM OF INDIA
Python is a Beginner's Language − Python is a
great language for the beginner-level programmers and
supports the development of a wide range of
applications from simple text processing to WWW
browsers to games.
History of Python
Python was developed by Guido van Rossum in the late
eighties and early nineties at the National Research Institute
for Mathematics and Computer Science in the Netherlands.
Python is derived from many other languages, including
ABC, Modula-3, C, C++, Algol-68, SmallTalk, and Unix shell
and other scripting languages.
Python is copyrighted. Like Perl, Python source code is now
available under the GNU General Public License (GPL).
Python is now maintained by a core development team at
the institute, although Guido van Rossum still holds a vital
role in directing its progress.
Python Features
10
LITERACY RATE ANALYSIS SYSTEM OF INDIA
Easy-to-learn − Python has few keywords, simple
structure, and a clearly defined syntax. This allows the
student to pick up the language quickly.
Easy-to-read − Python code is more clearly defined
and visible to the eyes.
Easy-to-maintain − Python's source code is fairly
easy-to-maintain.
A broad standard library − Python's bulk of the
library is very portable and cross-platform compatible
on UNIX, Windows, and Macintosh.
Interactive Mode − Python has support for an
interactive mode which allows interactive testing and
debugging of snippets of code.
Portable − Python can run on a wide variety of
hardware platforms and has the same interface on all
platforms.
Extendable − You can add low-level modules to the
Python interpreter. These modules enable programmers
to add to or customize their tools to be more efficient.
11
LITERACY RATE ANALYSIS SYSTEM OF INDIA
Databases − Python provides interfaces to all major
commercial databases.
GUI Programming − Python supports GUI
applications that can be created and ported to many
system calls, libraries and windows systems, such as
Windows MFC, Macintosh, and the X Window system of
Unix.
Scalable − Python provides a better structure and
support for large programs than shell scripting.
12
LITERACY RATE ANALYSIS SYSTEM OF INDIA
literacy_rate.csv (Notepad View):
13
LITERACY RATE ANALYSIS SYSTEM OF INDIA
14
LITERACY RATE ANALYSIS SYSTEM OF INDIA
CODING
15
LITERACY RATE ANALYSIS SYSTEM OF INDIA
16
LITERACY RATE ANALYSIS SYSTEM OF INDIA
17
LITERACY RATE ANALYSIS SYSTEM OF INDIA
18
LITERACY RATE ANALYSIS SYSTEM OF INDIA
19
LITERACY RATE ANALYSIS SYSTEM OF INDIA
20
LITERACY RATE ANALYSIS SYSTEM OF INDIA
21
LITERACY RATE ANALYSIS SYSTEM OF INDIA
Screen shot /Output
22
LITERACY RATE ANALYSIS SYSTEM OF INDIA
23
LITERACY RATE ANALYSIS SYSTEM OF INDIA
24
LITERACY RATE ANALYSIS SYSTEM OF INDIA
25
LITERACY RATE ANALYSIS SYSTEM OF INDIA
26
LITERACY RATE ANALYSIS SYSTEM OF INDIA
27
LITERACY RATE ANALYSIS SYSTEM OF INDIA
28
LITERACY RATE ANALYSIS SYSTEM OF INDIA
29
LITERACY RATE ANALYSIS SYSTEM OF INDIA
30
LITERACY RATE ANALYSIS SYSTEM OF INDIA
31
LITERACY RATE ANALYSIS SYSTEM OF INDIA
32
LITERACY RATE ANALYSIS SYSTEM OF INDIA
33
LITERACY RATE ANALYSIS SYSTEM OF INDIA
34
LITERACY RATE ANALYSIS SYSTEM OF INDIA
35
LITERACY RATE ANALYSIS SYSTEM OF INDIA
36
LITERACY RATE ANALYSIS SYSTEM OF INDIA
37
LITERACY RATE ANALYSIS SYSTEM OF INDIA
38
LITERACY RATE ANALYSIS SYSTEM OF INDIA
39
LITERACY RATE ANALYSIS SYSTEM OF INDIA
Bibliography
Youtube Channel(Computer Concepts A.k Pandey)
Google Images
https://www.tutorialspoint.com/
40
LITERACY RATE ANALYSIS SYSTEM OF INDIA