#N/A errors in DFS salaries explained

BigDataBall Leave a Comment

At BigDataBall, we only support “CLASSIC” style salaries and positions.  On the weekends and on special days like Christmas, MLK, if there is an afternoon game, DraftKings, or the other operators can sometimes prefer not to include the earliest game in any classic slate. We also added a note to the DFS dataset column headers. And the below image explains …

Adding a new column

BigDataBall Leave a Comment

Ever wanted to calculate a metric that is not included in the original dataset template? It is very easy to add a new column to a BigDataBall spreadsheet. As an example, we can use a simple IF formula to determine the winning/losing team for the NBA games.

Changes in NBA Play-By-Play Dataset

BigDataBall Leave a Comment

With the new NBA 2020-201 season, we’ve rolled out a new version that will help reduce the number of ‘unknown’ plays. Summary (tl;dr) Dataset format remains the same, no new columns, no relocations. The new version focuses on how shots, turnovers, fouls, and violations need to be categorized. To improve clarity, some play types will not be abbreviated and some …

Converting date formats in Excel

BigDataBall Leave a Comment

We use the MM/DD/YYYY format in the datasets. This might not be the date format you’d like, but with this guide, you can learn how to convert the cell value to any date format or convert date to text. Working with dates in Excel can be quite irritating. If you want to make date-based calculations, your cells must be recognized …

Creating shot charts using play-by-play data

BigDataBall Leave a Comment

1) Download Datasets Download play-by-play data in CSV format. If you open the dataset, you can see there is a whole lot of information. We’ll do some cleaning later to use only what we need! 2) Create a new R studio project Create a new project, we’ll call it ‘charts’. R will create a folder named charts. Move your data …

How to calculate aggregated stats

BigDataBall Leave a Comment

By default, BigDataBall provides game-by-game logs. In case you’d like to have a season averages table using the logs, follow this walkthrough. A) Getting the Unique List of Players A1) We need to transform game-by-game logs to a table that shows season averages of players from the NBA 2019-20 season. A2) Open your most recent version of the BigDataBall NBA …

Introduction to predictive analytics

BigDataBall Leave a Comment

In this guide, we will try to execute a multiple linear regression in Excel and our aim is to help you interpret the results statistically. Let’s try to predict DFS salaries to exercise how the ideal salary compares to the official DraftKings salary. After completing the regression, identifying value players or avoiding expensive players for a given day becomes quite …