Okay, so I wanted to mess around with some college football data, specifically the 2017 Ohio State roster. Here’s how I went about it.
First, I needed to find the data. I figured some sports website would have it, but I wasn’t sure which one would be best. I started by just Googling “ohio state 2017 roster football”. I know, super basic, but it’s a start, right?
The first few results were what I expected. After scrolling around a little bit, I saw the official athletics site. I figured that had to have the correct information. I mean, who knows better than the team itself, am i right?
I clicked on it, and yep, there it was! A full roster. I could see the players’ names, numbers, positions, heights, weights, everything. It looked pretty complete to me.
Digging into the Data
Now that I had the roster, I wanted to actually do something with it. I’m not a programmer or anything, but I figured I could at least copy and paste it into a spreadsheet. So, I highlighted all the player information on the website.
I created a new spreadsheet in Google Sheets and tried *! All the data was there, but it was a little messy. All the information for each player was in one cell, separated by spaces and stuff.
I wanted to separate the data into nice neat columns,one for name, one for position, and so on. Luckily I found out there is a “split text to columns” * took a little playing around to figure out the right settings, but it worked in the end.
So, that’s pretty much it. I found the 2017 Ohio State football roster and got it into a spreadsheet. It wasn’t rocket science, but I felt pretty good about figuring it out!
