Used Phones & Tablets Pricing Dataset

Sample pricing data for analysis of refurbished used handheld devices

@kaggle.ahsan81_used_handheld_device_data

Table List

1 table(100.96 KB)

Used Device Data

@kaggle.ahsan81_used_handheld_device_data.used_device_data

100.96 KB
3454 rows
15 columns

device_brand Device Brand	os Os	screen_size Screen Size	n_4g 4g	n_5g 5g	rear_camera_mp Rear Camera Mp	front_camera_mp Front Camera Mp	internal_memory Internal Memory	ram Ram	battery Battery	weight Weight	release_year Release Year	days_used Days Used	normalized_used_price Normalized Used Price	normalized_new_price Normalized New Price
Honor	Android	14.5	yes	no	13	5	64	3	3020	146	2020	127	4.307572449	4.715100245
Honor	Android	17.3	yes	yes	13	16	128	8	4300	213	2020	325	5.162096647	5.519017936
Honor	Android	16.69	yes	yes	13	8	128	8	4200	213	2020	162	5.111083765	5.884630724
Honor	Android	25.5	yes	yes	13	8	64	6	7250	480	2020	345	5.135386588	5.630960854
Honor	Android	15.32	yes	no	13	8	64	3	5000	185	2020	293	4.389994804	4.947837479
Honor	Android	16.23	yes	no	13	8	64	4	4000	176	2020	223	4.413888608	5.060694494
Honor	Android	13.84	yes	no	8	5	32	2	3020	144	2020	234	3.878259375	4.518958489
Honor	Android	15.77	yes	no	13	8	64	4	3400	164	2020	219	4.729421148	5.18872569
Honor	Android	15.32	yes	no	13	16	128	6	4000	165	2020	161	4.886054204	5.299916088
Honor	Android	16.23	yes	no	13	8	128	6	4000	176	2020	327	4.773223771	5.073610093


CREATE TABLE used_device_data (
  "device_brand" VARCHAR,
  "os" VARCHAR,
  "screen_size" DOUBLE,
  "n_4g" VARCHAR,
  "n_5g" VARCHAR,
  "rear_camera_mp" DOUBLE,
  "front_camera_mp" DOUBLE,
  "internal_memory" DOUBLE,
  "ram" DOUBLE,
  "battery" DOUBLE,
  "weight" DOUBLE,
  "release_year" BIGINT,
  "days_used" BIGINT,
  "normalized_used_price" DOUBLE,
  "normalized_new_price" DOUBLE
);