By colorado 
Alright, so yesterday I was itching to dig into some actual football stats, you know? See what patterns I could spot. Kept hearing about Spain’s dominance and Georgia being the underdog, so thought, “Hey, why not?” Picked the Spain vs Georgia clash as my little project.
Where the heck do I even start?
First step was obviously getting the raw numbers. Went hunting online. Searched something like “Spain Georgia football match detailed stats.” Yadda yadda. Found a couple sites reporting basic stuff – goals, possession, shots. But I wanted details, the nitty-gritty like shots on target, saves, passes, maybe even tackles. Took me a good while clicking around, bouncing between different football stats places. Some were messy, others needed signing up (nope!). Finally landed on a site that seemed legit and offered a downloadable spreadsheet format. Sweet. Clicked download. Felt like a small win already.
The Ugly Raw Data Stage
Opened the CSV file. Whoa. Instant headache. Total mess!Columns were labeled weirdly.
- “ShTarg” – Shots on target? Or target practice? Who knows!
- “Poss_Perc” was clear enough – possession percentage.
- But “KP” – Key Passes? Kitten Pictures? Gah!
Had to dig into the site’s glossary to figure out their shorthand. Also, stats were just dumped in rows for Spain and Georgia, but lacked clear labels sometimes for which was which. Needed to manually double-check against known facts (like, Spain usually has way more possession). Total pain, but hey, practice record gotta be real.
Cleaning Up the Mess
Time to make this readable. Opened my trusty spreadsheet tool (let’s be honest, I used Google Sheets).
- First, renamed those stupid columns: “ShTarg” became “Shots On Target”, “KP” became “Key Passes”. Simple stuff.
- Added clear headers: “Team”, “Goals”, “Shots”, “Shots On Target”, “Possession %”, “Pass Accuracy %”, “Fouls Committed”, “Corners” – you get the idea.
- Filled in missing bits by cross-referencing simpler reports I saw earlier. Found the exact numbers for fouls and corners elsewhere and plugged them in.
- Made one nice little table for each team, Spain up top, Georgia below. Looked clean. Phew.
Let’s See What This Stuff Actually Says
Okay, clean data. Time to stare at it.First thing jumped out:
- Spain’s Possession was like, 75%. Seventy-Five! Georgia barely had the ball. Gave them less than 30%? That’s insane control.
- Goals: Spain smashed them. 4-1? Ouch. No surprise seeing Spain had way more shots on target too.
But what about Georgia? The underdog story! Looked closer at Georgia’s little table:
- Only like maybe 2 shots on target? One of those went in! So, crazy efficient with the few chances they got. Pure grit?
- Also, their Pass Accuracy was surprisingly decent considering they hardly had the ball. Shows they weren’t just blindly hoofing it.
Slapped together some simple charts right in the spreadsheet. Bar charts showing Shots, Shots on Target, Goals. Clear as day – Spain overwhelming.
Basically, confirmed what everyone said. Spain machine just rolls on. Super high possession = control, lots of shots = constant threat, and they finish them. Georgia showed spirit with their one goal on minimal chances, but the stats really paint the picture of total Spanish domination through relentless possession and attacking pressure. Simple analysis, but seeing the actual numbers behind the result is always satisfying. There it is, my little stat dive! Fun way to spend an afternoon messing with spreadsheets and football numbers.