Questions tagged [extract]

Questions related to retrieving specific information from a (typically minimally structured) data source, such as a web site, media file, source code collection or compressed archive (in which case the desired information is one or more original, uncompressed files). When using this tag, please include additional tags to clarify which specific environment/language/scenario your question refers to.

Data extraction is a term with many different but related meanings, including:

  • Parsing files (such as HTML pages) or file metadata in order to obtain certain information. This often involves

  • Retrieving single frames from audio, video or image files

  • Breaking up functionality in a single source code unit (e.g. a function) into multiple units:

  • Retrieving the original files from a (optionally compressed) archive file, such as a .zip or .tar file.

and should be added as a synonym for this tag.

6876 questions
1
vote
0 answers

Extract data from a text file using Powershell

I have a file in the below format. Need to extract some data depth=3 C = US, ST = Arizona, L = Scottsdale, O = "Starfield Technologies, Inc.", CN = Starfield Services Root Certificate Authority - G2 verify error:num=20:unable to get local issuer…
Pratyush
  • 25
  • 3
1
vote
3 answers

Combine exported tables into usable layout

We routinely receive .CSV files from a contractor that consist of tables exported out of Revit. From a data perspective, they are less than useful so I am looking for a way to ingest these files and generate a properly laid out table. Layout of…
1
vote
2 answers

How to extract data from file and assign each data to each variables on python?

So i wannna know the solution from my question. I already tried this import re username = "" password = "" full_name = "" birth_date = "" phone_number = "" address = "" with open("file2.txt", "r") as f: contents = f.read() lines =…
1
vote
1 answer

Creating a Spatial Line Object with multiple individuals

I am trying to create a spatial line for multiple individuals in my dataset to then extract raster values across the line. I have tried a few things but unfortunately the code I am using is assigning all the line to one individual. WD is the dataset…
1
vote
0 answers

Unzip latest zip file with php

Can someone help me to unzip the newest zip file in a directory. I can unzip a file using the specific file name, but unfortunately, the file name changes daily. So unzipping the latest file is my best option. Or Can someone show me how to unzip a…
PaulW32
  • 63
  • 4
1
vote
1 answer

Is it possible to change the date in one cell when another cell on another sheet shows another date?

On google sheets, I have 1 sheet that has a date range selected in two cells for one year, and then on the second sheet I have a date range for the next year. I was wondering if its possible to have: sheet1!D2 and sheet1!D3 change to match sheet2!D2…
1
vote
1 answer

R: Extract parameter from list

I'm working with R and have a quite cascaded list of data wherefrom I would like to extract the same variable of every data frame. Here is an example (simplified from the original, I hope that is not too confusing) for one imported .csv…
Feli
  • 21
  • 2
1
vote
1 answer

Extract() from Postgres to calculate minutes between 2 columns

Want to calculate minutes between to columns with start_time and end_time as timestamp without zone for two customers types, and then averange the result for each. I tried to use extract() by using the following statement, but can't get the right…
1
vote
0 answers

Extract info from zepp in python

I need to take information from the "Zepp" app for use in another project. If possible in python but it's ok if there is another language in use. The Zepp app is a fitness app for android connected with a smart watch. Thank you in advance.
1
vote
1 answer

Extract data frame variable

I have a list of proteins in a column but they all end with _l how do I remove _l from proteins ? example: nr2_l , nr1_l , pkca_l , p_lr1_l , p_ln_l separate(protein_exp, c("protein", "l"), "_l") but this then separates protein **p_lr1_l ** to…
Drake
  • 47
  • 4
1
vote
1 answer

Extracting FirstName from Last, First Middle

I am trying to figure out a regular expression for extracting just the first name from Last, First Middle For example: Smith, Jane Ann returns just Jane. I figured out the last name field by using ^[a-zA-Z_'^\s]+. I believe I want the first name…
1
vote
1 answer

Connecting Rows of Array to Date and Time formate

Im New to Python, it sounds easy- but i cant solve it, nether find a resolution with similar questions. I have an Array where every row has one value ((...), Hour, Min., Sec., (...) ,D, M, Y) - Example: arr = np.array([x, x,0, 0, 3, x, x,10, 8,…
MaryJule
  • 23
  • 5
1
vote
2 answers

Deleting everything after after a certain string in R

I have some data in an object called all_lines that is a character class in R (as a result of reading into R a PDF file). My objective: to delete everything before a certain string and delete everything after another string. The data looks like this…
Purrsia
  • 712
  • 5
  • 18
1
vote
2 answers

I'm looking for a way to extract strings from a text file using specific criterias

I have a text file containing random strings. I want to use specific criterias to extract the strings that match these criterias. Example text : B311-SG-1700-ASJND83-ANSDN762 BAKSJD873-JAN-1293 Example criteria : All the strings that contains…
Jeza
  • 13
  • 3
1
vote
1 answer

How do i extract this object from his background in opencv?

For my internship, I am trying to extract this type of aluminum wires of the acquired vision camera footage. The purpose is to extract those connections and classify them with machine learning. My idea is to extract those connections to remove all…
1 2 3
99
100