Dataset For Data Mining

dataset data mining

I have just enrolled in a Data Science course on Udemy  and I learned good stuff.

To have the dataset to do Data Mining, you need to go to the superdatascience website . In « Part.1 Visualization », you see the section « How to use Tableau for Data Mining ». Click on « Churn Modeling » to download the file.

dataset data mining

Once you have downloaded the file, move the file to the directory you created for the course. In this directory, create a new directory (unless you already do it) named « 2.Chunk investigation ».

dataset data mining

dataset data mining

Open this fiel with Excel or with other spreadsheet software.

dataset data mining

Know that we use this dataset for the visualization part but we will also use this dataset for the modeling part.

Let’s analyze the data of this dataset.

This dataset is quite large because it contains 10 000 lines and a few columns. This is the list of a bank’s client. The client information is :

  • Customer id (login)

  • Surname (last name)

  • Credit score ( is the measure that indicates the client’s ability to borrow)

  • Geography (client’s country)

  • Gender (male or female)

  • Age

  • Tenure -(the number of years the client is in the bank)

  • Balance (balance of the client’s bank account)

  • NumOfProduct (number of product that the client has in the bank – credit card, contract, account)

  • HasCrCard (does the client have a credit card ?)

  • IsActiveMember (did the client use his/her credit card during the last month ?)

  • EstimatedSalary (the bank’s estimate of the client’s annual salary)

  • Exited (did the client leave the bank ?)

Now, I will explain the context related to this dataset. This bank has branches in several countries like Germany, Spain and France. This bank noticed that lately there were many clients who left the bank. The bank has a report called « churn rate » which is the customers rate who leave the bank and for a few months the « churn rate » is really higher than usual. It’s for this reason that the bank needs a data scientist (you) to find the problem and propose solutions.

This dataset is a small sample of clients bank. These are 10 000 randomly selected client.

The column « Exited » is a column that didn’t exist before. This column has created when the bank realized that there was an abnormal number of client who were leaving the bank.

dataset data mining

Then the bank observed these clients for 6 months to see which client left the bank.

dataset data mining

In the « Exited » column, the number « 1 » means that the client left the bank and the number « 0 » means that the client stayed in the bank.

To analyze this dataset, you’ll need to do A/B Tests. For exemple, a classic A/B Test is to see if women are more likely to left the bank than men. That’s means, see the number of men who left the bank, see the number of women who left the bank and then normalize by the total number of clients. It’s important to normalize the number of clients because there are not the same proportions of women as men. Next, based on the last column « Exited », you’ll find out if it’s the men or women who are likely to left the bank.

Once you have relevant results, you can show your report to the bank. And with this report you should be able to propose solutions to the bank. For example, if the report says that women leave the bank in bulk, it’s because there is a problem and it’s necessary to see whether the bank is offering women something right. Or it’s possible that another bank offers a much more attractive offer for women or something else.

You will learn how to investigate in the dataset and find answer through client information with A/B tests.

Share this article if you think it can help someone you know. Thank you.

-Steph

Please follow, like and share:

Rest Day

rest day

I read a Nerd Fitness article  about rest day and I want to share this with you.

Training program

In each training program, there is at least one rest day. During your training, you make micro breaks in your muscles and it takes around 24-48 hours to repair. There are no mental or physical benefits of training non-stop. We don’t want to destroy our muscles without giving them a chance to become stronger.

What we’re supposed to do during the rest days ?

It’s coming, it’s coming.

Plan your rest days

The problem with most people is that they use rest day as a « cheat day ». Because it’s a day without training, they don’t think to stay physically fit and do anything.

THIS IS NOT GOOD !

Remember that training only corresponds to 20% and food 80% of the equation to have a good physical condition.

Program your rest days as your program your training days. This isn’t a day off like at school or at work, it’s a rest day.

Program activities in your rest day like stretching or prepare all the meals for the week.

My rest day is cardio and stretching.

Stretching

stretching

After a training day, our muscles have micro breaks and are very tight during weight lifting. For this reason stretching is great to do during rest day to work on your flexibility and your mobility. It’s a good idea to have a strong body but if you can’t move your body correctly to use it well, all this is useless.

A fun activity

Genetically we’re designed to move, we aren’t designed to sit more than 60 hours per week. This means that during our rest days, we have to work on our happiness and stay active simultaneously.

A fun activity can be different for each person :

  • Ride a bike

  • Jogging

  • Play football / basketball

  • Swim

  • Go hiking

  • Rock climbing

  • Learn a martial art like Taekwondo, Kung fu or Brazilian Jiu Jitsu

  • Take a dance class

  • Try Live Action Role-Playing

No matter what it is, do an activity you like to do, an activity that makes you smile. The only important thing is to do an activity that moves your body and it doesn’t need to be an exhausting activity.

Yoga or Tai Chi

yoga

tai chi

These two activities are a perfect complement to your training. Training makes you stronger but it makes stiff our muscles too.

Yoga or Tai Chi lengthens our muscle and our tendons, aids in their recovery and helps our body to develop a better mobility and flexibility.

Now with YouTube, you can find videos about stretching and Yoga or Tai Chi but maybe you prefer to subscribe to a class, it’s up to you.

Stay focus on your goal even a day without training.

What is your rest day program ?

-Steph

PS: Do you want a free training program? Click 

Please follow, like and share: