90,367 questions
Advice
1
vote
11
replies
139
views
MS Excel displays garbled characters for Azerbaijani text in CSV file exported with UTF-8 encoding
I'm generating a CSV file with Azerbaijani text using Java and UTF-8 encoding with BOM. The file opens correctly in WPS Office, but when opened in MS Excel, Azerbaijani characters appear as garbled ...
-6
votes
0
answers
50
views
CSV 3d animation data to gLTF converting issue [closed]
I’m trying to convert this CSV file to a glTF file. I’m exhausted from tryin... no matter what I do, the result looks bad. Can anyone try to do it or guide me how to get a valid result?
example csv
...
0
votes
1
answer
130
views
How to decode this mojibaked CSV using PHP? [duplicate]
I'm trying to write an importer that processes a third-party CSV and ingests it into a MySQL database.
A lot of the lines in the CSV are fine but there's the occasional entry with what appears to be ...
- 71
1
vote
1
answer
30
views
Chinese CSV Headers Become Garbled When Importing to DolphinDB with loadTextEx
I have a CSV file where only the header row contains Chinese characters, while all the data values are in English. I'm trying to import this file into a DolphinDB distributed database using the ...
- 31
Advice
1
vote
7
replies
70
views
Searching for strings in multiple text files and outputting matched lines to a CSV
I have a folder full of hundreds of text files formatted like so:
holdrod =fl__2183_180325_0045
<bunch of data>
measburn_tot = 189.260915
<bunch of data>
I want to use ...
- 87
Best practices
1
vote
11
replies
4k
views
Reading data more efficiently from a csv file in python
I am programming an neural network to recognise digits trained on the MNIST dataset. At the moment I am reading each line separately using the following code:
file = np.loadtxt(dataLocation, delimiter=...
0
votes
3
answers
111
views
Removing $null or Blanks from CSV Results
I have a CSV that contains this information:
TEST1,TEST2,TEST3,TEST4
100,200,300,400
,,,
,,,
,,,
,,,
,,,
,,,
,,,
101,202,303,404
If I run this script
It returns the following:
It includes the $Null ...
- 37
1
vote
1
answer
66
views
Flutter skipping UI frames only on startup
When I try to start the app for the first time, some frames silently freeze. For example my splash screen doesn't show but my home page comes up. Also some functionalities don't work in other screens.
...
0
votes
1
answer
222
views
Return urls to Excel range
I made and have been using an Excel sheet at work for the last 6 months.
In the last few days some of my macros are no longer functioning as expected.
They stop and require debugging.
Sub Hour_1()
...
Advice
2
votes
5
replies
62
views
Find maximum value per group from CSV file
I have a CSV file with columns like:
student_id,subject,score
S001,Math,85
S001,Physics,92
S001,Chemistry,78
S002,Math,88
What I want to do is:
Filter rows by a given student_id
Find the highest ...
2
votes
2
answers
117
views
PowerShell Strings from headers is this possible?
I'm trying to create a script to make reading a CSV easier for a task I'm carrying out.
E.g. I have a csv with the following headers and values
Value1,Value2,Value3,Value4
10,20,30,40
11,12,13,14
I'...
- 37
Tooling
0
votes
8
replies
75
views
XML to CSV choosing best separator
Context
I am building an ETL pipeline to convert large XML datasets (ESMA financial data, ~50 GB total) into CSV format for bulk loading into SQL Server. The XML data contains free-text fields (...
- 17.9k
3
votes
0
answers
74
views
Python OCR Tesseract: Extraction of time stamps and coordinates from video frames
I have a python problem regarding OCR of time stamps/GPS overlays from video files.
The video files contain camera footage of seagrass meadows (screenshot).
I would like to extract date + time (left ...
- 31
Advice
0
votes
4
replies
106
views
How do I replace a certain file in a directory with the old one if it gets downloaded again?
I've been trying to figure this out for a while, but I can't seem to find a clear answer.
Is there a way to replace a file that already exists in a directory?
Context
I'm building an API that ...
- 27
2
votes
1
answer
111
views
Using csv how to write into file, list of dictionaries that sometimes have list inside them? [closed]
I need to create list from CSV file (it data is movies information like title, director, and actors. Directors and actors are list while other data is just string) it look like this:
with open('filmy....
- 33
