Main vs Skim emails over date/time updated

Main_Skim_Date_Time

#Main vs skim emails
mainboxCount = db.emails.find({"category": "main"}).count() 
print "Number of emails in mainbox: " + str(mainboxCount)
 
skimboxCount = db.emails.find({"category": "skim"}).count() 
print "Number of emails in skimbox:" + str(skimboxCount)
 
#to find main emails received at given day of week:
mainMonday = db.emails.find({"headers.Date":{"$regex":"Mon"}, "category": "main"}).count()
print "Number of mainbox emails received on Mondays: " + str(mainMonday)
mainTuesday = db.emails.find({"headers.Date":{"$regex":"Tue"}, "category": "main"}).count()
print "Number of mainbox emails received on Tuesdays: " + str(mainTuesday)
mainWednesday = db.emails.find({"headers.Date":{"$regex":"Wed"}, "category": "main"}).count()
print "Number of mainbox emails received on Wednesdays: " + str(mainWednesday)
mainThursday = db.emails.find({"headers.Date":{"$regex":"Thu"}, "category": "main"}).count()
print "Number of mainbox emails received on Thursdays: " + str(mainThursday)
mainFriday = db.emails.find({"headers.Date":{"$regex":"Fri"}, "category": "main"}).count()
print "Number of mainbox emails received on Fridays:" + str(mainFriday)
mainSaturday = db.emails.find({"headers.Date":{"$regex":"Sat"}, "category": "main"}).count()
print "Number of mainbox emails received on Saturday:" + str(mainSaturday)
mainSunday = db.emails.find({"headers.Date":{"$regex":"Sun"}, "category": "main"}).count()
print "Number of mainbox emails received on Sunday:" + str(mainSunday)
 
#to find skim emails received at a given day of week:
skimMonday = db.emails.find({"headers.Date":{"$regex":"Mon"}, "category": "skim"}).count()
print "Number of skimbox emails received on Mondays: " + str(skimMonday)
skimTuesday = db.emails.find({"headers.Date":{"$regex":"Tue"}, "category": "skim"}).count()
print "Number of skimbox emails received on Tuesdays: " + str(skimTuesday)
skimWednesday = db.emails.find({"headers.Date":{"$regex":"Wed"}, "category": "skim"}).count()
print "Number of skimbox emails received on Wednesdays: " + str(skimWednesday)
skimThursday = db.emails.find({"headers.Date":{"$regex":"Thu"}, "category": "skim"}).count()
print "Number of skimbox emails received on Thursdays: " + str(skimThursday)
skimFriday = db.emails.find({"headers.Date":{"$regex":"Fri"}, "category": "skim"}).count()
print "Number of skimbox emails received on Fridays: " + str(skimFriday)
skimSaturday = db.emails.find({"headers.Date":{"$regex":"Sat"}, "category": "skim"}).count()
print "Number of skimbox emails received on Saturday: " + str(skimSaturday)
skimSunday = db.emails.find({"headers.Date":{"$regex":"Sun"}, "category": "skim"}).count()
print "Number of skimbox emails received on Sunday: " + str(skimSunday)
 
 
#Main vs skim time of day
#number of main emails received in the early morning:
earlyMornMain = db.emails.find({"headers.X-Received": {"$regex":"0[4-7]:..:.."}, "category": "main"}).count() 
print "Number of main emails received between 4:00:00 AM and 7:59:59 AM: " + str(earlyMornMain)
 
#number main emails received in mid morning
midMornMain = db.emails.find({"headers.X-Received": {"$regex":"0[8-9]:..:..|1[0-1]:..:.."}, "category": "main"}).count() 
print "Number of main emails received between 8:00:00 AM and 11:59:59 AM: " + str(midMornMain)
 
#number main emails received in early afternoon
earlyAfternoonMain = db.emails.find({"headers.X-Received": {"$regex":"1[2-4]:..:.."}, "category": "main"}).count() 
print "Number of main emails received between 12:00:00 PM and 14:59:59 PM: " + str(earlyAfternoonMain)
 
#number main emails received in mid-late afternoon
midAfternoonMain = db.emails.find({"headers.X-Received": {"$regex":"1[5-7]:..:.."}, "category": "main"}).count() 
print "Number of main emails received between 13:00:00 PM and 17:59:59 PM: " + str(midAfternoonMain)
 
#number of main emails received in evening
eveningMain = db.emails.find({"headers.X-Received": {"$regex":"1[8-9]:..:..|20:59:59"}, "category": "main"}).count() 
print "Number of main emails received between 18:00:00 PM and 20:59:59 PM: " + str(eveningMain)
 
#number of main emails received at night
nightMain = db.emails.find({"headers.X-Received": {"$regex":"2[1-4]:..:.."}, "category": "main"}).count() 
print "Number of main emails received between 21:00:00 PM and 24:59:59 PM: " + str(nightMain)
 
#number of main emails received late night
lateNightMain = db.emails.find({"headers.X-Received": {"$regex":"0[1-3]:..:.."}, "category": "main"}).count() 
print "Number of main emails received between 01:00:00 AM and 03:59:59 PM: " + str(lateNightMain)
 
 
#Skim vs time of day
#number of skim emails received in the early morning:
earlyMornSkim = db.emails.find({"headers.X-Received": {"$regex":"0[4-7]:..:.."}, "category": "skim"}).count() 
print "Number of skim emails received between 4:00:00 AM and 7:59:59 AM: " + str(earlyMornSkim)
 
#number skim emails received in mid morning
midMornSkim = db.emails.find({"headers.X-Received": {"$regex":"0[8-9]:..:..|1[0-1]:..:.."}, "category": "skim"}).count() 
print "Number of skim emails received between 8:00:00 AM and 11:59:59 AM: " + str(midMornSkim)
 
#number skim emails received in early afternoon
earlyAfternoonSkim = db.emails.find({"headers.X-Received": {"$regex":"1[2-4]:..:.."}, "category": "skim"}).count() 
print "Number of skim emails received between 12:00:00 PM and 14:59:59 PM: " + str(earlyAfternoonSkim)
 
#number skim emails received in mid-late afternoon
midAfternoonSkim = db.emails.find({"headers.X-Received": {"$regex":"1[5-7]:..:.."}, "category": "skim"}).count() 
print "Number of skim emails received between 13:00:00 PM and 17:59:59 PM: " + str(midAfternoonSkim)
 
#number of skim emails received in evening
eveningSkim = db.emails.find({"headers.X-Received": {"$regex":"1[8-9]:..:..|20:59:59"}, "category": "skim"}).count() 
print "Number of skim emails received between 18:00:00 PM and 20:59:59 PM: " + str(eveningSkim)
 
#number of skim emails received at night
nightSkim = db.emails.find({"headers.X-Received": {"$regex":"2[1-4]:..:.."}, "category": "skim"}).count() 
print "Number of skim emails received between 21:00:00 PM and 24:59:59 PM: " + str(nightSkim)
 
#number of skim emails received late night
lateNightSkim = db.emails.find({"headers.X-Received": {"$regex":"0[1-3]:..:.."}, "category": "skim"}).count() 
print "Number of skim emails received between 01:00:00 AM and 03:59:59 PM: " + str(lateNightSkim)