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,397
questions
0
votes
0
answers
10
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 ...
- 106
0
votes
0
answers
30
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
| | |--...
- 392
1
vote
2
answers
43
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....
- 11
-3
votes
1
answer
63
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
54
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
38
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
...
- 21
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 ...
- 25
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 ...
- 295
-1
votes
0
answers
32
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, ...
- 9
0
votes
0
answers
15
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 ...
- 51
0
votes
1
answer
32
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
-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 ...
- 989
-4
votes
1
answer
31
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 ...
- 362