Delinquency Telecom Dataset

Historic Delinquency Telecom Data

@kaggle.sivakrishna3311_delinquency_telecom_dataset

Table List

1 table(12.42 MB)

Sample Data Intw

Sample Data Intw

@kaggle.sivakrishna3311_delinquency_telecom_dataset.sample_data_intw

12.42 MB
209593 rows
36 columns

label Label	msisdn Msisdn	aon Aon	daily_decr30 Daily Decr30	daily_decr90 Daily Decr90	rental30 Rental30	rental90 Rental90	last_rech_date_ma Last Rech Date Ma	last_rech_date_da Last Rech Date Da	last_rech_amt_ma Last Rech Amt Ma	cnt_ma_rech30 Cnt Ma Rech30	fr_ma_rech30 Fr Ma Rech30	sumamnt_ma_rech30 Sumamnt Ma Rech30	medianamnt_ma_rech30 Medianamnt Ma Rech30	medianmarechprebal30 Medianmarechprebal30	cnt_ma_rech90 Cnt Ma Rech90	fr_ma_rech90 Fr Ma Rech90	sumamnt_ma_rech90 Sumamnt Ma Rech90	medianamnt_ma_rech90 Medianamnt Ma Rech90	medianmarechprebal90 Medianmarechprebal90	cnt_da_rech90 Cnt Da Rech90	cnt_loans30 Cnt Loans30	amnt_loans30 Amnt Loans30	maxamnt_loans30 Maxamnt Loans30	cnt_loans90 Cnt Loans90	amnt_loans90 Amnt Loans90	maxamnt_loans90 Maxamnt Loans90	payback30 Payback30	payback90 Payback90	pcircle Pcircle	pdate Pdate
	21408I70789	272	3055.05	3065.15	220.13	260.13	2		1539	2	21	3078	1539	7.5	2	21	3078	1539	7.5		2	12	6	2	12	6	29	29	UPW	20-07-2016
1	76462I70374	712	12122	12124.75	3691.26	3691.26	20		5787	1		5787	5787	61.04	1		5787	5787	61.04		1	12	12	1	12	12			UPW	10-08-2016
1	17943I70372	535	1398	1398	900.13	900.13	3		1539	1		1539	1539	66.32	1		1539	1539	66.32		1	6	6	1	6	6			UPW	19-08-2016
1	55773I70781	241	21.228	21.228	159.42	159.42	41		947						1		947	947	2.5		2	12	6	2	12	6			UPW	06-06-2016
1	03813I82730	947	150.6193333	150.6193333	1098.9	1098.9	4		2309	7	2	20029	2309	29	8	2	23496	2888	35		7	42	6	7	42	6	2.333333333	2.333333333	UPW	22-06-2016
1	35819I70783	568	2257.362667	2261.46	368.13	380.13	2		1539	4	10	6156	1539	15.4	8		11744	1539	55.9		3	18	6	3	18	6	11	8.333333333	UPW	02-07-2016
1	96759I84459	545	2876.641667	2883.97	335.75	402.9	13		5787	1		5787	5787	277.8	1		5787	5787	277.8		1	6	6	1	6	6			UPW	05-07-2016
1	09832I90846	768	12905	17804.15	900.35	2549.11	4	55	3178	3	3	10404	3178	36	9	3	26095	3178	36	1	3	18	6	7	42	6	6	3.857142857	UPW	05-08-2016
1	59772I84450	1191	90.695	90.695	2287.5	2287.5	1		1539	4	1	6164	1539	39.9	4	1	6164	1539	39.9		4	24	6	4	24	6	2.666666667	2.666666667	UPW	15-06-2016
1	56331I70783	536	29.35733333	29.35733333	612.96	612.96	11		773	1		773	773	86.8	1		773	773	86.8		1	6	6	1	6	6			UPW	08-06-2016


CREATE TABLE sample_data_intw (
  "label" BIGINT,
  "msisdn" VARCHAR,
  "aon" DOUBLE,
  "daily_decr30" DOUBLE,
  "daily_decr90" DOUBLE,
  "rental30" DOUBLE,
  "rental90" DOUBLE,
  "last_rech_date_ma" DOUBLE,
  "last_rech_date_da" DOUBLE,
  "last_rech_amt_ma" BIGINT,
  "cnt_ma_rech30" BIGINT,
  "fr_ma_rech30" DOUBLE,
  "sumamnt_ma_rech30" DOUBLE,
  "medianamnt_ma_rech30" DOUBLE,
  "medianmarechprebal30" DOUBLE,
  "cnt_ma_rech90" BIGINT,
  "fr_ma_rech90" BIGINT,
  "sumamnt_ma_rech90" BIGINT,
  "medianamnt_ma_rech90" DOUBLE,
  "medianmarechprebal90" DOUBLE,
  "cnt_da_rech30" DOUBLE,
  "fr_da_rech30" DOUBLE,
  "cnt_da_rech90" BIGINT,
  "fr_da_rech90" BIGINT,
  "cnt_loans30" BIGINT,
  "amnt_loans30" BIGINT,
  "maxamnt_loans30" DOUBLE,
  "medianamnt_loans30" DOUBLE,
  "cnt_loans90" DOUBLE,
  "amnt_loans90" BIGINT,
  "maxamnt_loans90" BIGINT,
  "medianamnt_loans90" DOUBLE,
  "payback30" DOUBLE,
  "payback90" DOUBLE,
  "pcircle" VARCHAR,
  "pdate" VARCHAR
);