I used to be a jq masochist, but I discovered mlr, which seems to offer the opportunity for more (yet different) pain. I found a nice web site that allows me to issue curl commands without API keys, etc., to…
I am very new to python and I am trying to get the following JSON output from a csv file and the csv file looks like this date customer Ex employer emailID CIN CIN2 BatcheSource 9-Jul-24 ABC1 EmployerAnme1 [email protected] 123456…
I'm currently practicing converting plain text to csv, and them csv to json. I need to do the conversion only with jq and basic Linux commands. I didn't have any major problems converting plain text to csv, but further conversion…
There's a lot of discussion to convert JSON to CSV with jq, but can't find my situation. 2 points really blocking me : Get key and value of valuePerDay by row Sort valuePerDay keys to unsure values always in the…
I have a csv file that with rows that looks like this: 745198;2024-09-10 10:09:10.7;leaf-2;{"Accelerometer": {"X": 0.055297852, "Y": 0.993530273, "Z": 0.000244141}} 745199;2024-09-10 10:09:10.71;leaf-2;{"Accelerometer": {"X": 0.056274414, "Y": 0.994384766, "Z": 0.000976563}} 745200;2024-09-10 10:09:10.721;leaf-2;{"Accelerometer": {"X": 0.055786133, "Y": 0.994018555, "Z": 0.000854492}} 745201;2024-09-10 10:09:10.732;leaf-2;{"Accelerometer": {"X": 0.055053711,…
So I am very new to coding and have run into an issue when it comes to comparing arrays, especially ones that are nested and trying to pull out values that match using their indices into a new array. Say…
I am trying to read a csv file from 4th row, in my csv file first 3 rows contains some meta data in column1. But the actual number of columns in csv is 6. eg: metadata1 metadata2 metadata3 head01,head02,head03,head04,head05,head06 data11,data12,data13,data14,data15,data16…
I’m working on a PHP script that processes large CSV files (up to 1GB in size) by reading the file, performing some transformations on each row, and then saving the results to a database. My current approach involves reading the…
Good Day, I have very little knowledge of python scripting. I am trying to get a script to help me to convert a json file to csv. I have tried a number of scripts but keep on running into errors…
Need to extract recordID, date, title, and breakout action_history data. Since the action_history data also has the recordID, it does not all have to be on the same row for the CSV file. Here's the JSON string: { "783": {…