Project

HR Data Analysis

Medium

214 completions

~ 19 hours

4.5

This project guides you through advanced data handling and analysis using Python and pandas—from reindexing XML datasets to merging and pivoting data.

Provided by

JetBrains Academy

About

You work as an analyst in a company. The company's HR boss provided you with three datasets. The first two contain information about employees' performance in offices A and B: how much they work, their salaries, the number of their projects, departments, and so on. The third one is an extensive dataset with information on the employees' satisfaction with their jobs, their latest evaluation metrics, and the current status in the company. Your task is to analyze the data and answer some of the HR’s questions.

Graduate project

This project covers the core topics of the Pandas for Data Analysis course, making it sufficiently challenging to be a proud addition to your portfolio.

At least one graduate project is required to complete the course.

What you'll learn

Once you choose a project, we'll provide you with a study plan that includes all the necessary topics from your course to get it built. Here’s what awaits you:

Learn how to load data from the XML format, explore, and reindex it properly.

Practice how to merge several datasets into a big one.

Master the pandas methods to extract insights from the data.

Aggregating pandas DataFrames allows you to quickly find different metrics, such as the mean or standard deviation across other columns. Let's try that out!

Pivot tables are helpful when you want to summarize the data. Explore how to generate them with pandas.

Reviews

Owuor Jack Kamire

5 months ago

4.7

It was a good project to practice data cleaning and descriptive statistics

Fabian Pijcke

6 months ago

5.0

This project is a jewel for providing some hands on experience on concepts learned earlier. I really had fun with this one, and understood how to use indexing, especially in the two last stages.

Anton Teplov

7 months ago

5.0

I like this project, I learn new things about multiindexing and pivoting/melting tables in pandas.

4.5

Learners who completed this project within the Pandas for Data Analysis course rated it as follows:

Usefulness

4.8

Fun

4.4

Clarity

4.3