Category "filter"

How to filter all rows between two values containing a certain pattern for a list of data frames in R?

I have a large list of about thousand data frames and want to filter all the rows from between two values which contain a string pattern VALUE1 and VALUE2 in th

How can I get the indexes of a filtered array items

I have this situation, I have an array and I need to filter it and get the indexes of the filtered items, like this example: var arr = ['2022-05', '2023-01', '2

Why are react-table pagination and filter reset by changing its data?

I added 4 custom columns to my table columns list using its Cell property; each of them in each row contains a checkbox that changes a specific property of the

select(column, (contains()) not showing results

chase_2021 = chase[c(143:1020),] paychecks = chase_2021 %>% select(Posting.Date, Amount, Description, starts_with('CVS'), ends_with('PPD ID: 995338

Query to get all subtasks associated to stories with some labels in Jira

I have user stories in Jira with some labels A,B,C for example. But at subtasks level there is no labelling .Now I need to fetch count of all user stories of th

google sheet : How to find the length of array?

I try to query from other sheet using vlookup() or something similar. I want to count how many array it will produce. How can i find the length of the output or

Filter array by variable in Bot Framework .net

For each item in array1, I want to filter array2 by the array1 item the bot is currently in. Within an Edit an array property, if I filter array2 hard-coded lik

Blue Prism - How filter a collection using NOT operator

I need to filter a collection that have "HoldingSubholding" column, that can have lot of different value. I need All the rows with the values except the rows th

Kotlin: Problem with List Filter by Multiple Conditions

I'm trying to match two lists to another. In one list are items of crypto trades, the other contains so called candlesticks, which represents a price of crypto

Elegant way to saturate cross-filters values

Having filters sets for excluding/including entities according selected filtering categories, something like left-side on Booking/Ebay/etc: Filter works in fol

How Can I Add Multiple Value In Single Meta Field For Filter in shopify

My client has purchased a boost theme. I have set up the theme and want to set up Filters. I want to set product filter by Brand, price, age, and gender. for th

SQL Query for persons liking both fruits and vegetables [closed]

I have a situation I am trying to resolve. Might be simple but I can't figure it out. I have simplified my table that I am trying to pull data

Google Sheets - Removing the used items from drop-down lists

In Google Sheets I have a column containing a list of available Serial Numbers (say, column A). Somewhere else (say, column B) a user must choose the serial num

How to filter out a row if there are two consecutive instances of the same value?

I have a data frame with multiple similar sequences in which column Z has a string pattern containing "VALUE1" and "VALUE2" (only these two patterns matter) and

Directus Filtering multiple fields

I'm trying to filter directsus CMS data set through URL parameters. This is a sample data set. I can successfully filter data set by single parameter. { "data":

Excel Office Scripts - Copy and paste range if filtered data is not empty

Summary: I have a multi-step script where I need an IF statement to handle a scenario when the range I am copying from could be empty. I need the script to move

How to filter in django by greater than or less than dates?

I'm a little confused with the documentation on Django Rest Framework. I have read it several times but I cannot makes sense of it. Maybe I'm not smart enough,

Javascript - sort an array of multiple objects of objects

I tried with no success to sort an array of multiple objects of objects. Here my database : var jsonDatas = [ { "type": "Voiture", "item

remove rows in dataframe which are not all 1 or all 0

I need to retain rows in the dataframe which has all row values as 0 or all 1. a = np.repeat(0,10) b = np.repeat(1,10) ab = pd.DataFrame({'col1':a,'col2':b}).tr

Do not retrieve query if empty output

In this sheet I'm working on, I'd like only the applicable data to show on the Teacher1Results tab, not the #N/A for empty output. Secondly, is it possible to m