Mobile Metrics"

This fictional dataset is for educational purposes

@kaggle.willianoliveiragibin_mobile_metrics

Table List

1 table(54.02 KB)

Smartphone Retail Outlet Sale Data

@kaggle.willianoliveiragibin_mobile_metrics.smartphone_retail_outlet_sale_data

54.02 KB
6421 rows
10 columns

date Date	f_y F.Y	quarter QUARTER	p_no P NO	payment_type PAYMENT TYPE	type_of_product TYPE OF PRODUCT	quantity Quantity	price Price	amount Amount	type_of_accessory_mobile TYPE OF ACCESSORY/MOBILE
01-04-2018	2018-2019	1	P/A/36	CASH	ACCESSORY	1	2042.38	2542.38	COVER
01-04-2018	2018-2019	1	P/A/47	CASH	ACCESSORY	1	2042.38	2118.64	WIRELESS HEADSET
01-04-2018	2018-2019	1	P/M/A34	CREDIT	MOBILE	1	2042.38	13303.58	BUDGET PHONE
01-04-2018	2018-2019	1	P/M/A42	CREDIT	MOBILE	1	2042.38	51696.43	FLAGSHIP PHONE
01-04-2018	2018-2019	1	P/M/A42	DEBIT	MOBILE	1	2042.38	51696.42	FLAGSHIP PHONE
01-04-2018	2018-2019	1	P/M/A43	MOBILE PAYMENTS	MOBILE	1	2042.38	57946.42	FLAGSHIP PHONE
02-04-2018	2018-2019	1	P/M/A19	MOBILE PAYMENTS	MOBILE	1	2042.38	31241.08	PREMIUM MIDRANGE PHONE
02-04-2018	2018-2019	1	P/M/A34	DEBIT	MOBILE	1	2042.38	13303.58	BUDGET PHONE
02-04-2018	2018-2019	1	P/M/A43	CREDIT	MOBILE	1	2042.38	57946.42	FLAGSHIP PHONE
03-04-2018	2018-2019	1	P/A/47	CASH	ACCESSORY	1	2042.38	2203.38	WIRELESS HEADSET


CREATE TABLE smartphone_retail_outlet_sale_data (
  "date" VARCHAR,
  "f_y" VARCHAR,
  "quarter" BIGINT,
  "p_no" VARCHAR,
  "payment_type" VARCHAR,
  "type_of_product" VARCHAR,
  "quantity" BIGINT,
  "price" DOUBLE,
  "amount" DOUBLE,
  "type_of_accessory_mobile" VARCHAR
);