I managed to get the 32 best points. Now I am trying to get the index of 32 best students so that I can show who they are. The link to my json file is here:

https://drive.google.com/file/d/1OOkX1hAD6Ot-I3h_DUM2gRqdSl5Hy2Pl/view

And the code is below:

import json


file_path = "C:/Users/User/Desktop/leksion 10/testim/u2/olympiad.json"

with open(file_path, 'r') as j:

    contents = json.loads(j.read())
    print(contents)

print("\n================================================")

class Competitor:
    def __init__(self, first_name, last_name, country, point):
        self.first_name = first_name
        self.last_name = last_name
        self.country= country
        self.point = int(point)
    def __repr__(self):
        return f'{self.first_name} {self.last_name} {self.country} {self.point}'

olimpiade=[]

for i in contents:
    olimpiade.append(Competitor(i.get('first_name'),
                                i.get('last_name'),
                                i.get('country'),
                                i.get('point'),))
print(olimpiade)
print("\n================================================")


#32 nxënësit më të mirë do të kalojnë në fazën e dytë. Të ndërtohet një funksion i cili kthen konkurentët e fazës së dytë.
print("\n================================================")

print(type(olimpiade))
print(type(contents))
print(type(Competitor))

for i in contents:
    

print(a)

print("\n================================================")

for i in olimpiade:
    for j in i:
        L=olimpiade.sort(key=lambda x: x.point)
print(L)

I have tried this for example

pike=[]
for value in contents:
    pike.append(value['point'])
print(pike)


n = 32
  
pike.sort()
print(pike[-n:])

CodePudding user response：

Using the data from your link and downloading to file 'olympiad.json'

Code

import json

def best_students(lst, n=1):
    '''
        Top n students
    '''
    return sorted(lst, 
                  key = lambda d: d['point'],  # sort based upon points
                  reverse = True)[:n]          # Take n talk students

def best_students_by_country(lst, m=1):
    '''
        Top m students in each country
    '''
    # Sort by country
    by_country = sorted(lst, key = lambda d: d['country'])
    
    groups = []
           
    for d in by_country:
        if not groups:
            groups.append([])
        elif groups[-1][-1]['country'] != d['country']:
              groups.append([])    # add new country
        # Append student
        groups[-1].append(d)  # append student to new country
        
    # List comprehension for best m students in each group
    return [best_students(g, m) for g in groups]
          

Usage

# Deserialize json file
with open('olympiad.json', 'r') as f:
    data = json.load(f)

# Top two students overall
print(best_students(data, 2))

# Top two students by country
print(best_students_by_country(data, 2))

Outputs

[{'first_name': 'Harvey',
  'last_name': 'Massey',
  'country': 'Bolivia',
  'point': 9999},
 {'first_name': 'Barbra',
  'last_name': 'Knight',
  'country': 'Equatorial Guinea',
  'point': 9998}]

[[{'first_name': 'Wade',
   'last_name': 'Dyer',
   'country': 'Afghanistan',
   'point': 9822},
  {'first_name': 'Terrell',
   'last_name': 'Martin',
   'country': 'Afghanistan',
   'point': 8875}],
 [{'first_name': 'Delaney',
   'last_name': 'Buck',
   'country': 'Albania',
   'point': 9729},
  {'first_name': 'Melton',
   'last_name': 'Ford',
   'country': 'Albania',
   'point': 9359}],
    ...

CodePudding user response：

I have written how to make a useful dictionary out of your question.

Firstly, I am assuming all your values are in a list, and each value is a string

That would be texts

We can get list of countries from external sources

pip install country-list
from country_list import countries_for_language
countries = dict(countries_for_language('en'))
countries = list(countries.values())

Initialise empty dictionary - scores_dict = {}

for i in texts:
  for j in countries:
    if j in i:
      country = j
 
  score = [int(s) for s in i.split() if s.isdigit()]

  try:
    scores_dict[country].extend(score)
  except:
    scores_dict[country] = score

This will give you a dictionary that looks like this

{'Albania': [5287],
 'Bolivia': [1666],
 'Croatia': [1201],
 'Cyprus': [8508]}

From here, you can just iterate through each country to get top 5 students overall and top 5 students for each country.

CodePudding user response：

There should be a grade range and grade of each student, that is what will help you filter the best students.