پرس و جو روی داده های json (تمرین پایتون پیشرفته – درسمن)

Question

پرس و جو روی داده های json (تمرین پایتون پیشرفته – درسمن)

سوال

فایل JSON پیوست شده به سوال را مشاهده نماید، سپس برنامه ای بنویسید که به پرس و جوهای زیر پاسخ دهد.

فایل JSON پیوست : sample1

الف) نام و نام خانوادگی تمام افرادی که سن آنها بین ۲۰ تا ۴۰ سال می باشد

ب) نام، نام خانوادگی، و معدل افرادی که متاهل می باشند.

ج) نام و نام خانوادگی سه نفر اول از نظر معدل.

در حال بررسی 0

انجمن برنامه نویسان پایتون مهدی عباسی 4 سال 4 پاسخ ها 424 دیده شده 0

درباره مهدی عباسی

پاسخ ها ( ۴ )

ارسال یک پاسخ

سوال قبلی

سوال بعدی

Mona Azizi Jalilian · Answer 1 · ۱۴۰۰-۰۶-۲۷

import json
import jmespath
import operator
# -------------------------------------------------------------------------------
### deserialize JSON to object, then create a dictionary
with open("people.json","r") as file1:
    peopleList = json.load(file1)
    peopleDict = {}
    peopleDict["People"]= peopleList
# ===========================================================   
### search for special data in a dictionary with JSON format
def searchData(peopleDict):
    ## people between the ages of 20 and 40 
    peopleList1 =jmespath.search("People[?age>`20`&& age<`40`].[name,family]",peopleDict)
    yield peopleList1
    ## information about married people
    peopleList2 = jmespath.search("People[?marital == `true`].[name,family,avg]",peopleDict)
    yield peopleList2
    ## the first three people in terms of grade point average
    peopleList3 = jmespath.search("People[*].[name,family,avg]",peopleDict)
    sortedPeopleList3 = sorted(peopleList3,key= operator.itemgetter(2),reverse=True)
    finalList = list(operator.itemgetter(0,1,2)(sortedPeopleList3))
    finalListItems = []
    for item in finalList:
        finalListItems.append(item[0:2])
    yield finalListItems 
# ------------------------------------------------------------------------------    
object1 = searchData(peopleDict)
print("List of people between the ages of 20 and 40:")
print()
print(next(object1))
print(90*"*")
print("List of married people and their grade point averages:")
print()
print(next(object1))
print(90*"*")
print("List of first three people in terms of grade point average:")
print()
print(next(object1))

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

import json

import jmespath

import operator

# -------------------------------------------------------------------------------

### deserialize JSON to object, then create a dictionary

with open("people.json","r") as file1:

peopleList = json.load(file1)

peopleDict = {}

peopleDict["People"]= peopleList

# ===========================================================

### search for special data in a dictionary with JSON format

def searchData(peopleDict):

## people between the ages of 20 and 40

peopleList1 =jmespath.search("People[?age>`20`&& age<`40`].[name,family]",peopleDict)

yield peopleList1

## information about married people

peopleList2 = jmespath.search("People[?marital == `true`].[name,family,avg]",peopleDict)

yield peopleList2

## the first three people in terms of grade point average

peopleList3 = jmespath.search("People[*].[name,family,avg]",peopleDict)

sortedPeopleList3 = sorted(peopleList3,key= operator.itemgetter(2),reverse=True)

finalList = list(operator.itemgetter(0,1,2)(sortedPeopleList3))

finalListItems = []

for item in finalList:

finalListItems.append(item[0:2])

yield finalListItems

# ------------------------------------------------------------------------------

object1 = searchData(peopleDict)

print("List of people between the ages of 20 and 40:")

print()

print(next(object1))

print(90*"*")

print("List of married people and their grade point averages:")

print()

print(next(object1))

print(90*"*")

print("List of first three people in terms of grade point average:")

print()

print(next(object1))

Reza · Answer 2 · ۱۴۰۰-۰۷-۰۴

import jmespath
import json


def find_people_as_age(people_data):
    result = jmespath.search("[?age>`20` && age<`40`].{name: name, family: family}", people_data)

    return result


def find_married_people(people_data):
    result = jmespath.search("[?marital == `true`].{name: name, family: family, age: age}", people_data)

    return result


def find_three_highest_averages(people_data):
    search_str = "sort_by(@, &avg)[-3::].{name: name, family: family, avg: avg}"
    result = jmespath.search(search_str, people_data)

    return result


with open('sample1.json', 'r') as sample_file:
    people_data = json.load(sample_file)

print(find_people_as_age(people_data))
print('-'*50)
print(find_married_people(people_data))
print('-'*50)
print(find_three_highest_averages(people_data))

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

import jmespath

import json

def find_people_as_age(people_data):

result = jmespath.search("[?age>`20` && age<`40`].{name: name, family: family}", people_data)

return result

def find_married_people(people_data):

result = jmespath.search("[?marital == `true`].{name: name, family: family, age: age}", people_data)

return result

def find_three_highest_averages(people_data):

