Premium project
Streamlining Employee Data
Use DataFrames to read and merge employee data from different sources.
Start Project8 Tasks1,500 XP
Loved by learners at thousands of companies
Project Description
Wouldn't it be great if your data was stored in your favorite format, ready to be analyzed? Unfortunately, that's rarely the case. Data comes in different formats, and being able to merge these different sources in a single file for analysis is a fundamental skill for any data practitioner.
In this project, you will import employee and human resources data in CSV, Excel, and JSON format. You will then merge it all into a single DataFrame, before cleaning it and exporting your results into a single CSV file.
Project Tasks
- 1Loading data from CSV and Excel files
- 2Loading employee data from Excel sheets
- 3Loading role data from JSON files
- 4Merging several DataFrames into one
- 5Editing column names
- 6Changing column order
- 7The last minute request
- 8Saving your work
Technologies
Python
Hadrien Lacroix
Curriculum Manager at DataCamp
Hadrien has collaborated on 30+ courses ranging from machine learning to database administration through data engineering. He's currently enrolled in a Masters of Analytics at Georgia Tech.
Hadrien started using DataCamp when the platform only had 27 courses. He then joined the Support team and helped students before becoming a Content Developer himself.
Follow Hadrien on LinkedIn
Hadrien started using DataCamp when the platform only had 27 courses. He then joined the Support team and helped students before becoming a Content Developer himself.
Follow Hadrien on LinkedIn