5-Minute Crafts: Video Clickbait Titles?

Video titles of youtube channel 5-minute crafts

@kaggle.shivamb_5minute_crafts_video_views_dataset

Table List

1 table(279.34 KB)

N 5 Minute Crafts

@kaggle.shivamb_5minute_crafts_video_views_dataset.n_5_minute_crafts

279.34 KB
4978 rows
15 columns

video_id Video Id	title Title	active_since_days Active Since Days	duration_seconds Duration Seconds	total_views Total Views	num_chars Num Chars	num_words Num Words	num_punctuation Num Punctuation	num_words_uppercase Num Words Uppercase	num_words_lowercase Num Words Lowercase	num_stopwords Num Stopwords	avg_word_len Avg Word Len	contain_digits Contain Digits	startswith_digits Startswith Digits	title_sentiment Title Sentiment
v=XHTofu5wbbM	SUPER LAZY LIFE HACKS \|\| Cool Hacks To Make Your Life Easier	22	623	295614	60	12	2	4		2	5			0.1444444444444444
v=HGxx0umIQvk	YUM! EASY SMART FOOD HACKS \|\| Tasty Recipes For The Whole Family & Ideas To Avoid Fails	1	739	130544	87	17	4	5		3	5.117647058823529			0.0869047619047619
v=Tt4RMk3Ih04	HELPFUL LIFE HACKS FOR YOUR HOUSE	1	960	17834	33	6		6		2	5.5
v=A2MTydM5e58	USEFUL HACKS FOR YOUR HOME \|\| Simple Tips That Work Extremely Well	30	833	3128867	66	12	2	5		3	5.5			0.0583333333333333
v=_halJ4yrmGQ	ARE YOU A CRAFTY MOM? Amazing Parenting Hacks And Crafts	15	3600	4210362	56	10	1	5		4	5.6			0.5
v=hkgV_8n-iI0	100+ HACKS & GADGETS FOR COOL PARENTS	6	3600	90733	37	7	2	5		1	5.285714285714286	1	1	0.35
v=vws8zmRT_T8	30 BEST HACKS FOR EVERY LIFE SITUATION	60	900	1081439	38	7		6		1	5.428571428571429	1	1	1
v=Yd1l0j6L5x0	KID'S ROOM MAKEOVER IDEAS \|\| Awesome Home Decorating Hacks	2	3660	582492	58	9	3	4			6.444444444444445			1
v=pE-56vEmRXc	Brilliant Clothing Hacks For Adults and Their Kids	3	900	471701	50	8			1	3	6.25			0.9
v=HMbDPgINfto	BRILLIANT LIFE HACKS FOR ANY SITUATION	90	3600	11175800	38	6		6		2	6.333333333333333			0.9


CREATE TABLE n_5_minute_crafts (
  "video_id" VARCHAR,
  "title" VARCHAR,
  "active_since_days" BIGINT,
  "duration_seconds" BIGINT,
  "total_views" BIGINT,
  "num_chars" BIGINT,
  "num_words" BIGINT,
  "num_punctuation" BIGINT,
  "num_words_uppercase" BIGINT,
  "num_words_lowercase" BIGINT,
  "num_stopwords" BIGINT,
  "avg_word_len" DOUBLE,
  "contain_digits" BIGINT,
  "startswith_digits" BIGINT,
  "title_sentiment" DOUBLE
);