Takes in a Parent Dataset which contains unique ID(key) and Name/Group ID as Attributes (JSON file), And another .xlsx which has been categorized into different sheets (Clubs), with unique IDs from the parent dataset along with the "interest" of that unique ID for that specific "club" (google sheet, in this case). Our code outputs a JSON file that has been populated and categorized according to different excel sheets(or "clubs") and gives a convenient way to store it as a database in a single file.
Made in Collaboration with Deepak Kumar (/deepakjuit)