Skip to main content
HomePythonCleaning Bank Marketing Campaign Data
Premium project

Cleaning Bank Marketing Campaign Data

4.2+
11 reviews
Beginner

Tidy a bank marketing campaign dataset by splitting it into subsets, updating values, converting data types, and storing it as multiple csv files.

Start Project
1 Tasks1,500 XP

Loved by learners at thousands of companies


Project Description

Data cleaning is an essential skill for data engineers, encompassing reading, modifying, splitting, and storing data.

In this notebook, you will apply your data-cleaning skills to process information about marketing campaigns run by a bank.

You will need to modify values, add new features, convert data types, and save data into multiple files.

Project Tasks

  1. 1
    Use your data-cleaning skills to modify and process bank marketing campaign data!

Technologies

Python Python

Topics

Programming
George Boorman HeadshotGeorge Boorman

Curriculum Manager, DataCamp

George is a Curriculum Manager at DataCamp. He holds a PGDip in Exercise for Health and BSc (Hons) in Sports Science and has experience in project management across public health, applied research, and not-for-profit sectors. George is passionate about sports, tech for good, and all things data science.
See More

Don’t just take our word for it

*4.2
from 11 reviews
55%
18%
27%
0%
0%
Sort by
  • Alysson C.
    about 5 hours

    It's a good project.

  • Bob J.
    4 months

    This is a very good challenging exercise for data cleaning

  • Charbel B.
    6 months

    Would be nice to actually manipulate the PostgreSQL database.

  • Mehdi Z.
    6 months

    I was stuck with this project just because I kept receiving a wrong feedback on my code

  • Jordan D.
    8 months

    The instructions needs to stick to one level of detail. I love being able to solve the task how I see fit, but the instructions seem to mislead in certain ways. Based on the data engineering career path, I strongly believe that if we want to focus on writing efficient python, that should have been added into the mix. If we wanted to be more hands free, the instructions should be more along the lines of "the data isn't perfect, please do EDA to determine what needs to be cleaned to match the desired output." Instead, the instructions currently tell you certain things to do but leave out others which makes me think it isn't a problem until you run the script (i.e month field is a string "may, jun, etc."). The last thing is part of the code requires the code written to be exactly as expected which drove me crazy (creation table part). I didn't like the fact that I had to call out the foreign key in a different way than I thought it should be but it may have been the type of sql. But the sql was different from the other practices. Please stick to one.

"It's a good project."

Alysson C.

"This is a very good challenging exercise for data cleaning"

Bob J.

"Would be nice to actually manipulate the PostgreSQL database."

Charbel B.

FAQs

What do other learners have to say?