Questions tagged [filter]
A program or routine that rejects or accepts data that meets a given criterion. An example would be a filter that removed entries less than a given limit from a set of values. Do NOT use this tag for: Signal or image processing, use [filtering]. Java servlet filters. Use [servlet-filters]. For Bloom filters, use [bloom-filter]. For CSS filters use [css-filters].
filter
32,389
questions
0
votes
1
answer
44
views
Filter datetime column with object as data type in python
I have a df with a Timestamp and Value columns. Both have the 'object' dtype
| Timestamp | Value |
--------------------------------------
| 8/21/2023 12:00:00 AM | a |
| 11/...
0
votes
0
answers
17
views
How do I add built-in Google protection for my webscraper to filter out NSFW/illegal content?
Currently I'm coding a webscraper, it only scans the first 10 pages of Google so I'm not all too worried, but it downloads pdfs and I want to add some protection for filtering out NSFW content/content ...
1
vote
0
answers
17
views
Filtering across multiple fields from a subquery where there is no related field
I'm trying to find a portable way to express the following record filtering query using the Django ORM.
The intention is to:
take a subquery of FilterSpec (eg. with a common FilterGroup)
find all ...
0
votes
1
answer
47
views
Pyspark Filtering Array inside a Struct column
I have a column in my Spark DataFrame that has this schema:
root
|-- my_feature_name: struct (nullable = true)
| |-- first_profiles: map (nullable = true)
| | |-- key: string
| | |--...
1
vote
2
answers
44
views
How to select the row with specific condition and the row just above? [closed]
Here is how I defined my condition , but I need the row just above as well. There are many observations per ID.
data2<- data2 %>%
group_by (ID_number) %>%
filter(time_diff_hour > 8....
-3
votes
1
answer
64
views
Does filter have a way to export the "list" one element at a time?
On a practice exercise about prime numbers I found out that filter does not return a list itself and I need to do:
list(filter())
to obtain that list.
I do the exercise twice, once with a for loop:
...
-2
votes
0
answers
55
views
How can I improve this code for detecting swear words [closed]
I know there are only "idiot" and "idiotic" added to the list but its because adding words takes a lot of time and this is an test
this is my code:
// this code filters swear words ...
1
vote
2
answers
40
views
How to keep the first appearance of a value while filtering everything else out in R?
This is the appearance of my dataset currently. I want to include patient 1 data until the first '1' occurs in 'test.result' then remove any information about patient 1 after that.
current dataset
...
1
vote
1
answer
21
views
Display averages of a column for past five months in Google Sheets
I am working with a dataset that has multiple entries per month with different values. For instance, a row of data will have a certain month + year, as well as a value. I'd like to find the average ...
1
vote
1
answer
15
views
Return Top value plus ties for each change in another Column value
Using Columns A to J, I am looking to return the answer in Columns L to N.
I am trying to get the maximum value (plus ties) of Column B for each Tier (Column A) and show the corresponding fixture (...
0
votes
0
answers
18
views
Filter as Multiple combinations in Power BI
I have a database loaded into Power BI.
One of the columns contains long text.
I would like to implement for users the possibility of filtering through a search field that allows the combination of ...
0
votes
0
answers
9
views
How to Dynamically Filter Second Dropdown Based on First Dropdown Selection in jira insight CMDB?
How to Dynamically Filter Second Dropdown Based on First Dropdown Selection in jira insight CMDB?
Jira CMDB Insight objects configuration allows aql attribute filtering in the config cog near ...
-1
votes
0
answers
34
views
GoogleSheets ordering matrix columns of 3
I have a dataset organized into 3 columns, being the first row the title.
Data is organized by category DC,PH,DA,PF and date. But imputed in a randomly order
Notice there are 147 columns and 127 rows, ...
0
votes
0
answers
16
views
How can I filter data using Evrete Rule Engine
I want to use rule engine to filter out data.
For e.g. if there are 10 Account records, I would like to apply a rule like all accounts which are less than 1 year old.
I am exploring Evrete Rule engine ...
0
votes
1
answer
39
views
Google sheet Filter + Match?
I have 2 different reports which I am trying to match the invoice no. in sheet 2 to sheet 1 in google sheet. It is impossible to clean the transaction description column.
I had try to combine Match ...
-1
votes
1
answer
46
views
How to merge two array using .map and .find by avoiding iterating twice
I have two arrays below. I am trying to merge conditions array based on customerLOB.code match. The problem is, I am getting the results added twice because the loop gets iterated twice. How can I ...
-4
votes
1
answer
33
views
how to extract files from a list using substring filter [duplicate]
I have a list of files from os.listdir like:
TXSHP_20240712052921.csv
TXSHP_20240715045301.csv
TXSHP_FC_20210323084010.csv
TXSHP_FC_20231116060918.csv
how do I extract only the ones where 'FC' is ...
0
votes
0
answers
28
views
Cannot use IN function for Partition Filter of a View Table in BigQuery
so I have a view table named table_1 and it has a partition field called business_date. Thie table_1 is constructed by using a raw table named data_mart.customer_raw.
There are a lot business needs ...
0
votes
0
answers
39
views
Dependent Pivot Drop Downs
I am hoping someone can help. My search thus far has yielded no results, and I refuse to think this hasn't been released yet.
I have a Pivot of an extremely large set of data. In the filters is a ...
1
vote
2
answers
78
views
Filtering specific sequences in R
I am trying to filter a dataset I have obtained after RNASeq Analysis. I have "Sequence Name" assigned to "topological domain" and "transmembrane region". I would like to ...
1
vote
1
answer
22
views
SQL Group By Then Filter [duplicate]
I have two tables as follows:
Table A : contacts
Contact_Primary_Num
Displayed_Name
1
Smith, Joe
2
Doe, Donna
3
Jerry, Tom
4
Crocker, Betty
Table B : contact_notes
Contact_Note_Primary_Num
...
0
votes
0
answers
40
views
How to delete duplicates in a table?
I have written a software that every second copies the contents of a JSON file from a server into a variable (serverData). Using the json-path library I extract some information from the serverData ...
0
votes
1
answer
57
views
xml.etree.ElementTree. Element object has no attribute 'nsmap'
I try to process xml data from the website https://www.marktstammdatenregister.de/MaStR/Datendownload
I downloaded some datasets for a certain technology for example Netzanschlusspunkte. First step ...
-2
votes
0
answers
30
views
How to changing checkbox in table only for filtered position Access [closed]
I have an Access database where I have a lot of checkboxes in Table, I need to change the data to yes/no only for filtered items
what better way to do it? via VBA or Query
I made a query but it ...
-1
votes
0
answers
8
views
Why "info@" filter does not work in Gmail?
I have a list that filters out junk and automated emails. However, no matter how I try, if I put any form of "info@" into the list, the entire list becomes unusable and when editing, it no ...
0
votes
1
answer
15
views
Vlookup + Filter + Sort + Arrayformula workaround in google sheets
I have two tables, RECORDS and TYPES.
Link to a similar spreadsheet
RECORDS has 3 columns, "Type" in column A, "Entry Date" in column B, and "Status on Entry Date" in ...
0
votes
1
answer
29
views
Add a value to filter result in Google Sheets
I have the following formula that works in Google Sheets
=Sort({IFERROR((FILTER({'My Log'!B13:B, 'My Log'!F13:F, 'My Log'!E13:E, 'My Log'!H13:H, 'My Log'!I13:I,'My Log'!J13:J, 'My Log'!K13:K,'My ...
0
votes
0
answers
23
views
How to keep ag grid filter after selecting all filtered?
I have an ag grid table that I am filtering, and upon a button click it is set to select all the rows that are currently filtered using selectAllFiltered(), and after clicking the button the filtered ...
0
votes
1
answer
27
views
How to construct a Map with conditional items with typescript
I want to add an item to a Map conditionally, and adding .filter but I'm getting Type 'null' is not assignable to type 'readonly [string, Book]'.(2769). This is only issue when adding item ...
3
votes
1
answer
125
views
Primes using setjmp
I wrote a simple Haskell function, that gives a list of primes.
primes' :: [Int] -> [Int]
primes' (p : xs) = p : primes' (filter (\x -> x `rem` p /= 0) xs)
primes :: [Int]
primes = primes' [2 .....