Vct Data extraction V2

View:
Threaded
Linear
Threaded
#1
Foxym
5
Frags
+

After admittedly more time spent than wanted im happy to report
im done
(if you're curious how V1 looked like: https://www.vlr.gg/684690/vct-data-part-3 )

PLEASE NOTE
For the CN teams there was lacking data thanks to their third Party events not having things like VLR rating, sometimes not even Kda data
that of course will make the CN players look worse
so please dont harrass anyone
i doubt any of yall actually would, but just to be safe

also some said that the images look like eyesores so there will be two spoilerd areas, the top one will include the images and thous more data
while the bottom one is just going to be score and the Teams name
(also dont mind the extra commas in the second spoiler)

PLEASE also Note
Numbers DONT tell the whole story

Are you ready to have your eyes vomit? (THERE WAS A VOTE FOR THE DESIGN! (https://www.vlr.gg/715560/important) DONT COMPLAIN)

(formatting: round_diff, Team_Name, img_link)

(with img)

  1. 123, 100 Thieves, https://i.ibb.co/YBDDWj9X/30c376ec08c0.png,
  2. 99, Nova Esports, https://i.ibb.co/hJcpYFQy/589af2e134ff.png,
  3. 87, LEVIATÁN, https://i.ibb.co/QvKrrrT4/b6ccf52ec869.png,
  4. 75, Nongshim RedForce, https://i.ibb.co/KY5tKg9/581e986ac101.png,
  5. 73, Karmine Corp, https://i.ibb.co/bjrqvNRm/d5f99dd7f316.png,
  6. 70, BBL Esports, https://i.ibb.co/TzxmFgJ/8f3d12b1467e.png,
  7. 50, Gen.G, https://i.ibb.co/W4kV790x/e88795224928.png,
  8. 45, TYLOO, https://i.ibb.co/whW6vT2Q/a85502d5d506.png,
  9. 44, NRG, https://i.ibb.co/wqCp3Gd/8059731e3d8c.png,
  10. 42, MIBR, https://i.ibb.co/Zb683dw/c43efe062230.png,
  11. 39, Paper Rex, https://i.ibb.co/QjrZfx9M/7658c605bc6d.png,
  12. 29, G2 Esports, https://i.ibb.co/T3QLR2v/ebf81389e3da.png,
  13. 28, T1, https://i.ibb.co/4w505dQ4/457bd88ff142.png,
  14. 26, LOUD, https://i.ibb.co/yBm3wGK7/dc8a51995921.png,
  15. 21, Global Esports, https://i.ibb.co/zWSdLpfF/4c6d19ce8b45.png,
  16. 20, Team Liquid, https://i.ibb.co/MynfPtxw/d8274201ac8b.png,
  17. 19, Team Vitality, https://i.ibb.co/mVYHK1Sm/c806668dac93.png,
  18. 5, FunPlus Phoenix, https://i.ibb.co/tpPYZ3Fw/87010a4bfa97.png,
  19. 4, DetonatioN FocusMe, https://i.ibb.co/939VJjRd/76daee9edf7c.png,
  20. 2, Team Heretics, https://i.ibb.co/84tJdc8V/f0c7e735a1f4.png,
  21. 0, Gentle Mates, https://i.ibb.co/Wv7pY2Yx/9fa882d25f25.png,
  22. -3, Sentinels, https://i.ibb.co/Dfm5DhYm/ee32f2517e9f.png,
  23. -5, JD Gaming, https://i.ibb.co/Wpjm3VJd/aca4d976d711.png,
  24. -7, Natus Vincere, https://i.ibb.co/bMKtcny5/7ce23cba9bd2.png,
  25. -7, FUT Esports, https://i.ibb.co/4Rht21fp/5e1840ce7ac5.png,
  26. -11, Eternal Fire, https://i.ibb.co/Cs4t2qGQ/f43ad132974d.png,
  27. -17, VARREL, https://i.ibb.co/cSdNDpHG/8e17df731134.png,
  28. -21, FNATIC, https://i.ibb.co/XrMBLHh9/6bdd8f2a633d.png,
  29. -21, All Gamers, https://i.ibb.co/N2dfYGxY/03396663687e.png,
  30. -27, KIWOOM DRX, https://i.ibb.co/gLFPbkSY/7c74f2bc75b2.png,
  31. -28, EDward Gaming, https://i.ibb.co/F4qswhPS/d5b998db9743.png,
  32. -29, Bilibili Gaming, https://i.ibb.co/4ZvK9Jwz/aecbb5818a72.png,
  33. -35, Rex Regum Qeon, https://i.ibb.co/VY1HjqWs/c8334f6182e9.png,
  34. -36, Trace Esports, https://i.ibb.co/kgsnHCXg/28512ad7134c.png,
  35. -44, Xi Lai Gaming, https://i.ibb.co/GfLLMLdn/319dc51e2929.png,
  36. -49, Evil Geniuses, https://i.ibb.co/JWB1QfcT/7dec98729b85.png,
  37. -50, Dragon Ranger Gaming, https://i.ibb.co/twXVRnLX/fd1dd33b0438.png,
  38. -53, Wolves Esports, https://i.ibb.co/4gV10r3G/de78efee97a4.png,
  39. -61, Titan Esports Club, https://i.ibb.co/YBhdchdS/6798fe3e5ae6.png,
  40. -62, ENVY, https://i.ibb.co/Pvh5csbB/d7c66bfe6938.png,
  41. -64, Team Secret, https://i.ibb.co/LhZfLxJz/6bc4d350b5e7.png,
  42. -64, KRÜ Esports, https://i.ibb.co/jvM3rPvb/94268480864b.png,
  43. -67, GIANTX, https://i.ibb.co/wFmLw5S5/9aad57951326.png,
  44. -71, Cloud9, https://i.ibb.co/k2hzh1cL/f68f5381d0e4.png,
  45. -83, ZETA DIVISION, https://i.ibb.co/0pR0C2tF/199a1f7acf83.png,
  46. -88, FULL SENSE, https://i.ibb.co/HpD6YMkc/c3ee9bc3a49f.png,
  47. -91, FURIA, https://i.ibb.co/xSXsbBX9/944de43e7079.png,
  48. -134, PCIFIC Esports, https://i.ibb.co/99ZfFRgf/282697948284.png,

(without img)

  1. 123, 100 Thieves, ,
  2. 99, Nova Esports, ,
  3. 87, LEVIATÁN, ,
  4. 75, Nongshim RedForce, ,
  5. 73, Karmine Corp, ,
  6. 70, BBL Esports, ,
  7. 50, Gen.G, ,
  8. 45, TYLOO, ,
  9. 44, NRG, ,
  10. 42, MIBR, ,
  11. 39, Paper Rex, ,
  12. 29, G2 Esports, ,
  13. 28, T1, ,
  14. 26, LOUD, ,
  15. 21, Global Esports, ,
  16. 20, Team Liquid, ,
  17. 19, Team Vitality, ,
  18. 5, FunPlus Phoenix, ,
  19. 4, DetonatioN FocusMe, ,
  20. 2, Team Heretics, ,
  21. 0, Gentle Mates, ,
  22. -3, Sentinels, ,
  23. -5, JD Gaming, ,
  24. -7, Natus Vincere, ,
  25. -7, FUT Esports, ,
  26. -11, Eternal Fire, ,
  27. -17, VARREL, ,
  28. -21, FNATIC, ,
  29. -21, All Gamers, ,
  30. -27, KIWOOM DRX, ,
  31. -28, EDward Gaming, ,
  32. -29, Bilibili Gaming, ,
  33. -35, Rex Regum Qeon, ,
  34. -36, Trace Esports, ,
  35. -44, Xi Lai Gaming, ,
  36. -49, Evil Geniuses, ,
  37. -50, Dragon Ranger Gaming, ,
  38. -53, Wolves Esports, ,
  39. -61, Titan Esports Club, ,
  40. -62, ENVY, ,
  41. -64, Team Secret, ,
  42. -64, KRÜ Esports, ,
  43. -67, GIANTX, ,
  44. -71, Cloud9, ,
  45. -83, ZETA DIVISION, ,
  46. -88, FULL SENSE, ,
  47. -91, FURIA, ,
  48. -134, PCIFIC Esports, ,
#2
Useless_Miks_Ult
0
Frags
+

crazy that BBL missed shanghai tbh

#3
Foxym
0
Frags
+

sometimes you get what you want
sometimes you dont
bbl got unlucky in playoffs i assume, i cant quite remember the matches even though i watched them

#4
Useless_Miks_Ult
0
Frags
+

We had a bad summit then we took over on the next 2 maps pretty easily
FF game was really close but reazy had an insane clutch
and tbh this shows that this stat can be misleading sometimes

#6
Foxym
0
Frags
+

yeah,
numbers, while important, are not the main definition of good or bad

#5
Useless_Miks_Ult
1
Frags
+

ima bump this this is cool

#7
Foxym
0
Frags
+

thanks
there is still some stuff i could make better but i feel like this is a solid start

#8
Useless_Miks_Ult
0
Frags
+

how do your post get litreally 0 engagement bro like wtf

#9
Foxym
0
Frags
+

idk
im just unlucky ig

#10
Useless_Miks_Ult
0
Frags
+

man thats bs

#11
Foxym
0
Frags
+

you say it
and i agree
what have i done for chance to have forsaken me

#12
Foxym
0
Frags
+

a bump for hope
i will bump again in the morning

#13
LouBag
0
Frags
+

pretty cool

#14
Foxym
0
Frags
+

Thanks
I started this project in June (and 100% finished it today) and it's kinda demoralizing not seeing it gain much traction

#15
Foxym
0
Frags
+

morning bump

#16
sh1lll
0
Frags
+

100t #1!!!

kinda crazy how nova is #2

#17
Foxym
0
Frags
+

like shown in the pictures
im only using the 15 most recent matches for this data
but in their 15 most recent matches they have shown solid form (both teams)

#18
Foxym
0
Frags
+

final self bump
if it still gets no recognition i will start to think that the work i put into this was all for nothing

#19
Useless_Miks_Ult
0
Frags
+

you deserve better :(

#20
Foxym
0
Frags
+

thanks
i wont stop doing stuff like this, but if the engagement stays low i start to wonder, for who am i even making this?

its a small mental battle, especially because i worked so long on it

#21
macncheese
0
Frags
+

ur effort is much appreciated, u should look into APIs and formatting and try to construct an API for people to use this data easily. you should think, how will people use this data? why would they use it?

for example, i think u could make alot of cool stats like 'scrappy' and 'clean' teams and establish tiers based on avg stats and stuff, also see which teams are more dependent on fks to win rounds.

the issue isnt with the data u have or have extracted, it IS of value (even if it was done before or there are other ways to reach the same conclusions), imo its w formatting and ease of use. i think putting it into a spreadsheet first of all is a really easy step.

in reality data extraction itself is not smth to awe at, altho i think u did a really cool job here and have something really solid to build on, its what useful insights u can extract from the data.

#22
Foxym
0
Frags
+

sorry for late reply, i had classes

i have an local SQL database for this project where the data is kept
turning it into an Excel Table shouldnt be that hard

as for an Api, no idea how to build one and i dont really want to go through the process of setting up a server, buying a domain, setting up a website, and api
im just one Student

#23
ShanksGamblingAddiction
0
Frags
+

bump cause this is cool af

  • Preview
  • Edit
› check that that your post follows the forum rules and guidelines or get formatting help
Sign up or log in to post a comment