you can filter using the following:
a = list(filter(lambda x: x['name'] == 'IE_Traitement_0A', data['completedapps']))
a will contain a list of all dict that match your filter and then you can sort the the list for the latest one -- using whatever key to sort it by
sorted_a = sorted(a, key=lambda k: k['starttime'])
if you want only one then select the first element of sorted_a assuming it's not empty.
EDIT: use min instead of sorted thanks for the tip @VPfB
min_a = min(a, key=lambda k: k['starttime'])
Top answer 1 of 3
2
you can filter using the following:
a = list(filter(lambda x: x['name'] == 'IE_Traitement_0A', data['completedapps']))
a will contain a list of all dict that match your filter and then you can sort the the list for the latest one -- using whatever key to sort it by
sorted_a = sorted(a, key=lambda k: k['starttime'])
if you want only one then select the first element of sorted_a assuming it's not empty.
EDIT: use min instead of sorted thanks for the tip @VPfB
min_a = min(a, key=lambda k: k['starttime'])
2 of 3
0
req_json = """{"completedapps" : [ {
"starttime" : 1520863179923,
"id" : "app-20180312145939-0183",
"name" : "IE_Traitement_3",
"cores" : 1,
"user" : "root",
"memoryperslave" : 1024,
"submitdate" : "Mon Mar 12 14:59:39 CET 2018",
"state" : "FINISHED",
"duration" : 212967
}, {
"starttime" : 1520863398147,
"id" : "app-20180312150318-0186",
"name" : "IE_Traitement_3",
"cores" : 1,
"user" : "root",
"memoryperslave" : 1024,
"submitdate" : "Mon Mar 12 15:03:18 CET 2018",
"state" : "FINISHED",
"duration" : 6321
}, {
"starttime" : 1520863387941,
"id" : "app-20180312150307-0185",
"name" : "IE_Traitement_0A",
"cores" : 1,
"user" : "root",
"memoryperslave" : 1024,
"submitdate" : "Mon Mar 12 15:03:07 CET 2018",
"state" : "FINISHED",
"duration" : 149536
} ]}"""
import json
data = json.loads(req_json)
print(sorted(data['completedapps'], key=lambda x: x['starttime'])[0]['id'])
out:
app-20180312145939-0183
Explanation: first get list of dict and sort then by timestamp.
Python Json. Getting only the last element in the json array - Stack Overflow
I just started trying out python, and right now i am in a little bit of a dilemma. I am trying to print from a json documents, and i am only getting the last element in the array. [{ "FullMea... More on stackoverflow.com
python - How do I get the last element of a json list? - Stack Overflow
Communities for your favorite technologies. Explore all Collectives · Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work More on stackoverflow.com
json - How to get the last value from the list using python? - Stack Overflow
Communities for your favorite technologies. Explore all Collectives · Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work More on stackoverflow.com
Get last item in JSON array with Python - Stack Overflow
I'm trying to grab the last item in a json array and haven't been able to come across any documentation that shows how to do this. {'numbers': [1, 2, 3]} how do I just get 3? ANSWERED: import json More on stackoverflow.com
Reddit
reddit.com › r/learnpython › reading the last element in a json file
r/learnpython on Reddit: Reading the last element in a json file
March 30, 2019 -
I have a json file that looks like this: https://gist.github.com/SirDarknight/95cf48d46c17059a5f42a38ec70c7fa5
What's the best way to get the last object's "Title" key? (In this case: Mercy Black (2019) )
Edit: I'm thinking about wrapping the whole thing in a list and then loading the list
Top answer 1 of 2
2
That file isn't a json object, it's multiple json objects in a single 'file'. Compare the difference between {"a": 1} {"b": 1} to [ # <- a single container holding the items {"a": 1}, # <- comma's to separate the items {"b": 1}, ] the first example is an analogue of your file, the second an example of a proper json object containing those two objects. Note that you always need either a list or a dict in a json to hold multiple items. You can't simply list them below each others (so just newline separated) as in the first example. If your file would actually be the second example, then the outer sequence is a list already, so, you can already do my_json_file[-1] to get the last item in that list
2 of 2
1
Json has no ordering in it. Neither do python dictionaries, which you can create from json objects with the json library. Check it out. If you want the order to be preserved, you might try using collections.OrderedDict but it might be put in the wrong order before it gets to be ordered. How should the json know what the order is? You might want to add a numeric ID or order field so you can check which one is the last.
Top answer 1 of 9
1
You are replacing the value every time through that loop. You should be adding to the value, instead.
So first create the value as an empty list (before the loop), then on each iteration of the loop, append to that list:
value = []
rec = recipes['Recipes'][0]['Ingredients']
for records in rec:
value.append({'Ingredient ID': records['IngredientID']})
However, having a list of dictionaries, where each dictionary has one single value with the same known key, seems a bit pointless. Depending on your requirements, you probably may want to do either this:
value.append(rec)
or
value.append(records['IngredientID'])
2 of 9
0
What you're doing right now is that you're redefining value again every loop. You will need to define value before the loop and assign it to an empty list that you can add to.
value = {'Ingredient ID':[]}
for records in rec:
value['Ingredient ID'].append(records['IngredientID'])
You can also define value as a list like this:
value = []
for records in rec:
value.append(records['IngredientID'])
Stack Overflow
stackoverflow.com › questions › 68394053 › how-do-i-get-the-last-element-of-a-json-list
python - How do I get the last element of a json list? - Stack Overflow
July 15, 2021 - How do I get the last element of a list? [closed] (20 answers) Closed 4 years ago. Here I'm trying to get the last m2id to print it into console. [{ "m2id":"865199733949071370", "author":{ "id":"862323352869797948" } }, { "m2id":"865199658103078925", "author":{ "id":"751742911682445312" } }] And here's the code I wrote for it. (r.json being the json above): data = r.json() for id in data: id3 = id["id"][-1] print(id3) Running the code gave me the last number of the first m2id, Which is not what I want.
CoenRaets
jsonviewer.ai › python-get-last-element-in-list5-methods-with-code-examples
Python Get Last Element in List[5 Methods with Code Examples] - JSON Viewer
July 29, 2023 - Additionally, Python supports negative indexing, where -1 refers to the last element, -2 to the second last, and so forth. Positive indexing allows you to access elements from the start of the list, with starting index as 0.
Stack Overflow
stackoverflow.com › questions › 49505335 › how-to-get-the-last-value-from-the-list-using-python
json - How to get the last value from the list using python? - Stack Overflow
data = ['reply': '{"osc":{"version":"1.0"}}'] data1 = ['reply':'{"device":{"network":{"ipv4_dante":{"auto":"1.0"}}}}'] I need to get only the "1.0" value from data and data1 using python 3.6. How ...
Stack Overflow
stackoverflow.com › questions › 77223566 › get-last-item-in-json-array-with-python
Get last item in JSON array with Python - Stack Overflow
import json array = json.load(str({'numbers': [1, 2, 3]})) lastItem = array['numbers'][-1] # This is the format. ... semi-related in that it shows examples of numpy multi-dimensional array vs python list access stackoverflow.com/questions/1...
Stack Overflow
stackoverflow.com › questions › 63501465 › only-returns-the-last-element-of-the-list
python - Only returns the last element of the list? - Stack Overflow
August 20, 2020 - Copyimport json print(len(test_json)) # Using simple for loop for index in range(len(test_json)): shapes = test_json[index][u'shapes'] print(shapes) But this returns only the points from the last element of the list. How do I get all the points from this list?
Stack Overflow
stackoverflow.com › questions › 65447666 › get-the-last-element-in-a-large-json-file-using-python
Get the Last Element in A Large JSON file using Python - Stack Overflow
import ijson with open('customerAccounts.json', 'rb') as file: for key, value in ijson.kvitems(file, ''): pass print(key, value) key and value are here the last values from the iteration process. There are other ways to get the latest value from an iteration that might be faster (e.g., using a deque of size 1), but this should do.
Microsoft Power Platform Community
powerusers.microsoft.com › t5 › Building-Flows › Parsing-JSON-get-the-last-array › td-p › 1270092
Forums | Microsoft Power Platform Community
September 14, 2021 - Quickly search for answers, join discussions, post questions, and work smarter in your business applications by joining the Microsoft Dynamics 365 Community.
Top answer 1 of 5
46
You can do this by accessing the jsonData.seats array by index, index of the last item being equal to jsonData.seats.length-1
simply:
var countryId = jsonData.seats[jsonData.seats.length-1].countryid
2 of 5
3
NB: Copy of @iuliu.net's code
use DOT at
example.at(-1)
var jsonObject = {
"expirationDate":"April 21, 2017",
"remainingDays":325,
"seats":[{"activeStatus":"S","pid":"TE70","firstName":"TE70","countryid":840},
{"activeStatus":"Y","pid":"TE80","firstName":"TE80","countryid":845}]
}
var lastElement = jsonObject.seats.at(-1).countryid
GeeksforGeeks
geeksforgeeks.org › python-how-to-get-the-last-element-of-list
Get the Last Element of List in Python - GeeksforGeeks
May 10, 2025 - The simplest and most efficient method uses negative indexing with a[-1]. In Python, we can use -1 as an index to access the last element directly. ... We can also find the last element by using len() function.
SitePoint
sitepoint.com › javascript
How can I access last object in JSON array - JavaScript
February 2, 2015 - I have an object in localstorage and would like to match the last element that I have added when I called $(‘form’).serializeArray(); I am trying to match the text from a dropdown that is populated with the keys from lo…
PythonHow
pythonhow.com › how › get-the-last-element-of-a-list
Here is how to get the last element of a list in Python
New: Practice Python, JavaScript & SQL with AI feedback — Try ActiveSkill free → × ... To get the last element of a list in Python, you can use the index -1.You can also use the pop() method to remove and return the last element of a list. This method removes the element from the list, ...
Spark By {Examples}
sparkbyexamples.com › home › python › python get the last element of a list
Python Get the Last Element of a List - Spark By {Examples}
May 31, 2024 - Have you ever needed to get the last element of a list in Python, but weren't sure of the best way to do it? There are several different methods you can
Gatling
community.gatling.io › gatling (open-source)
Get last element of JSON tab of objects response - Gatling (Open-Source) - Gatling
June 28, 2023 - I have a project where I need to get the last object of a JSON list that is returned in JSON but I can’t get any idea of how to from a .check My builder: ChainBuilder getAllOrders = exec(http("Orders: /api/orders") .get("/api/orders") .header("Authorization", "Bearer ${BearerToken}") .check(status().is(200)) .check(jsonPath("$..id").saveAs("OrderIds"))); The response of the get is "[ { "id": 3, "order_number": "{ord_nb}", "dat...
freeCodeCamp
freecodecamp.org › news › python-get-last-element-in-list-how-to-select-the-last-item
Python Get Last Element in List – How to Select the Last Item
March 15, 2022 - Just like we established in the last section, each item in a list has an index number which starts at zero. In Python, we can also use negative values for these indexes. While the positive indexes start from 0 (which denotes the position of the first element), negative indexes start from -1, and this denotes the position of the last element.
Scaler
scaler.com › home › topics › last element in list python
Program to Get the Last Element in List in Python - Scaler Topics
May 18, 2023 - Using negative indexing is a very efficient solution to get the last element from the list, even if the size of the list is large. The list[-n] gives the nth-to-last element of the list. In Python, the list class provides a method pop().
EyeHunts
tutorial.eyehunts.com › home › get last element of list python
Get last element of list Python - Tutorial - EyeHunts
December 26, 2023 - A simple example code gets the last element. list1 = [1, 2, 3, 4, 5] ele = list1.pop() print(ele) print("Updated list: " + str(list1)) # another way a_list = ['zero', 'one', 'two', 'three'] print(a_list[-1]) print(a_list) ... You can do li[-n] to get the nth element starting from the end, it is just accessed by the index and it is faster than li[len(li) – 1]...