sal.info()
sal[sal['EmployeeName'] == 'JOSEPH DRISCOLL']['JobTitle']
sal[sal['TotalPayBenefits'] == sal['TotalPayBenefits'].max()]
sal.groupby('Year')['BasePay'].mean()
len(sal['JobTitle'].unique())
sal['JobTitle'].value_counts().head(5) #head mai mai value bhi de sakta hu
sum(sal[sal['Year']==2013]['JobTitle'].value_counts() == 1)

sal['jobtitlelen'] = sal['JobTitle'].apply(len)
sal[['jobtitlelen','TotalPayBenefits']].corr() #to find corelation

ecom.info()
ecom['AM or PM'].value_counts() #return the data and counts as info
ecom['Email'].apply(lambda x: x.split('@')[1]).value_counts().head(5)