Questions tagged [churn]

Code churn measures quantify how much change is occurring in your project.

Code churn measures quantify how much change is occurring in your project. In general, high levels of churn indicate project instability. You should expect high rates of churn at the start of a product cycle or after the team has implemented many changes. Toward the end of an iteration or before a release, you should expect the level of churn to decrease, which indicates that your project is more stable.

See http://msdn.microsoft.com/en-us/library/ms244661%28v=vs.110%29.aspx

57 questions
7
votes
1 answer

How to measure C++ or Java file complexity?

I want to start measuring what Michael Feathers has referred to as the turbulence of code, namely churn vs. complexity. To do this, I need to measure the complexity of a C++ or Java file. So I found a couple tools that measure cyclomatic complexity…
2
votes
1 answer

How do I extract for each row in a data frame, the column that contains the first 0 knowing that all the following values have to be zeros too (R)

Let's suppose I have the following data frame: one = c(0, 2, 1, 3, 0, 5) two = c(0, 2, 1, 3, 0, 0) three = c(1, 0, 8, 0, 5, 0) four = c(3, 0, 0, 7, 9, 0) df <- data.frame(one, two, three, four) df For row 1: There is no column containing…
2
votes
1 answer

How to find churned customers on a monthly basis? Python Pandas

I have a large customer dataset, it has things like Customer ID, Service ID, Product, etc. So the two ways we can measure churn are at a Customer-ID level, if the entire customer leaves and at a Service-ID level where maybe they cancel 2 out of 5…
2
votes
1 answer

How to transform and create a pandas column with 0 and 1 based on specific condition

I want to create a column churn as shown. The code should group and compare each year's column Col and assign 0 if it finds Col value in next year. In this example 3rd row is missing from 2017. Hence assigning 1. How do I do this in pandas? State ID…
Priyank
  • 144
  • 10
2
votes
2 answers

How can I incorporate the prior weight in to my GLM function?

I am trying to incorporate the prior settings of my dependent variable in my logistic-regression in r using the glm-function. The data-set I am using is created to predict churn. So far I am using the function below: V1_log <- glm(CH1 ~ RET + ORD +…
Nienke Bos
  • 59
  • 1
  • 5
2
votes
1 answer

Churn Rate From Contract Start & End Dates

I am trying to calculate the churn rate of customer and all I have to play with is contract start & end dates. When the date year is 9999 it just means they are still a customer and I would like to consider account only who have a tenure of more…
Danielle
  • 81
  • 4
1
vote
1 answer

postgres simple churn/retention

I'm trying to create a simple user retention, I tried a lot of ways searching, but none of them seems efficient and most of them have a lot of calculations that I don't really need. Input my table…
1
vote
2 answers

Use SQL to get monthly churn count and churn rate

Currently using Postgres 9.5 I want to calculate monthly churn_count and churn_rate of the search function. churn_count: number of users who used the search function last month but not this month churn_rate: churn_count/total_users_last_month My…
union77
  • 103
  • 7
1
vote
0 answers

What to do when one feature has very large importance/weight?

I am new to Data Science and currently am trying to predict customers churn for a company that offers of subscription-based bookings management software. Its customers are gyms. I have a small unbalanced dataset of a historical data (False 670, True…
Daria
  • 51
  • 5
1
vote
2 answers

How to compare two rows in pandas (across all columns), and sum the output?

I have data like this- User1 User2 User3 User4 User5 User6 User7 User8 w1 1 1 1 1 0 1 1 1 w2 0 1 0 0 1 1 1 1 w3 0 0 1 1 1 1 …
1
vote
1 answer

How to test churn prediction using the data in performance window

I am working on churn prediction. The observation and performance windows are sliced as below: # use user last n.th mounth and create userpofile from this # |## observed period - user profile # |##perdict period-chur or not###| # |<- …
zdz
  • 307
  • 1
  • 2
  • 9
1
vote
0 answers

Churn Prediction Model for an online fashion company

I have been working on a individual project with an online fashion company dataset. I aim building a churn prediction model. In order to do that I set a churn criteria such that a customer turns out to be churn with 12 months inactivity. But I have…
1
vote
0 answers

Feature selection in churn prediction

I have built a churn prediction model for a e-commerce company data. In the model, churn criterion is to be inactive for 12 months from the last available date in the data. While building the model, I created some calculated features to consider the…
1
vote
2 answers

Calculate monthly churn rate in pandas

This is an example of the data I have in my dataframe: test = pd.DataFrame({ 'month': [1,2,3,4,5,6,7,8,9], 'new': [23,45,67,89,12,34,56,90,12], 'drop': [2,4,7,9,1,4,6,9,1], }) month new drop 0 1 23 2 1 2 45 4 2 3 67 7 3…
aviss
  • 2,179
  • 7
  • 29
  • 52
1
2 3 4