Add additional measures into an NBA dataset

I’m looking for a data analyst to help add 10 additional measures to an NBA dataset.

• Matchup Specific ELO

• Simple Moving Average of ELO_I for both teams with period of 3,5,7 & 10 games

The dataset is built from [login to view URL] CARMELO ratings. There are approximately 7000 rows (1 per game) from the 2009/10 through 2015/16 NBA seasons. Each game taking a single row and having 42 datapoints.


ELO rating is a simple measure which takes an arbitrary point in time and starts all teams at the same score. For this project, each team will begin the 2009/10 season at 1300. With each game played, each teams ELO rating is either increased or decreased by the number of points that they have won or lost by.

For eg. GSW play CLE and GSW win by 10 points. If we assume the ELO rating for each team was 1300 coming into the game. The GSW ELO (GSWCLE) is now 1310 and the CLE ELO (CLEGSW) is now 1290. Only games where these two teams play changes these ratings.

I’d like to create a specific ELO for each matchup of teams that excludes which team is playing at home. There are 30 teams in the league, so doing this manually in Excel isn't something I want to do. Therefore, I'm asking someone to help create and execute a script that will do this work and then fold it back into the dataset.

Simple Moving Average of CARMELO

I’d also like to add a simple moving average of the pregame CARMELO rating for each team with a period of 3, 5, 7 and 10 games for each team.

The attached spreadsheet is the first 50 rows and I've created and coloured columns where I want the new measures to be located.

Speed is not the key with this project, accuracy is key. Folks that have worked on basketball data before would be a plus as is communicating clearly and asking questions. Once I have this data and am able to work it into an existing model, I will potentially have other tasks like this so developing a relationship with whomever completes this is in the back of my mind.


Habilidades: Extração de Dados, Processamento de dados, Excel, Python

Veja mais: datasets for bayesian analysis, work from home excel projects, data mining projects based on clustering, naive bayes classifier dataset, freelance excel jobs from home, naive bayes with simple example, data mining project ideas for students, dataset for data mining download, add additional form fields javascript, javascript add additional fields, add additional categories box oscommerce, cutenews add additional fields add news, zen cart add additional images products, add additional page full flash site, add additional fields profile dolphin, add additional image virtuemart, zencart add additional images, add player flash racing game, add additional fields paypal checkout form, add additional radio buttons existing form

Acerca do Empregador:
( 5 comentários ) Berlin, Germany

ID do Projeto: #16055551

Concedido a:


I can provide you updated spreadsheet (+ matchup specific ELO, + SMA of ELO_i for 3, 5, 7 & 10 games) in less than a day. I have worked with NBA statistics before that's why I'm sure you'll be impressed with my work Mais

€140 EUR em 1 dia
(282 Comentários)

12 freelancers estão ofertando em média €175 para esse trabalho


Greeting, I have understood your Add additional measures into an NBA dataset task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Min Mais

€250 EUR in 3 dias
(296 Comentários)

Hi there. My name is Daniel. I understand both calculations that you want to add to the spreadsheet, as well as I have worked with basketball and many other sports data in the future, which is why I can guarantee an ex Mais

€199 EUR in 5 dias
(127 Comentários)

I have a good hand on working with Advanced Excel, R and Python. I have quite a good knowledge of deep learning Algorithm and ML algos, have also developed dashboards and Web Application and BI tools.I understand the p Mais

€250 EUR in 3 dias
(70 Comentários)
€155 EUR in 3 dias
(60 Comentários)
€222 EUR in 4 dias
(32 Comentários)

This bid is to write Python code perform the required statistical analysis of an existing basketball data set. Specifically it will compute the ELO metrics described for each team pair and for each game in the data set Mais

€250 EUR in 7 dias
(17 Comentários)

Dear sir. Your project attracted my attention at first glance, because I've really rich experience in python. I'm really confident about your project, and very eager to join your project. If we have a chance to coop Mais

€150 EUR in 3 dias
(25 Comentários)
€100 EUR em 1 dia
(39 Comentários)

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.

€150 EUR in 3 dias
(33 Comentários)

Dear mintgreenstrat, I have gone through your project "Add additional measures into an NBA dataset". Relevant Skills and Experience Having skill set in Data Mining, Data Processing, Excel, Python with an experienc Mais

€175 EUR in 4 dias
(2 Comentários)
€55 EUR in 5 dias
(0 Comentários)