I have two columns, [Date Activated] and [Date Closed]. One is the date an account was activated, and the other column is the date an account is closed.
There are three scenarios:
Case 1 (1/6 data) Closed Account: An account has an activated and closed date
- Will result in a value
Case 2 (1/6 data) Active Account: An account has an activated date, but no close date
- Will result in NaT, so it will have to be imputed.
Case 3 (2/3 of the data) Never Activated Account: An account that has neither an activated or closed date.
- Will result in NaT, so it will have to be imputed
For case 2, Should I just take the difference between the current date and date activated for those active accounts?
For case 3, what should I impute the NaT values with? The data isn't missing, it just doesn't have dates since it was never activated and thus never closed. Imputing it with 0's sounds like it would throw off the data for the accounts that were activated and closed on the same day and within a few days.