LUSHKARY PREPARATORY
SCHOOL
Name:- Sakshi Soni
Class:- XII
Roll no. :- 19
I have made this file via inspiring by this quote…
“ I WANT TO SEE THAT WHAT HAPPENS IF I NEVER GIVE
UP !!! ”
In this file I am going to represented following things shown in
table below :-
Type of codings Number of codings
1. PYTHON PANDAS 15
2. PYTHON MATPLOTLIB 04
3. MYSQL 15
I want to give special thanks
to my computer teacher Miss Gudiya Sharma for
her kind guidance which helped me a lot to complete my file
work without any obstacles.
I also want to pay a huge thanks to my friends and
families who not only guided me but also provided the best
out of best resources needed to be accomplishing my file
work.
I am delighted to have such people around me.
Again, a lot of thanks all mentioned over here.
- SAKSHI SONI
PYTHON PANDAS
Pandas is a powerful and versatile library that
simplifies tasks of data manipulation in Python .
Pandas is built on top of the NumPy library and is
particularly well-suited for working with tabular
data, such as spreadsheets or SQL tables.
Its versatility and ease of use make it an essential tool for data analysts,
scientists, and engineers working with structured data in Python.
A Pandas Series is a one-dimensional labelled array capable of holding
data of any type (integer, string, float, python objects, etc.). The axis
labels are collectively called indexes.
Pandas Series is nothing but a column in an Excel sheet. Labels need not
be unique but must be a hashable type. The object supports both integer
and label-based indexing and provides a host of methods for performing
operations involving the index .
Pandas are generally used for data science but have you wondered why?
This is because pandas are used in conjunction with other libraries that
are used for data science.
It is built on the top of the NumPy library which means that a lot of
structures of NumPy are used or replicated in Pandas. The data produced
by Pandas are often used as input for plotting functions of Matplotlib,
statistical analysis in SciPy, and machine learning algorithms in
Scikit-learn.
Here is a list of things that we can do using Pandas:=
● Data set cleaning, merging, and joining.
● Easy handling of missing data (represented as NaN) in floating point
as well as non-floating point data.
● Columns can be inserted and deleted from DataFrame and higher
dimensional objects.
● Powerful group by functionality for performing split-apply-combine
operations on data sets.
● Data Visualization
1. Creating Series
Output of the above code :-
2. Using numpy creating series
Output of the above code:-
3. Indexing in series
Output of the above code:-
4. Formatting in series
Output of the above code:-
5. Calculating per capita income using series
Output of the coding:-
6. Creating dataframe
Output of the above the coding:-
7. Getting number of rows in a dataframe
Output of the above coding:-
8. Transpose of a dataframe
Output of the above code:-
9.Accessing rows in a dataframe
Output of the above code:-
10. Modifying/changing a column in a dataframe
Output after performing certain operations:-
11. Modifying/changing row of a dataframe
Output after performing certain operations:-
12. Deleting a column in this dataframe
Output after performing certain operations:-
13. Renaming columns in a dataframe
Output after performing certain operations:-
14. Binary operations on a dataframe
Output after performing certain operations:-
15. Performing descriptive statistics on a dataframe
Output after performing certain operations:-
PYTHON MATPLOTLIB
Python
Matplotlib is an amazing visualisation library in Python for 2D plots of arrays.
Matplotlib is a multi-platform data visualisation library built on NumPy arrays
and designed to work with the broader SciPy stack. It was introduced by John
Hunter in 2002. One of the greatest benefits of visualisation is that it allows
us visual access to huge amounts of data in easily digestible visuals.
Matplotlib consists of several plots like line, bar, scatter, histogram, etc.
Installation: Windows, Linux, and macOS distributions have Matplotlib and
most of its dependencies as wheel packages.
Matplotlib comes with a wide variety of plots. Plots help to understand
trends, and patterns, and to make correlations. They’re typically instruments
for reasoning about quantitative information. Some of the sample plots are
covered here.
● Matplotlib Line Plot
● Matplotlib Bar Plot
● Matplotlib Histograms Plot
● Matplotlib Scatter Plot
● Matplotlib Pie Charts
● Matplotlib Area Plot
1.Creating Line Chart
Output will be ->
2.Changing linewidth,linestyle and markersize
Output will be ->
3.Creating bar chart
Output will be ->
4.Creating histogram
Output will be ->
MYSQL
MySQL is the world’s most popular open source database. According to DB-Engines,
MySQL ranks as the second-most-popular database, behind Oracle Database. MySQL
powers many of the most accessed applications, including Facebook, Twitter, Netflix,
Uber, Airbnb, Shopify, and Booking.com.
Since MySQL is open source, it includes numerous features developed in close
cooperation with users over more than 25 years. So it’s very likely that your favourite
application or programming language is supported by MySQL Database.
A relational database stores data in separate tables rather than putting all the data in one big storeroom. The
database structure is organised into physical files optimised for speed. The logical data model, with objects such
as data tables, views, rows, and columns, offers a flexible programming environment. You set up rules governing
the relationships between different data fields, such as one to one, one to many, unique, required, or optional, and
“pointers” between different tables. The database enforces these rules so that with a well-designed database your
application never sees data that’s inconsistent, duplicated, orphaned, out of date, or missing.
The “SQL” part of “MySQL” stands for “Structured Query Language.” SQL is the most common standardised
language used to access databases.
1.Inserting values in the given
table
Result:-
2.Adding column
Result:-
3.Updating table
Result:-
4.Concat function
Result:-
5.Using Uppercase function
Result:-
6.Using length()
Result:-
7.Using sqrt()
Result:-
8. Ordering the data
Result:-
9.Using count()
Result:-
10.Using sum()
Result:-
11.Using truncate()
Result:-
12.Using Curdate()
a) Getting 10 days before current
date
b) Getting current date
13.Using modulus()
14. Using round()
15.Using power()
