Site
Home / Forum / General Discussion / What are you working on? (2025 edition)
Home / Forum / General Discussion / What are you working on? (2025 edition)
What are you working on? (2025 edition) |
| Posted: 28 Feb 2025 10:57 | |||
 zag Posts: 3,848 Joined: 2020 | Just a new thread to see what people are working on. Personally I have plans to finish UCI cycling teams with all player artwork as my next project. Someone mentioned to me that NRL rugby is looking a little dated, might also work on that in the future if nobody else beats me  EDIT: Also The recent bulk retired player imports need lots of info. Will work ad-hoc on those for Golf, boxing players etc. | ||
 | |||
| Posted: 28 Feb 2025 12:57 | |||
Posts: 1,084 Joined: 2020 | Currently trying to update all unautomated team sports to the latest fixtures and adding past results if there's a gap. zag | ||
| |||
| Posted: 17 Mar 2025 13:35 | |||
zag Posts: 3,848 Joined: 2020 | Worked on Cricket retired players and ATP current top 100 players recently. Still Loads of stuff to do, but looking much better. | ||
| |||
| Posted: 21 Mar 2025 13:33 | |||
Posts: 94 Joined: 2020 | Adding missing UFC fighters to the fight results for 1993-2012. Making sure the Desc is past tense. Adding venues/attendance. Zag, would you be willing to try another CSV import for F1 results? Maybe add Quali to old races. Not sure if you have all the F1 drivers added. zag | ||
| |||
| Posted: 22 Mar 2025 10:32 | |||
zag Posts: 3,848 Joined: 2020 | Making sure the Desc is past tense. Adding venues/attendance. Zag, would you be willing to try another CSV import for F1 results? Maybe add Quali to old races. Not sure if you have all the F1 drivers added. Sure, but yes all the drivers need adding first htpcmac2 | ||
| |||
| Posted: 22 Mar 2025 14:13 | |||
Posts: 94 Joined: 2020 | Making sure the Desc is past tense. Adding venues/attendance. Zag, would you be willing to try another CSV import for F1 results? Maybe add Quali to old races. Not sure if you have all the F1 drivers added. Sure, but yes all the drivers need adding first I have a dataset with 862 racers, 215 Constructors, and 1144 races. It seems to have a CSV for the drivers that has a driver ID, then the races use that unique driver ID for race results. CSV headers for drivers driverId,driverRef,number,code,forename,surname,dob,nationality,url 1,"hamilton",44,"HAM","Lewis","Hamilton","1985-01-07","British","https://en.wikipedia.org/wiki/Lewis_Hamilton" I could add birthplace, height, weight, status, team, and socials to it. Results csv https://imgur.com/a/dLB1GOc I could use some python wizardry to replace all the placeholder with actual names and teams. Can you provide me a the CSV headers you'd need just for the drivers? | ||
| |||
| Posted: 22 Mar 2025 17:28 | |||
zag Posts: 3,848 Joined: 2020 | I've actually just done a big motorsport driver import recently, can you check all drivers are somewhere here? https://www.thesportsdb.com/team/135361-_retired-motorsport | ||
| |||
| Posted: 22 Mar 2025 17:40 | |||
Posts: 94 Joined: 2020 | https://www.thesportsdb.com/team/135361-_retired-motorsport There are some there but a lot missing from the sampling I did. https://www.kaggle.com/datasets/rohanrao/formula-1-world-championship-1950-2020/data?select=drivers.csv That is the CSV with the Formula 1 drivers. zag | ||
| |||
| Posted: 27 Mar 2025 10:23 | |||
zag Posts: 3,848 Joined: 2020 | Working on driver import now.... EDIT: 850 former F1 drivers all imported. They will need artwork and details added to each but can now be used for result entry. It doesn't look like I can automate the results this time, so people will have to add them I think. | ||
| |||
| Posted: 27 Mar 2025 20:19 | |||
Posts: 94 Joined: 2020 | EDIT: 850 former F1 drivers all imported. They will need artwork and details added to each but can now be used for result entry. It doesn't look like I can automate the results this time, so people will have to add them I think. I am going to edit the data. What reference do I use for the drivers in the data base? How do I get each imported drivers tsbd id so I can match them in the database and make them import friendly? Would a column for surename, forname, full name or just the id, be ok? https://ibb.co/M5C4wy9X That looks more friendly | ||
| |||
| Posted: 27 Mar 2025 20:55 | |||
zag Posts: 3,848 Joined: 2020 | I would need: Full race name, Season, full drivers name, TheSportsDB team ID, finishing position, time The data is nice but had no names so very hard to do anything with. htpcmac2 | ||
| |||
| Posted: 27 Mar 2025 21:40 | |||
Posts: 94 Joined: 2020 | Full race name, Season, full drivers name, TheSportsDB team ID, finishing position, time The data is nice but had no names so very hard to do anything with. Is eventID, Season, full drivers name, TheSportsDB team ID, finishing position, time work? The event ID is static and the names vary. | ||
| |||
| Posted: 27 Mar 2025 21:44 | |||
zag Posts: 3,848 Joined: 2020 | Full race name, Season, full drivers name, TheSportsDB team ID, finishing position, time The data is nice but had no names so very hard to do anything with. Is eventID, Season, full drivers name, TheSportsDB team ID, finishing position, time work? The event ID is static and the names vary. Yeh I think that would be perfect. Especially with the event ID that would make it very easy. | ||
| |||
| Posted: 27 Mar 2025 21:56 | |||
Posts: 94 Joined: 2020 | Full race name, Season, full drivers name, TheSportsDB team ID, finishing position, time The data is nice but had no names so very hard to do anything with. Is eventID, Season, full drivers name, TheSportsDB team ID, finishing position, time work? The event ID is static and the names vary. Yeh I think that would be perfect. Especially with the event ID that would make it very easy. What should we do about the missing events? 1970-1980 is incomplete on the site, and the csv goes back to 1950. Also did you input the teams as well as the drivers? I can't match to any of the teams in the csv. | ||
| |||
| Posted: 27 Mar 2025 23:53 | |||
Posts: 94 Joined: 2020 | https://ibb.co/RpXRLDgt How is this? I did not put the sprint data in. There are so few of them and are most likely done anyway. Edit: https://ibb.co/LDSwMVND Cleaned up the times. Just need the teams to be added and should be an easy import. https://www.dropbox.com/scl/fi/2hk5banbjlrq0kmbba490/tsdb_refined_times.csv?rlkey=f6yrkm9vuxieiqmevryirekcr&dl=0 Edit 2: For the missing events I'll make a csv for events between 1950-1980 (skipping 1970,1978,1979) Season 1976 only has one race on the site. I think this event import should be BEFORE the results. https://ibb.co/svhVpJK2 https://www.dropbox.com/scl/fi/bnkfppps1z1r833dasty4/missing_races_tracks.csv?rlkey=2fay8as953vtg8mykddwdv4fq&dl=0 (Looks like some venues are missing. Maybe import circuits.csv too) Let me work on qualifying. | ||
| |||
| Posted: 28 Mar 2025 13:31 | |||
zag Posts: 3,848 Joined: 2020 | Do we have a list of missing teams? That's the first place to start. I will add manually. EDIT: Hmm matching the teams is going to be difficult as they all have different sponsor names now. The ID would be really useful in that CSV. Let's keep things simple and concentrate on the results first. We can always re-run it later when the older events are added. | ||
| |||
| Posted: 28 Mar 2025 15:02 | |||
Posts: 94 Joined: 2020 | EDIT: Hmm matching the teams is going to be difficult as they all have different sponsor names now. The ID would be really useful in that CSV. Let's keep things simple and concentrate on the results first. We can always re-run it later when the older events are added. I only see the current teams on the site. Any defunct teams, if added, are in a black hole. The constructors.csv has all the team names. https://www.kaggle.com/datasets/rohanrao/formula-1-world-championship-1950-2020/data?select=constructors.csv You can kind of tell the team name changes by looking at the wiki links for each entry. There are 215 team names, but a lot less when you consider some are just name changes. What about using the constructorRef as the team short name. https://ibb.co/4nHJ8qJz That way it won't interfere with sponsor names. All the same team Minardi -> Toro Rosso -> Alpha Tauri - > Visa Cash App RB F1 Team -> Racing Bulls Toleman -> Benetton -> Renault -> Lotus Renault GP -> Lotus F1 Team -> Renault F1 Team -> BWT Alpine It gets a little weird with the Privateer Teams. https://en.wikipedia.org/wiki/List_of_Formula_One_constructors#Privateer_teams Here is a chart of the team name changes https://docs.google.com/spreadsheets/d/1YcuDHkVnemCrw0tWe_kQ28r8f4fdKfwW/edit?gid=1251989152#gid=1251989152 (red lines indicate team name changes) Would teams by year be better? zag | ||
| |||
| Posted: 03 Apr 2025 14:58 | |||
Posts: 427 Joined: 2020 | Worked on UK Elite Ice Hockey League, mainly player updates which were well out of date. zag | ||
| |||
| Posted: 13 Jun 2025 14:01 | |||
Posts: 427 Joined: 2020 | M L B player updates needs a lot of changes. | ||
| |||
| Posted: 13 Jun 2025 14:30 | |||
zag Posts: 3,848 Joined: 2020 | Yes I'm also working on the NFL player updates for the new season. Lots to do there as well  | ||
| |||
| Posted: 15 Jun 2025 07:31 | |||
Posts: 9 Joined: 2022 | Looking to be more active, especially with regards to TV channels for events zag, YGPM on discord about that zag | ||
| |||
| Posted: 21 Jun 2025 12:38 | |||
zag Posts: 3,848 Joined: 2020 | Half way through NFL transfers now. 16 more teams to go!! | ||
| |||
| Posted: 19 Jul 2025 18:44 | |||
Posts: 427 Joined: 2020 | Bit of a slog but MLB should be pretty well up to date. ( for now) zag | ||
| |||
| Posted: 23 Jul 2025 23:23 | |||
zag Posts: 3,848 Joined: 2020 | NFL also done with recent transfers. Big slog as well. Should help going forward making things easier now. | ||
| |||
| Posted: 03 Sep 2025 21:16 | |||
zag Posts: 3,848 Joined: 2020 | I'm still working on NFL, it feels never-ending.... Currently trying to add all the current safety and cornerbacks, so I can import some statistics for the players I found. But there are 500+ of them!! Crazy but still fun | ||
|