What high schools produce the most recruits in the Pac-12 recruiting footprint?

AIRWOLF

In my continuing quest to prove I have no life whatsoever learn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).

A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.

High Schools Producing the Most Recruits in Pac-12 Footprint

Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.

RaceBannon

Good stuff

IE Life

FireCohen

I thought my life was pathetic

AIRWOLF

Oh, forgot to mention that I also included Nevada in the geographical footprint.

UW_Doog_Bot

AIRWOLF said:

In my continuing quest to prove I have no life whatsoever learn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).

A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.

High Schools Producing the Most Recruits in Pac-12 Footprint

Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.

It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.

AIRWOLF

WeakarmCobra said:

I thought my life was pathetic

I am not arguing, but I would much rather do these tutorials using recruiting data rather than the sales and financial results of a fake bicycle company (that is a real example).

FireCohen

AIRWOLF said:

WeakarmCobra said:

I thought my life was pathetic

I am not arguing, but I would much rather do these tutorials using recruiting data rather than the sales and financial results of a fake bicycle company (that is a real example).

Fuck you, u just described my fucking job.

AIRWOLF

UW_Doog_Bot said:

AIRWOLF said:

In my continuing quest to prove I have no life whatsoever learn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).

A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.

High Schools Producing the Most Recruits in Pac-12 Footprint

Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.

It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.

I did a quick filter and included only recruits that eventually signed with Pac-12 schools. That filtered out the recruits that signed with Group of 5 schools, but also removed the recruits that got poached by Power 5 level schools from outside of the region.

The biggest takeaway, is that outside of CA there are very few high schools that produce Pac-12 level recruits year in and year out.



Of course we all know this, but looking at the numbers, it is pretty sobering.

UW_Doog_Bot

Looking at some of it it seems you have 35 Ca. schools who have produced 9(avg 1 per year) or more recruits. Those schools are responsible for producing almost exactly HALF or all the recruits recorded.

UW_Doog_Bot

AIRWOLF said:

UW_Doog_Bot said:

AIRWOLF said:

In my continuing quest to prove I have no life whatsoever learn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).

A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.

High Schools Producing the Most Recruits in Pac-12 Footprint

Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.

It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.

I did a quick filter and included only recruits that eventually signed with Pac-12 schools. That filtered out the recruits that signed with Group of 5 schools, but also removed the recruits that got poached by Power 5 level schools from outside of the region.

The biggest takeaway, is that outside of CA there are very few high schools that produce Pac-12 level recruits year in and year out.



Of course we all know this, but looking at the numbers, it is pretty sobering.

Even more sobering when you consider the average over time means only about 4 schools in that entire sample are producing more than 1 player per year. Someone send this to Kalepo's coach.

CFetters_Nacho_Lover

AIRWOLF said:

UW_Doog_Bot said:

AIRWOLF said:

In my continuing quest to prove I have no life whatsoever learn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).

A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.

High Schools Producing the Most Recruits in Pac-12 Footprint

Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.

It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.

I did a quick filter and included only recruits that eventually signed with Pac-12 schools. That filtered out the recruits that signed with Group of 5 schools, but also removed the recruits that got poached by Power 5 level schools from outside of the region.

The biggest takeaway, is that outside of CA there are very few high schools that produce Pac-12 level recruits year in and year out.



Of course we all know this, but looking at the numbers, it is pretty sobering.

Your spreadsheet is obviously wrong as I see no mention of #mylancers.