This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Python (34 exercises)
Topic ==>	Overview of Pandas (3 exercises)
Level ==>	Average difficulty
Subject ==>	Python training

Read an Excel workbook into a Pandas dataframe, then perform various operations

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

The Excel workbook above contains the results to date of this year's Poohsticks tournament in the Hundred Acre Wood:

Tigger is in the lead, but Pooh Bear and Roo have only played 2 games each.

Import the pandas module in a new program, then read this workbook into a Pandas dataframe and show information for this using the info method:

Use the read_excel method in pandas to read in the Excel worksheet's data.

Apply the sort_values method to your dataframe to sort the rows by Poohsticks score (highest first) and within this by games played, then pick out the first 3 rows using the head function (or slicing) to show the current 3 leaders:

The leaderboard as things stand.

Apply the rename method to your dataframe, passing in a dictionary of objects where the key is the old name of each column and the value is the new name, to get this:

The dataframe with its new column names.

Finally apply the agg function to your final dataframe, passing in a dictionary where the key to each item is the name of each integer column and the value is a list of statistical functions you want to apply, to get: