Sparkify users churn prediction

The case solvation consists of:

The shape of the dataset is 286500 rows and 18 columns. The one record display that the user Colin Freeman listened the song Rockpools by Martha Tilston.

The data is not a dataset. It is a part of log file. This data does not consist of any features could be using for prediction directly. All of the data columns are using to describe a user or a user action. We can see the 18th columns in the dataframe and we have to determine which column contains the information about user churn.

We have to explore dataframe columns. And the first task is to determine target to predict. Column ‘page’ have this information.

The visiting counts of the ‘Cancel’ and ‘Cancellation Confirmation’ are 52. These rows contain the information about churned users.

Handling null values

Initial dataset has null values in some columns. We can see that columns ‘firstName’ and ‘LastName’ have 8346 null values. Furthermore, the column ‘userAgent’ includes the 8346 null values too.

Related posts:

If he had to give a reason, he might have said it was because the man took his shoes off. But, of course, Michael did not need a reason. Previously, Michael entered the cafe on S. street. It was…

Many small businesses are finding that PPP loans are far more difficult to use than advertised. Here are some alternatives to PPP loans.

Saturdays are for the boys, shirtless and howling through the streets. The boys who are, legally and physically, grown men, but who also, at least for Saturday, are boys. Our boys. Saturday is like…