Q$18$:

Note: Before you begin working on this question, please note that CodeGrade has a $1$GB RAM limit$.$ If you see an Exit $-9$ code when submitting your assignment, it is probably due to this RAM limit and previous students had an issue with this question causing too much memory usage. The biggest thing to think about is to only use the tables that you need to answer for this question. For instance, you do not need any of the minifigs data since this is not needed for the output and the merging of this data could cause the number of rows to "explode" in terms of the total count. I understand that this can be annoying that we have to work around CodeGrade's limitations$,$ but it is good practice in memory management.

You should only need to merge the following datasets for this answer so as to not go above the RAM limit: themes, sets, inventories, inventory$\_$parts, parts, and colors

Create a function called set$\_$parts that takes as input the set number $($as a string$)$ and version number $($as an integer$)$ and outputs a DataFrame with each part in the set.

The DataFrame should have the following columns$/$column names: set$\_$num, version, name$\_$sets, year, name$\_$themes, part$\_$num, name$\_$part, name$\_$color,quantity,is$\_$spare.

The Data should be sorted by part$\_$num and then name$\_$color.

The index should go from $0$ to n$-1.$

The datarames are in the image.