SQL Scouting Algorithms

[ProfessorAlekM]

Hello!
Our rookie team had a hard time choosing an alliance during the Livonia eliminations, and since I have some experience in using python with SQL, I am going to attempt making a simple command line interface program for scouting.

Since it will be a pain for my team to type in sql arguments, I'll just use a GUI sql database editor so that they can easily add and edit team data.

However I would like to make a python program that can read my database and figure out the capabilities of my team and the enemy team, then come up with possible defense selections.

I would also like to make it list the teams that would work best with our robot in an alliance, based on data about defenses they cross, and how efficiently they can score.

Of course this is alot to ask for, but the key is in what you put into the database.

For example, visibility was a major issue scouting teams overlooked. The database could tell us what teams had the camera extender poles, cameras on bots, or positioning flags (quite genius!), so we could decide if we want to pick big defenses to block vision.

Another issue in deciding teams is simplicity and speed. Some teams that shot for the high goal where actually less point efficient then low goal shooters, and some drivers breached defenses Waaay faster than others.

This last bit of data may be hard to get, but what about "percentage of tournament robot is broken" or "percentage of matches the robot dies on the field" or "average points"?

Any ideas on what I should put into my database? (Or what I should put into each category ie. 0-1 for defense categories, or points added together for each extra vision add-on) So far I've got:
low goal
high goal
defenses
visibility
average points
speed

We are only a rookie team with 10ish people, so most of the data I mentioned we probably won't have time to gather or code.

Any recommendations?

(sorry for any misspelling, I typed this on a phone)