What Is Parquet? Column-Oriented Storage Explained with Racing Data
Learn how Parquet stores racing telemetry, create files with Python, and compare file sizes, read times, and column selection using 205,002 rows of real GT7 data.
Read articleToolstudio22 / Independent software studio
Turn ideas into
useful software.
An independent studio building data analysis tools and web applications.
Explore the tools, and the design, implementation, and testing behind them.
01 / FEATURED WORK
GT7 Telemetry Lab
A Windows analysis tool for the racing game Gran Turismo 7. Compare driving logs, understand the differences, and decide what to try in your next practice session.
01 / OVERVIEW
Turn the time gap into a focus for your next lap.
See sections where time is lost and differences in driving inputs in one view.
Watkins Glen Long Course / Genesis Gr.3 / RM · Dry
02 / FOCUS
Start with a section worth a closer look.
Begin your analysis with sections that show larger time losses.
Improvement areas and map / Excerpts from the same screenACTUAL APPLICATION SCREEN 03 / COMPARE
Compare driving inputs at the same point on track.
Use speed, brake, and throttle traces to decide what to try next.
1,400–2,100 m / Three channels and the original distance axisACTUAL APPLICATION SCREEN 04 / PRACTICE
Turn a section into focused practice.
Save a section and review how its times change across your laps.
Saved section and time trends / Actual screen excerptsACTUAL APPLICATION SCREEN Section and full-lap times across all 24 recorded laps on August 31, 2026. The first lap remains selected, as in the analysis.
02 / LATEST BLOG
Notes from the work.
Why compare by distance? How should the interactions connect? Read about the decisions and experiments behind the tools.
Can you capture GT7 telemetry? How receiving it with Python works
Learn how a PC receives GT7 driving data through UDP, heartbeats, and decryption, and discover the gt-telem Python library and its requirements.
Read article03 / ENGINEERING PRINCIPLES
The thinking behind the tools.
In GT7 Telemetry Lab, these principles shape how laps are compared, decisions are explained, and source data is handled.
- 01
Make comparisons meaningful.
Align laps by distance, even when speeds differ. Interpolate on a one-meter grid to compare driving inputs at the same place.
- 02
Show the basis for a decision.
Connect sections with time losses to differences in speed, braking, and throttle, so the numbers can inform what to try next.
- 03
Keep source data intact.
Read driving CSV files without changing them. Store practice sections and settings in separate JSON files.
04 / TOOLSTUDIO22
Beyond an idea.
Something that works.
Toolstudio22 is an independent software studio turning ideas into useful tools through AI, data analytics, and web application development.
Get in touch