so, it displays what the output of step 6 should be; a variety of average comments by hour.
my code instead displayed .5 for all averages, which is startlingly wrong.
Basics (1).ipynb (10.2 KB)
edit: so after i had the total comments per category printed, i should be distributing out 24000 comments, averaging 1000 comments per hour.
but both count by hour and count by post are getting a couple hundred
def com_count(post_section):
total_comments = 0
for row in post_section:
com_count = int(row[4])
total_comments += com_count
avg_comments = round(total_comments / len(post_section),4)
print(avg_comments)
print(total_comments)
output;
The average and total number of comments on Ask HN posts is:
14.0315
24485
The average and total number of comments on Show HN posts is:
10.3021
12002
import datetime as dt
result_list = []
for row in ask_posts:
created_at = row[6]
comments = int(row[4])
result_list.append([created_at, comments])
counts_by_hour = {}
coms_by_hour = {}
for row in result_list:
dt_string= row[0]
#m/d/yyyy 24:mm
dt_object = dt.datetime.strptime(dt_string, '%m/%d/%Y %H:%M')
post_hour = dt_object.strftime('%H')
if post_hour not in counts_by_hour:
counts_by_hour[post_hour] = 1
coms_by_hour[post_hour] = comments
else:
counts_by_hour[post_hour] += 1
coms_by_hour[post_hour] += comments
print(counts_by_hour)
print(lb)
print(coms_by_hour)
{‘06’: 44, ‘18’: 109, ‘05’: 46, ‘11’: 58, ‘23’: 69, ‘21’: 109, ‘09’: 45, ‘14’: 107, ‘20’: 80, ‘10’: 59, ‘08’: 48, ‘15’: 116, ‘13’: 85, ‘12’: 73, ‘02’: 58, ‘01’: 60, ‘16’: 108, ‘17’: 100, ‘07’: 34, ‘22’: 71, ‘19’: 110, ‘00’: 55, ‘03’: 54, ‘04’: 47}
{‘06’: 88, ‘18’: 218, ‘05’: 92, ‘11’: 116, ‘23’: 138, ‘21’: 218, ‘09’: 90, ‘14’: 214, ‘20’: 160, ‘10’: 118, ‘08’: 96, ‘15’: 232, ‘13’: 170, ‘12’: 146, ‘02’: 116, ‘01’: 120, ‘16’: 216, ‘17’: 200, ‘07’: 68, ‘22’: 142, ‘19’: 220, ‘00’: 110, ‘03’: 108, ‘04’: 94}
so the total comments accounted for total to 3490, out of the desired 24,485