MLB Season Streaks

README.md

mlb-season-streaks

I was curious about the Cubs 2016 season and what it looked liked broken into chunks of 10 games (or some other nuber). I was also curious with how it stacked up against the 2001 Mariners.

Here's how to run it:

npm install
node index 2016-CHC 10
# Then look at the output
node index 2001-SEA 10

Data is from Baseball Reference.

.gitignore

node_modules

2001-SEA.csv

2016-CHC.csv

2017-LAD.csv

index.js

'use strict'

const fs = require('fs')
const path = require('path')
const _ = require('lodash')
const { Converter } = require('csvtojson');

const args = process.argv.slice(2)
const FILE = args[0] || '2016-CHC'
const chunk = parseInt(args[1] || 10, 10)

const converter = new Converter({})

const win = (g) => g['W/L'].charAt(0) === 'W'
const record = (results) => results.reduce((memo, game) => { return memo[win(game) ? 0 : 1]++, memo }, [0, 0])
const most = (obj, index) => _.max(_.values(_.mapValues(obj, (i) => i[index] || 0))) || 0

const pretty = (obj) => JSON.stringify(obj, (key, value) => {
  return Array.isArray(value) ? value.join('-') : value
}, 2).replace(/"/g, '').replace(/[\{\}]/gm, '').replace(/,/g, '')

converter.fromFile(`./${FILE}.csv`, (err, games) => {
  let best = {}
  let all = {}
  let worst = {}
  const perfect = {}
  const below500 = {}

  games.filter((g) => parseInt(g['Gm#'], 10)).forEach((g, index, gs) => {
    const start = index
    const end = start + chunk
    const result = record(gs.slice(start, end))
    const wins = result[0]
    const losses = result[1]
    const length = wins + losses
    const key = `${start + 1}-${start + length}`

    if (length < chunk) return

    if (wins < length / 2) {
      below500[key] = result
    }

    if (losses === 0) {
      perfect[key] = result
    }

    const mostWins = most(best, 0)
    if (wins >= mostWins) {
      if (wins > mostWins) best = {}
      best[key] = result
    }

    const mostLosses = most(worst, 1)
    if (losses >= mostLosses) {
      if (losses > mostLosses) worst = {}
      worst[key] = result
    }

    all[key] = result
  })

  all = _.map(all, (record, key) => ({
    record,
    key,
    pct: record[0] / (record[0] + record[1]),
    wins: record[0],
    start: parseInt(key.split('-')[0])
  }))

  all = _.orderBy(all, ['pct', 'wins', 'start'], ['desc', 'desc', 'asc'])
  all = all.reduce((res, d) => (res[d.key] = d.record, res), {})

  console.log('-------------------------')
  console.log('WORST')
  console.log(pretty(worst))
  console.log('-------------------------')
  console.log('BELOW 500')
  console.log(pretty(below500))
  console.log('-------------------------')
  console.log('BEST')
  console.log(pretty(best))
  console.log('-------------------------')
  console.log('ALL (SORTED)')
  console.log(pretty(all))
  console.log('-------------------------')
});

package-lock.json

{
  "name": "mlb-season-streaks",
  "version": "1.0.0",
  "lockfileVersion": 1,
  "requires": true,
  "dependencies": {
    "csvtojson": {
      "version": "1.1.8",
      "resolved": "https://registry.npmjs.org/csvtojson/-/csvtojson-1.1.8.tgz",
      "integrity": "sha1-5k5emOZf3n5v0BQ2y13grH0d2nA=",
      "requires": {
        "lodash": "4.17.4",
        "strip-bom": "1.0.0"
      }
    },
    "first-chunk-stream": {
      "version": "1.0.0",
      "resolved": "https://registry.npmjs.org/first-chunk-stream/-/first-chunk-stream-1.0.0.tgz",
      "integrity": "sha1-Wb+1DNkF9g18OUzT2ayqtOatk04="
    },
    "is-utf8": {
      "version": "0.2.1",
      "resolved": "https://registry.npmjs.org/is-utf8/-/is-utf8-0.2.1.tgz",
      "integrity": "sha1-Sw2hRCEE0bM2NA6AeX6GXPOffXI="
    },
    "lodash": {
      "version": "4.17.4",
      "resolved": "https://registry.npmjs.org/lodash/-/lodash-4.17.4.tgz",
      "integrity": "sha1-eCA6TRwyiuHYbcpkYONptX9AVa4="
    },
    "strip-bom": {
      "version": "1.0.0",
      "resolved": "https://registry.npmjs.org/strip-bom/-/strip-bom-1.0.0.tgz",
      "integrity": "sha1-hbiGLzhEtabV7IRnqTWYFzo295Q=",
      "requires": {
        "first-chunk-stream": "1.0.0",
        "is-utf8": "0.2.1"
      }
    }
  }
}

package.json

{
  "name": "mlb-season-streaks",
  "description": "Look at an MLB season as chunks of games.",
  "version": "1.0.0",
  "author": "Luke Karrys <luke@lukekarrys.com>",
  "dependencies": {
    "csvtojson": "^1.0.2",
    "lodash": "^4.16.2"
  },
  "license": "ISC",
  "main": "index.js",
  "private": true
}