1.
import pandas as pd
l1={'Khushi':42536,'Shambhavi':67577,'Bhavika':64355}
s=[Link](l1)
print(s)
2.
import pandas as pd
ser=[Link](64559,index=range(1,6,2))
print(ser)
3.
import pandas as pd
ser=[Link](64559,index=range(1,6,2))
print(ser)
4.
import pandas as pd
import numpy as np
s=["Shambhavi","Khushi",[Link],"bhavika",[Link],"Abhi",[Link]]
b=[Link](s)
[Link]='Students'
[Link]='Series'
print(b)
print([Link])
print([Link])
print([Link])
print([Link])
print([Link])
print([Link])
print([Link])
print([Link])
print([Link])
print([Link])
print([Link])
5.
import pandas as pd
import numpy as np
Ser1=[Link]([1.8,-2.75,-3.25,45.05,5.5])
n=[1.5,12.50,24.00,14.50,55.50]
i=['A','B','C','D','E']
Ser2=[Link](n)
Ser3=[Link](n,i)
#print(Ser1,Ser2,Ser3)
'''print(Ser1+198)
print(Ser1*29)
print(Ser1**5)
print(Ser1>34)
print(Ser2+878)
print(Ser2*19)
print(Ser2**2)
print(Ser2>1.5)
print(Ser3+5607)
print(Ser3*16)
print(Ser3**4)
print(Ser3>9)'''
print(Ser1*Ser2)
print(Ser2+Ser1)
print(Ser2/Ser1)
print(Ser1-Ser3)
6. import pandas as pd
STUDS=[Link]([56,76,92,89,94,72,91,90,95,93])
[Link]=['Alice', 'Bob', 'Charlie', 'David', 'Eve', 'Frank', 'Grace', 'Hannah', 'Isaac', 'Judy']
[Link](STUDS[STUDS>90])
c..top_3_scorers = STUDS.sort_values(ascending=False).head(3)
print(top_3_scorers)
d.STUD_NEW= STUDS.sort_values(ascending=False)
print(STUD_NEW)
[Link][Link] = 95
print(STUDS)
Q7.
import pandas as pd
r=[79.50,'Cricekt','Ruchika']
n=[83.75,'Badminton','Neha']
m=[74.00,'Football','Mark']
j=[89.00,'Kabaddi','Jamal']
g=[88.50,'Athletics','Gurjyot']
S_DATA=[Link]((r,n,m,g,j),columns=['Marks','Sport','Students'])
print(S_DATA)
8.
people={'Sales':{"name":'Rohit','age':24,'gender':'Male'},
'Marketing':{"name":'Shambhavi','age':27,'gender':'Female'}}
df1=[Link](people)
print(df1)
9.
A={'Rollno.':12104,'Name':'Sakshi','Marks':67}
B={'Rollno.':12213,'Name':'Rudra','Marks':97}
C={'Rollno.':12306,'Name':'Gautam','Marks':77}
D={'Rollno.':12436,'Name':'Ruby','Marks':72}
top=[A,B,C,D]
df1=[Link](top)
print(df1)
10.
import pandas as pd
l=[[30,80,90],[307,68,990],[9087,760,345],[990,8976,897],[234,675,8]]
df=[Link](l,index=[row1,row2,row3,row4,row5])
print(df)
11.
import pandas as pd
import numpy as np
ar=[Link]([[101,102,103],[111,112,113],[121,122,123]])
df=[Link](ar)
print(df)
12.
import pandas as pd
import numpy as np
days=['Monday','Tuesday','Wednesday','Thrusday','Friday']
classes=[6,0,3,0,8]
dc={'Days':days,'No of Classes':classes}
df=[Link](dc,index=[True,False,True,True,False])
print(df)
13.
1.
[Link](index={'Sharad':1,'Mansi':2,'Kanika':3,'Ramesh':4,'Ankita':5,'Pranay':6}
,inplace=True)
print(RESULTSHEET)
2.
[Link](columns={'UT1':'Term1','Half
Yearly':'Term2','UT2':'Term3','Final':'Term4'},inplace=True)
print(RESULTSHEET)
3.
RESULTSHEET['Internal Assessment']=['A', 'A','B','A','C','B']
print(RESULTSHEET)
4.
[Link]['Asatha',:]=[49, 56, 75,58]
print(RESULTSHEET)
5.
del RESULTSHEET['UT1']
print(RESULTSHEET)
6.
RESULTSHEET=[Link](['Kanika'])
print(RESULTSHEET)
7.
[Link](index={'Mansi':'Mahak'},inplace=True)
print(RESULTSHEET)
8.
print([Link]['Mansi'])
9.
print([Link][['Sharad':’Pranay’,['Half Yearly','Final']])
10.
print([Link]['Mansi':'Ankita',:])
11.
print([Link]['Mansi':'Ankita',['UT1','UT2']])
12.
print([Link][['Kanika','Ankita'],['Half Yearly','Final']])
13.
print([Link](3))
14.
print([Link](4))
Que.14
import [Link] as plt
Years= [2000,2004,2005,2006,2008,2010,2012,2014,2015,2016,2018,2020]
Salary= [10000,14000,18000,20000,24000,28000,30000,34000,38000,40000,44000,48000]
[Link]('Year')
[Link]('Salary')
[Link]('Salary Hike of an Employee')
[Link](Years,Salary,'r',linewidth=4)
[Link](Years,Years,color='r',label='line1')
[Link](loc='upper left')
[Link]()
[Link](“[Link]”)
15.
import [Link] as plt
Category = ['gold', 'silver', 'bronze']
Medal = [10,15,8]
[Link](Category,Medal,color=['gold','silver','brown'])
[Link]('Medal')
[Link]('Medal Type')
[Link]('Indian Medal Tally in Olympics')
[Link]("Medal",'Medal',color='gold',label='goldmedal')
[Link]("Medal",'Medal',color='silver',label='silvermedal')
[Link]("Medal",'Medal',color='brown',label='bronze')
[Link](loc='upper left')
[Link]()
[Link]("[Link]")
