Plot:
import matplotlib.pyplot as plt
sizes =  [105, 30, 30, 195]
label= ["sleeping", "eating", "working", "playing"]
plt.pie (sizes, labels = labels, autopct = "%.2f")
plt, axes ( ). set_aspect ("equal")
plt.show ( )

(i) Data Visualization help users to analyze and interpret the data easily.
(ii) It makes complex data understandable and usable.
(iii) Various Charts in Data Visualization helps to show relationship in the data for one or more variables.

The WHERE clause is used to extract only those records that fulfill a specified condition. In this example we are going to display the different grades scored by male students from "student table.
import sqlite3
connection = sqlite3.connect ("Academy.db")
cursor = connection.cursor()
cursor.execute ("SELECT DISTINCT (Grade) FROM student where gender = "M")
result = cursor.fetchall()
print(* result, sep ="\n")
Output:
('B,')
('A,')
('C,')
('D,')

fetchone() fetchmany() Returns the next row of a query result set or none in case there is no row left.
Using while loop and fetchone() method we can display all the records from a table one by one. Returns the next number of rows(n) of the result set.
Displaying specified number of records is done by using fetchmany():  

welcome → module name
      ●      →  operator name
display() → definition name

(i) MinGW refers to a set of runtime header files, used in compiling and linking the code of C, C++ and FORTRAN to be run on Windows Operating System.
(ii) MinGw- W64 (version of MinGW) is the best compiler for C++ on Windows. To compile and execute the C++ program, need 'g++' for Windows. MinGW allows to compile and execute C++ program dynamically through Python program using g++.
(iii) Python program that contains the c++ coding can be executed only through 'MinGW_w64 project' run terminal. The run terminal open the command -line window through which Python program should be executed.
(iv) g++ is a program that calls GCC (GNU C compiler) and automatically links the required C++ Library files to the object code.

Program: To read a csv file with comma (,)
#importing csv
import csv
#opening the csv file which is in different location with read mode
with open('c:\\Pyprg\ \sample1.csv', 'r') as F:
#other way to open the file is
f=('C:\\pyprg\\sample1.csv', 'r')
reader = csv.reader(F))
#printing each line of the Data row by row.
print (row)
F. close( )
Output:
['SNO','NAME', 'CITY']
['12101', 'RAM', 'CHENNAI']
['12102', 'LAVANYA' "TIRUCHY']
['12103', 'LAKSHMAN', 'MADURAI']

Program: To modify an existing file
import csv
row = ['3: 'Meena','Bangalore']
with open('Student.csv', 'r') as read file:
reader = csv.reader (read File)
lines = list (reader) 
lines [3] = row
with open ('Student.csv', 'w') as write file:
# returns the writer object which converts the user data with delimiter.
writer = csv.writer(writefile)
#writerows() method writes multiple rows to a csv file
writer. writerows(lines)
readFile.close()
writeFile.close()
Output:

Roll No	Name	City
1.	Harshini,	Chennai
2.	Adhith,	Mumbai
3.	Meena,	Bangalore
4.	Egiste	Tiruchy
5.	Venkat,	Madurai

Data Definition Language:
(i) Create Command: To create tables in the database.
CREATE TABLE Student
(Admno integer,
      Name char(20),
      Gender char(1),
      Age integer,
      Place char(10),
);
(ii) Alter Command: The ALTER command is used to alter the table structure like adding a column, renaming the existing column, change the data type of any column or size of the column or delete the column from the table.
ALTER TABLE <table-name> ADD <column-name><data type><size>;
To add a new column "Address" of type 'char' to the Student table, the command is used as
ALTER TABLE Student ADD Address char;
(iii) Drop Command: The DROP TABLE command is used to remove a table from the database.
The table can be deleted by DROP TABLE command in the following way:
DROP TABLE table-name;

ALTER TABLE <table-name> ADD <column- name><data type><size>;
Example: ALTER TABLE Student MODIFY Address char (25)

 

 

(i) Cross product is a way of combining two relations. The resulting relation contains, both relations being combined.
(ii) A x B means A times B, where the relation A and B have different attributes.
(iii) This type of operation is helpful to merge columns from two relations

Database Administrator or DBA is the one who manages the complete database management system. DBA takes care of the security of the DBMS, managing the license keys, managing user accounts and access etc.

Good Morning Bindu Madhavan.

Code:
class Sample:
def_init_(self, n1, n2):
            self._n1=nt
            self_n2-n2
def sum(self):
           print ("Class Variable 1:" self_n1)
           print ("Class Variable 2:", self_n2)
S=Sample (5,10)
S.sum()
Output:
Class Variable 1:5
Class Variable 2: 10
Sum: 15

	del	Clear( )
(i)	The del statements is used to delete elements whose index is known.	The function clear ( ) is used to delete all the elements in list.
(ii)	The del statement can also be used to delete entire list.	It deletes only the elements and retains the list.
(iii)	Example: del Dict ["MarkT"]	Example : Dict.clear( )

 

Sort ( ) :
It sorts the element in list.
Syntax :
   List.sort(reverse=True|False,key=myfunc)
Sorts the element in list :
Both arguments are optional
(i) If reverse is set as True, list sorting is in descending order.
(ii) Ascending is default.
(iii) Key=myFunc; "myFunc" - the name of the user defined function that specifies the sorting criteria.
Example :
MyList = [Thilothamma', "Tharani', 'Anitha','SaiSree', 'Lavanya')
MyList.sort( )
print(MyList)
MyList.sort(reverse=True)
print(MyList)
Output :
['Anitha', 'Lavanya', 'SaiSree', 'Tharani', 'Thilothamma']
['Thilothamma', 'Tharani', 'SaiSree', 'Lavanya', 'Anitha']
 

(i) The format( ) function used with strings is very versatile and powerful function used for formatting strings.
(ii) The curly braces {} are used as placeholders or replacement fields which get replaced along with format( ) function.
Example:
num1 = int (input("Number 1:")) 
num2 = int (input("Number 2:")) 
print ("The, sum of {} and {} is {}". format (num1, num2, (num1 + num2)))
Output:
Number 1: 34
Number 2: 54
The sum of 34 and 54 is 88.

Syntax	Description	Example
(a) capitalize()	Used to capitalize the first character of the string	>>> city="chennai" >>> print(city, capitalize( )) Chennai
(b) swapcase( )	It will change case of every character to its opposite case vice-versa.	>>> strl="tAmilL NaDu" >>>print(strl.swapcase( )) TaMIl nAdU

 

(i) Recursive function is called by some external code.
(ii) If the base condition is met then the program gives meaningful output and exits.
(iii) Otherwise, function does some required processing and then calls itself to continue recursion.

Code:
n=int(input("Enter the year"))
if(y%4==0):
         print ("Leap Year")
else:
         print ("Not a Leap Year")
Output:
Enter the year      2012
Leap Year

Rules of global Keyword: The basic rules for global keyword in Python are:
(i) When we define a variable outside a function, it's global by default. you don't have to use global keyword.
(ii) We use global keyword to modify the value of the global variable inside a function.
(iii) Use of global keyword outside a function has no effect.

for i in range (1, 6) :
for j in range (65, 65 + i)
         a = chr(j)
print a
print

Asymptotic Notations are languages that uses meaningful statements about time and space complexity. The following three asymptotic notations are mostly used to represent time complexity of algorithms:
(i) Big O: Big O is often used to describe the worst -case of an algorithm.
(ii) Big \(\Omega \):Big Omega is the reverse Big O, if Big O is used to describe the upper bound (worst - case) of a asymptotic function, Big Omega is used to describe the lower bound (best -case).
(iii) Big \(\Theta \):When an algorithm has complexity with lower bound = upper bound, Say that an algorithm has a complexity O(n log n) and \(\Omega \) (n log n), it's actually has the complexity \(\Theta \) (n log n), which means the running time of that algorithm always falls in n log n in the best-case and worst-case.

(i) Time Factor -Time is measured by counting the number of key operations like comparisons in the sorting algorithm.
(ii) Space Factor -Space is measured by the maximum memory space required by the algorithm.