Generate Summary Statistics Using the pandas Python Package

The Scenario

You are working as a database admin and overhear some coworkers arguing in the breakroom. Needing a coffee refill, you venture closer and learn there is a disagreement over the average age of men versus women in the workforce.

You recall a friend in web development previously shared a copy of the US census data with you. This data — combined with the pandas skills you acquired from the ACG courses you've been watching — can resolve this breakroom bickering. You quickly return to your workstation to complete the following tasks:

• Load the CSV file.
• Confirm the data.
• Find the average age of men versus women workers.

Work quickly and bring your findings back to the breakroom, before things get out of hand!

Log in to the server over SSH using the credentials provided.

The data.csv file is already available in your workstation (the lab instance), but if you'd like to follow along on another machine, you can download it from here.

The data was sourced from the Center for Machine Learning and Intelligent Systems. Learn more here.