SET-1
1 a) Using numpy arrays
import pandas as pd
import numpy as np
a=[Link]([45,24,50,
34])
b=[Link](['Term1','Term2','Term3','Term4'])
s1=[Link](a,b)
print(s1)
Output
Term1 45
Term2 24
Term3 50
Term4 34
dtype: int32
b)Using dictionary
import pandas as pd
d={'Term1':45,'Term2':24,'Term3':50,'Term4':34
}
s1=[Link](d)
print(s1)
Output
Term1 45
Term2 24
Term3 50
Term4 34
dtype:int32
1 b)
import [Link] as plt
ename=['Hari','Riya','Chandhan','Joe','Mita']
sal=[4000,6000,5000,3500,8000]
[Link](ename,sal,marker='d')
[Link]('Emlpoyee Name')
[Link]('Salary')
[Link]('Employee Salary Details')
[Link]('[Link]')
[Link]()
OUTPUT:
1 c)
i. mysql> create table Department(deptno int primary key,deptname varchar(15),HOD
varchar(20));
ii. mysql> create table Employee(eno int primary key,ename varchar(20), deptno int,sal
int, foreign key(deptno) references Department(deptno));
iii.
iv. mysql> select ename,deptname from Employee,Department where
v. mysql> select ename,deptname from Employee,Department where
[Link]=[Link];
(or)
mysql> select ename,deptname from Employee e,Department d where
[Link]=[Link]; Output:
vi. mysql> select ename,HOD from Employee,Department where
[Link]=[Link];
(or)
mysql> select ename,HOD from Employee e,Department d where
[Link]=[Link]; Output:
vii. mysql> select ename,HOD from Employee,Department where
[Link]=[Link] and Deptname='CS';
(or)
mysql> select ename,HOD from Employee e,Department d where [Link]=[Link] and
Deptname='CS';
Output
SET-2
2 a) import pandas as pd
mileage=[Link]([15.2,18.8,17.4,17.0,17.4],
['ROXX','PUNCH','CRETA','XUV700','NEXON'])
print(mileage)
print('number of elements is Series=',[Link])
print('shape of Series=',[Link])
print('Dimension of Series=',[Link])
print('Number of Bytes occupied by Series=',[Link])
print('Is Series empty=',[Link])
output:
2b) import [Link] as plt
years=[2020,2021,2022,2023,2024]
passpercentage=[95,84,90,95,98]
[Link](years,passpercentage) [Link]('Year')
[Link]('pass percentage')
[Link]('school pass percentage')
[Link]('[Link]')
[Link]()
output:
2c)
i. mysql> create table Department(deptno int primary key,deptname varchar(15),HOD
varchar(20));
ii. mysql> create table Employee(eno int primary key,ename varchar(20), deptno int,sal
int, foreign key(deptno) references Department(deptno));
iii.
iv. mysql> select ename,deptname from Employee,Department where
v. mysql> select ename,deptname from Employee,Department where
[Link]=[Link];
(or)
mysql> select ename,deptname from Employee e,Department d where
[Link]=[Link]; Output:
vi. mysql> select ename,HOD from Employee,Department where
[Link]=[Link];
(or)
mysql> select ename,HOD from Employee e,Department d where
[Link]=[Link]; Output:
vii. mysql> select ename,HOD from Employee,Department where
[Link]=[Link] and Deptname='CS';
(or)
mysql> select ename,HOD from Employee e,Department d where [Link]=[Link] and
Deptname='CS';
Output
SET-3
3a)
(i)
import pandas as pd
s1=[Link]([45,36,27,35],['A','B','C','D'])
print(s1)
Output
A 45
C 27
D 35
E 54
dtype: int64
(ii)
[Link]('B',inplace=True)
(or)
del s1['B']
(or)
s1=[Link]('B')
(iii)
[Link]['E']=54
(or)
S1[‘E’]=54
3b) import [Link] as plt
ename=['Hari','Riya','Chandhan','Joe','Mita']
sal=[4000,6000,5000,3500,8000]
[Link](ename,sal,marker='d')
[Link]('Emlpoyee Name')
[Link]('Salary')
[Link]('Employee Salary Details')
[Link]('[Link]')
[Link]()
OUTPUT:
3c)
i. mysql> create table Department(deptno int primary key,deptname varchar(15),HOD
varchar(20));
ii. mysql> create table Employee(eno int primary key,ename varchar(20), deptno int,sal
int, foreign key(deptno) references Department(deptno));
iii.
iv. mysql> select ename,deptname from Employee,Department where
v. mysql> select ename,deptname from Employee,Department where
[Link]=[Link];
(or)
mysql> select ename,deptname from Employee e,Department d where
[Link]=[Link]; Output:
vi. mysql> select ename,HOD from Employee,Department where
[Link]=[Link];
(or)
mysql> select ename,HOD from Employee e,Department d where
[Link]=[Link]; Output:
vii. mysql> select ename,HOD from Employee,Department where
[Link]=[Link] and Deptname='CS';
(or)
mysql> select ename,HOD from Employee e,Department d where [Link]=[Link] and
Deptname='CS';
Output
SET-4
4a) import pandas as pd
L=[{"Model":"Samurai","Brand":"Suzuki","Make":1993},
{"Model":"Accord","Brand":"Honda","Make":1997},
{"Model":"CR-V","Brand":"Honda","Make":1997},
{"Model":"Nexon","Brand":"Tata","Make":2021},]
cars=[Link](L)
print(cars)
4b) import [Link] as plt
runs=[81,85,65,42,57,72,85,99,94,72,66,67,76]
bins=[50,60,70,80,90,100]
[Link](runs,bins,rwidth=0.5)
[Link]('Runs Range')
[Link]('Runs')
[Link]('Batsman Score')
[Link]('[Link]')
[Link](bins)
[Link]()
output:
4c)
i. mysql> create table student(Rollno int primary key,Name varchar(20),dob date,city
varchar(16),Stream varchar(10),Fee decimal(6,2));
ii. mysql> insert into student values(1,'Srinath','2015-11-05','Bangalore','Science',2344.75);
mysql> insert into student values(2,'Supriya','2016-09-25','Nagpur','Humanities',5454.50);
mysql> insert into student values(3,'Chandhan','2018-12-18','Delhi NCR','Arts',1234.56);
mysql> insert into student values(4,'Giri','2012-12-12','Hyderabad','Science',8746.89);
mysql> insert into student values(5,'Kaveri','2015-02-18','Chennai','Science',8746.89);
iii. mysql>select * from student group by stream;
iv. mysql>select count(rollno) from student group by stream;
v. mysql>select name from student where year(DOB)=2015;
vi. mysql>select substr(name,3,4) from student;
vii. mysql>select sum(fee) from student;
SET-5
5a)
import pandas as pd
d={'Name':['Anya','Smith','Bina','Vinay','Arjun'],
'Job':['Clerk','Analyst','Analyst','Clerk','Salesman'],
'Sal':[500,550,480,475,540]}
emp=[Link](d)
print(emp)
i)emp['Dept']=['Maths','Phy','Chem','Comp','Phy']
ii)emp['HRA']=emp['Sal']*0.1
iii) del emp[‘Total’]
(or)
[Link]([‘Total’],axis=1,inplace=
True)
5b) import [Link] as plt
ename=['Hari','Riya','Chandhan','Joe','Mita']
sal=[4000,6000,5000,3500,8000]
[Link](ename,sal,marker='d')
[Link]('Emlpoyee Name')
[Link]('Salary')
[Link]('Employee Salary Details')
[Link]('[Link]')
[Link]()
output:
5c)
i. mysql> create table student(Rollno int primary key,Name varchar(20),dob date,city
varchar(16),Stream varchar(10),Fee decimal(6,2));
ii. mysql> insert into student values(1,'Srinath','2015-11-05','Bangalore','Science',2344.75);
mysql> insert into student values(2,'Supriya','2016-09-25','Nagpur','Humanities',5454.50);
mysql> insert into student values(3,'Chandhan','2018-12-18','Delhi NCR','Arts',1234.56);
mysql> insert into student values(4,'Giri','2012-12-12','Hyderabad','Science',8746.89);
mysql> insert into student values(5,'Kaveri','2015-02-18','Chennai','Science',8746.89);
iii. mysql>select * from student group by stream;
iv. mysql>select sum(fees) from student group by stream having stream=”science”;
v. mysql>select name,city from student where month(DOB)=12;
vi. mysql>select right(name,2) from student;
vii. mysql>select round(fee,0) from student;
SET-6
6. a) import pandas as pd
L=[{'Test1':45,'Test2':58,'Test3':47,'Test4':65},
{'Test1':36,'Test2':85,'Test3':44,'Test4':46},
{'Test1':78,'Test2':96,'Test3':88,'Test4':77},
{'Test1':54,'Test2':50,'Test3':74,'Test4':85}]
marks=[Link](L,index=['Ram','Peter','Alex','John'])
print(marks)
i) print([Link](2))
(or)
print(marks[0:3])
ii) print([Link](2))
iii) marks['Total']=marks['Test1']+marks['Test2']+marks['Test3']+marks['Test4']
6.b) import [Link] as plt
years=[2020,2021,2022,2023,2024]
passpercentage=[95,84,90,95,98]
[Link](years,passpercentage)
[Link]('Year')
[Link]('pass percentage')
[Link]('school pass percentage')
[Link]('[Link]')
[Link]()
output:
6.c)
i. mysql> create table student(Rollno int primary key,Name varchar(20),dob date,city
varchar(16),Stream varchar(10),Fee decimal(6,2));
ii. mysql> insert into student values(1,'Srinath','2015-11-05','Bangalore','Science',2344.75);
mysql> insert into student values(2,'Supriya','2016-09-25','Nagpur','Humanities',5454.50);
mysql> insert into student values(3,'Chandhan','2018-12-18','Delhi NCR','Arts',1234.56);
mysql> insert into student values(4,'Giri','2012-12-12','Hyderabad','Science',8746.89);
mysql> insert into student values(5,'Kaveri','2015-02-18','Chennai','Science',8746.89);
iii. mysql>select * from student group by city;
iv. mysql>select count(rollno) from student group by stream;
v. mysql>select name,city from student where month(DOB)=11;
vi. mysql>select left(name,2) from student;
vii. mysql>select * from student where city=”Nagpur”;
