I am trying to read a csv file into a dataframe to transform that into nested jsons. The deliminter in the csv file is ';'. After loading the data into a dataframe, following is what I get: name frequency frequency_start_date…
import json response_message = { 'id': 'chatcmpl-9Iof6Uwf74o9N6uKsyxIVMFFIDJYC', 'object': 'chat.completion', 'created': 1714271676, 'model': 'gpt-3.5-turbo-0125', 'choices': [ { 'index': 0, 'message': { 'role': 'assistant', 'content': 'sfsdfs {n "plant": {n "light blocker": 1,n "give water": 0,n "spray water": 0,n "conditions": {n "humidity (%)":…
Below is the JSON I have [ { "item_attr1": "abc", "item_attr2": "123", "item_attr3": "123", "item_id": "12345", "bucket_attr1": 1919, "bucket_attr2": "abc", "bucket_attr3": 1922, "bucket_attr4": "abc", "bucket_id_1": "abc", "bucket_id_2": "def", "bucket_id_3": "ghi", "articleattribute1": "abc", "articleattribute2": "abc", "articleattribute3": "2233", "article_id": "123458" }, {…
That's my basic code: public class MyObject { public decimal MyDeciaml { get; set; } public string? MyImageBase64 { get { if (MyImageBase64 != null) { byte[] imageBytes = Convert.FromBase64String(MyImageBase64); using (MemoryStream stream = new MemoryStream(imageBytes)) { BitmapImage bitmapImage =…
I need to write a file that can be appended (and not overwritten!) and then to read this file. This is the code I wrote: import io, json def WriteJSON(): Taskslist = [["1Name", "1c:/path/file.ext", "1Some other text", 10, ["a", "b",…
Using Presto SQL, the original format of the column appears like this "{"ORDERS (completed)": 1000.00, "ORDERS (failed) USD": 3000.00}" and I am trying to extract the key and value by parsing and casting as map (varchar, double) and then unnesting…
I'm trying to ingest some Microsoft Flow API data into Azure Log Analytics. Goal is that a Power Automate send a JSON with the Flows details to Log Analytics. Here is the sample JSON : { "body": [ { "NAME":…
This is my first time working with AWS SCPs. Hello everyone! I am designing an AWS test SCP policy and I am curious to understand why this doesn't work. The goal is to deny all network modifications except for this…
var data_filter = data.filter( element => element.zip == "12180") console.log(data_filter) I have this so far which gets me 1 zip code match but I have 126, how do I rewrite this to return results for all entries that contain any…
I am working on a Java Spring Boot application. I have a JSON in the following format. I need to search for a string and return the results in the same JSON format containing only the matching entries. The original…