Steam Hardware Survey July 2020
Distribution of CPU , GPU across steam devices as published by
@kaggle.kunwardeepak_steam_hardware_survey_july_2020
Distribution of CPU , GPU across steam devices as published by
@kaggle.kunwardeepak_steam_hardware_survey_july_2020
I got intrigued when steam asked my permission to collect data regarding my system's hardware . Obviously , very next instant i was out googling for this data to see if its public or not . And voila here it is .
This particular datasets contains really limited data of just distribution of CPU, GPU among various platform . Steam it self releases minimal data publicly and from that I decided to web scrap just this particular data as i think for every person either making a new rig or upgrading a current one combination of CPU and GPU contribute to be of major concern for both performance and money .
Data is scraped from the following link .
https://store.steampowered.com/hwsurvey/Steam-Hardware-Software-Survey-Welcome-to-Steam
Further I will be publishing a scrapping notebook for this website so as to help any one else scrape data in order to have updated monthly data with ease .
CREATE TABLE cpu_cores (
"unnamed_0" BIGINT -- Unnamed: 0,
"cpu_cores" VARCHAR,
"os" VARCHAR,
"mar" VARCHAR,
"apr" VARCHAR,
"may" VARCHAR,
"jun" VARCHAR,
"jul" VARCHAR,
"n__change" VARCHAR -- % CHANGE
);CREATE TABLE cpu_frequency (
"unnamed_0" BIGINT -- Unnamed: 0,
"cpu_frequency" VARCHAR,
"manufacturer" VARCHAR,
"os" VARCHAR,
"mar" VARCHAR,
"apr" VARCHAR,
"may" VARCHAR,
"jun" VARCHAR,
"jul" VARCHAR,
"n__change" VARCHAR -- % CHANGE
);CREATE TABLE gpu (
"unnamed_0" BIGINT -- Unnamed: 0,
"gpu_name" VARCHAR,
"mar" VARCHAR,
"apr" VARCHAR,
"may" VARCHAR,
"jun" VARCHAR,
"jul" VARCHAR,
"n__change" VARCHAR -- % CHANGE
);CREATE TABLE gpu_directx (
"unnamed_0" BIGINT -- Unnamed: 0,
"gpu_name" VARCHAR,
"directx" VARCHAR,
"mar" VARCHAR,
"apr" VARCHAR,
"may" VARCHAR,
"jun" VARCHAR,
"jul" VARCHAR,
"n__change" VARCHAR -- % CHANGE
);Anyone who has the link will be able to view this.