Read JSON file, write nested lists to CSV file
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…
PHP – create CSV file from POST $data = curl_exec($ch); that Contains only 1 big String
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…
Query PostGreSQL table with 2 billion rows faster
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…
PHP – Calculate Array with Non Numeric Value
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…
Mongodb – Missing column on power bi
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…
How do I convert a complex nested JSON to csv using Python?
I want to convert the following nested JSON file to a CSV file using Python. { "page": { "page": 1, "pageSize": 250 }, "dataRows": [ { "entityId": 349255, "Id": "41432-95P", "disabled": false, "followed": false, "suggestion": false, "inactive": false, "pinned": false,…
Json – How to split one specific nested list element in list of lists and write to new list as two elements
I have some pretty messy JSON data that (using brute force and jmespath to query the data) I have managed to get into a list of lists. I need to take the last element of each nested list and split…
Javascript – Handling monthly recurring meetings on the same day of the week within the same week of the month
I'm facing difficulty handling monthly recurring meetings in my application. The requirement is for these meetings to consistently fall on the same day of the week within the same week of the month, regardless of the specific date. For example,…
Xcode – How to remove lines in CSV file enclosed in DOUBLE Quotes Python pandas
I am new to Python and I am having trouble with a CSV file. I have a sample CSV file containing data like this: "123,hahaha,,," "345,hohoho,,," When I use read_csv, the output treats each line as the first column. I…
Mongodb – How I can remove extra commas from my CSV format file in Node.js?
I only want to remove the extra commas but don't want to shift any data. Just remove the extra commas and left that cell to be empty. a b c d e f First row 1 0 , , ,…