I'm trying to merge some json objects using jq. It seems to complicated for me ^^ I have a json which looks like this [ { "name": "test_name", "cpu": "1", "ip": "192.168.0.1", "kv_key": "test2_key", "kv_value": "test2_value", "location": "here" }, {…
How to convert a pyspark data frame like below to a json array structure OrderID field fieldValue itemSeqNo 123 Date 01-01-23 1 123 Amount 10.00 1 123 description Pencil 1 123 Date 01-02-23 2 123 Amount 11.00 2 123 description…
I am using python to convert the text input file to json. My Code: import json import re filename = "text.txt" text = {} pattern = re.compile(r's*([^=t]+)s*=s*(.*)') with open(filename, encoding='utf8') as file: for line in file: match = pattern.match(line.strip()) if…
My business requirement is to store lists of issues & responses as JSON data within a SQL Server 2019 table. Each list corresponds to a page within a document. At minimum, I'd like to be able to retrieve the GUID…
I have a column called users with this JSON. { "[email protected]":[1.0,5.95], "[email protected]":[2.0,30.733], "[email protected]":[1.0,4.433], "[email protected]":[2.0,16.25] } I want to unwrap it in this way splitUsers firstValue secondValue [email protected] 1.0 5.95 [email protected] 2.0 30.733 [email protected] 1.2 4.433 [email protected] 2.0 16.25 I managed…
I programmed a classic Snake using pygame. i want to save the top 5 scores and when someone beats one of those scores the game overrides the current top records. what would the topfive dictionary look like and how can…
I have data that looks like this (sanitized). This is axios output from Azure artefact feeds into response array { "value": [ { "normalizedName": "@test", "name": "@test", "versions": [ { "normalizedVersion": "1.2.6", "version": "1.2.6", } ], }, { "normalizedName": "@test2",…
This is my docker-compose file: { "name": "movies-docker-test", "services": { "movies-rp": { "volumes": [ { "type": "volume", "source": "certs", "target": "/etc/nginx/certs", }, { "type": "bind", "source": "/home/nblanchet/jeudi_infra/kubernetes/okd/movies-docker-test/reverse-proxy/wikibase.conf.template", "target": "/etc/nginx/templates/wikibase.conf.template" } ] } } } I'd like to update this file…
I'm attempting to find the number of occurrences based on input value for ownerId in the JavaScript Json Object below. If the ownerId is the number "1" the result should be three since the ownerId appears 3 times. ownerID: 3…
I have a json object with key cgi, tag and name key where cgi is repeated in any multiple object if any cgi get the tag as 'revert' then that cgi should not get returned. [ { "cgi": "abc-123", "tag":…