Create Python code to process data on IT courses held in a l…
Create Python code to process data on IT courses held in a list of lists (i.e. a two dimensional list) like the following: courseList = [ [‘IT109’, ‘001’, ‘TR720’, ‘Hashmi’, ’29’], [‘IT109’, ‘002’, ‘MW1030’, ‘Shuman’, ’28’], [‘IT109’, ‘003’, ‘TR720’, ‘Vosoughi’, ’24’], … ] # a variable number of other sublists follow You should assume the above variable “courseList” is available in your answer code and not have to be retyped into your answer. Each sublist in courseList consists of five data items. Your code must convert the above list into JSON formatted data and write it to a file called “JSONCourseData.txt”. To do that the above sublists must be converted into a list of dictionaries, each sublist (course line) becoming a dictionary and then appended to a list. The sublist (course) dictionary must have three labelled data elements: “number”, which consists of a concatenation of the course number and section, “instructor”, and “registrants”. The resulting dictionary for the first sublist in the courseList example above should look like this: courseDict = {“number”: “IT109-001”, “instructor”: “Hashmi”, “registrants”: “29”} One of these dictionaries is created for each sublist, then appended to a list. When done, the entire list of dictionaries is written to the file “JSONCourseData.txt”. Be sure to use the appropriate Python json code to create the correct format. Note that nothing needs to be printed, but be sure to name the list of dictionaries “allCourses”. The estimated number of lines of code needed to do the above is in the 10 – 15 range.
Read Details