sulk | Solidity compilation without the tears | Cryptocurrency library

I apologize for any formatting issues or unclear parts, I'm VERY new to Python and programming in general. I want to make a script that pulls a list of research participant records (the code provided here is sample data) and the list contains separate dictionary-like items that have all of the screening questions (including the record id, or subject ID). I want to pull particular items (self-harm reports and suicidal thoughts questions) from this depending on what the script's user inputs as the record id

I want the script to be able to pull from a growing list of dictionaries, so it has to index So far I have tried to return a tuple based on the user input, but it returns the same values regardless of what I input for subj, it returns the same three values ('1', '2', '1'), the values of ONLY the first dictionary

I have been sulking around this place for a while and until now I have been able to find an answer to virtually any problem I have come across. I feel like I am on the right path for the answer I need, but I can't seem to figure out the right way to go about it.

Below I have a screenshot of a simplistic example of what I am wanting to do. In the example, I have 4 people, who picked their top 5 favorite colors (I am horrible at generating fake data like this, so please excuse the color choices haha). Ultimately, I want to know how many individuals matched all 5 colors (doesn't have to be in the same order), how many matched 4, 3, 2, etc. To the right of the data set is ideally how I would want my data to look (H2:M11).

I have approached this a number of ways, but haven't had much success. The two methods that seem to be closest are:

SEE FAILED IDEA 1) I wanted to write a formula that basically said "count the number of times that sumproduct(countif(Colors from Person 2,3, and 4 : Colors from Person 1)) is equal to 5 (in this example zero). I would replicate the formula for 4 matching colors, 3, 2, and so on. Then just sum and average.

The formula itself is flawed and returns as error. So, since this didn't pan out...

SEE FAILED IDEA 2) I thought about making a "heat map" style table where I could have Persons 1 through 4 on rows and columns then do something I know that worked like sumproduct(countif(B4:F4,B5:F5)) for Person 1 vs Person 2 (answer 3). Only difference is that I would have to use an index(match) to identify the proper row by using the column name (see example). Drag for all 16 (4x4) cells and then just have a countif(F19:I22,"5") to count the number of each. Unfortunately, the use of index(match) within the countif causes a #REF!

Simplistic Example Data

If either concept can actually be made to work, I could manipulate the rest. I know I could just do the heat map design and manually change the formulas for each column, but my real data is over 100 rows long. VBA alternatives are also welcome.

I apologize if my description wasn't very clear. If it was confusing, just let me know and I will try to be more clear. THANKS!