Determining Which Hacker News Postings Drive More Engagement
Hacker News is a startup and tech news site that consists of user-submitted stories. Due to its popularity, highly-ranked posts can get hundreds of thousands of visitors.
In this project, we'll be analyzing Hacker News data to understand which postings drive more engagement. The results will help inform the best strategies for posting to Hacker News.
To make our recommendation, we'll try to find out:
Show HNposts receive more comments on average?
- Do posts created at a certain time receive more comments on average?
After analyzing the data, we learned
Ask HN posts which are published at 3pm receive the highest average number of comments.
For more details, please refer to the full analysis below.
Revisit this section to learn what's happening under the hood for a given function.
We used a Hacker news dataset containing approximately 20,000 rows. Below are descriptions of the columns:
id: Unique identifier for the post
title: Title of the post
url: URL that the post links to
num_points: Number of points the post acquired, calculated as the total number of upvotes minus the total number of downvotes
num_comments: Number of comments that were made on the post
author: Username of the person who submitted the post
created_at: Date and time at which the post was submitted
Here are the first few rows:
Extracting Ask HN and Show HN Posts
Ask HN and
Share HN posts share roughly the same percentage of posts.
Average Number of Comments for Each Category
Ask HN, on average, receives the most comment per posts (
Show HN receives the least (
It's worthwhile investigating how the popularity of these postings differ by hour posted.
Number of Comments by the Hour the Post was Created
Ask HN Comments by Hour Post Created
Show HN Comments by Hour Post Created
Other HN Comments by Hour Post Created
Analying these 3 groups suggest that the majority of comments are on posts created between 2-5pm.
Average Number of Comments by the Hour the Post was Created
Average Ask HN Comments by Hour Post Created
Average Show HN Comments by Hour Post Created
Average Other HN Comments by Hour Post Created
Ask HN, people are more likely to comment between the hours of 12-3pm. Note that 3pm sees a particularly high avg comment number.
Show HN and the
Other category, people are most likely to comment around 12pm.
Recommendations for Posting to Hacker News
From our analysis, it's clear that
Ask HN posts receive the most comments per post (
10.39) by a wide margin.
Of this category, posts that were published at 3pm received the highest average number of comments.
To maximise engagement on posts, our recommendations are thus as follows:
- Publish those posts at 3pm.
In this project, we analyzed Hacker News data to determine which Hacker News postings drive the most engagement.
The conclusion we arrived at was that
Ask HN posts which are published at 3pm are receved the highest average number of comments.