Analyzing App User Segmentation&Uninstall Behavior

User segmentation in an app involves categorizing users based ontheir engagement

@kaggle.cs49adityarajsharma_app_segmentation_using_k_means_algorithm

Table List

1 table(22.6 KB)

Userbehaviour

@kaggle.cs49adityarajsharma_app_segmentation_using_k_means_algorithm.userbehaviour

22.6 KB
999 rows
8 columns

userid Userid	average_screen_time Average Screen Time	average_spent_on_app_inr Average Spent On App (INR)	left_review Left Review	ratings Ratings	new_password_request New Password Request	last_visited_minutes Last Visited Minutes	status Status
1001	17	634	1	9	7	2990	Installed
1002		54		4	8	24008	Uninstalled
1003	37	207		8	5	971	Installed
1004	32	445	1	6	2	799	Installed
1005	45	427	1	5	6	3668	Installed
1006	28	599		9	4	2878	Installed
1007	49	887	1	9	6	4481	Installed
1008	8	31		2	1	1715	Installed
1009	28	741	1	8	2	801	Installed
1010	28	524	1	8	4	4621	Installed


CREATE TABLE userbehaviour (
  "userid" BIGINT,
  "average_screen_time" DOUBLE,
  "average_spent_on_app_inr" DOUBLE,
  "left_review" BIGINT,
  "ratings" BIGINT,
  "new_password_request" BIGINT,
  "last_visited_minutes" BIGINT,
  "status" VARCHAR
);