MYSQL with Python Interface — Computer Science STD 12 Science — Question

WAP to input a number and check whether it is palindrome or not.

Write a program to read the records from laps.csv.

Write a python program to draw the line chart for the following:

x_data = [2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2013]

y_data = [18, 21, 18, 21, 16, 14, 13, 18, 17, 16, 19, 23]

What is Worm? How is it removed? 

What are the significant features of the pandas Library?

Write the python function to accept the rollno as parameter and find out whether record present in the table or not

Write SOL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii) which are based on the tables.

TABLE : CUSTOMERS

NO	CNAME	ADDRESS
101	Richa jain	Delhi
101	Surbhi Sinha	Chennai
103	Lisa Thomas	Bangalore
104	Imran Ali	Delhi
105	Roshan Singh	Chennai

TABLE : TRANSACTION

TRNO	CNO	AMOUNT	TYPE	DOT
T001	101	1500	Credit	2017-11-23
T002	103	2000	Debit	2017-05-12
T003	102	3000	Credit	2017-06-10
T004	103	12000	Credit	2017-09-12
T004	101	1000	Debit	2017-09-05

(a) To display details of all transactions of TYPE Credit from Table TRANSACTION.
(b) To display the CNO and AMOUNT of all transactions done in the month September 2017 from the table TRANSACTION.
(c) To display the last date of transaction (DOT) from the table TRANSACTION for the customer having CNO as 103.
(d) To display all CNO,CNAME and DOT (date of transaction) of those CUSTOMERS from tables CUSTOMERS and TRANSACTION who have done transactions more than or equal to 2000.
(e) Select count(*), avg(amount) from transaction where dot>= ‘2017-06-01’;
(f) Select cno, count(*), max (amount) from transaction group by cno having count(*)> 1;
(g) Select cno, cname from customer where address not in (‘Delhi, ‘Bangalore’);
(h) Select distinct cno from transaction;

Write a python program to create the pie chart use a different colour for the different countries.

Title: Carbon emission of the coutries 1990-2011

values=[27, 11, 25, 8, 1, 3, 25]

countres= [ "US", "China", "European Union", "Russian Federation", "Brazil","India","Rest of World"]

Write script to input two integers and find their LCM.

Write a Python program to draw a line chart with the suitable label in the x-axis, y-axis and a title. Value of X must be entered by the user as the list from the user and Y should be twice of X.