Jonomuffin
Jonomuffin
CC#
Created by ZaDukk™ on 9/14/2023 in #help
❔ Want to try predict the ballon d'or but not really sure where to start
This is coming from the perspective of someone who knows nothing about the sport so I'm looking at it purely from an ML scope which may not give good results just based on the amount of data and the fact it's a popularity contest? Someone else on here might give you a better answer but this is just here to get you thinking. Linear regression, or any regression, is a good way of modeling continuous numeric outcomes but in the case of past soccer players there are only 2 outcomes... they either won the trophy or lost it. A regression would be appropriate if in your data you have some numeric column that you're trying to predict. Classification models would be good here since you're trying to see if your model predicts the player is a winner and how confident (probability) they are with that prediction. I'd suggest some basic classification models like KNN, logistic regression, and decision tree. Start by doing some data collection. Going off the Wikipedia page, I'd collect the top 3 players between 1956-2021 and label first place as winners and second and third as losers. You'd also want to compile the stats of said players. One issue I see you running into is sparse data, so you need to decide what to do if there's no data about certain players during that year. You may also have to consider oddities in years. Maybe in 1960 all the goal keepers just sucked which resulted in higher goals that year compared to every other year. Or one year all individuals were amazing and could have easily won the award if they played another year. After that you'll just go through the motions of creating your models. (Test/Train/Validation sets, Feature/Hyperparameter selection, Creating and evaluating the models) Honestly, you're dataset is kinda small ~180 (w/ 30 positive cases) so it'd be very easy to over/underfit. Even if you included all 30 nominees you'll run into a problem of class imbalance. https://en.wikipedia.org/wiki/Ballon_d%27Or
3 replies
CC#
Created by Jonomuffin on 9/14/2023 in #help
❔ Connecting to a local DB
Revolved! The spaces for TrustServerCertificate, ApplicationIntent, and MultiSubnutFailover all needed to be removed. In my second photo is there a reason why the connection strings don't have the same keywords as https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?view=dotnet-plat-ext-7.0 ?
6 replies