Program 1 import pandas as pd df=pd.read_excel(“E://mypandas/employee.xlsx”) #print(df.loc[df[‘totalsalary’]>10000]) #print(df.loc[~(df[‘gender’]==’male’) & (df[‘totalsalary’]>10000)]) #print(df.loc[(df[’empdept’]==’CS’) | (df[‘gender’]==’male’)]) #print(df.loc[df[’empname’].str.contains(‘a’)])
Program 1 import pandas as pd df=pd.read_excel(“E://mypandas/employee.xlsx”) #print(df.head(3)) #print(df.tail(3)) #print(df.columns) # #print(df[[’empname’,’totalsalary’]]) # print(df[1:11:2]) #[start:stop:step] print(df[[’empname’,’totalsalary’]][1:11])
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)
