Lazada Indonesian Reviews

Product reviews from Lazada Indonesia based on categories

@kaggle.grikomsn_lazada_indonesian_reviews

Table List

2 tables(7.24 MB)

N 20191002 Items

N 20191002 Reviews

N 20191002 Reviews

@kaggle.grikomsn_lazada_indonesian_reviews.n_20191002_reviews

6.76 MB
203787 rows
15 columns

itemid ItemId	category Category	name Name	rating Rating	reviewtitle ReviewTitle	reviewcontent ReviewContent	likecount LikeCount	upvotes UpVotes	helpful Helpful	relevancescore RelevanceScore	boughtdate BoughtDate	clienttype ClientType	retrieveddate RetrievedDate
100002528	beli-harddisk-eksternal	Kamal U.	5	nan	bagus mantap dah sesui pesanan			true	26.51	09 Apr 2019	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100002528	beli-harddisk-eksternal	yofanca m.	4	nan	Bagus, sesuai foto			true	22.49	24 Sep 2017	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100002528	beli-harddisk-eksternal	Lazada Customer	5	ok mantaaapppp barang sesuai pesanan.. good	okkkkk mantaaaaaaapppp ... goood			true	21.5	04 Apr 2018	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100002528	beli-harddisk-eksternal	Lazada Customer	4	nan	bagus sesuai			true	20.51	22 Sep 2017	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100002528	beli-harddisk-eksternal	Yosep M.	5	nan	nan			true	16.01	17 Agu 2018	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100002528	beli-harddisk-eksternal	Deden	5	nan	nan			true	16.01	02 Nov 2017	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100002528	beli-harddisk-eksternal	Yeana	5	nan	nan			true	13.01	25 Sep 2017	mobile	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100002528	beli-harddisk-eksternal	nurfarida	1	ada pengirimn ntb bima	bima	4	4	true	7.22	nan	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100003785	beli-harddisk-eksternal	Fadjar B.	1	nan	baru 10 bulan layarnya dah bergaris			true	21.49	06 Apr 2017	androidApp	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
100003785	beli-harddisk-eksternal	agung p.	5	Barang bagus sesuai specs	Pesan rabu sore,minggu sore sampe,,barang sesuai specs mantab,tks lazada			true	19.5	01 Mar 2017	mobile	Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE n_20191002_reviews (
  "itemid" BIGINT,
  "category" VARCHAR,
  "name" VARCHAR,
  "rating" BIGINT,
  "originalrating" DOUBLE,
  "reviewtitle" VARCHAR,
  "reviewcontent" VARCHAR,
  "likecount" BIGINT,
  "upvotes" BIGINT,
  "downvotes" BIGINT,
  "helpful" BOOLEAN,
  "relevancescore" DOUBLE,
  "boughtdate" VARCHAR,
  "clienttype" VARCHAR,
  "retrieveddate" TIMESTAMP
);