3. Project - 2 (Case Study - 2) | Data Analysis With Python Pandas | Kaggle Dataset

Project - 2 | Data Analysis With Python Pandas | San Francisco City Employee Salary DataSet Dataset Link: https://www.kaggle.com/kaggle/sf-salaries To perform data analysis, I have mentioned 21 questions that we are going to solve one by one. Questions are as follows. 1. Display Top 10 Rows of The Dataset 2. Check Last 10 Rows of The Dataset 3. Find Shape of Our Dataset (Number of Rows And Number of Columns) 4. Getting Information About Our Dataset Like Total Number Rows, Total Number of Columns, Datatypes of Each Column And Memory Requirement 5. Check Null Values In The Dataset 6. Drop ID, Notes, Agency, and Status Columns 7. Get Overall Statistics About The Dataframe 8. Find Occurrence of The Employee Names (Top 5) 9. Find The Number of Unique Job Titles 10.Total Number of Job Titles Contain Captain 11. Display All the Employee Names From Fire Department 12. Find Minimum, Maximum, and Average BasePay 13. Replace 'Not Provided' in EmployeeName' Column to NaN 14. Drop The Rows Having 5 Missing Values 15. Find Job Title of ALBERT PARDINI 16. How Much ALBERT PARDINI Make (Include Benefits)? 17.Display Name of The Person Having The Highest BasePay 18.Find Average BasePay of All Employee Per Year 19. Find Average BasePay of All Employee Per JobTitle 20. Find Average BasePay of Employee Having Job Title ACCOUNTANT 21. Find Top 5 Most Common Jobs Github Link: https://github.com/PRIYANG-BHATT/Datasets-Youtube-Pandas/tree/main/DS If you enjoy these tutorials, like the video, and give it a thumbs-up, and also share these videos with your friends and families if you think these videos would help him. Please consider clicking the SUBSCRIBE button to be notified of future videos. pandas practice projects pandas projects for beginners pandas python projects pandas project ideas python pandas project ideas python projects using pandas pandas project in python python pandas project example python pandas practice projects pandas project python pandas