Larry Wall

Perl6 Data Visualizations

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

Data Resources: 
Examples
Tags: 
perl6
Data Science
Larry Wall
Sparkline