python - Formatting JSON output -

-

i have json file key value pair data. json file looks this.

{     "professors": [         {             "first_name": "richard",              "last_name": "saykally",              "helpfullness": "3.3",              "url": "http://www.ratemyprofessors.com/showratings.jsp?tid=111119",              "reviews": [                 {                     "attendance": "n/a",                      "class": "chem 1a",                      "textbook_use": "it's must have",                      "review_text": "tests incredibly difficult (averages in 40s) , lectures useless. attended both lectures every day , still unable grasp concepts on midterms. scope out gsi , ride curve."                 },                  {                     "attendance": "n/a",                      "class": "chemistry1a",                      "textbook_use": "essential passing",                      "review_text": "saykally isn't bad made him out  be. if go lectures spends half time blowing things up, if read texts before lectures , pay attention he's writing/saying, you'd okay. posts practice tests representative of actual tests , curves class nicely!"                 }]          {       {         "first_name": "laura",          "last_name": "stoker",          "helpfullness": "4.1",          "url": "http://www.ratemyprofessors.com/showratings.jsp?tid=536606",          "reviews": [             {                 "attendance": "n/a",                  "class": "ps3",                  "textbook_use": "you need sometimes",                  "review_text": "stoker far best professor.  if put in effort, take notes, , ask questions, fine in class. far lecture, go bit fast, lecture in form of outline. long take notes, have need exams. funny , super nice if speak her"             },              {                 "attendance": "mandatory",                  "class": "164a",                  "textbook_use": "barely cracked open",                  "review_text": "amazing professor.  has way of keeping lectures interesting.  yes, can little everywhere , quick lecture, gsi's useful make sure understand material.  oh, , did mention she's hilarious!"             }]     }]

so i'm trying multiple things. i'm trying mentioned ['class'] key under reviews. class name , times mentioned. i'd output format in manner. under professor array. it's info of professors instance chem 1a, chemistry1a - it's richard saykally. 

{     courses:[     {        "course_name" : # class name        "course_mentioned_times" : # amount of times class mentioned        professors:[ #the professor array should have professor teaches class in shown json file          {               'first_name' : 'professor name'               'last_name' : 'professor last name'          }     }

so i'd sort json file key-value have max minimum. far i've been able figure out isd

if __name__ == "__main__":         open_json = open('result.json')         load_as_json = json.load(open_json)['professors']         outer_arr = []         outer_dict = {}         items in load_as_json:              output_dictionary = {}             all_classes = items['reviews']             classes in all_classes:                 arr_info = []                 output_dictionary['class'] = classes['class']                 output_dictionary['first_name'] = items['first_name']                 output_dictionary['last_name'] = items['last_name']                 #output_dictionary['department'] = items['department']                 output_dictionary['reviews'] = classes['review_text']                 open('output_info.json','wb') outfile:                     json.dump(output_dictionary,outfile,indent=4)

i think program want:

import json   open('result.json') open_json:     load_as_json = json.load(open_json)  courses = {} professor in load_as_json['professors']:     review in professor['reviews']:         course = courses.setdefault(review['class'], {})         course.setdefault('course_name', review['class'])         course.setdefault('course_mentioned_times', 0)         course['course_mentioned_times'] += 1         course.setdefault('professors', [])         prof_name = {             'first_name': professor['first_name'],             'last_name': professor['last_name'],         }         if prof_name not in course['professors']:             course['professors'].append(prof_name)  courses = {     'courses': sorted(courses.values(),                       key=lambda x: x['course_mentioned_times'],                       reverse=true) } open('output_info.json', 'w') outfile:     json.dump(courses, outfile, indent=4)

result, using example input in question:

{     "courses": [         {             "professors": [                  {                     "first_name": "laura",                     "last_name": "stoker"                 }             ],              "course_name": "ps3",              "course_mentioned_times": 1         },          {             "professors": [                 {                     "first_name": "laura",                      "last_name": "stoker"                 }             ],             "course_name": "164a",              "course_mentioned_times": 1         },         {             "professors": [                 {                     "first_name": "richard",                      "last_name": "saykally"                 }             ],              "course_name": "chem 1a",              "course_mentioned_times": 1         },          {             "professors": [                 {                     "first_name": "richard",                      "last_name": "saykally"                 }             ],              "course_name": "chemistry1a",              "course_mentioned_times": 1         }     ] }

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more