Top 10 Tech Subreddits
A comprehensive look at posts and comments of tech subreddits
@kaggle.mohamedkhaledelsafty_top_10_tech_subreddits
A comprehensive look at posts and comments of tech subreddits
@kaggle.mohamedkhaledelsafty_top_10_tech_subreddits
This dataset comes from Reddit website.
There are 11 CSV files. Each file represents a tech subreddit, and a combined subreddit file contains 10 tech subreddits.
Our combined subreddits file contains 7003 rows and 10 columns.
Our top 10 tech subreddits are :
Futurology
ProgrammerHumor
apple
buildapcsales
buildapc
gadgets
sysadmin
tech
technews
technology
CREATE TABLE apple (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE buildapc (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE buildapcsales (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE combined_subreddits (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE futurology (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE gadgets (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE programmerhumor (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE sysadmin (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE tech (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE technews (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);CREATE TABLE technology (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);Anyone who has the link will be able to view this.