Python Foundation

+91-7982108418            

PANDAS DATABASE

1.Write a Pandas program to display all the records of REGIONS file.

REGION.csv

2. Write a Pandas program to display all the location id from locations file.

LOCATIONS.csv

3. Write a Pandas program to extract first 7 records from employees file.

EMPLOYEES.csv

4. Write a Pandas program to select distinct department id from employees file.

DEPARTMENTS.csv

5. Write a Pandas program to display the first and last name, and department number for all employees whose last name is “McEwen”.

EMPLOYEES.csv DEPARTMENTS.csv

6. Write a Pandas program to display the first, last name, salary and department number for those employees whose first name starts with the letter ‘S’.

EMPLOYEES.csv DEPARTMENTS.csv

7. Write a Pandas program to display the first, last name, salary and department number for those employees whose first name does not contain the letter ‘M’.

DEPARTMENTS.csv EMPLOYEES.csv

8. Write a Pandas program to display the first name, last an……………………………………………………………………………………………………………………………………me, salary and department number in ascending order by department number.

DEPARTMENTS.csv EMPLOYEES.csv

9. Write a Pandas program to disp……………….lay the first name, last name, salary and department number in descending order by first name.

DEPARTMENTS.csv EMPLOYEES.csv

10. Write a Pandas program to display the first name, last name, salary and manger id where manager ids are null

EMPLOYEES.csv

11. Write a Pandas program to display the first name, last name, salary and manger id where manager ids are not null.

EMPLOYEES.csv

12. Write a Pandas program to create and display a boolean series, where True for not null and False for null values or missing values in state_province column of locations file.

LOCATIONS.csv

13. Write a Pandas program to create a boolean series selecting rows with one or more nulls from locations file.

LOCATIONS.csv

14. Write a Pandas program to count the NaN values of all the columns of locations file.

LOCATIONS.csv

15. Write a Pandas program to display the first name, last name, salary and department number for those employees whose first name ends with the letter ‘m’.

EMPLOYEES.csv

16.Write a Pandas program to display the first name, last name, salary and department number for those employees whose first name ends with the letter ‘d’ or ‘n’ or ‘s’ and also arrange the result in descending order by department id. EMPLOYEES.csv

17. Write a Pandas program to display the first name, last name, salary and department number for employees who works either in department 70 or 90.

EMPLOYEES.csv

18. Write a Pandas program to display the first name, last name, salary and department number for those employees whose managers are hold the ID 120, 103 or 145.

EMPLOYEES.csv

19. Write a Pandas program to display the first, last name, salary and department number for those employees who holds a letter n as a 3rd character in their first name.

EMPLOYEES.csv

20. Write a Pandas program to display the first name, job id, salary and department for those employees not working in the departments 50,30 and 80. EMPLOYEES.csv……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

21.Write a Pandas program to display the ID for those employees who did two or more jobs in the past.

JOB_HISTORY.csv

22. Write a Pandas program to calculate minimum, maximum and mean salary from employees file.

EMPLOYEES.csv

23. Write a Pandas program to display the details of jobs in descending sequence on job title.

JOBS.csv

24. Write a Pandas program to display the first and last name and date of joining of the employees who is either Sales Representative or Sales Man.

EMPLOYEES.csv

Powered by BetterDocs

Contact Us
close slider

error: Content is protected !!