Reddit R/AskScience Flair Dataset

Dataset for Predicting Post Flair Categories on r/AskScience Subreddit

@kaggle.sumitm004_reddit_raskscience_flair_dataset

Table List

1 table(66.75 MB)

Flair Data

@kaggle.sumitm004_reddit_raskscience_flair_dataset.flair_data

66.75 MB
612668 rows
22 columns

id Id	author Author	author_fullname Author Fullname	domain Domain	question Question	link_flair_css_class Link Flair Css Class	link_flair_text Link Flair Text	description Description	contest_mode Contest Mode	created_utc Created Utc	year Year	retrieved_on Retrieved On	is_self Is Self	num_comments Num Comments	score Score	spoiler Spoiler	thumbnail Thumbnail	banned Banned
421zyl	[deleted]	[deleted]	self.askscience	How is time defined at the big bang?	physics	Physics	[removed]	nan	Thu Jan 21 2016 20:58:09 GMT+0000 (Coordinated Universal Time)	2016	Tue Feb 09 2016 12:21:05 GMT+0000 (Coordinated Universal Time)	true	1	1	nan	default	Yes
4r857d	[deleted]	[deleted]	self.askscience	UFO best scientific explanation. Atmospherical event or meteorite?	geo	Earth Sciences	[removed]	nan	Mon Jul 04 2016 17:05:51 GMT+0000 (Coordinated Universal Time)	2016	Sat Sep 03 2016 18:04:14 GMT+0000 (Coordinated Universal Time)	true	1	1	nan	default	Yes
4r0zwj	De_La_Soul_	t2_tzi58	self.askscience	It's a commonly known fact that metals oxidize, but is it possible for them to ____-dize with other gases?	chem	Chemistry	nan	nan	Sun Jul 03 2016 06:40:06 GMT+0000 (Coordinated Universal Time)	2016	Fri Sep 02 2016 17:31:58 GMT+0000 (Coordinated Universal Time)	true	12	10	nan	self	No
540ohz	MacShakeIt	t2_k15nb	self.askscience	China builds large telescope, but i have a question	astro	Astronomy	[removed]	False	Thu Sep 22 2016 19:17:55 GMT+0000 (Coordinated Universal Time)	2016	Fri Oct 14 2016 11:02:04 GMT+0000 (Coordinated Universal Time)	true	1	1	nan	default	No
4r191k	[deleted]	[deleted]	self.askscience	Geoscientists: Is there any current research into projected shortfalls of key minerals/elements in the next X decades?	geo	Planetary Sci.	[removed]	nan	Sun Jul 03 2016 08:26:38 GMT+0000 (Coordinated Universal Time)	2016	Fri Sep 02 2016 17:34:09 GMT+0000 (Coordinated Universal Time)	true		1	nan	default	Yes
4r18ga	Mitzuiro	t2_oo22s	self.askscience	Why are there so many "accident" babies yet so many people struggle to conceive?	bio	Biology	[removed]	nan	Sun Jul 03 2016 08:19:16 GMT+0000 (Coordinated Universal Time)	2016	Fri Sep 02 2016 17:33:59 GMT+0000 (Coordinated Universal Time)	true		1	nan	default	No
4r15kv	SexyBigEyebrowz	t2_hla0k	self.askscience	I understand how time dialates when we speed up our velocity to near the speed of light, but what happens if we slow down?	physics	Physics	[removed]	nan	Sun Jul 03 2016 07:44:19 GMT+0000 (Coordinated Universal Time)	2016	Fri Sep 02 2016 17:33:20 GMT+0000 (Coordinated Universal Time)	true		1	nan	default	No
4r13on	[deleted]	[deleted]	self.askscience	Could a colonised Mars be shielded from the Sun's atmosphere stripping radiation?	geo	Planetary Sci.	[removed]	nan	Sun Jul 03 2016 07:22:21 GMT+0000 (Coordinated Universal Time)	2016	Fri Sep 02 2016 17:32:53 GMT+0000 (Coordinated Universal Time)	true		1	nan	default	Yes
4r13jj	sulfate4	t2_41chr	self.askscience	To hold your breath longer underwater, should you keep your lungs full or empty? Also, any other scientific tips to extend your breath?	med	Human Body	[removed]	nan	Sun Jul 03 2016 07:20:28 GMT+0000 (Coordinated Universal Time)	2016	Fri Sep 02 2016 17:32:51 GMT+0000 (Coordinated Universal Time)	true	1	1	nan	default	No
4r11ps	My_Bipolar_Account	nan	self.askscience	Why do so many different psychiatric medications cause weight gain?	med	Medicine	[removed]	nan	Sun Jul 03 2016 06:59:31 GMT+0000 (Coordinated Universal Time)	2016	Fri Sep 02 2016 17:32:24 GMT+0000 (Coordinated Universal Time)	true		1	nan	default	No


CREATE TABLE flair_data (
  "id" VARCHAR,
  "author" VARCHAR,
  "author_fullname" VARCHAR,
  "domain" VARCHAR,
  "question" VARCHAR,
  "link_flair_css_class" VARCHAR,
  "link_flair_text" VARCHAR,
  "description" VARCHAR,
  "contest_mode" VARCHAR,
  "created_utc" TIMESTAMP,
  "year" BIGINT,
  "edited" DOUBLE,
  "retrieved_on" TIMESTAMP,
  "over_18" BOOLEAN,
  "is_self" BOOLEAN,
  "locked" BOOLEAN,
  "num_comments" BIGINT,
  "score" BIGINT,
  "spoiler" VARCHAR,
  "stickied" BOOLEAN,
  "thumbnail" VARCHAR,
  "banned" VARCHAR
);