Telco Product Subscription Data

Network Subscription data

@kaggle.gemalarahmani_telco_product_subscription_data

Table List

3 tables(216.07 KB)

Customerdata

Productplan

Subscriptiondata

Customerdata

@kaggle.gemalarahmani_telco_product_subscription_data.customerdata

15.41 KB
300 rows
8 columns

customer_id Customer ID	customer_name Customer Name	city City	province Province	age Age	region Region	customer_segment Customer Segment	lifetime_value Lifetime Value
1	Waluyo Narpati	Balikpapan	East Kalimantan	21	Urban	Government	1286877.48
2	Aslijan Purnawati, S.Pd	Balikpapan	East Kalimantan	32	Urban	Individual	4250326.66
3	Hasna Ramadan, M.TI.	Balikpapan	East Kalimantan	53	Rural	Enterprise	2122166.07
4	Vinsen Wijaya	Yogyakarta	DI Yogyakarta	32	Rural	Government	1395694.99
5	Aurora Agustina	Makassar	South Sulawesi	46	Rural	Individual	192223.02
6	Dt. Laswi Utama, S.Sos	Balikpapan	East Kalimantan	53	Urban	Individual	5422580.6
7	Ani Nashiruddin, M.Farm	Palembang	South Sumatra	33	Urban	Enterprise	8820555.32
8	Shania Rajasa	Bandung	West Java	40	Rural	SME	4438027.27
9	dr. Danu Wijaya	Palembang	South Sumatra	62	Rural	Individual	6711845.72
10	Wulan Rahayu	Palembang	South Sumatra	36	Urban	SME	2718212.62


CREATE TABLE customerdata (
  "customer_id" BIGINT,
  "customer_name" VARCHAR,
  "city" VARCHAR,
  "province" VARCHAR,
  "age" BIGINT,
  "region" VARCHAR,
  "customer_segment" VARCHAR,
  "lifetime_value" DOUBLE
);