i have a big number of CSV files which should be filtered and eventually combined, sorted and get duplicate rows removed. so usually no big deal with sed and sort and i would achieve this with something like... sed -E…
Customer ID,First Name,Last Name,Email,Accepts Email Marketing,Company,Address1,Address2,City,Province Code,Country Code,Zip,Phone,Accepts SMS Marketing,Total Spent,Total Orders,Note,Tax Exempt,Tags '7271785759024,mehmet,bilgiç,,no,,,,,,,,+905343842739,no,0.00,0,,no, Hi i want to transfer my shopify customers csv file to another shopify account. But i always get error. error is: Customer ID not found I…
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…