562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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:
The minimum, maximum, median and average score and number of games played.
Close your program down!
25 Aytoun Street