7,030 questions
0
votes
0
answers
17
views
How to extract a specific column information from a pdf using flutter
I have a pdf file which has a table. Inside the table I have multiple columns. I want to extract the data from a specific column for all the entries. The pdf might contain multiple pages.
I am able to ...
- 237
0
votes
0
answers
27
views
Recursively Extracting Nested Archive Files
I have 500+ archive files that contain other archive files (.zip, .rar, .7z). For example:
archive.zip
|
|-file.abc
|
|-nested_archive.7z
|
file.def
|
...
- 19
0
votes
1
answer
56
views
Extract specific conditional string SQL Redshift
I want to extract only val2 from the below column1 of a table, I'm not sure how to do it with SQL though I've tried with regexp_subtr/instr, the length of column values are dynamic but the contents of ...
- 136
1
vote
1
answer
33
views
It is not possible to extract specific columns of data in gnuplot based on a specific heading
In the following Gnuplot script, I want to extract values from a specific table. This works fine for columns that contain numbers but I cannot extract the path from the column "Measure:volume&...
- 465
2
votes
5
answers
100
views
Splitting one column to three columns for uneven characters in r
I have tried to split a single column to three columns. But I failed.
I have the following data set
> dat
name
Jhon Austin B 100kg
Mick Gray C 110kg
Tom Jef A 30kg
First I tried to extract ...
- 127
0
votes
1
answer
37
views
How to Extract Emails from .pst Files Using Python?
I have .pst file of outlook emails from which i want to extract the emails. what approach should I follow to extract the emails from this.
i'm writing python code for it.
data extraction from .pst ...
0
votes
1
answer
42
views
Extract specific dictionary value from dataframe in PySpark
I have a below dataframe
dataDictionary = [('value1', [{'key': 'Fruit', 'value': 'Apple'}, {'key': 'Colour', 'value': 'White'}]),
('value2', [{'key': 'Fruit', 'value': 'Mango'}, {'...
- 5,165
1
vote
0
answers
75
views
Extracting audio from a video (camera trapping) and generate GUANO metadata
I have a large quantity (thousands) of video files (.MP4) generated by camera traps.
I want to extract the sounds (as .WAV or any other relevant format for further analysis in an acoustic software ...
0
votes
0
answers
30
views
How to Extract Audio From BGM.DAT file?
I know that the music is contained in the file called BGM.DAT and the file is .3gb so online converters are no use because of their file size limitations. How do I extract the audio files form the ....
- 1
1
vote
2
answers
84
views
How can I scrap the data within the "informations détaillées" section of this URL : https://gallica.bnf.fr/ark:/12148/cb42768809f/date?
Hi guys i am brand new with webscraping.
I am trying to webscrape the the data within the "informations détaillées" section of this webpage (https://gallica.bnf.fr/ark:/12148/cb42768809f/...
- 13
0
votes
1
answer
52
views
How to Convert a PDF Table with Thousands of Rows into JSON in React
I am working on a project where I need to convert a PDF containing a large table (thousands of rows) into a JSON Array of object. The PDF has a table with headers that should be used as keys in the ...
- 1
0
votes
1
answer
31
views
extract vector charts from PDF
I can't find the solution to how to isolate or extract vector chart and graphs(that are not images) from pdf.
I have tried extract directly, but I realize that it is not that straight forward. I was ...
- 11
0
votes
0
answers
27
views
Textract extract 2 columns of QUANTITY type data. What would be the best way to detect which is the good one?
I'm using AWS Textract with AnalyzeExpense to extract data from P.O.
But sometime, P.O. have "QTY ORDERED" and "QTY SHIPPED" and both are detected as QUANTITY. So I end up with 2 ...
- 319
-3
votes
2
answers
56
views
How to extract items from a list in Excel 2019
There is list of values (not text, numbers only) in document (for example from B3 to B14).
Values may appear in different cells in the list and not always in all of these cells of the list. There may ...
0
votes
1
answer
44
views
Preserve xy coordinates while using terra::extract with vector data
I have a list of xy coordinates (originally from a raster) that I want to associate with their political unit (e.g., point a is in New York, point b is in Vermont). Associating a point with a separate ...
- 543
0
votes
0
answers
30
views
is pdfjs-dist external library is compatible for chrome extension , if yes then what are the step to add into plugin?
I want to extract data from a PDF file in my plugin and use the data for information. I am trying with pdfjs-dist, but it breaks my gulp-building process, showing pdf-dist as an external dependency. ...
- 1
1
vote
1
answer
51
views
How to extract text associated with image from pdf?
I am using pymupdf to extract images from PDF. Code sample is as below.
import pymupdf
doc = pymupdf.open('sample.pdf')
page = doc[0] # get the page
image_list = page.get_images()
page_index = 0
...
- 21.3k
0
votes
1
answer
38
views
Decoding X32 Behringer mixer response
I would like help please to get the 4 Return meter values (post gain/trim, gate, dyn gain reduction and post‐fade) from the X32 behringer mixer, these are in 32 bits floats, little‐endian coded. to ...
- 2,443
0
votes
0
answers
11
views
Conditional Data Extraction from Nested JSON Using Recursive Search Fails to Return Non-Empty Specific Values
I'm working on a Python script to extract specific values from (several 100,000) deeply nested JSON files. While my script correctly extracts most of the desired fields using recursive searching, it ...
0
votes
1
answer
43
views
How can I extract specific values from a .csv-File and add them into a specific cell in a pre-exisiting dataframe/tibble in R automatically?
I want to automatically extract specific values from a .csv-File, which is generated by our measuring device, into a a dataframe/tibble in R which has a pre-defined layout. The name of the measured ...
0
votes
2
answers
58
views
Extract an item by name from an MapType() column in a PySpark column
I have a PySpark dataframe structured like this, where the array is formatted to start with a number: 1: "item / state / zip" most, but not all of the time. Sometimes the order will be ...
- 317
0
votes
3
answers
75
views
Need Excel VBA program that will extract two $numbers from column A and place them in Col B&C
I found some python code on this site via a google search and adopted it for Excel VBA, but it doesn't quite work. Column A has multiple rows with two numbers. The numbers always follow a dollar sign ...
- 1
0
votes
0
answers
22
views
While running Feature Extraction for VIT model, I am getting Resource Exhausted Error
While running Feature Extraction for VIT model for 2000 images, I am getting Resource Exhausted Error. We are using Google Colab Pro plan. We selected Compute Machine as T4 GPU.
We find that GPU RAM ...
- 31
-5
votes
1
answer
62
views
regex returns more data than it should
please read before you comment.
im trying to make a simple website scraper but i run into this error, it scrapes urls for scripts and its apparently capturing :
SCRIPT URL : https://accounts.google....
0
votes
0
answers
47
views
Extracting tables through puppeeteer
I am working on my university project. I want to extract data from my university LMS; I cracked the login authentication, and now I want to extract HTML of my subjects attendance and sessional marks ...
0
votes
1
answer
44
views
Extract precipitation values from netcfd
I’m stuck on a question about extracting a variable from a NetCDF file. Here is the structure of my input netcdf file:
comephore_all
Out[37]:
<xarray.Dataset>
Dimensions: (x: 85, y: 99, time: ...
3
votes
1
answer
89
views
How to store the time offset given in a timestamptz literal?
I need to store the the given time zone in the column (operation_time_zone):
INSERT INTO segments (
operation_type, operation_time, operation_time_zone, operation_place,
passenger_name, ...
- 139
0
votes
0
answers
15
views
Aligning Extracted Emails, Dates, and Phone Numbers from Text File in Python
I’m working on a Python script to extract emails, dates, and phone numbers from a text file and save them into a table or CSV file without regex. While I'm able to extract the data successfully, I'm ...
-1
votes
1
answer
70
views
How to turn URL into its Title in Bulk using App Script?
I need to export bulk data for real estate. There is an option to replace the URL with its Title, but you have to do it one by one in Google Sheets. I was hoping to see if there is a way I can do it ...
- 1
0
votes
0
answers
68
views
How to extract page numbers when using Azure Form Recognizer with DOCX files? [duplicate]
I am currently using Azure Form Recognizer to process DOCX files, but I've encountered an issue that I need help with. Unlike when I process PDF files, where I can extract text along with the ...
0
votes
1
answer
78
views
How do I programmatically access the Description field of MP4 metadata?
I'd like to write an AppleScript that extracts the metadata from the "Description" field in .mp4 files. I usually do this manually opening VLC > Media Information > General. On "...
- 9,919
0
votes
0
answers
63
views
Transfrom Update in Delete Insert Oracle Golden Gate
I have a Oracle GoldenGate extract verions 19.21.0.0.231017 and a Oracle GoldenGate for Big Data replicat Version 21.9.0.0.3, i want to trasform every UPDATE in 2 transaction DELETE and INSERT.
There ...
2
votes
1
answer
74
views
How do I extract the choices of a menu picker in XCTest?
My app uses the SwiftUI Picker, and I'd like to test that it only contains the expected choices. When I try to extract the choices in XCTest, I get back an extra entry, Choose an option, Option 1, i.e....
- 33
0
votes
1
answer
66
views
How to Extract Point Data from Multiple Subsetted Netcdf Files for Sea Surface Density using terra::rast() and terra::extract functions in R
Description of Data
I downloaded MULTIOBS_GLO_PHY_S_SURFACE_MYNRT_015_013 data for daily sea surface density from 2012 to 2024 from The Copernicus Website. A person can only download 2 years of data ...
- 1,215
0
votes
1
answer
61
views
Odd error in a BigQuery SQL Query, looking for an explanation
SELECT
DISTINCT
CONCAT(ue.vb_name, ue.b_name) AS Uber_Eats_Slug,
CONCAT(gh.vb_name, gh.b_name) AS Grub_Hub_Slug,
FORMAT_TIMESTAMP('%Y-%m-%d %H:%M', CAST(ue.timestamp AS TIMESTAMP)) ...
0
votes
0
answers
19
views
tessract fails to extract text from image with leptonica error?
I'm downloading file from a windows machine and store it to linux machine
with below code I'm getting error which I've added.
Below code is running on Ubuntu 16.04
Tesseract Open Source OCR Engine v3....
0
votes
1
answer
99
views
Return first n characters following header in fasta file
I'm trying to extract the first n sequences following a header in a fasta file. Headers are defined typically with a ">" character, such that a block of sequences corresponding to a ...
- 66
0
votes
1
answer
131
views
Extract passing-bablok slopes and intercepts by group using mcreg (mcr package) in R
For about a hundred of different analytes (groups), I would like to compare serum and plasma values using passing-bablok regressions with the mcr::mcreg function, and extract slopes and intercepts (...
- 802
0
votes
0
answers
32
views
CloudWatch log parsing
I want to parse the log events in the following format in AWS CloudWatch Insights using Cloudwatch queries for visulaisation of my log data.
Example:
{
"Start Time": "2024-10-11 12:...
1
vote
0
answers
52
views
Excel - charting with Python
I have an excel file having large no. of experiment data, each experiment data start with time column value 00:00:00., ending time is not same for all. I want plot of all experiment data in same graph
...
- 11
1
vote
1
answer
45
views
Obtain all attributes from an rgbif occurrence download
I have downloaded occurrence data using the rgbif package successfully. However, the attributes that are available seem restricted. Specifically, I would like: Habitat, Identification remarks and ...
- 323
1
vote
4
answers
72
views
Formula to extract from cell, anything that comes before the first text and number string
In Excel, I am trying to find a formula to do the following
I have a list of addresses with postal codes that are either 3 or 6 characters:
Cell A1: 3 Red Street, Vancouver, BC, A1C 9C2, CAN
Cell A2: ...
- 13
-1
votes
3
answers
62
views
Run Python script to Extract file in different folder
I have trouble with my Python script.
Currently, my script works to run the script which is file and myscript.py in the same folder.
I want to run myscript.py to extract files in another folder.
...
- 115
3
votes
1
answer
293
views
Problems with table extraction using pdfplumber - empty fields in large tables
The script below extracts a PDF table using pdfpumbler. It is a table that always comes after the second appearance of the expression "Quadro de Definições" - and a table that is 12 pages ...
- 995
0
votes
1
answer
59
views
Extract 12 character from a string impala query
I have a column that contains productID,catalogID and organization.
For example 1000002121US200100 contains 1000002121=product ID, US20=catalogID, 01=product channel and finally 00=sales area.
Is ...
- 13
0
votes
2
answers
70
views
How to Extract data from rows data collected from logs
Seeking help on how to extract data from rows of data similar to this
Raw Data
and convert data placement to this
Process Data
im having problem to extract "Process X" and populate the ...
- 1
0
votes
1
answer
41
views
How to extract values from a multi level XML and make them a new format
I've tried several posts but no success yet, I would like to change the format of the following tables (the levels keep going up to 100)
<level val="1">
<hp>...
0
votes
0
answers
27
views
How to convert daily ERA5 data to Monthly mean data in GEE
I want to convert daily max temperature data to monthly average from ERA5 daily data
I HAVE A CODE TO EXTRACT DAILY MAX TEMPERATURE DATA
Map.addLayer(bho, {}, "Bhopal");
Map.centerObject(bho)...
- 1
0
votes
0
answers
34
views
How do you read each password protected excels in one folder and extract certain columns from each spreadsheets?
Per title, I have multiple weekly reports that have the exact same format/columns, and I want to extract all the rows and some columns and make an annually report. The filename for each spreadsheets ...
- 33
0
votes
1
answer
200
views
Run-time error '9' for Yahoo Finance data extract
My VBA code to extract stock price data from Yahoo Finance now shows an error.
The bug is at the following line ReDim resultArray(0 To UBound(csv_rows), 0 To nColumns) As Variant
Is this due to Yahoo ...
- 87