Python Column Generation With Averageif Equivalent To Excel

I've poured over StackOverflow and just cant figure this one out. I a data tables with unique letter# combinations, and im trying to get the 'averageif' of those values into the se

Solution 1:

Well, you can do that using groupby as follows:

df.groupby('Letter').mean()