Python Script json to csv
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…
Convert JSON dictionary file to CSV
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": {…
Need help parsing HTML markup with CSVHelper through my .NET API
I receive a CSV from an third party in this format: Job Requisition Id,Brand,Is Deleted,Internal Status,Job Code,Job Title-JobRequisitionLocale,Posting Start Date-JobRequisitionPosting,Posting End Date-JobRequisitionPosting,Job Posting Status-JobRequisitionPosting,Minimum Salary,Maximum Salary,Job Board Id-JobRequisitionPosting,Postal Code,Job Description-JobRequisitionLocale 1,TEST,TEST,TEST,TEST,TEST,2024-07-16T11:41:50Z,2024-07-31T00:59:59Z,TEST,00.00,00,00,TEST,TEST,"<p class="MsoNoSpacing"><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><b><span lang="EN-US" style="font-size:12.0pt">Role: </span></b></p" I have shortened…
Ubuntu – How to use jq in linux for multiple files?
I am trying to convert SAFECAST API JSON to a CSV suitable for spreadsheet programs like Excel etc. to prepare some data summaries etc. I have semi-manual WGET script to download several JSON files based on my filters. I am…
Amazon web services – AWS Athena SQL Query – Converting date to String
I have a Athena SQL Query where I am calculating some delivery date like below. CASE WHEN eventtime IS NOT NULL AND eventtime != '' THEN date_format(from_iso8601_timestamp (eventtime), '%Y-%m-%d %H:%i:%s') ELSE NULL END AS computation_date When I download the data…
How To Import a Big .csv(~2GB) Into a PostgreSQL Table
I am new into databases and PostgreSQL and today I wanted to import this dataset: https://www.kaggle.com/datasets/wilmerarltstrmberg/recipe-dataset-over-2m/data into a PostgreSQL so I can make a recipe finder app. I started by creating a new database, then creating a table and then…
Python Pandas extract csv column containing json
I want to learn Pandas framework, so I find free csv with Euro data from kaggle.com https://www.kaggle.com/datasets/piterfm/football-soccer-uefa-euro-1960-2024/data But there're plenty of columns which looks like this subset['goals'][1] "[{'phase': 'FIRST_HALF', 'time': {'minute': 7, 'second': 41}, 'international_name': 'Xavi Simons', 'club_shirt_name': 'Xavi', 'country_code':…
I'm trying to convert data from csv to json . My csv input is split by (;) is there an easy way to do so?
the dataweave script i tried is throwing an error that says i have to first transform the data into an array using then concert to a json object.It's returning null instead of the values. INPUT: id;email;phone;Fname;Lname 154784;[email protected];0123456789;omd;lamia MY CODE: %dw…
Postgresql – Is there any simple way to transform jsonb field into csv?
I have a model with a jsonb field where responses from a third-party service are stored. The response changes periodically; some fields are added, some disappear. I want to generate a CSV from a sample of records. To do this,…
Html – Data from web scraping did not fully load into csv file
I tried to websraping this website in order to get the award list. But after i saw in my csv file, the award ceremony is not load csv file, i don't want the ref load into csv file, some award…