Submitted by gbatchelor on June 28, 2016 - 9:36am
The following are a few examples of some quick queries and visualizations we made to show how to use the Perl6 IRC data.
(1) Posts by hour of day over the years
SQL code:
SELECT YEAR(`date_of_entry`),HOUR(`time_of_entry`),COUNT(HOUR(`time_of_entry`))
FROM `perl6_irc`
GROUP BY 1,2
(2) Perl6 IRC Posts by hour
Submitted by megan on June 2, 2016 - 1:17pm
Thanks to the work of my two summer research assistants Evan Ashwell & Greg Batchelor, the IRC channels for #bitcoin-dev, perl6, #ubuntu, #django, and puppet (#gen, #dev, and #razor) have been updated.
Things to know:
