Run169 2017 Race Schedule - Data Table Summary

This example summarizes a data table using Datalib.

This data is from debticonn.org: Qualifying Race Schedule. The source file contains multiple tabs. The 2017 schedule was exported as a CSV. From the date column we extracted day, month, quarter, and weekday (Monday = 1) derived columns. Some data cleanup is still needed for the "cost" column.

This dataset has the 2017 schedule of races that qualify for Run 169 (run a race in every town in Connecticut)

forked from curran's block: Data Table Summary

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Run 169 Race Schedule - Data Summary</title>
    <script src="https://d3js.org/d3.v4.min.js"></script>
    <script src="https://unpkg.com/datalib@1.8.0/datalib.min.js"></script>
    <style>

</style>
  </head>
  <body>
    <script>
      
      // Use these for other formats:
      // d3.tsv('data.tsv', data => {
      // d3.json('data.json', data => {
      
      // Load and summarize the data.
      d3.csv('races2017.csv', data => {
        
        // Assemble a summary string.
        const summary = [
          'Data table summary: ',
          data.length + ' rows',
          data.columns.length + ' columns',
          Math.round(d3.csvFormat(data).length / 1024) + ' kB',
          '\nSummary of each column:',
          dl.format.summary(data)
        ].join('\n');
        
        // Show the summary string on the page.
        d3.select('body').append('pre').text(summary);
        
        // Log the summary to the console.
        console.log(summary);
      });

</script>
  </body>
</html>

https://d3js.org/d3.v4.min.js

https://unpkg.com/datalib@1.8.0/datalib.min.js