Case Study: Sim Racing Hardware Survey – From University Project to Annual Community Census
How a forgotten university project evolved into an annual benchmark census for the global sim racing community, uncovering profound hardware and spending shifts using a custom Python ETL pipeline.
1. The Accidental Census
In May 2022, I compiled a simple hardware questionnaire for a university project, shared it on Reddit's r/simracing community, and promptly forgot about it. When I checked back, I was stunned: hundreds of sim racers had filled out the form, eager to see how their hardware and preferences compared to their peers. What was supposed to be a one-time homework assignment had tapped into a deep, underserved demand for raw, community-centric market research. I realized this couldn't be a one-off; it had to become an annual benchmark census.
Over the next four years (2022–2026), the survey grew into a massive recurring initiative, capturing a cumulative 2,364+ detailed responses. Rather than relying on expensive, polished market research firms, I decided to tackle this as a 'vibe-coder'—a product-minded enthusiast leveraging AI coding assistants to design robust data pipelines, analyze open-text feedback, and export publication-grade community insights.
2. Inside the Vibe-Coder's Toolkit
As a vibe-coder, my superpower is not syntax memorization, but system architecture and rapid prototyping. I designed the entire ETL (Extract, Transform, Load) pipeline using Python and Pandas, directing ChatGPT Codex to write clean, vectorized data manipulation scripts. I then utilized NotebookLM to parse thousands of open-text qualitative comments, auto-generate podcast summaries, and analyze visual video feedback. By coordinating these tools as a product architect, I built a zero-cost, highly sophisticated community analytics pipeline that would normally require a team of researchers.
3. The Data Standardization Gauntlet
Aggregating questionnaire responses over four years introduced a series of formidable data engineering hurdles that required creative logic:
Fuzzy Name Standardization
Raw inputs were incredibly messy. Users entered hardware brands in hundreds of spelling variants (e.g., 'Simucube 2 Pro', 'sc2 pro', 'simu cube', 'simucub'). I built a Python fuzzy matching and dictionary mapping engine that strips punctuation, applies case-insensitive regex rules, and clusters disparate strings into standardized hardware families (e.g., Moza, Fanatec, Simagic, Logitech).
Cross-Year Comparability
As the survey evolved, questions and multiple-choice categories shifted. Ingesting four separate Google Forms CSVs required mapping dynamic schemas. I engineered an integration layer that aligns inconsistent column headers, resolves missing data points, and standardizes currency entries to maintain precise trend-line integrity across all years.
Multi-Dimensional Spending
Simple single-column counts only tell half the story. I leveraged Pandas to build multi-dimensional cross-tabulations, correlating drivers' self-reported experience levels with their overall cockpit budget. This mapped clear high-end spending corridors, showing exactly where beginner vs. advanced racers cluster on the budget spectrum.
4. Spotlight: The Turkish Dimension
Recognizing that global hardware statistics hide local macroeconomic realities, I expanded the survey in 2025 to offer dedicated Turkish insights, localized for r/simracingtr:
5. Implementation & Analysis Workflow
The pipeline executes a rigid multi-phase sequence to convert raw inputs into structured assets:
We ingest annual Google Forms CSV outputs into Pandas DataFrames, programmatically removing obvious joke submissions and cleaning empty rows while preserving raw counts.
We use regex-driven mappings and string distances to standardize hundreds of variations of wheelbase, pedal, and VR brands into neat, deterministic categories.
The Python script automatically generates high-resolution bar charts, trend lines, and dumbbell plots with curated HSL-tailored colors for community posts.
6. Key Insights & Market Disruption
Automated ETL Performance
Data Span: 2022 to 2026. Cleanup Automation: 100% automated. Cumulative responses: 2,364+. The entire pipeline executes in under 2.5 seconds, saving weeks of manual spreadsheet sorting.
Top Direct-Drive Moza Disruption
"Moza rose from 0% in 2022 to 24.1% in 2026, leading the wheelbase sample. Spending did not cool down: setups costing $2k+ grew from 29.4% to 59.5%."
Key Lessons
System Architecture Wins Over Code Syntax
As a vibe-coder, you don't need a computer science degree to build sophisticated analytics pipelines. Orchestrating AI models (Codex for Python/Pandas, NotebookLM for comments) allows you to act as a Product Architect, focusing on vision and insights.
Standardize Data Schemas Early
Clean, uniform data is critical for trend accuracy. Designing consistent survey forms avoids massive fuzzy-mapping debt later and makes cross-year comparisons seamless.
Localize for True Impact
Macro trends obscure local realities. Localizing data analysis (like our r/simracingtr subset) uncovers socioeconomic and market nuances that make reports infinitely more resonant.
Summary of Achievements
The Sim Racing Hardware Survey project is a testament to the power of community-driven data science. What began as a forgotten university homework assignment has blossomed into a comprehensive annual census, trusted by thousands of racing enthusiasts to track equipment trends and market shifts.
The Rise of Direct-Drive: A 4-Year Hardware Disruption
The most dramatic story told by the data is the rapid democratization of Direct-Drive (DD) wheelbases. In 2022, entry-level gear- and belt-driven wheels from Logitech and Thrustmaster represented over 65% of the market. High-end direct-drive setups from brands like Simucube were expensive, niche investments.
By 2026, the landscape had flipped entirely. Moza Racing, a brand that was virtually non-existent in our 2022 data, emerged as the leading wheelbase manufacturer at 24.1% of the sample, closely followed by Fanatec at 21.7% and Simagic at 17.2%. Conversely, Logitech fell from 38.5% to 17.9%, and Thrustmaster collapsed from 26.6% to just 5.8%. This indicates a massive migration towards accessible direct-drive technology.
Wheelbase Brand Market Share shifts
The Premium Shift: Rigs and Riches
Sim racing is no longer a casual desk-bound hobby. In 2022, only 29.4% of respondents had hardware setups valued over $2,000, and standard desks were the default mounting surface.
In 2026, setups costing $2,000+ made up 59.5% of the sample, and the ultra-premium tier ($10,000+) climbed to 8.9%. This massive financial expansion is mirrored in rig hardware: dedicated aluminium profile rigs rose to 41.7% of all setups, while desk mounts plummeted to 12.3%.
Setup Cost Shifts over 4 Years
The Demographics Controversy: Re-evaluating the "Aging Cliff"
When we analyzed the 2025 results, we observed a massive aging spike. The estimated average age of respondents jumped to 37.9 years, leading to a widespread community discussion about a potential "aging cliff"—the idea that young racers were being priced out of the hobby by escalating equipment costs, leaving only older, high-income enthusiasts.
However, adding the 2026 survey data challenged this neat conclusion. In 2026, the estimated average age cooled down to 35.1 years, driven by a strong rebound in the 25-34 age bracket (climbing to 37.1%). This highlights the critical importance of multi-year, continuous tracking: a single year's result is often just a localized anomaly, not a permanent demographic trajectory.
Resources & External Links
Live Interactive Dashboards & Search Engines
- Sim Racing Results Interactive Dashboard – Explore dynamic, interactive charts and filters mapping the 2026 survey findings.
- NotebookLM Shared Notebook – Access the raw survey documents, AI-generated podcasts, and natural language Q&A interface.
Raw Data Google Sheets (4 Years)
- 2026 Raw Data Google Sheet
- 2025 Raw Data Google Sheet
- 2023 Raw Data Google Sheet
- 2022 Raw Data Google Sheet
Reddit Community Threads
- 2026 Edition: Questionnaire Launch | Results & Analysis Discussion
- 2025 Edition: Questionnaire Launch | Results Discussion
- 2023 Edition: Questionnaire Launch | Results Discussion
- 2022 Edition: Questionnaire Launch | Results Discussion