All Questions
944
questions
-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
3
answers
53
views
Automatically filtered a specific element in a list and input them in a separate lists
I am working on a large list of data. The list should look like this
List=[1,2,3,0,0,0,0,4,5,6,0,0,0,7,8,9]
It consists of chain of positive number, and is discreted by 0 values. I want to take to ...
0
votes
2
answers
44
views
what is the most efficient way to gather all points at a certain height?
I have a List[List[int]] that represents points [x,y]
points = [[1,2],[1,3],[2,1],[2,3]]
What is the most efficient way to gather-up all the points with a specific height ?
So if we want all points ...
0
votes
0
answers
23
views
Pull unique lists from multiple tabs with dynamic row and column ranges
I have the attached file, where there are 2 "animals" tabs that I would like to extract unique lists from.
https://docs.google.com/spreadsheets/d/1rycpqCRCFJdqaWea624_BHvJnntB9WWZ/edit?gid=...
0
votes
0
answers
29
views
Reducing the width of data validation list - Excel
I can't seem to find an easy, VBA free way of reducing the width of the validation list below to fit the data. The source list alos has a narrow column width. So too does the destination data. Any ...
0
votes
2
answers
37
views
Pandas - Filter - TypeError: 'in <string>' requires string as left operand, not list
I am exploring Pandas filter and while doing so I came across this error while using the below query
df2.filter(like = ['Republic','United'], axis=0 )
How do I provide a list in Like parameter in ...
0
votes
3
answers
30
views
Merge two lists based on device Name
I have these two lists:
"list": [
{
"DEVICE_NAME": "uscx001.net",
"IMPLEMENTATION": "system\nInterface range ...
0
votes
2
answers
66
views
Querying Data in Python
I have seen a number of posts, but none seem to quite answer what I am after. Please note that I am currently working under the constraint of only having the standard Python classes available.
The ...
0
votes
0
answers
156
views
How do I filter a list populated with SwiftData objects from array via custom filter chips
I have an app where I want to filter an array of objects stored in SwiftData by using filter chips. I have build both components and the chips to update based on a toggle of .onTapGesture inside their ...
1
vote
1
answer
48
views
Paste string from list into dplyr filter inside for loop in R
I'm trying to create a loop that outputs a descriptive table for me for different combinations of variables in order to compare their distribution. I've figured out how to iterate through my list and ...
1
vote
1
answer
39
views
How do I sort specific elements in list in javascript?
In javascript, I want to sort specific elements which are represented by variables in list in automatic way.
const PHQ = [
{
q: '1',
a: [
{ answer: '1', type: ['a']},
{ answer: '...
0
votes
0
answers
58
views
Is there a way to filter individual items within a list of values in Excel using the filter tool?
I am unsure how to create a filter list with individual value entries. Essentially I have a column, where its cells contain multiple values (e.g. HAZOP, LOPA, etc.), but when using the filter drop ...
0
votes
1
answer
169
views
How to use dynamic filter used between sharepoint list to add new item
I want to insert a new element in list 2 with in ParentID the value of the ID used in the filter. If nothing is selected
on list 1, it should not be possible to add a new element in list 2.
Is there ...
2
votes
3
answers
97
views
How to efficiently filter items in a list based on a property in Python?
I'm working on a Python script where I need to filter a list of objects based on a property that the objects have. I'm currently using a list comprehension to do this, but I'm not sure if this is the ...
0
votes
1
answer
49
views
Python Dataframe: For Each Row Pick One Value from Five Different Columns And Place In New Column Based on if Value is in List
Let's say I'm starting with the following input table below:
date
id
val1
val2
val3
val4
val5
val_final
2023-08-29
B3241
496C
2023-09-08
A3290
349C
078F
274F
2023-09-12
D2903
349C
072F
307C
170F
...