search_str = "sort_by(@, &avg)[-3::].{name: name, family: family, avg: avg}"

result = jmespath.search(search_str, people_data)

return result

with open('sample1.json', 'r') as sample_file:

people_data = json.load(sample_file)

print(find_people_as_age(people_data))

print('-'*50)

print(find_married_people(people_data))

print('-'*50)

print(find_three_highest_averages(people_data))

M.jahangiri · Answer 3 · ۱۴۰۰-۰۷-۰۱

import json
import jmespath
import operator
# loading sampel file --------------------------------------- 
sapmelDict=[]
with open("sampel.json","r")as sampel:
    sapmelDict=json.load(sampel)
# Between Twenty And Forty Years pepole file-----------------
def BetweenTwentyAndFortyYears(jstr):
    result=jmespath.search("[?`40>age`&& age>`20`].{name: name,family:family age:age}",sapmelDict)
    with open("file1.json","w")as file1:
        json.dump(result,file1,indent=4)
        print("writing compele....")
# marital true pepole file ----------------------------------
def maritalTrue(jstr):
    result=jmespath.search("[?marital==`true`].{name: name,family:family marital:marital}",sapmelDict)
    with open("file2.json","w")as file2:
        json.dump(result,file2,indent=4)
        print("writing compele....")
# three most avge file ---------------------------------------
def mostAvgs(jstr):
    sortavglist=sorted(jstr,key=operator.itemgetter("avg"),reverse=True) 
    sortavglistGetter=operator.itemgetter(1,2,3)
    resolt=sortavglistGetter(sortavglist)
    with open("file3.json","w")as file3:
        json.dump(resolt,file3,indent=4)
        print("writing compele....")
#----------------------------------------------------------------- 
BetweenTwentyAndFortyYears(sapmelDict) 
maritalTrue(sapmelDict)       
mostAvgs(sapmelDict)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

import json

import jmespath

import operator

# loading sampel file ---------------------------------------

sapmelDict=[]

with open("sampel.json","r")as sampel:

sapmelDict=json.load(sampel)

# Between Twenty And Forty Years pepole file-----------------

def BetweenTwentyAndFortyYears(jstr):

result=jmespath.search("[?`40>age`&& age>`20`].{name: name,family:family age:age}",sapmelDict)

with open("file1.json","w")as file1:

json.dump(result,file1,indent=4)

print("writing compele....")

# marital true pepole file ----------------------------------

def maritalTrue(jstr):

result=jmespath.search("[?marital==`true`].{name: name,family:family marital:marital}",sapmelDict)

with open("file2.json","w")as file2:

json.dump(result,file2,indent=4)

print("writing compele....")

# three most avge file ---------------------------------------

def mostAvgs(jstr):

sortavglist=sorted(jstr,key=operator.itemgetter("avg"),reverse=True)

sortavglistGetter=operator.itemgetter(1,2,3)

resolt=sortavglistGetter(sortavglist)

with open("file3.json","w")as file3:

json.dump(resolt,file3,indent=4)

print("writing compele....")

#-----------------------------------------------------------------

BetweenTwentyAndFortyYears(sapmelDict)

maritalTrue(sapmelDict)

mostAvgs(sapmelDict)

ijavadddd · Answer 4 · ۱۴۰۰-۰۶-۲۶

import json
import jmespath
import operator 


try:
    directoryAddress="C:/Users/Javad/Desktop/Python/proj2/file/pro3.json"
    with open(directoryAddress,"rb") as file3:
        jsonFileData=file3.read()
        DataToJson=json.loads(jsonFileData)
        DataToJson=sorted(DataToJson,key=operator.itemgetter("age"),reverse=True)
        searchResultAge=jmespath.search("[?age>`20` && age<`40`].[name,family]",DataToJson)
        searchResultMarital=jmespath.search("[?marital==`true`].[name,family,age]",DataToJson)
        searchResultMax=jmespath.search("[*].[name,family]",DataToJson)
    
        for person in searchResultAge:
            print(f"Name : {person[:][0]}\tFamily : {person[:][1]}")
        
        print(100*"#")
    
        for person in searchResultMarital:
            print(f"Name : {person[:][0]}\tFamily : {person[:][1]}\tAge : {person[:][2]}")
    
        print(100*"*")
        
        count=0
        for person in searchResultMax:
            print(f"Name : {person[:][0]}\tFamily : {person[:][1]}")
            if count==2:
                break
            count+=1
except:
    print("Incorrect Directory,No Such File.")

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

import json

import jmespath

import operator

try:

directoryAddress="C:/Users/Javad/Desktop/Python/proj2/file/pro3.json"

with open(directoryAddress,"rb") as file3:

jsonFileData=file3.read()

DataToJson=json.loads(jsonFileData)

DataToJson=sorted(DataToJson,key=operator.itemgetter("age"),reverse=True)

searchResultAge=jmespath.search("[?age>`20` && age<`40`].[name,family]",DataToJson)

searchResultMarital=jmespath.search("[?marital==`true`].[name,family,age]",DataToJson)