Program 1 import pandas as pd df=pd.read_excel(“E://mypandas/employee.xlsx”) # print(df) # print(“———————————————“) # print(df.loc[3,[’empname’,’totalsalary’]]) # print(df.loc[1:5,’empname’:’totalsalary’]) print(“———————————————“) print(df.iloc[:,1:4])
program 1 import pandas as pd df=pd.read_excel(“E://mypandas/employee.xlsx”) # df=df.fillna(0) # print(df) # print(“Before Drop”) # print(df) # df=df.dropna() # print(“After Drop”) # print(“——————————–“) # print(df) print(df[[’empname’,’HRA’]].fillna(0))
Program 1 import pandas as pd df=pd.read_excel(“E://mypandas/mydata.xlsx”,sheet_name=’employee’) print(df.duplicated()) df.drop_duplicates(inplace=True) print(“——————-After Drop——————“) print(df.duplicated()) df.to_excel(“E://mypandas/newdata.xlsx”) #print(df) print(“Success”)
Program 1 import pandas as pd df=pd.read_excel(“E://mypandas/employee.xlsx”) #print(df.sort_index(ascending=False)) #print(df.columns) #print(df.sort_values(‘totalsalary’,ascending=False)) print(df.sort_values(’empname’,ascending=[0]))
Program 1 import pandas as pd #df=pd.read_excel(“E://mypandas/employee.xlsx”) #print(df) #df[‘totalsalary’]=df[‘HRA’]+df[‘TA’]+df[‘DA’] # print(df) # df.to_excel(“E://mypandas/employee.xlsx”,index=False) # print(“Sucess”) #print(df) df=pd.read_csv(“E://mypandas/employee.csv”) df[‘totalsalary’]=df[‘HRA’]+df[‘TA’]+df[‘DA’] df.to_csv(“E://mypandas/employee.csv”,index=False) print(“Sucess”)
Program 1 import pandas as pd # myfile=pd.read_excel(“E://mypandas/mydata.xlsx”,sheet_name=’employee’) df=pd.read_excel(“E://mypandas/mydata.xlsx”,sheet_name=’employee’) # df=pd.DataFrame(myfile) print(df) # df=pd.read_csv(“E://mypandas/employee.csv”) # print(df)
Program 1 import pandas as pd # To Create DataFrame using List # mylist=[0,1,2,3,4,5,6,7,8,9] # df=pd.DataFrame(mylist) # print(df) #empdata={’empid’:[1,2,3,4,5],’empname’:[‘Rahul’,’Nilesh’,’Monu’,’Sonu’,’Ranu’],’salary’:[70000,40000,60000,25000,12000]} #df=pd.DataFrame(empdata) #print(df) # df=pd.read_clipboard() # print(df) #Using ClipBorad data=[(1,’vivek’,8000),(2,’vivek’,8000),(3,’vivek’,8000)] sr=pd.DataFrame(data) print(sr)
Program 1 import pandas as pd mylist=[10,20,30,40,50,60] sr=pd.Series(mylist,index=[‘a’,’b’,’c’,’d’,’e’,’f’],name=”Number Series”) print(sr) # print(sr.name) # print(“Size of Series is “,sr.size) #print(sr.values) #print(sr.empty) # print(sr.ndim) #print(sr.memory_usage()) #print(sr.nbytes) #print(sr.shape) myar=sr.array print(“This is Array”) print(myar)
Program 1 import pandas as pd mylist1=[10,20,15,25,30] mylist2=[5,10,25,30,20] sr1=pd.Series(mylist1) sr2=pd.Series(mylist2) #print(sr1.add(sr2)) #print(sr1+sr2) #print(sr1.sub(sr2)) #print(sr1-sr2) #print(sr1.divide(sr2)) #print(sr1/sr2) #print(sr1.multiply(sr2)) #print(sr1*sr2) #print(sr1%sr2) #print(sr1.gt(sr2)) print(sr1.lt(sr2))
This Python Pandas Quiz will test your knowledge about Pandas and help you gauge where you stand currently. So, be ready to attempt this interesting quiz. Attempt another part of the Python Pandas quiz...
