Python Foundation

+91-7982108418            
Table of Contents

PANDAS EXCEL & PIVOT TABLE

1.Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a Pandas dataframe.

2. Write a Pandas program to get the data types of the given excel data (coalpublic2013.xlsx ) fields.

3. Write a Pandas program to read specific columns from a given excel file.

4. Write a Pandas program to find the sum, mean, max, min value of ‘Production (short tons)’ column of coalpublic2013.xlsx file.

5. Write a Pandas program to insert a column in the sixth position of the said excel sheet and fill it with NaN values.

6. Write a Pandas program to import excel data (coalpublic2013.xlsx ) skipping first twenty rows into a Pandas dataframe.

7. Write a Pandas program to add summation to a row of the given excel file.

8. Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a Pandas dataframe and display the last ten rows.

9. Write a Pandas program to create a subtotal of “Labor Hours” against MSHA ID from the given excel data (coalpublic2013.xlsx ).

10. Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a dataframe and find a specific MSHA ID.

11.Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a dataframe and find details where “Labor Hours” > 20000.

12. Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a dataframe and find details where “Mine Name” starts with “P”.

13. Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a dataframe and find all records that include two specific MSHA ID.

14. Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a Pandas dataframe and find a list of specified customers by name.

15. Write a Pandas program to import excel data (employee.xlsx ) into a Pandas dataframe and find a list of employees where hire_date> 01-01-07.

16. Write a Pandas program to import excel data (employee.xlsx ) into a Pandas dataframe and to sort the records by the hire_date column

17. Write a Pandas program to import excel data (employee.xlsx ) into a Pandas dataframe and find a list of employees where hire_date between two specific month and year.

18. Write a Pandas program to import excel data (employee.xlsx ) into a Pandas dataframe and find a list of employees of a specified year.

19. Write a Pandas program to import excel data (employee.xlsx ) into a Pandas dataframe and convert the data to use the hire_date as the index.

20.Write a Pandas program to import given excel data (employee.xlsx ) into a Pandas dataframe and sort based on multiple given columns.

21. Write a Pandas program to import sheet2 data from a given excel data (employee.xlsx ) into a Pandas dataframe.

22. Write a Pandas program to import three datasheets from a given excel data (coalpublic2013.xlsx ) and combine in to a single dataframe. Note: Structure of the three datasheets are same.

23. Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a dataframe and draw a bar plot where each bar will represent one of the top 10 production.

24. Write a Pandas program to import excel data (coalpublic2013.xlsx ) into a dataframe and draw a bar plot comparing year, MSHA ID, Production and Labor_hours of first ten records.

25. Write a Pandas program to import three datasheets from a given excel data (employee.xlsx ) into a single dataframe and export the result into new Excel file. Note: Structure of the three datasheets are same.


Pivot #

1. Write a Pandas program to create a Pivot table with multiple indexes from a given excel sheet (Salesdata.xlsx). 2. Write a Pandas program to create a Pivot table and find the total sale amount region wise, manager wise.

2.Write a Pandas program to create a Pivot table and find the total sale amount region wise, manager wise, sales man wise.

4. Write a Pandas program to create a Pivot table and find the item wise unit sold.

5. Write a Pandas program to create a Pivot table and find the region wise total sale.

6. Write a Pandas program to create a Pivot table and find the region wise, item wise unit sold.

7. Write a Pandas program to create a Pivot table and count the manager wise sale and mean value of sale amount.

8. Write a Pandas program to create a Pivot table and find manager wise, salesman wise total sale and also display the sum of all sale amount at the bottom.

9. Write a Pandas program to create a Pivot table and find the total sale amount region wise, manager wise, sales man wise where Manager = “Douglas”.

10. Write a Pandas program to create a Pivot table and find the region wise Television and Home Theater sold.

11. Write a Pandas program to create a Pivot table and find the maximum sale value of the items.

12. Write a Pandas program to create a Pivot table and find the minimum sale value of the items.

13.Write a Pandas program to create a Pivot table and find the maximum and minimum sale value of the items.

Powered by BetterDocs

Contact Us
close slider

error: Content is protected !!