json Questions

Is there a tidy way to read a JSON string and translate into new variables?

June 13, 2023
MoDe
2 Answers

I have a JSON string that I would like to spearate into new variables. I feel there must be a clever way but I cannot find the solution. df <- structure(list(subject = c("dtv85251vucquc45", "mcj8vdqz7sxmjcr0" ), response = c("{"P0_Q0":{"aktiv":2,"bekümmert":3,"interessiert":4,"freudig erregt":2,"verärgert":2,"stark":0,"schuldig":1,"erschrocken":1,"feindselig":1,"angeregt":2},"P1_Q0":{"stolz":1,"gereizt":1,"begeistert":2,"beschämt":2,"wach":1,"nervös":1,"entschlossen":1,"ängstlich":1,"aufmerksam":2,"durcheinander":2}}", "{"P0_Q0":{"aktiv":1,"bekümmert":3,"interessiert":1,"freudig…

VIEW QUESTION

How to convert four and 2 space indented text to json format

June 13, 2023
dallascow
3 Answers

I have been spending hours to convert the space indented text to JSON. In my raw text data, nested values are indented by 4 spaces and key:value are indented by 2 spaces. I am trying to make a JSON out…

VIEW QUESTION

Load JSON file into SQL Server Table with Powershell

June 13, 2023
Cenko
2 Answers

I am trying to load a JSON file (output from Mongo's Export-MdbcData) into a SQL Server table using Powershell. The example JSON file data is as follows: { "code" : "0088", "name" : "BUTTON", "detail" : { "quantity" : 1…

VIEW QUESTION

Json – Why does the deserialization return null?

June 13, 2023
MrSourceSys
2 Answers

I am trying to deserialize the response from the SteamAPI in C# .NET 7. I make the REST request via RestSharp and save the content as a file. Later I load the file and want to deserialize it to search…

VIEW QUESTION

Convert the XML to JSON by preserving the data types without model in c#

June 13, 2023
Manil
2 Answers

I am trying to convert an XML to JSON without changing the datatypes but it is always returning the string value. I have tried different ways to convert with proper data types. Below is my source XML and expected JSON…

VIEW QUESTION

Pandas: Convert group into list of jsons without using groupby or apply

June 13, 2023
Animeartist
2 Answers

I have an item dataframe such as: item_dict = { 'index': [18, 24, 25, 26, 30, 31, 37, 38, 61, 62, 63, 67, 68, 69], 'BarCode_x': ['12345678ABCD', '12345678IJKL', '12345678IJKL', '12345678IJKL', '12345678EFGH', '12345678EFGH', '67890123IJKL', '67890123IJKL', '67890123ABCD', '67890123ABCD', '67890123ABCD', '67890123EFGH', '67890123EFGH', '67890123EFGH'],…

VIEW QUESTION

How do I convert a JSONArray to a multidimensional arraylist?

June 13, 2023
abhishek_6198
2 Answers

My code: try { JSONArray array = new JSONArray(response.body()); List<JSONArray> arr = new ArrayList<>(); for (int i = 0; i < array.length(); i++) { arr.add(array.getJSONArray(i)); } Log.d("arr",arr.toString()); }catch (JSONException e) { throw new RuntimeException(e); } This is my arr: [["bdbd","hdhs","hdhd","1234567890","[[shhs,…

VIEW QUESTION

Converting large (140MB) JSON file into CSV in Python

June 13, 2023
Amazing Random
2 Answers

I've been trying to do a data wrangling exercise with large files and I chose this big file, I googled around and saw that it is fairly straightforward in Python, but I'm not the most well versed with coding in…

VIEW QUESTION

Mysql – Generating json data and filtering on matching condition from a specific table

June 13, 2023
notAChance
2 Answers

Table "ORDER": ID ORDERN_NUM 1 123 2 321 3 456 Table "RECEIVERS": FIRST_NAME ID LAST_NAME Pete 1 Tyler Sarah 1 Bowden Bart 2 Simpson Table "PRODUCTS": TYPE ID Towel 1 Pen 1 Spoon 2 We can say "FIRST_NAME" and "TYPE"…

VIEW QUESTION

Flutter – Expected a value of type 'String', but got one of type 'List<dynamic>'

June 13, 2023
Ayman
3 Answers

I want integrate Flutter with an ASP.NET API. the problem is when I create minimal API, the JSON I retrieved from MapGet is a string, when I try to jsondecode() it give me: Expected a value of type 'String', but…

VIEW QUESTION