Skip to main content
7,885 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-2 votes
0 answers
65 views

I hope you're doing great. I'm facing a situation where I need to dynamically extract data from Excel (.xlsx) files that contain: Multiple tables per sheet Different table formats Inconsistent ...
Hamzaoui Mohamed Amine's user avatar
  • 1
0 votes
0 answers
76 views

Error 0x80010135: Path too long. ‎ ‎I keep getting this error while trying to extract my Sentinel-1 datasets zip folder ‎ ‎Note that I am using Windows 11 PC.
Francis's user avatar
  • 1
-1 votes
0 answers
43 views

I am reading in some .xpt data using the haven package. When I view the dataframe in RStudio, it appears as in the snapshot below (showing only a small number of the columns): There are actually 16 ...
please help's user avatar
  • 243
1 vote
1 answer
96 views

I need an Excel conditional formatting formula or VBA to identify product names in a column to highlight cells red if the product name contains two or more sub-products (number+letter codes like r600, ...
Saad's user avatar
  • 13
0 votes
0 answers
54 views

How to extract the first n rows of a block compressed tab-separated value text file (.tsv.bgz), which could only be accessed with gsutil, into a text file? The original file is very large, so I wonder ...
Xunzhi Zhang's user avatar
  • 1
1 vote
0 answers
120 views

I use VBA to show 1 value from SAP (Total in COOIS). All works well but I have to type the value into Excel because the Total value is every time on another position, and I can't find how to copy into ...
lexmrk's user avatar
  • 21
0 votes
0 answers
181 views

I want to obtain an excel file as well as printed results of the "Ru, max" values (Liquefaction values) of my plaxis model by coding in its python API. I have modelled a soil column in ...
Brenda Trujillo's user avatar
  • 1
0 votes
2 answers
94 views

I'm trying to extract info from a JSON file via a ConvertFrom-Json command. Its format is: { "Id": "0", "Name": "John", "Actions": [ ...
RichM's user avatar
  • 3
0 votes
3 answers
121 views

I have a directory with a bunch of subfolders and each subfolder contain a cbz file. Extract each .cbz file. If the extraction creates a subfolder, move its contents up to the .cbz file's folder. ...
TravelWhere's user avatar
  • 403
0 votes
1 answer
79 views

I’m writing a query to calculate the total monthly sales per employee and display only the data for April. I’m using PostgreSQL, and while the logic seems fine to me, the output isn’t working as ...
Amaal.Psau's user avatar
  • 1
0 votes
1 answer
60 views

I'm working on pulling some information from word document. I have multiple tables in it and i want to get 1 specific table that does not have any specific location in the document that could be ...
Dione Saturn's user avatar
  • 31
-1 votes
1 answer
63 views

I've been trying to get some data from classes instantiated by Spring boot, like controllers and services, to display them in local program, the same on that is supposed to start the whole thing. ...
user29983345's user avatar
  • 1
-1 votes
1 answer
72 views

Using Google Sheets: I'm trying to extract the price e.g. 250, 990 and 1760, the currency e.g. CZK, and problematically the text /p, /2p or /3p from some text field. Some example lines are shown ...
Mark Dowty's user avatar
  • 3
3 votes
2 answers
96 views

I have learned that subtracting two dates in Db2 results in a number which is to be interpreted as an interval: SELECT current_date - '1943-02-25' FROM SYSIBM.DUAL; -- 820020: 82 years, 0 months, ...
Manngo's user avatar
  • 17k
0 votes
1 answer
102 views

Good afternoon. I am working on Power Automate and I would like to create a compose action that extract a specific data from a .txt file (Mail1.txt). I would like to extract the number which is ...
A.B's user avatar
  • 3
0 votes
0 answers
42 views

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 ...
Sindu's user avatar
  • 247
0 votes
1 answer
74 views

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 ...
Raven Smith's user avatar
  • 146
1 vote
1 answer
45 views

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&...
magfan's user avatar
  • 465
3 votes
5 answers
133 views

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 ...
Rokib's user avatar
  • 137
-1 votes
1 answer
135 views

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 ...
Sushant Singh Negi's user avatar
  • 1
0 votes
1 answer
66 views

I have a below dataframe dataDictionary = [('value1', [{'key': 'Fruit', 'value': 'Apple'}, {'key': 'Colour', 'value': 'White'}]), ('value2', [{'key': 'Fruit', 'value': 'Mango'}, {'...
Jim Macaulay's user avatar
  • 5,251
1 vote
0 answers
126 views

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 ...
Quentin Dubois's user avatar
  • 11
0 votes
0 answers
82 views

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 ....
Aleksei 's user avatar
  • 1
0 votes
2 answers
110 views

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/...
Moran Hanane's user avatar
  • 11
0 votes
1 answer
141 views

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 ...
Manu H N's user avatar
  • 1
0 votes
1 answer
140 views

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 ...
ravshanovbek's user avatar
  • 11
0 votes
0 answers
45 views

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 ...
Steve's user avatar
  • 329
-3 votes
2 answers
67 views

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 ...
Angetenars's user avatar
  • 1
0 votes
1 answer
166 views

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 ...
Jaken's user avatar
  • 601
0 votes
0 answers
58 views

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. ...
user's user avatar
  • 1
1 vote
1 answer
164 views

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 ...
NPatel's user avatar
  • 21.4k
0 votes
1 answer
82 views

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 ...
Ossama's user avatar
  • 2,441
0 votes
0 answers
23 views

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 ...
Joseph Brockly-Anderson's user avatar
  • 1
0 votes
1 answer
58 views

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 ...
Piratepenguin's user avatar
  • 13
0 votes
2 answers
82 views

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 ...
Whitewater's user avatar
  • 316
0 votes
3 answers
93 views

Column A has multiple rows with two numbers. The numbers always follow a dollar sign and there are always only two numbers. Some numbers can include a "," or a ".". I'd like to ...
Bear's user avatar
  • 1
-5 votes
1 answer
77 views

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....
mrneedhelp's user avatar
  • 1
0 votes
1 answer
57 views

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: ...
Lucie Armand's user avatar
  • 1
3 votes
1 answer
105 views

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, ...
user11225404's user avatar
  • 149
-1 votes
1 answer
83 views

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 ...
Riyahh's user avatar
  • 1
0 votes
1 answer
199 views

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 "...
pepe's user avatar
  • 9,909
3 votes
1 answer
108 views

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....
Pabtuz's user avatar
  • 43
0 votes
1 answer
99 views

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 ...
Alice Hobbs's user avatar
  • 1,247
0 votes
1 answer
71 views

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)) ...
Tejas Mallikarjuna's user avatar
  • 9
0 votes
1 answer
137 views

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 ...
Luca's user avatar
  • 66
0 votes
1 answer
200 views

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 (...
denis's user avatar
  • 972
1 vote
0 answers
53 views

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 ...
Sajan Kumar's user avatar
  • 11
1 vote
1 answer
82 views

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 ...
kl-higgins's user avatar
  • 323
1 vote
4 answers
97 views

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: ...
leever's user avatar
  • 13
-1 votes
3 answers
89 views

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. ...
Septiana Fajrin's user avatar
  • 113

1
2 3 4 5
…
158