I've pulled together a radio schedule PHP script to read a CSV file and post the results on a website depending on time and date. However, it appears to be posting twice. Here is the script: <?php // Step 1:…
I have the following unnormalized csv file user_id,nickname,joinDate,product_id,price 1,kmh,2023-07-24,P131,3000 1,kmh,2023-07-24,P132,4000 1,kmh,2023-07-24,P133,7000 1,kmh,2023-07-24,P134,9000 2,john,2023-07-24,P135,2500 2,john,2023-07-24,P136,6000 3,alice,2023-07-25,P137,4500 3,alice,2023-07-25,P138,8000 I'm going to change this to the following json format (or java object). [ { "user_id": 1, "nickname": "kmh", "joinDate": "2023-07-24", "orders": [ {…
I'm new in using jq tool. I have a json file extracted from mongodb database to be formatted into csv: json data in foo.json { "_id" : "8888888888", "unitcode" : "Unit123", "purpose" : "Validate", "request" : { "url" : "Brocolli",…
In my Python code, I have a for loop that generates flattened JSON files. I would like to append these JSON files recursively to a file (for example a .csv file) using the same for loop. my final .csv should…
I am unable to download a csv file from the storage container, here is my code as i keep getting an error... : import datetime import logging from azure.storage.blob import BlobServiceClient import azure.functions as func import os def main(mytimer: func.TimerRequest)…
WE ARE NOT ALLOWED TO IMPORT ANY MODULES INTO PYTHON EXCEPT THOSE ALLOWED IN THE PROMPT I have an assignment I am working on in class. The prompt is to write a class that reads data from a json file…
I did $data = curl_exec($ch); with POST method. When I did echo '<pre>',var_dump($data),'</pre>'; string(15124) ""A","B","C","D","E","F","G","H" ,"2",,"4","5",,,"8" "ONE",,,"QW AH",,"US",,"EU"" I tried to split them and make into array $lines = str_getcsv($data, PHP_EOL); But I got only 1 array with everything in…
I am trying to run the following query on an SQL table of about 2.66 billion rows, keep in mind I am using Python psycopg (but I can use something else if it would make my life easier) to eventually…
From mycsv.csv $data[7] has these: 4294967296/4294967296 4294967296 8589934592/8589934592 I want to calculate and put GB, so they become like this: 4GB/4GB 4GB 8GB/8GB What I did: <?php $a = str_ireplace("/"," ",$data[7]); echo (floor($a/1000000000))."GB"; But it gives error for the ones…
I exported a collection in mongo db as a csv file and then imported that csv into power bi…all fields imported except one . Even after manually adding it in mongodb before exporting as csv, the column showed blank when…