PRACTICAL FILE
CLASS – XII
Informatics Practices (New)
1. How to create a series from a list, numpy array and dict?
# Inputs
import numpy as np
mylist = list('abcedfghijklmnopqrstuvwxyz')
myarr = np.arange(26)
mydict = dict(zip(mylist, myarr))
Solution:
ser1 = pd.Series(mylist)
ser2 = pd.Series(myarr)
ser3 = pd.Series(mydict)
print(ser3.head())
Output
a 0
b 1
c 2
d 3
e 4
2. How to combine many series to form a dataframe?
# Input
import numpy as np
ser1 = pd.Series(list('abcedfghijklmnopqrstuvwxyz'))
ser2 = pd.Series(np.arange(26))
# Solution-1
df = pd.concat([ser1, ser2], axis=1)
# Solution-2
df = pd.DataFrame({'col1': ser1, 'col2': ser2})
print(df.head())
col1 col2
0 a 0
1 b 1
2 c 2
3 e 3
4 d 4
3. How to get the items of series A not present in series B?
# Input
ser1 = pd.Series([1, 2, 3, 4, 5])
ser2 = pd.Series([4, 5, 6, 7, 8])
Solution:
ser1[~ser1.isin(ser2)]
Output :
0 1
1 2
2 3
dtype: int64
4. How to get the minimum, 25th percentile, median, 75th, and max of a numeric series?
# Input
state = np.random.RandomState(100)
ser = pd.Series(state.normal(10, 5, 25))
Solution:
np.percentile(ser, q=[0, 25, 50, 75, 100])
Output
array([ 1.39267584, 6.49135133, 10.2578186 , 13.06985067, 25.80920994])
5. How to convert a numpy array to a dataframe of given shape? (L1)
# Input
ser = pd.Series(np.random.randint(1, 10, 35))
Solution:
df = pd.DataFrame(ser.values.reshape(7,5))
print(df)
Output :
0 1 2 3 4
0 1 2 1 2 5
1 1 2 4 5 2
2 1 3 3 2 8
3 8 6 4 9 6
4 2 1 1 8 5
5 3 2 8 5 6
6 1 5 5 4 6
6. How to get the day of month, week number, day of year and day of week from a series of
date strings?
# Input
ser = pd.Series(['01 Jan 2010', '02-02-2011', '20120303', '2013/04/04', '2014-05-05', '2015-
06-06T12:20'])
Solution:
from dateutil.parser import parse
ser_ts = ser.map(lambda x: parse(x))
# day of month
print("Date: ", ser_ts.dt.day.tolist())
# week number
print("Week number: ", ser_ts.dt.weekofyear.tolist())
# day of year
print("Day number of year: ", ser_ts.dt.dayofyear.tolist())
# day of week
print("Day of week: ", ser_ts.dt.weekday_name.tolist())
Date: [1, 2, 3, 4, 5, 6 ]
We number: [53, 5, 9, 14, 19, 23]
Day num of year: [1, 33, 63, 94, 125, 157]
Day of week: ['Friday', 'Wednesday', 'Saturday', 'Thursday', 'Monday', 'Saturday']
7. How to extract all numbers between a given range from a numpy array?
( Get all items between 5 and 10 from a)
Input:
a = np.array([2, 6, 1, 9, 10, 3, 27])
Desired Output:
(array([6, 9, 10]),)
Solution:
a = np.arange(15)
# Method 1
index = np.where((a >= 5) & (a <= 10))
a[index]
# Method 2:
index = np.where(np.logical_and(a>=5, a<=10))
a[index]
#> (array([6, 9, 10]),)
# Method 3: (thanks loganzk!)
a[(a >= 5) & (a <= 10)]
8. How to swap two columns in a 2d numpy array?
Solution:
# Input
arr = np.arange(9).reshape(3,3)
arr
arr[:, [1,0,2]]
#> array([[1, 0, 2],
#> [4, 3, 5],
#> [7, 6, 8]])
9.How to swap two rows in a 2d numpy array?
Solution:
# Input
arr = np.arange(9).reshape(3,3)
arr[[1,0,2], :]
#> array([[3, 4, 5],
#> [0, 1, 2],
#> [6, 7, 8]])
10. How to print only 3 decimal places in python numpy array?
Solution:
# Input
rand_arr = np.random.random((5,3))
# Create the random array
rand_arr = np.random.random([5,3])
# Limit to 3 decimal places
np.set_printoptions(precision=3)
rand_arr[:4]
#> array([[ 0.443, 0.109, 0.97 ],
#> [ 0.388, 0.447, 0.191],
#> [ 0.891, 0.474, 0.212],
#> [ 0.609, 0.518, 0.403]])
11. Write a Program in Pandas to create series using pre-defined array/ create series using user-defined
array/list/ create series using pre-defined list/create Series using Predefined Dictionary/create series using
User-defined Dictionary/ change index in series/print head and tail elements/print according to index
position and condition in python.”””
import pandas as pd
'''#creating series using pre-defined array
data=['a','b','c']
s=pd.Series(data)
print(s)
#creating series using user-defined array/list
#creating an array
ar1=list()
n=int(input("Enter the values for an array"))
print("Enter numbers")
for i in range(0,n):
num=int(input("num:"))
ar1.append(num)
s=pd.Series(ar1)
print(s)
#creating series using pre-defined list
list=['a','b','c']
s=pd.Series(list)
print(s)
list=[[0,1,2,3],['a','b','c'],["vedant","purnendu","rupali"]]
s=pd.Series(list)
print(s)'''
#creating Series using Predefined Dictionary
dic=({'rupali':[9826386977,'rupali@gmail.com'], 'purnendu':[9826911972,'purnendup@gmail.com'],
'vedant':[788990,'vedant@gmail.com']})
s=pd.Series(dic)
print (s)
#creating series using User-defined Dictionary
key=input("Enter the Key")
value=int(input("enter the value"))
dict[key]=value
s=pd.Series(dict)
print (s)
#change index in series
s=pd.Series(data,index=[1,2,3])
print (s)
#printing head and tail elements
print(s.head(2)) #displays first 2 elements
print(s.tail(1)) #displays last 1 elements'''
#printing according to index position and condition
print(s[1])
print("According to Condition")
print(s[s==9826386977])
12. Write a Program to enter data and show data in python using dataFrames and pandas.
import pandas as pd
data = [['Rajiv',10],['Sameer',12],['Kapil',13]]
df = pd.DataFrame(data,columns=['Name','Age'])
print (df)
data1 = {'Name':['Rajiv', 'Sameer', 'Kapil', 'Nischay'],'Age':[28,34,29,42], 'Designation':
['Accountant','Cashier','Clerk','Manager']}
df1 = pd.DataFrame(data1)
print (df1)
13. Write a Program to enter multiple values based data in multiple columns/rows and show that data
in python using dataFrames and pandas.’’’
import pandas as pd
weather_data={
'day':['01/01/2018','01/02/2018','01/03/2018','01/04/2018','01/05/2018','01/01/2018'],
'temperature':[42,41,43,42,41,40],
'windspeed':[6,7,2,4,7,2],
'event':['Sunny','Rain','Sunny','Sunny','Rain','Sunny']
df=pd.DataFrame(weather_data)
print(df)
print("Number of Rows and Columns")
print(df.shape)
print(df.head())
print("Tail")
print(df.tail(2))
print("Specified Number of Rows")
print(df[2:5])
print("Print Everything")
print(df[:])
print("Print Column Names")
print(df.columns)
print("Data from Individual Column")
print(df['day']) #or df.day
print(df['temperature'])
print("Maximum Temperature : ", df['temperature'].max())
print("Printing According to Condition")
print(df[df.temperature>41])
print("Printing the row with maximum temperature")
print(df[df.temperature==df.temperature.max()])
print("Printing specific columns with maximum temperature")
print(df[['day','temperature']][df.temperature==df.temperature.max()])
print("According to index")
print(df.loc[3])
print("Changing of Index")
df.set_index('day',inplace=True)
print(df)
print("Searching according to new index")
print(df.loc['01/03/2018'])
print("Resetting the Index")
df.reset_index(inplace=True)
print(df)
print("Sorting")
print(df.sort_values(by=['temperature'],ascending=False))
print("Sorting on Multiple Columns")
print(df.sort_values(by=['temperature','windspeed'],ascending=True))
print("Sorting on Multiple Columns one in ascending, another in descending")
print(df.sort_values(by=['temperature','windspeed'],ascending=[True,False]))
print("Sum Operations on Data Frame")
print(df['temperature'].sum())
print("Group By Operations")
print(df.groupby('windspeed')['temperature'].sum())
14. Write a Program to read CSV file and show its data in python using dataFrames and pandas.’’’
import pandas as pd
df=pd.read_csv("student.csv", nrows=3)
print("To display selected number of rows from beginning")
print(df)
df=pd.read_csv("student.csv")
print(df)
print("Number of Rows and Columns")
print(df.shape)
print(df.head())
print("Tail")
print(df.tail(2))
print("Specified Number of Rows")
print(df[2:5])
print("Print Everything")
print(df[:])
print("Print Column Names")
print(df.columns)
print("Data from Individual Column")
print(df['Name']) #or df.Name
print(df['Marks'])
print("Maximum Marks : ", df['Marks'].max())
print("Printing According to Condition")
print(df[df.Marks>70])
print("Printing the row with maximum temperature")
print(df[df.Marks==df.Marks.max()])
print("Printing specific columns with maximum Marks")
print(df[['Name','Marks']][df.Marks==df.Marks.max()])
print("According to index")
print(df.loc[3])
print("Changing of Index")
df.set_index('Scno',inplace=True)
print(df)
print("Searching according to new index")
print(df.loc[4862])
print("Resetting the Index")
df.reset_index(inplace=True)
print(df)
print("Sorting")
print(df.sort_values(by=['Marks'],ascending=False))
print("Sorting on Multiple Columns")
print(df.sort_values(by=['Class','Section'],ascending=True))
print("Sorting on Multiple Columns one in ascending, another in descending")
print(df.sort_values(by=['Marks','Name'],ascending=[False,True]))
print("Sum Operations on Data Frame")
print(df['Marks'].sum())
print("Group By Operations")
print(df.groupby('Class')['Marks'].sum())
15. How to compute the mean, median, standard deviation of a numpy array?
# Solution
mu, med, sd = np.mean(sepallength), np.median(sepallength), np.std(sepallength)
print(mu, med, sd)
#> 5.84333333333 5.8 0.825301291785
16. Write a program to create dataframe for 3 students including name and roll numbers and add
new columns for 5 subjects and 1 column to calculate percentage. It should include random
numbers in marks of all subjects
import pandas as pd, numpy as np, random
D={‘Roll’:[1,2,3],’Name’:[‘Sangeeta’,’Shanti’,’Swati’]}
P=[]
C=[]
M=[]
E=[]
H=[]
SD=pd.DataFrame(D)
for i in range(3):
P.append(random.randint(1,101))
C.append(random.randint(1,101))
M.append(random.randint(1,101))
E.append(random.randint(1,101))
H.append(random.randint(1,101))
SD[‘Phy’]=P
SD[‘Chem’]=C
SD[‘Maths’]=M
SD[‘Eng’]=E
SD[‘Hin’]=H
SD[‘Total’]=SD.Phy+SD.Chem+SD.Maths+SD.Eng+SD.Hin
SD[‘Per’]=SD.Total/5
print(SD)
17. Write a complete Program to show database connectivity of python Data Frames with mysql
#database using Student table with all operations involved in the Result Management System .
Solution:
def fetchdata():
import mysql.connector
try:
db = mysql.connector.connect(user='root', password=' ', host=’localhost’,database='test')
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
results = cursor.fetchall()
for cols in results:
nm = cols[0]
st = cols[1]
stream =cols[2]
av=cols[3]
gd=cols[4]
cl=cols[5]
print ("Name =%s, Stipend=%f, Stream=%s, Average Marks=%f, Grade=%s, Class=%d" %
(nm,st,stream,av,gd,cl ))
except:
print ("Error: unable to fetch data")
db.close()
def adddata():
import mysql.connector
nm=input("Enter Name : ")
stipend=int(input('Enter Stipend : '))
stream=input("Stream: ")
avgmark=float(input("Enter Average Marks : "))
grade=input("Enter Grade : ")
cls=int(input('Enter Class : '))
db = mysql.connector.connect(user='root', password='', host=’localhost’, database='test')
cursor = db.cursor()
sql="INSERT INTO student VALUES ( '%s' ,'%d','%s','%f','%s','%d')" %(nm, stipend, stream, avgmark, grade,
cls)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
def updatedata():
import mysql.connector
try:
db = mysql.connector.connect(user='root', password=' ', host=’localhost’,database='test')
cursor = db.cursor()
sql = "Update student set stipend=%d where name='%s'" % (500,'Arun')
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
db.close()
def udata():
import mysql.connector
try:
db = mysql.connector.connect(user='root', password=' ', host=’localhost’, database='test')
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
results = cursor.fetchall()
for cols in results:
nm = cols[0]
st = cols[1]
stream =cols[2]
av=cols[3]
gd=cols[4]
cl=cols[5]
print ("Name =%s, Stipend=%f, Stream=%s, Average Marks=%f, Grade=%s, Class=%d" %
(nm,st,stream,av,gd,cl ))
except:
print ("Error: unable to fetch data")
temp=input("Enter Student Name to Updated : ")
tempst=int(input("Enter New Stipend Amount : "))
try:
#db = mysql.connector.connect(user='root', password=' ', host=’localhost’,database='test')
#cursor = db.cursor()
sql = "Update student set stipend=%d where name='%s'" % (tempst,temp)
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
db.close()
def deldata():
import mysql.connector
try:
db = mysql.connector.connect(user='root', password=' ', host=’localhost’,database='test')
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
results = cursor.fetchall()
for cols in results:
nm = cols[0]
st = cols[1]
stream =cols[2]
av=cols[3]
gd=cols[4]
cl=cols[5]
print ("Name =%s, Stipend=%f, Stream=%s, Average Marks=%f, Grade=%s, Class=%d" %
(nm,st,stream,av,gd,cl ))
except:
print ("Error: unable to fetch data")
temp=input("Enter Student Name to deleted : ")
try:
#db = mysql.connector.connect(user='root', password=' ', host=’localhost’,database='test')
#cursor = db.cursor()
sql = "delete from student where name='%s'" % (temp)
ans=input("Are you sure you want to delete the record : ")
if ans=='yes' or ans=='YES':
cursor.execute(sql)
db.commit()
except Exception as e:
print (e)
try:
db = mysql.connector.connect(user='root', password=' ', host=’localhost’,database='test')
cursor = db.cursor()
sql = "SELECT * FROM student"
cursor.execute(sql)
results = cursor.fetchall()
for row in results:
nm = row[0]
st = row[1]
stream =row[2]
av=row[3]
gd=row[4]
cl=row[5]
print ("Name =%s, Stipend=%f, Stream=%s, Average Marks=%f, Grade=%s, Class=%d" %
(nm,st,stream,av,gd,cl ))
except:
print ("Error: unable to fetch data")
