I’ve always been interested in this stuff I’m going to give it a try.. wish me luck I’m fairly new to coding and only did one little project before months ago
Great stuff, T! Question for you. When I run the scraper, leading up to scrubbing, I see the file create in my project folder. I see the info pulling as you do when the project runs, however, there is no data in my csv file to scrape. Any ideas as to what I am doing wrong?
Most likely it is not seeing the table or object you pointed the scraper at. So it would print the url it’s going to hit, try to find a table or object defined, can’t and moves on. It’s moving on due to the try and except statement. You could test to be sure you’re pointing at correct data by printing the object as shown in the print of the table to collect IDs. If it doesn’t print it doesn’t see it, it could also be the table structure, which may require modifying the scraper.
@@wageredontilt1649 Hey T! Thank you for checking in. I just got back home to try it, and it does now appear to be working. For some reason, I could not get it work to work on the advanced page but it worked when I referenced back to the regular game log. Thank you for the tutorials!
I literally used the same exact code on python as you did, and got the same output, but when I selected all and copied and pasted it into excel, it didn't turn into a table and instead stayed as code. What did I do wrong? Thank you!
So, usually once you paste it in for the first time, you will need to modify the data to match a table, however that setup should continue to exist. Did it at least paste in as some readable values, or is it all in column A with html?
@@wageredontilt1649It was just html in column a. So weird. I also switched the settings to split by column and it didn’t do anything. Thank you for responding!
@@Actapguru That is odd. The only other thing I would suggest is maybe point your excel to a website, and import html. Then give it a try by copying and pasting in the html from python. Not sure why it is only wanting to display it as html. The only other thing I can think is that the html is incomplete so it doesn't know how to render.
The environment I use is PyCharm. There are several options out there, but for me I like the ease of PyCharm. Some have also tried using googles cloud options to not need to store and run locally, but I prefer to have it run on my machine.
Hello, when trying to run my code just as you did 30:10, i get an Error response: File "parsers.pyx", line 574, in pandas._libs.parsers.TextReader.__cinit__ File "parsers.pyx", line 663, in pandas._libs.parsers.TextReader._get_header File "parsers.pyx", line 874, in pandas._libs.parsers.TextReader._tokenize_rows File "parsers.pyx", line 891, in pandas._libs.parsers.TextReader._check_tokenize_status File "parsers.pyx", line 2053, in pandas._libs.parsers.raise_parser_error File "", line 322, in decode UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe9 in position 262: invalid continuation byte Do you have any idea how to fix it? It would be really appreciated as Ive already been trying ChatGPT to help me. Cool video btw!
The issue is with the format of the text/values in the file you have. They must have some kind of special charter. Often this can happen with player names. You can either clean up the values in the file, or use additional code to tell it to ignore the issues. I can get the line of code you’d need in a day, I need to grab from one of my other models.
None that I know of, as there are hundreds of ways to make a model using differing approaches and differing stats. If you find a site claiming to build you a model, I would be cautious as I doubt the strength would be present. Often models will only survive for so long with out tweaks along the way. I don't know if a site would have the ability to adapt. Also, if it is pulling from a library of models to provide you, most likely those models have already been tapped out for any edge it would provide.
Sorry, been a while since I made this video. Which part of the video are you referring to where I copy paste? I can take a look at that part and give ya any help I can.
@@wageredontilt1649 My guess is he is talking about around 7:35, I came to the comments for the same question. It's pasting exactly how it looks in the output from print(players) **Edit** I got on my other laptop, running Windows instead of Ubuntu, and it worked on Excel, it just doesn't work on Google Sheets or LibreOffice Calc
@@wageredontilt1649 I'm having the same problem. For me it's the initial copy and paste after you run the very first formula for passing. I don't have excel, just google sheets, and when i paste it in it's just the raw html taken from the terminal.
@@wageredontilt1649 i'm having a similar problem copying the passing stats at the beginning of the video from the interpreter to the excel sheet. it doesn't format automatically into a neat table. do you by chance know what the fix is?
Ah, I see what you mean. Thank you for the update as well! I believe to get it to work in Google Sheets, you can set column A to be Split to Column, and when you put the data in, it should split it. Google Sheets often updates and break workflows like that unfortunately.
I had looked into it in the past, however at books the edges aren’t as good, and some of the data being reported can be suspect. If you know of a good eSports data site, I’d be willing to look back into it.
@@wageredontilt1649 I’ve seen people have pretty good models based off adding pinnacle odds for how close a game should be as props like headshots and kills are very round dependent while adding their projection to cross reference multiple DFS app lines like prize picks, underdog, SportsBattle, Jock MKT, etc.
@@wageredontilt1649 also important to factor in map pools for teams as they vote on which maps to play or ban and that factors in to how well they play and how close the games are
For sure. I was using that in some of the initial modeling I was doing, but to actually fetch the data I need was a bit cumbersome. Know of any sites good for this data I can try to scrape?
Sorry it didn’t go into enough detail on the model building for you. What aspect of the model building piece were you hoping to find that wasn’t covered?
@@jefffriend1306 @jefffriend1306 Okay, thank you for the reply back! If there is anything specific that you were hoping to see on modeling, or sports betting that you don't see in any of my content, please let me know. I can try and work something up.
@@wageredontilt1649 right now I am trying to learn all I can about differnet models for different NFL stats. I really know nothing about any of it. Thanks for the reply!
Nice video! currently learning python atm and this really helps! Keep it up!
Glad you are finding it useful! Let me know if you have any questions.
I’ve always been interested in this stuff I’m going to give it a try.. wish me luck I’m fairly new to coding and only did one little project before months ago
Tbh, this stuff will come to you quickly. I only started Python in Aprilish if 2023.
If you have any questions let me know
Great stuff, T! Question for you. When I run the scraper, leading up to scrubbing, I see the file create in my project folder. I see the info pulling as you do when the project runs, however, there is no data in my csv file to scrape. Any ideas as to what I am doing wrong?
Most likely it is not seeing the table or object you pointed the scraper at.
So it would print the url it’s going to hit, try to find a table or object defined, can’t and moves on. It’s moving on due to the try and except statement.
You could test to be sure you’re pointing at correct data by printing the object as shown in the print of the table to collect IDs. If it doesn’t print it doesn’t see it, it could also be the table structure, which may require modifying the scraper.
Have you had any progress on this?
@@wageredontilt1649 Hey T! Thank you for checking in. I just got back home to try it, and it does now appear to be working. For some reason, I could not get it work to work on the advanced page but it worked when I referenced back to the regular game log. Thank you for the tutorials!
@@jd200600 glad it’s working! Let me know if there are any future issues!
@@wageredontilt1649 Will do and thank you!
I literally used the same exact code on python as you did, and got the same output, but when I selected all and copied and pasted it into excel, it didn't turn into a table and instead stayed as code. What did I do wrong? Thank you!
So, usually once you paste it in for the first time, you will need to modify the data to match a table, however that setup should continue to exist. Did it at least paste in as some readable values, or is it all in column A with html?
@@wageredontilt1649It was just html in column a. So weird. I also switched the settings to split by column and it didn’t do anything. Thank you for responding!
@@Actapguru That is odd. The only other thing I would suggest is maybe point your excel to a website, and import html. Then give it a try by copying and pasting in the html from python. Not sure why it is only wanting to display it as html. The only other thing I can think is that the html is incomplete so it doesn't know how to render.
@@wageredontilt1649 Ok thank you! What python software do you use? i use pycharm so i’m wondering if it delivers the html differently
It’s an excel issue, I use the same Pycharm. Some have had issues with it before as well
Thanks T. Great video!
Let me know if ya have any questions!
Great video!
Let me know if ya have any questions!
New to python. What program do you use to put the python coding in?
The environment I use is PyCharm. There are several options out there, but for me I like the ease of PyCharm. Some have also tried using googles cloud options to not need to store and run locally, but I prefer to have it run on my machine.
Hello, when trying to run my code just as you did 30:10, i get an Error response:
File "parsers.pyx", line 574, in pandas._libs.parsers.TextReader.__cinit__
File "parsers.pyx", line 663, in pandas._libs.parsers.TextReader._get_header
File "parsers.pyx", line 874, in pandas._libs.parsers.TextReader._tokenize_rows
File "parsers.pyx", line 891, in pandas._libs.parsers.TextReader._check_tokenize_status
File "parsers.pyx", line 2053, in pandas._libs.parsers.raise_parser_error
File "", line 322, in decode
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe9 in position 262: invalid continuation byte
Do you have any idea how to fix it? It would be really appreciated as Ive already been trying ChatGPT to help me. Cool video btw!
The issue is with the format of the text/values in the file you have. They must have some kind of special charter. Often this can happen with player names. You can either clean up the values in the file, or use additional code to tell it to ignore the issues.
I can get the line of code you’d need in a day, I need to grab from one of my other models.
Okay, so for the file you are importing, I would add ", encoding="ISO-8859-1" "
That should help with the encoding issue.
Any place on the net where you can get code and it spits a model out for you?
Do you mean a website that makes a model for you or a site that is a model and returns results?
@@wageredontilt1649 makes a model
None that I know of, as there are hundreds of ways to make a model using differing approaches and differing stats. If you find a site claiming to build you a model, I would be cautious as I doubt the strength would be present. Often models will only survive for so long with out tweaks along the way. I don't know if a site would have the ability to adapt. Also, if it is pulling from a library of models to provide you, most likely those models have already been tapped out for any edge it would provide.
how did you just copy and paste like that? mine doesn't translate as well
Sorry, been a while since I made this video. Which part of the video are you referring to where I copy paste? I can take a look at that part and give ya any help I can.
@@wageredontilt1649 My guess is he is talking about around 7:35, I came to the comments for the same question. It's pasting exactly how it looks in the output from print(players)
**Edit** I got on my other laptop, running Windows instead of Ubuntu, and it worked on Excel, it just doesn't work on Google Sheets or LibreOffice Calc
@@wageredontilt1649 I'm having the same problem. For me it's the initial copy and paste after you run the very first formula for passing. I don't have excel, just google sheets, and when i paste it in it's just the raw html taken from the terminal.
@@wageredontilt1649 i'm having a similar problem copying the passing stats at the beginning of the video from the interpreter to the excel sheet. it doesn't format automatically into a neat table. do you by chance know what the fix is?
Ah, I see what you mean. Thank you for the update as well!
I believe to get it to work in Google Sheets, you can set column A to be Split to Column, and when you put the data in, it should split it. Google Sheets often updates and break workflows like that unfortunately.
Anything on esports like csgo? Lots of edge in that especially on DFS apps
I had looked into it in the past, however at books the edges aren’t as good, and some of the data being reported can be suspect.
If you know of a good eSports data site, I’d be willing to look back into it.
@@wageredontilt1649 I’ve seen people have pretty good models based off adding pinnacle odds for how close a game should be as props like headshots and kills are very round dependent while adding their projection to cross reference multiple DFS app lines like prize picks, underdog, SportsBattle, Jock MKT, etc.
I’ll probably take a look then into some of the eSports stuff in the next month or so. Need some time to think through how I’d tackle it.
@@wageredontilt1649 also important to factor in map pools for teams as they vote on which maps to play or ban and that factors in to how well they play and how close the games are
For sure. I was using that in some of the initial modeling I was doing, but to actually fetch the data I need was a bit cumbersome. Know of any sites good for this data I can try to scrape?
do you have a git repo for this?
No, I no longer offer a git for this, I had too many ppl asking for customized code, or passing code off as their own.
🎉
I can't read.
Sorry it didn’t go into enough detail on the model building for you. What aspect of the model building piece were you hoping to find that wasn’t covered?
@@wageredontilt1649 Sorry I miss read the Title. Changed my comment.
@@jefffriend1306 @jefffriend1306 Okay, thank you for the reply back! If there is anything specific that you were hoping to see on modeling, or sports betting that you don't see in any of my content, please let me know. I can try and work something up.
@@wageredontilt1649 right now I am trying to learn all I can about differnet models for different NFL stats. I really know nothing about any of it. Thanks for the reply!
Can you please increase resolution and do not use black background its hard to read