90,418 questions
-5
votes
0
answers
39
views
How should I approach my CSV cleaning project for my OCBC bank statements? [closed]
I am new to programming, and I am trying to start a project on cleaning my CSV file into different formats that I want. How should I go about doing that, and what resources can I use to do it?
1
vote
1
answer
50
views
Python Gmail API script not saving attachments — CSV shows filename but files are never downloaded
I’m building a Python script using the Gmail API to read model application emails, extract data, and download photo attachments. Everything works except the attachments. the script keeps saying: ...
-3
votes
0
answers
31
views
How can i convert a string csv to an array of real with tia portal scl [closed]
I have a qr code reader in my machine where i get a csv with data for the machine so it knows how to fill it. But i cant figure out how to get al the values in the string in a array of real so i can ...
0
votes
1
answer
44
views
Import-Csv on file with `"#"` in the header
I'm importing a CSV generated by the chess cli tool Ordo. It has this output format:
"#","PLAYER","RATING","ERROR","POINTS","PLAYED","(%...
0
votes
0
answers
67
views
Reading in values from CSV and making sure they are non-scientific format in R? [duplicate]
Assume I have the following Excel Sheet:
Location
Mar2000
London
1234567891011
Tokyo
12345667897
These are the raw values saved in a CSV format e.g. my_data.csv (assume it is CSV not UTF-8 format). ...
1
vote
1
answer
72
views
Converting JSON to CSV using jq with header line
I have a task to convert a JSON file to a CSV with a header at the top. The header has to be in a particular order. So the order of the keys in the JSON file will be in different order than the ...
1
vote
1
answer
80
views
Saving Movement Data as a CSV File in VR Headset (C#/Unity)
I'm working on a project where I want to collect movement data (X/Y/Z position and rotation) from a VR headset (a PICO Neo 3 Pro Eye) using a C#/Unity script, and export it as a CSV.
I have a script ...
1
vote
3
answers
160
views
How to lazily load DataTable rows from a large text file using IEnumerable and yield return in C#?
I'm working on a C# application where I need to read a very large text file and convert its contents into a DataTable. However, I don't always need all the rows—so I want to avoid loading the entire ...
1
vote
1
answer
39
views
pandas.read_csv uses only utf-8 encoding for django file upload
I'm testing django using file uploads. Was facing a strange issue, when despide which encoding I choose, I'm always getting same error message that pandas is trying to decode with UTF-8
pd.read_csv(...
0
votes
0
answers
61
views
Way to transform a BalanceSheet from QBO inside BigQuery?
I'm using dbt models to transform a QBO Balance Sheet uploaded as a CSV into Bigquery.
Data comes from a fictional company inside QuickBooks test drives from which I export reports in CSV format.
Here'...
0
votes
0
answers
43
views
GAMS csv importing and load issue
i am very new to GAMS and im trying to understand how sets work while importing from CSV and what im doing wrong. I have data as in picture below (prices_wide_example.csv), i would like to import it ...
0
votes
0
answers
31
views
Databricks group cluster fails to read CSV (TextFileFormatEdge$.disabled) while personal cluster works
I have a PySpark function that reads a reference CSV file inside a larger ETL pipeline.
On my personal Databricks cluster, this works fine. On the group cluster, it return empty dataframe, the same ...
1
vote
3
answers
109
views
CSV iteration addition algorithm Python
I am currently trying to write an algorithm that reads in a CSV file, gets a list of names from column 0, a list of hours worked from column 6, then iterate through a list of staff names, if a name is ...
2
votes
1
answer
111
views
How to bulk load CSV file in mySQL workbench without import wizard?
I am trying to write a stored procedure to import CSV data from local system to mySQL tables. I do not want to use import wizard as I want SP to create, import and display time taken to import.
...
0
votes
1
answer
68
views
Python Convert List Image to multiple PDF [closed]
In the case
I have a folder of image list and list name file with csv
I want to write a python script to convert list of PNG's to multiple pdf file with name file of pdf from csv file at column D
like ...
0
votes
1
answer
117
views
How to make Microsoft Excel load Unicode characters correctly when open double clicking CSV file
Note: This issue is specific to Microsoft Excel. It works fine on LibreOffice without any problems.
I am developing a React application where I need to let the user download some table data upon a ...
0
votes
3
answers
158
views
How do I populate a column in a PowerShell array from a Groups column in a CSV by searching for a matching Name of a corresponding user?
I have a PowerShell script that works up to a certain point that imports two CSV files, CSV #1 and CSV #2, and creates a new array ($content3) with input from both CSV files. I need to populate the ...
1
vote
0
answers
56
views
fast-csv append writing headers to last row
I'm appending data to a CSV file from a JSON rest API call. However, I'm finding whenever I write too it, it's adding the headers to the last item in the list.
My code is as follows
const csv = ...
1
vote
1
answer
30
views
Neo4J (5.14.0): add labels based on values in CSV file
I'm trying to create nodes with one set label (:object) and two additional labels that are based on values in the following CSV file:
Object_ID
Classification
Hierarchy_name
Object_type
O0010
...
3
votes
1
answer
82
views
How to use emptyValue option in pyspark while reading a csv file?
According to docs of csv options:
Property Name
Default
Meaning
emptyValue
(for reading), "" (for writing)
Sets the string representation of an empty value.
But it doesn't seem to work:
with ...
4
votes
3
answers
130
views
Why is pandas not formatting dates with date_format?
Why is pandas not formatting dates with date_format argument of to_csv?
pandas.DataFrame([datetime.datetime.now().date()]).to_csv(date_format="%Y %b")
',0\n0,2025-07-31\n'
0
votes
1
answer
102
views
Duplicate Headers and Rows in CSV File When Exporting PowerShell Log
I'm using the following PowerShell script to remove self-signed certificates from a server. Based on the outcome, I log the results to a CSV file. However, I'm encountering two issues:
Duplicate ...
1
vote
3
answers
158
views
How can I read multiple csv files from within multiple zip files with sometimes different columns using R fread?
I'm trying to read in a lot of data as efficiently as possible; the data are in about 1,400 CSV files within 6 individual ZIP files. The CSV files are all similar timeseries data with the same columns,...
5
votes
4
answers
182
views
How to cleanup some content from the text file
I have the following data in a CSV.
"ID","OTHER_FIELDS_2"
"87","25 R160 22 13 E"
"87","25 R165 22 08 E"
"77",""
&...
0
votes
1
answer
87
views
Python to convert CSV to JSON [closed]
I need to convert below csv file to json
cat /tmp/input.csv
ID,item,name
1,A,aname
2,A,bname
6,A,zname
8,A,xname
expected json
{
"filters": [
{
"ID": “1”,
“item”: “A”...