dictionary Questions

Function to return all related data from json list using any given key

March 14, 2023
SIM777
3 Answers

I have the following json data about experts. result={ "experts":[ { "thumbnail": "https://scholar.googleusercontent.com/citations?view_op=small_photo&user=JicYPdAAAAAJ&citpid=2", "name": "Geoffrey Hinton", "link": "https://scholar.google.com/citations?hl=en&user=JicYPdAAAAAJ", "author_id": "JicYPdAAAAAJ", "email": "Verified email at cs.toronto.edu", "affiliations": "Emeritus Prof. Comp Sci, U.Toronto & Engineering Fellow, Google", "cited_by": 638900, "interests": [ {…

VIEW QUESTION

Python – Json: append element

March 13, 2023
JonesDK
2 Answers

I'm trying to add a element to a json file, but i can add it to the level 4 of the file (LogDetails), however, it works for level 3 (Logs). I'm all new to Python and i can seem to…

VIEW QUESTION

Return number of objects based on created date from a list of nested JSON objects

March 12, 2023
Mar3eczek17
2 Answers

I have a list of JSON objects and want to return a dictionary with the count of objects based on created[year-month] where created[year-month] is the key and count the value. I tried: result = {} for record in data_in: if…

VIEW QUESTION

Python format json for saving to file

March 9, 2023
Nikky Leed
2 Answers

My data looks like this: Key1: [Key2:[{},{},...{}]] The code something like this: dict_={} dict_['Key2']=all_items dict_fin={} dict_fin['Ke1']=[dict_] df=pd.DataFrame(dict_fin) df.to_json(filepath, orient="records",lines=True) I would like to have saved json like this: { "Key1": [{"Key2" : [{},{},...,{}]}] } Instead, I get it like this:…

VIEW QUESTION

Is there any way to add multiple dictionaries to a JSON file

March 9, 2023
xKwm1
2 Answers

I tried adding an array with dictionaries into a JSON file, but it returns a bunch of errors, so I'm wondering if is it possible to add dictionaries into a JSON file. (I'm not trying to push data into the…

VIEW QUESTION

Removing items from nested json in Python

March 1, 2023
LuiTe
2 Answers

I have to manipulate nested json file in way that only one assignment stays. How it looks now: import json a = ''' { "tasks": [ { "Assignments": [ { "EmployeeId": "1000", "TotalWork": 1, "RemainingWork": 1 }, { "EmployeeId": "3L2kVk00x",…

VIEW QUESTION

Json – How can I fetch the activity_message value if my conditions are verified:

March 1, 2023
Perl_Newbie
3 Answers

Sample data: user_id = 1 project_id = 2 a = [{ "_id": { "$oid": "63fda80f3ab1f908c146131d" }, "data": { "project_id": 2, "user_id": 1, "activity_message": "Success 1", "activity_created_on": { "$date": "2023-02-28T12:30:55.652Z" } } },{ "_id": { "$oid": "63fda80f3ab1f908c146131d" }, "data": { "project_id":…

VIEW QUESTION

Json – Python flatten a dictionary column

March 1, 2023
Young Z
2 Answers

It should be a simple line of code using pd.json_normalize function but it's working only with a single string and it's not batch processing my whole column Orginial dataframe df['addresses'][0] [{'addressLine1': '124 Main Street', 'addressLine2': '', 'addressLine3': '', 'city': 'Portland',…

VIEW QUESTION

Json Exercise to dictionary using python

February 28, 2023
Sebastian Hanania
4 Answers

I'm doing a course and I'm a little complicated with this exercise I have 2 json that I have to join in a dictionary, but this must meet certain rules. department = [ {"ID": 1, "Name": "John", "Role": "Manager", "employees"…

VIEW QUESTION

Json – Update values of an array of dictionaries from a pandas dataframe

February 24, 2023
matheusppedroso
4 Answers

I have a this array of dictionaries: jsn = [{'ID' : '01', 'Item' : 'Apple', 'salesman' :'Johnny'}, {'ID': '02', 'Item': 'carrot', 'salesman':'Patricia'}, {'ID': '04', 'Item' : 'airplane', 'salesman' : 'Eddgard'}, {'ID' : '05', 'item' : 'iron', 'salesman' : 'Bettany'}] and…

VIEW QUESTION