Should be every player who has played a VLR game not sure if my program missed some.
https://docs.google.com/spreadsheets/d/1dWFdY6TL0_asIcBHr1y6kr7wOpGb4VWd3Nvdi_vAF80/edit?gid=190653449#gid=190653449
Do what you will with this information, i made it for fun
3
Player Stats Spreadsheet
posted in
General Discussion
Comments:
Threaded
Linear
Is this stats for their current team only or all time?
If its all time I think its off btw cause flors avg rating all time rating is 1.50
ratings = [1.41, 1.37, 1.28, 1.29, 1.39, 1.13, 1.14, 1.51, 1.17, 1.37, 1.58, 1.42, 1.35, 1.77, 1.69, 1.71, 1.72, 1.53, 1.67, 1.12, 1.63, 2.12, 1.42, 2.23]
total_sum = sum(ratings)
count = len(ratings)
average_rating = total_sum / count
print(average_rating) #1.5008333333333332Convoy [#9]how the fuck did you scrap the information
Yeahhhhhhhhh you got me thinking with this comment, just coded it. Was pretty fun
The below code gives me these all time avg stats for flor though:
{'player_name': 'florescent', 'rnd': 451, 'rating': 1.5, 'acs': 284.03, 'kd': 1.9, 'adr': 184.59, 'kast': 81, 'kpr': 1.03, 'apr': 0.38, 'fkpr': 0.11, 'fdpr': 0.07, 'k': 463, 'd': 302, 'a': 99, 'fk': 90, 'fd': 52}
import requests
from bs4 import BeautifulSoup
player_stats_template = {
"player_name": "", # Player's name
"rnd": 0, # Number of rounds played
"rating": 0.0, # Player rating
"acs": 0.0, # Average combat score
"kd": 0.0, # Kill/Death ratio
"adr": 0.0, # Average damage per round
"kast": 0, # Kill, Assist, Survive, or Traded percentage
"kpr": 0.0, # Kills per round
"apr": 0.0, # Assists per round
"fkpr": 0.0, # First kills per round
"fdpr": 0.0, # First deaths per round
"k": 0, # Total kills
"d": 0, # Total deaths
"a": 0, # Total assists
"fk": 0, # Total first kills
"fd": 0 # Total first deaths
}
TOTAL_MAX_PLAYERS = 48850 # total number of players on vlr to potentially scrape
def get_player_data(player_num):
url = f"https://www.vlr.gg/player/{player_num}/?timespan=all"
response = requests.get(url)
if response.status_code != 200:
return None
soup = BeautifulSoup(response.content, 'html.parser')
# player name ^-^
player_name_tag = soup.find('h1', class_='wf-title')
player_name = player_name_tag.text.strip() if player_name_tag else player_num
player_stats_template["player_name"] = player_name
accumulator = {key: 0 for key in player_stats_template if key != "player_name"}
num_rows = 0
stat_keys = list(player_stats_template.keys())[1:]
# get stats table
table = soup.find_all('table', class_='wf-table')
for ratings_tag in table:
tbody = ratings_tag.find('tbody')
if tbody:
rows = tbody.find_all('tr')
for row in rows:
# extract all td that do not have a style attribute (no agent img & use % )
cols = row.find_all('td')
row_values = [col.text.strip() for col in cols if not col.has_attr('style')]
# If the number of columns matches our expected stats, process the row
if row_values and len(row_values) == len(stat_keys):
for i, key in enumerate(stat_keys):
# Accumulate values based on the key's expected data type
if isinstance(player_stats_template[key], int):
accumulator[key] += int(row_values[i].replace('%', ''))
else:
accumulator[key] += float(row_values[i])
num_rows += 1
# calculate averages
if num_rows > 0:
for key in accumulator:
if isinstance(player_stats_template[key], int):
# for intege use floor division
player_stats_template[key] = accumulator[key] // num_rows
else:
# for floating point round to two decimal places
player_stats_template[key] = round(accumulator[key] / num_rows, 2)
return player_stats_template
# florescent
player_num = '17976'
player_data = get_player_data(player_num)
if player_data:
print(player_data)
# Uncomment the code below to iterate through every player up to TOTAL_MAX_PLAYERS
# for i in range(1, TOTAL_MAX_PLAYERS + 1):
# player_num = str(i) # Convert player number to string for URL construction
# player_data = get_player_data(player_num)
# if player_data:
# print(player_data)
# break # Stop after finding and printing the first valid player data
ariLMFAO [#12]How have you got this information
I saw on the spreadsheet your discord was ari.aim and that rung a bell somewhere
so I checked Refraction's discord server eventually after realising and yeah, there you were
Aayan [#15]I saw on the spreadsheet your discord was ari.aim and that rung a bell somewhere
so I checked Refraction's discord server eventually after realising and yeah, there you were
pretty funny lol
yukky [#11]Yeahhhhhhhhh you got me thinking with this comment, just coded it. Was pretty fun
The below code gives me these all time avg stats for flor though:
{'player_name': 'florescent', 'rnd': 451, 'rating': 1.5, 'acs': 284.03, 'kd': 1.9, 'adr': 184.59, 'kast': 81, 'kpr': 1.03, 'apr': 0.38, 'fkpr': 0.11, 'fdpr': 0.07, 'k': 463, 'd': 302, 'a': 99, 'fk': 90, 'fd': 52}
import requests from bs4 import BeautifulSoup player_stats_template = { "player_name": "", # Player's name "rnd": 0, # Number of rounds played "rating": 0.0, # Player rating "acs": 0.0, # Average combat score "kd": 0.0, # Kill/Death ratio "adr": 0.0, # Average damage per round "kast": 0, # Kill, Assist, Survive, or Traded percentage "kpr": 0.0, # Kills per round "apr": 0.0, # Assists per round "fkpr": 0.0, # First kills per round "fdpr": 0.0, # First deaths per round "k": 0, # Total kills "d": 0, # Total deaths "a": 0, # Total assists "fk": 0, # Total first kills "fd": 0 # Total first deaths } TOTAL_MAX_PLAYERS = 48850 # total number of players on vlr to potentially scrape def get_player_data(player_num): url = f"https://www.vlr.gg/player/{player_num}/?timespan=all" response = requests.get(url) if response.status_code != 200: return None soup = BeautifulSoup(response.content, 'html.parser') # player name ^-^ player_name_tag = soup.find('h1', class_='wf-title') player_name = player_name_tag.text.strip() if player_name_tag else player_num player_stats_template["player_name"] = player_name accumulator = {key: 0 for key in player_stats_template if key != "player_name"} num_rows = 0 stat_keys = list(player_stats_template.keys())[1:] # get stats table table = soup.find_all('table', class_='wf-table') for ratings_tag in table: tbody = ratings_tag.find('tbody') if tbody: rows = tbody.find_all('tr') for row in rows: # extract all td that do not have a style attribute (no agent img & use % ) cols = row.find_all('td') row_values = [col.text.strip() for col in cols if not col.has_attr('style')] # If the number of columns matches our expected stats, process the row if row_values and len(row_values) == len(stat_keys): for i, key in enumerate(stat_keys): # Accumulate values based on the key's expected data type if isinstance(player_stats_template[key], int): accumulator[key] += int(row_values[i].replace('%', '')) else: accumulator[key] += float(row_values[i]) num_rows += 1 # calculate averages if num_rows > 0: for key in accumulator: if isinstance(player_stats_template[key], int): # for intege use floor division player_stats_template[key] = accumulator[key] // num_rows else: # for floating point round to two decimal places player_stats_template[key] = round(accumulator[key] / num_rows, 2) return player_stats_template # florescent player_num = '17976' player_data = get_player_data(player_num) if player_data: print(player_data) # Uncomment the code below to iterate through every player up to TOTAL_MAX_PLAYERS # for i in range(1, TOTAL_MAX_PLAYERS + 1): # player_num = str(i) # Convert player number to string for URL construction # player_data = get_player_data(player_num) # if player_data: # print(player_data) # break # Stop after finding and printing the first valid player data
ahhh right thanks mate
Discord