FAQ Database Discussion Community


Filter Range by specific Color Index/RGB using Worksheet.Range.Autofilter(Field,Criteria,Operator)

c#,vb.net,excel,colors,filtering
I am doing some automated excel manipulation using C#. I have been having a hard time figuring out how to autofilter based on a specific color. There is very little documentation about this type of manipulation, however I have found some VB.net and VBA code for it. I cannot seem...

How to plot frequency response of butterworth filter using Matlab

matlab,plot,filtering,frequency
I am trying to plot the frequency response of my sequence when filtered by a butterworth, low-pass filter. I have my pole and zero plot figured out just fine but can't seem to get my frequency response plotted correctly. When I do my axis are always way out of scale....

AngularJs: programmatically filter by either of 2 columns

javascript,angularjs,controller,filtering
I have the following code in my controller: $scope.filteredTransactions = $scope.invoiceTransactionsObject.transactions.concat(); // make a copy of the initial array if ($scope.searchTerm.message) { var search = $scope.searchTerm.message; $scope.filteredTransactions = $filter('filter')($scope.filteredTransactions, ({ message: search } || { item: search })); } I want to be able to filter by typing some value...

Bandpass Filter in Python for Image Processing

python,image,opencv,image-processing,filtering
I have a noisy dataset (a stack of images) which films dim particles moving about some really bright artefacts (which are immobilized). I would like to somehow remove the immobilized artefacts from the images by applying some sort of bandpass filter wherein only pixels within a specific range are converted...

Implementing mean filter in MATLAB

matlab,image-processing,filtering
I have done the question by searching here on stack but I'm here to ask what's the difference between what I was previously doing and what I've done now which works. So we have an assignment and we're supposed to implement a mean filter and the way I was going...

How do I combine Facet and FilterQueries using Spring data Solr?

spring,solr,filtering,facet
Is it possible to combine a facet and field query in spring data solr? Something that would build a query like this: > http://localhost:8983/solr/myCore/select?q=lastName%3AHarris*&fq=filterQueryField%3Ared&wt=json&indent=true&facet=true&facet.field=state In other words, how do I add FilterParameters to a SimpleFacetQuery? Any/all replies welcome, thanks in advance, -- Griff...

Primefaces totalRecords undefined value after Filter

primefaces,datatable,pagination,filtering
I try to have a totalRecords number (who count the row numbers when filter and no filter) with Primefaces 4. My Paginator output for the totalRecords number is working until I try to filter the dataTable : <p:dataTable id="tbl_queue" var="c" value="#{productionQueue.cartQueue}" widgetVar="queueTable" filteredValue="#{productionQueue.filteredCartQueue}" paginator="true" currentPageReportTemplate="Nb rows: {totalRecords}" paginatorTemplate="{CurrentPageReport}"> <p:column id="Bumper_column"...

Shopify: how to add a class depending on collection

collections,filtering,shopify,liquid
On a clients homepage they want 'all the products' listed with a load more button at the bottom. There are four categories and each has a different color associated. I want to pull in all the products by date listed order and apply a class to the product depending on...

How do I filter a pandas DataFrame based on value counts?

python,pandas,filtering,dataframes
I'm working in Python with a pandas DataFrame of video games, each with a genre. I'm trying to remove any video game with a genre that appears less than some number of times in the DataFrame, but I have no clue how to go about this. I did find a...

Adding classes to filtered items and hidden items in Isotope. Buttons not checkbox

javascript,jquery,filtering,jquery-isotope
I know this question has been answered, and here is a fiddle which achieves exactly what I want to do, HOWEVER, in the example they use radio buttons, whereas I'm using a set of buttons (essentially just divs which gain a class of .active once clicked). I've tried to adapt...

How to filter/smooth with SciPy/Numpy?

python,numpy,scipy,filtering,smoothing
I am trying to filter/smooth signal obtained from a pressure transducer of sampling frequency 50 kHz. A sample signal is shown below: I would like to obtain a smooth signal obtained by loess in MATLAB (I am not plotting the same data, values are different). I calculated the power spectral...

filter table mysql using multiple colums also between

php,mysql,filtering,between,sql-like
how to join BETWEEN statement and AND statement using multiple category? SELECT * FROM quick_inquiry WHERE inquiry_time BETWEEN '$start' AND '$end' AND inquiry_language LIKE '%$language%' AND service_country LIKE '%$country%' AND category LIKE '%$category%' AND replied LIKE '%$replied%' ...

filter image with less damage to edges

opencv,image-processing,filtering
I have an image like this http://i.stack.imgur.com/uO6pl.jpg I want to filter noise with the least possible damage to the edges given this constraint: The edge is always a straight line with possibility of rotation. I tried Bilateral Filter. It is pretty good but slow with large scale image. For now,...

Filtering Rows in R on Mutliple Conditional Test [duplicate]

r,data.frame,filtering,rows
This question already has an answer here: R count number of zero's per row, and remove every row more than 5 zero's 1 answer So am trying to filter rows of a data.frame based on the condition of having two or more 0 values. mir Target_2 Score value_2 Blank...

C++ FIR noise filter

c++,filtering,signal-processing
I'm digging up some info about filtering the noise out of my IQ data samples in C++. I have learned that this can be done by using a simple filter which calculates the average of last few data samples and applies it to the current sample. Do you have any...

Deconvolution of data convolved by a Gaussian response

matlab,filtering,signal-processing,fft
I have a set of experimental data s(t) which consists of a vector (with 81 points as a function of time t). From the physics, this is the result of the convolution of the system response e(t) with a probe p(t), which is a Gaussian (actually a laser pulse). In...

How do I apply filter_input to superglobals

php,netbeans,filter,filtering,superglobals
According to netbeans IDE, I need to add some sort of a filter to superglobals, filter_input() suggested by netbeans, for the code below $page = (isset($_GET['p']) && !empty($_GET['p'])) ? $_GET['p']: 'home'; After researching, I found this example on stackoverflow $name = ($name = filter_input(INPUT_GET, 'name')) ? $name : 'default_value'; But...

Unable to use Filtering while using google Places API (Android)

android,api,filtering
I'm trying to use Google Places API on my Android and fail in the filtering process. I've used the code shown in this guide: https://developers.google.com/places/training/autocomplete-android -My API key is fine (I've tested it in the browser and it worked fine). -Also, the URL I'm giving is fine (tested it in...

Best way to code PHP/MYSQL search with options [closed]

php,mysql,forms,search,filtering
So I am building a search form which has a lot of options for users to select from. As you can see from the image below a user selects a search criteria and it allows them to enter or check what they like. If this is unticked it removes all...

SciPy lfilter with initial conditions applied along any axis of N-D array

python,numpy,scipy,filtering
According to SciPy docs for lfilter: zi : array_like, optional Initial conditions for the filter delays. It is a vector (or array of vectors for an N-dimensional input) of length max(len(a),len(b))-1. If zi is None or is not given then initial rest is assumed. See lfiltic for more information. The...

How does kernel work in unsharp masking?

matlab,image-processing,filtering
I applied the kernel below to the picture for unsharp masking k = [-1 -1 -1; -1 8 -1; -1 -1 -1] I got Then I changed 8 to 14. And I got How does kernel work for unsharp masking the original picture and what does exactly do the number...

p:dataTable doesn't render header after filtering and paging back

jsf,primefaces,datatable,filtering,tableheader
I need to keep filtered data when I navigate between pages. After entering data into a filter cell of a data table, it displays correct filtered rows. If last entered data in the filter cell doesn't match any data rows to display and when I navigate to another page and...

Asp.net Telerik Radsearchbox not filter properly

asp.net,telerik,filtering
I'm using radsearchbox as a control in my site for search trough db. I used a object data source as radsearchbox's datasource. the aspx code is here: <telerik:RadSearchBox ID="RadSearchBox1" runat="server" DataSourceID="ObjectDataSourceSearch" DataTextField="Name" DataValueField="ID" EmptyMessage="search here" Skin="Silk" MinFilterLength="3"> </telerik:RadSearchBox> <asp:ObjectDataSource ID="ObjectDataSourceSearch" runat="server" SelectMethod="detail" TypeName="InStore"> </asp:ObjectDataSource> And detail function is:...

Wordpress filter products by price using numeric comparison

php,wordpress,filter,filtering
With pre_get_posts I extend the query with filters. I'm now trying to make a custom price filter, because i can't use the original filter De code i'm using: $minprice = 0; $maxprice = 0; if ( isset( $_GET['min_price'] ) && $_GET['min_price'] > 0 ) $minprice = $_GET['min_price']; if ( isset(...

NSPredicate to filter out parent-child objects where a player owns none

objective-c,arrays,filtering,nspredicate
I have an array of groups. Each group has a basic make-up of this; Group { Name : NSString Children : NSArray } Each child within the children array can be owned by a certain Player So ie; Child1.owner = PlayerA A player can only ever own 1 child item...

Using AngularJS to create an instant search by querying an array

javascript,arrays,angularjs,search,filtering
This is going to be a rather longwinded question, so please bear with me... I have an array of about 25-30 items. They are sorted through various filters such as brand, type, material, size, etc.. How can I go about building a searchable filter. All of the ones I've seen...

CGridView filter by year of date

search,yii,filtering,cgridview,cactivedataprovider
Sorry for long text but my problem is long :-) I made grid like this $this->widget('zii.widgets.grid.CGridView', array( 'dataProvider'=>$model->search(), 'filter'=>$model, 'columns'=>array( array( 'name'=>'title', 'type'=>'raw', 'value'=>'CHtml::link(CHtml::encode($data->title), $data->url)' ), array( 'name'=>'create_time', 'type'=>'raw', 'value' => 'Yii::app()->dateFormatter->format("yyyy", $data->create_time)', ), ), )); and then i want to filtering by date like title filtering, by textfield. I...

Eclipse error using Maven filtering in persistence.xml

maven,jar,persistence,filtering
I have a Maven project with JPA using hibernate. I had to specify a jar file to load external classes in persistence.xml located in src/main/resources/META-INF <persistence unit name="PersistenceUnit" transaction-type="JTA" ... <jar-file>lib/${project.persistencejar}.jar</jar-file> using Maven filtering (the filename can change based on various Maven settings). I instruct then Maven to filter by...

Modifying $post->post_content in WordPress

wordpress,filtering,shortcode
I'm using a template that seems to be outputting $post->post_content in the search page. I maintain a plugin that uses a non-standard shortcode format and I'm trying to find out how can I filter $post->post_content before it gets displayed because currently my shortcode is not getting covered (again, not using...

Filter image that contains NaNs in Matlab?

matlab,filtering,nan
I have a 2d array (doubles) representing some data, and it has a bunch of NaNs in it. The contour plot of the data looks like this: All of the white spaces are NaNs, the gray diamond is there for reference, and the filled contour shows the shape of my...

icCube cascading Filters with multiple selections

filtering,iccube,iccube-reporting
Looking at this, http://www.iccube.com/livedemo/?ic3reportName=I%20want%20a%20BigMac I want to do the same thing but with a multi-selection (Buttons) first filter which would reduce the choices list on a second filter (TreeFilter) Thanks....

Isotope with multiple filter [closed]

javascript,jquery,filtering,jquery-isotope
I'm currently working on a page that has a filter effect using the jQuery plugin, Isotope. https://colab.aut.ac.nz/events-test/. Currently it accepts only one active filter and it functions as a tab. I'm trying to find any solution that I so that It can toggle more than one filter but still has...

Filtering with SQL

mysql,sql,search,filtering
I'm trying to write a SQL query for filtering people in a data set. There are some "facets", which are things like "How old is the person?", "How tall is the person?". There are some "buckets" for each facet. For example, the "How old?" facet might have buckets "0-20", "21-40",...

What's the best way to filter a pandas series and then set the values of the part selected?

select,pandas,filtering,series,setvalue
For example I have a series like this: AFalse 0.220522 BTrue -1.050370 CFalse -1.202922 DTrue 0.950305 EFalse 0.003110 FTrue 1.115483 GFalse 0.767281 HTrue -1.376692 IFalse 1.729867 JTrue 2.574027 dtype: float64 I want to filter out only the rows with 'True' and set the values to None. What's the best way...

How to get filtered value on Primefaces lazy datatable?

jsf-2,primefaces,datatable,filtering,lazy-loading
I use lazy="true" on primefaces datatable because my data is large. But this time I didn't get the filtered list. I guess, the problem is dataTable value is org.primefaces.model.LazyDataModel and filteredValue is java.util.List. So, how can I get the filteredValue on my datatable ? Any suggestion? My datatable declaration :...

angular filtering nested objects: AND vs OR

angularjs,filtering
I'm using angular filtering from Controller level, i.e. filterFilter. I need to implement nested filtering and I'm not sure how to do that in angular the best way. I've got a collection of objects that look like the following: { "id": "5d004ff4-46a9-47d5-b068-6b9d581bb6fa", "number": 80501703098, "firstName": "Loma", "lastName": "Collins", "age": 44,...

Leaflet filtering existing featuregroup

filter,filtering,leaflet,layer
I have a leftleat map and i would like to filter the featuregroup i am displaying. exp_colJSON = new L.geoJson(exp_col,{ onEachFeature: pop_col, pointToLayer: function (feature, latlng) { return L.circleMarker(latlng, { radius: feature.properties.radius_qgis2leaf, fillColor: feature.properties.color_qgis2leaf, color: feature.properties.borderColor_qgis2leaf, weight: 1, opacity: feature.properties.transp_qgis2leaf, fillOpacity: feature.properties.transp_qgis2leaf...

Dynamic filtering in D3 with HTML input

javascript,html,d3.js,filtering
I am far to be a D3 geek and just made one of my first 'scatter plots' reading from a tab delimited file. Each dot (or circle) has a date (x axis) and a count (y axis) attached to it and a sentence, which shows on mouseover. The code and...

Pixelated texture filtering distorted

java,libgdx,filtering,isometric,texturepacker
I've created a isometric tile based game in Libgdx. The textures I'm using are 64x64 and packed using TexturePacker into a TextureAtlas. They are then drawn onto the screen. However, while moving around the pixelated edges of the 64x64 texture flicker and they are distorted, which can be seen in...

How to use JavaFX FilteredList in a ListView? [closed]

listview,javafx,filtering
I have a ListView in my application which contains Strings. Now, I want to filter this list by an input field. But all examples about FilteredLists I found are about how to filter a table. How can I filter a ListView using a FilteredList?...

Access only filtered values in a MS Access table

ms-access,filtering
Is it possible to get the values from rows in an Access table that are showing after the filter is applied? Example as requested: I have a table in which employees fill in project tasks, hours on the project etc. It is made as a table on a form. The...

Swift UISearchController wired up in Core Data Project, app runs, but search not updating

swift,core-data,filtering,uisearchcontroller,uisearchresultscontroller
I have been wrestling the past few days with creating a filter in a Swift project for a TableViewController that uses Core Data. I finally figured out I need to use a UISearchController, create an NSPredicate for the searchController.searchBar, etc. I found this post EXTREMELY helpful, but after modeling my...

Python 3 filtering directories by name that matches specific pattern

python,regex,python-3.x,directory,filtering
Currently I'm developing script that will perform cleanup of specific directories. For example: Directory: /app/test/log contains many sub-directories with name pattern testYYYYMMDD and logYYYYMMDD What I need, is to filter out only directories like testYYYYMMDD To get all folders with absolute path that are in given directory I use: folders_in_given_folder...

SAPUI5 Filter Search

filtering,sapui5,sap-fiori
I'm Developing Fiori App with Master-Master-Detail template, First I'm filtering by date but I want to use the search box that it's generated by default. I need to use both condition filters: Date and the element specified in serach box. Somebody knows how to add search filter without remove previous...

R Shiny - filter two table and heatmap simultaneously (with cells of fix width)

r,callback,filtering,shiny
I have two input tables: label and main_plot. I am able to filter the plot using controls in the sidePanel. Column in "main_plot" corresponds to columns of "label". I want to filter both tables using controls simultaneously. (e.g.: if I see only first and second column of "label" after filtering...

Removing some text in input submitted field

php,html,validation,input,filtering
<form method="get" id="download" action="getvideo.php"> <h1 class="form-download-heading">Youtube Downloader</h1> <input type="text" name="videoid" id="videoid" class="inputtext" size="40" /> <input class="styled-button-11" type="submit" name="type" id="type" value="Download" /> </form> <!-- php code in getvideo.php --> <?php // removing the http and https from input $string = $_POST['videoid']; $words = array('HTTP', 'HTTPS'); $replacements = array('', ''); $result...

Convolution only for selected pixels or nlfilter() for selected pixels

performance,matlab,image-processing,filtering,convolution
Is there any built-in function for doing convolution only for a subset of pixels on the image? Basically, I know the coordinates of these points and I want to get the results of applying convolution kernel centered at these points. I want to use it in my implementation of Hessian-Laplace...

Filter multidimensional array on second level [duplicate]

php,arrays,multidimensional-array,filtering
This question already has an answer here: Is there a function to extract a 'column' from an array in PHP? 13 answers There are a lot of Threads about filtering, but i'm google all day long and can't get this to work. I have an array, who is created...

How to gauss-filter (blur) a floating point numpy array

python,numpy,filtering,python-imaging-library
I have got a numpy array a of type float64. How can I blur this data with a Gauss filter? I have tried from PIL import Image, ImageFilter image = Image.fromarray(a) filtered = image.filter(ImageFilter.GaussianBlur(radius=7)) , but this yields ValueError: 'image has wrong mode'. (It has mode F.) I could create...

xcorr function with impulse response

matlab,filtering,convolution
I'm trying to design a Wiener filter in Matlab for a deconvolution problem but I'm having a lot of problems. I have a gaussian white noise process with a variance of 1.2 and a impulse response which has length two. Its values are g(0) = 5 and g(1) = 4....

What should I supply to the “freq” input for Frequency Xlating FIR Filter for GnuRadio Companion?

filtering,gnuradio,software-defined-radio
I am using GnuRadio Companion (GRC) 3.75 and I am trying to use the Frequency Xlating FIR Filter (FXFF) block to perform some filtering. All the tutorials I've seen had this FXFF block take in only 1 input (such as this), which is the complex signal (blue in colour). However,...

filtering not working from select

jquery,table,datatable,filtering,html-select
I have created a application with dataTable with fixed headers and sorting, the application is working fine but the issue is that I am having a name filtering through a drop-down, which is not working when I select a particular name. My code is given below. Can anyone please tell...

Filtering a list with jQuery, when multiple words are entered as input, using AND condition

javascript,jquery,filtering
I'm trying to filter a list based on user input, with jQuery. So far it works OK, but I'd like to be able to filter the list adequately if the user inputs more than one word, using the equivalent of an AND condition. For example, if the user enters "Toyota...

FFT low-pass filter

python,numpy,scipy,filtering,fft
Be warned, this is a newbie question. I acquired some noisy data (a 1x200 pixel sclice from a grayscale image), for which I am trying to build a simple FFT low-pass filter. I do understand the general principle of the Fourier Transform, but I ran into trouble trying to implement...

PIG filter out rows with improper number of columns

apache-pig,filtering
I have simple data loaded in a: dump a ahoeh,1,e32 hello,2,10 ho,3 I need to filter out all rows with number of columns/fields different than 3. How to do it? In other words result should be: dump results ahoeh,1,e32 hello,2,10 I know there should be a FILTER built-in function. However...

Kalman filter for RSSI in iOS

ios,filtering,kalman-filter,rssi
I've made an iOS App to range the beacons. I've noticed that the RSSI value from beacons is fluctuating randomly with time. In order to get smooth RSSI value, I am trying to use Kalman filter. In Kalman filter equations as described here, the measurement noise (R) can be calculated...

Spark: Counting co-occurrence - Algoritm for efficient multi-pass filtering of huge collections

algorithm,scala,group-by,apache-spark,filtering
There is a table with two columns books and readers of these books, where books and readers are book and reader IDs, respectively : books readers 1: 1 30 2: 2 10 3: 3 20 4: 1 20 5: 1 10 6: 2 30 Record book = 1, reader =...

Filtering records results in undefined method when category_id is provided

ruby-on-rails-4,filtering
I've got a problem with filtering function in my app. Please enter here: http://leszczyna.wzks.uj.edu.pl/12_stolarski/events_for_seniors/pl/events?utf8=%E2%9C%93&search=Warszawa&date=02-06-2015 Search works fine, but when I try to filter by categories (left panel) then I get error: undefined method `category_id' What is more, if you change category_id in link for category_whatever, then the error disappear (but...

filtering the filtered result in vb.net

vb.net,filtering
Can someone please help me with this? I have two comboboxes, cboSearchby(which holds the items 1st sem and 2nd sem) and cboSY(which holds the items 2014-2015 and 2015-2016) conn = New OleDbConnection(Get_Constring) conn.Open() cmd.Connection = conn cmd.CommandType = CommandType.Text sSQL = "SELECT edp_number, LastName + ', ' + FirstName as...

How to filter an array between 2 values using NSpredicate in objective c ? I want to filter an array via name or version

ios,iphone,nsarray,filtering,nspredicate
(void)filterListForSearchText:(NSString *)searchText { NSPredicate *filterPredicate = [NSPredicate predicateWithFormat:@"SELF.name contains[cd]%@" ,searchText]; self.searchResults = [NSMutableArray arrayWithArray:[self.devices filteredArrayUsingPredicate:filterPredicate]]; [self.tableView reloadData]; } where self.device log is::: Array is, ( "<NSManagedObject: 0x7ffa32caab60> (entity: Device; id: 0xd000000000080000 <x-coredata://7EE6EBA4-6F15-49D8-B994-2E02379A75CD /Device/p2> ; data: {\n company = c1;\n name = apple;\n...

efficient way to remove duplicates from list of custom objects in python

python,list,filtering,subset,subsetting
I have a custom class of objects with an assortment of various attributes of different types. I would like to remove duplicates from a list of these objects based on one of these attributes. Something like this, but actually get a list of the objects rather than a list of...

Using Yii2 with array of data and a Gridview with sorting and filter

arrays,sorting,gridview,filtering,yii2
I've an array $resultData = [ array("id"=>1,"name"=>"Cyrus","email"=>"[email protected]"), array("id"=>2,"name"=>"Justin","email"=>"[email protected]"), array("id"=>3,"name"=>"Mason","email"=>"[email protected]"), array("id"=>4,"name"=>"Fulton","email"=>"[email protected]"), array("id"=>5,"name"=>"Neville","email"=>"[email protected]"),...

Should I put all data in one table for Implementing Filtration or use junction table

c#,sql,sql-server,database-design,filtering
I thought about using a junction table to avoid repeating the data in my database. So I have the following schema Apartments: +----+-------+----------+------------------+ | ID | Price | CityID | ContractTypeID | +----+-------+----------+------------------+ | 1 | 200 | 1 | 1 | | 2 | 150 | 1 | 2...

Spark: Filtering out agregated data?

scala,hash,apache-spark,filtering
There is a table with two columns books and readers of these books, where books and readers are book and reader IDs, respectively. I need to remove from this table readers who read more then 10 books. First I group books by reader and get sizes of these groups: val...

Angular - applying filter in real time

javascript,angularjs,filtering
I have an array of objects: [{ name: "test", type: 0, speed: 50 }, { name: "test2", type: 4, speed: 10 }, { name: "test3", type: 4, speed: 67 }, { name: "test4", type: 2, speed: 40 }] I want to show the array with ng-repeat.. Until here everything is...

how to use multiple combo boxes to filter data

vb.net,combobox,filtering
can someone please help me with this problem i'm a beginner in programming. there is two comboboxes which is S.Y.(school year) and Sem(semester) and i want to use these two combo boxes to have more specific data in the listview below. Private Sub Search_Record() Dim conn As New OleDbConnection Dim...

PHP: Filtering and posting a text file

php,csv,text-files,filtering
I have a text file that contains a persons surname, address, time of accident and reason of accident separated by a white space in a line. I need to filter this file by only the people that have called in at least two times for the same reason and echo...

Can Java 8 Streams operate on an item in a collection, and then remove it?

java,collections,java-8,filtering,java-stream
Like just about everyone, I'm still learning the intricacies (and loving them) of the new Java 8 Streams API. I have a question concerning usage of streams. I'll provide a simplified example. Java Streams allows us to take a Collection, and use the stream() method on it to receive a...

Filtering for all periods based on one period

filtering,tableau
I have a tableau question relating filtering. I want to filter for values above a particular point for multiple IDs and periods. Suppose: ID Date Balance 1 2014 100 1 2015 100 1 2016 90 1 2017 80 2 2014 120 2 2015 150 2 2016 100 2 2017 90...

Filtering using multiple wildcards

make,filtering,wildcard,gnu-make,glob
I've git a project where, at some point in its Makefile, I'm filtering out stuff from a certain directory: relevant = $(filter-out irrelevant/%,$^) Now I want to use this in a VPATH-enabled environment. So the paths of my dependencies in $^ might not start with irrelevant any more, but instead...

filtering firstname and lastname using datatable.js

javascript,jquery,table,datatable,filtering
I have created a application with dataTable for filtering firstname and lastname, I am having a firstname and lastname text-field through which I would filter firstname and lastname. The filtering is working but the issue is that firstname and lastname filtering is doing from both the textfield, Actually I need...

excel macro vba Filtering using wildcards

excel,vba,excel-vba,filtering,wildcard
I need to filter in pivot. I need to deselect all items starting with "A." and "H." and keep everything else selected. the items ranges from: A.(3-13 characters) B.(3-13 characters) all the way to Z.(3-13 characters) the raw data also changes from 50-500 rows (I can have a data with...

Opencv getGaborKernel parameters for filter bank

c++,opencv,computer-vision,filtering
How opencv getGaborKernel function parameters related to orientation and scale parameters? I assume theta is orientation, but what refers to scale? //! returns the Gabor kernel with the specified parameters CV_EXPORTS_W Mat getGaborKernel( Size ksize, double sigma, double theta, double lambd,double gamma, double psi=CV_PI*0.5, int ktype=CV_64F ); Here is example...

How to Add external frequency inputs in the analog filter design block simulink in matlab

matlab,filtering,signal-processing,simulink
I want to be able to externally have inputs for the lower passband edge frequency and higher passband edge frequencies for the butterworth filter block in the simulink signal processing toolbox in matlab. How can I achieve this. Currently you'll have to click the block to specify these frequencies and...

Using jQuery to filtering with two input types

javascript,jquery,filtering
I am trying to use checkboxes and a dropdown menu to filter (.hide(), .show()) divs. I have an example working but need the two functions to check each other. http://jsfiddle.net/fj8vLns1/3/ The idea would be to have the check box for link2 checked and select 2015 on the dropdown menu and...

Data Filter Shows Nothing To Filter On

excel,excel-2007,filtering
I have imported a query into Excel, very straight-forward process. The issue I am having is if I click the header row and say filter, if I select any of the filter arrows, their are no values to filter on? What should I change so that I am able to...

live searching on the actionbar's searchView

android,filtering,searchview
i was wondering onto how we can implement/ create a list View below the search view widget on the action bar. And finally filter the list when a string is entered just like the one on the Google play store.

Combining unique cell's values

excel,excel-formula,filtering,unique
I'm trying to get the combined values from column B from a list in column A that contains duplicates names. Sally Cookies, Apples Jamie Pie Sally Muffins Bob Jam Bob Pie and have the result be: Sally Cookies, Apples, Muffins Jamie Pie Bob Jam, Pie I've tried sorting with Unique,...

Remove spurious small islands of noise in an image - Python OpenCV

python,opencv,image-processing,filtering
I am trying to get rid of background noise from some of my images. This is the unfiltered image. To filter, I used this code to generate a mask of what should remain in the image: element = cv2.getStructuringElement(cv2.MORPH_RECT, (2,2)) mask = cv2.erode(mask, element, iterations = 1) mask = cv2.dilate(mask,...

data.table sum and subset

r,sum,filtering,data.table
I have a data.table that I am wanting to aggregate library(data.table) dt1 <- data.table(year=c("2001","2001","2001","2002","2002","2002","2002"), group=c("a","a","b","a","a","b","b"), amt=c(20,40,20,35,30,28,19)) I am wanting to sum the amt by year and group and then filter where the summed amt for any given group is greater than 100. I've got the data.table sum nailed. dt1[, sum(amt),by=list(year,group)]...

Visual Studio 2013 Extending Solution Explorer Filter

c#,visual-studio-2013,filtering,visual-studio-sdk
I'm trying to create a VsPackage with a custom filter for the solution explorer. I followed the walkthrough on https://msdn.microsoft.com/en-us/library/hh966591.aspx to the latter, I see the button and I can click it but the filter is never applied. And I can't even debug it because no single method in the...

High Pass Butterworth Filter on images in MATLAB

image,matlab,image-processing,filtering,signal-processing
I need to implement a high pass Butterworth filter in MATLAB for the purposes of image filtering. I have implemented one but it looks like it doesn't work. Here is the code I have written. Can anyone tell me what is wrong? n=1; d=50; A=1.5; im=imread('imagex.jpg'); h=size(im,1); w=size(im,2); [x y]=meshgrid(-floor(w/2):floor(w-1/2),-floor(h/2):floor(h-1/2));...

How can I filter a list having multiple values using jQuery and CSS?

jquery,css,filtering
Having tested various solutions found here and on the rest of the web, I can't figure out the logic to do this the "simple" way (or make it work at all). I have the following list: <ul class="store-list"> <li data-categories="Bags Shoes Accessories Belts"> <h3 itemprop="name">Enzo Poli</h3> </li> <li data-categories="Womenswear Shoes">...

Matlab Low Pass filter using fft

matlab,filtering,fft,lowpass-filter
I implemented a simple low pass filter in matlab using a forward and backward fft. It works in principle, but the minimum and maximum values differ from the original. signal = data; %% fourier spectrum % number of elements in fft NFFT = 1024; % fft of data Y =...

C++ Butterworth Nth order filter design

c++,filtering,signal-processing
I am looking for a function which calculate a Butterworth Nth filter design coefficients like a Matlab function: [bl,al]=butter(but_order,Ws); and [bh,ah]=butter(but_order,2*bandwidth(1)/fs,'high'); I found many examples of calculating 2nd order but not Nth order (for example I work with order 18 ...). - unfortunately I haven't any knowledge about DSP. Do...

Filtering for UI developed using GWT

java,java-ee,gwt,filtering
I am developing an application using GWT as the front end technology stack. Backend stack is Struts, Spring, mybatis We have a requirement to support column level filtering. for instance, if the client enters 'am', all words containing 'am' are filtering in the column. For GWT, to support filtering, what...

Filtering for only complete sets of years

r,filtering,panel
I have data on yield organized by State and County. Out of this data I want to retain only those counties providing complete years between 1970 to 2000. The following code clears away some incomplete cases, however fails to omit all the cases- especially with a larger data set. The...

Obtain a list containing string elements excluding elements prefixed with any other element from initial list

python,string,list,python-2.7,filtering
I have some trouble with filtering a list of strings. I found a similar question here but is not what i need. The input list is: l = ['ab', 'xc', 'abb', 'abed', 'sdfdg', 'abfdsdg', 'xccc'] and the expected result is ['ab', 'xc', 'sdfdg'] The order of the items in the...

Live Search in Android [closed]

android,json,filtering
I have the following task to do, I need to build a live search from an endpoint. Now, the thing is I know how to do it but, what I don't know, is how to do it efficient. The small app should do the following: Live search from a specific...

jQuery merging/filter selector

javascript,jquery,filtering
I want to merge a selector split by another selector. My actual selector looks like $('.JS_toggle-submenu') <li class=​"JS_toggle-submenu" data-submenu=​"#submenu-l2-foo">​…​</li>​ <h2 class=​"JS_toggle-submenu" data-submenu=​"#submenu-l2-foo">​…​</h2>​ <p class=​"JS_toggle-submenu" data-submenu=​"#submenu-l3-bar">​…</p>​ <h3 class=​"JS_toggle-submenu" data-submenu=​"#submenu-l3-bar">​…</h3>​ And would like to filter it to the first of each...

How to set checked value of checkbox on filtered rows in a jQuery dataTable?

jquery,checkbox,datatable,filtering
I have problems settings checkboxes with checked state in a jQuery dataTable. My setup jQuery DataTable v. 1.9.4 filtered data paging enabled and filtered data spans multiple pages. I am trying to set checked state on checkboxes in a filtered dataTable that (can) span multiple pages. I can only get...

pythonic way to filter list for elements with unique length

python,filtering
I want to filter a list, leaving only first elements with unique length. I wrote a function for it, but I believe there should be a simpler way of doing it: def uniq_len(_list): from itertools import groupby uniq_lens = list(set([x for x, g in groupby(_list, len)])) all_goods = [] for...

SQL query: where array is in array

sql,arrays,filtering
I've got sample data in database: id (int) name (varchar) parts (varchar) 1 some_element wheel, bearing, hinge, servo 2 another_element bearing, servo, lift 3 third_element motor, wire I want to filter results by parts. For example: I'm typing wheel, servo - no results I'm typing wheel, bearing, servo, hinge -...

Wrong column filtering for date column

javascript,sorting,formatting,filtering,tablesorter
I use tablesorter to sort columns. But I found the following issue: As you can see the second row doesn't have 16. This table also have the external search field and search result equals 1 if I type 16, thus second row doesn't show. But it lools like a tablesorter...

query_string filter inside a nested filter throws an error

elasticsearch,nested,filtering
In this example I've placed a full query example that's been paired down to the non-working portion that has me stuck. Basically we have a document that has a nested document type under datailItems and trying to do a query_string filter against a field in that nested document fails. I...

Powershell Filtering with Where-Object not applying

powershell,filtering
I'm having an issue with following piece of code: $NodeList = (get-scvmhostcluster ClusterName| where-object {$_.nodes.fullyqualifieddomainname -ne "Host001.Domain.Tld"}).nodes.fullyqualifieddomainname Normally this should filter from the list of Hosts the "Host001.Domain.tld" out of the list. (Host001 up to Host014 is what this list normally generates, unfiltered). However, when running the script block and...

Eclipse + maven : profile ignored

maven,filtering,profile
Here is my pom.xml: <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.heliosophiclabs</groupId> <artifactId>artifactId</artifactId> <version>0.0.1-SNAPSHOT</version> <profiles> <profile> <id>local</id> <activation>...

Mode filter for large matrices

matlab,filtering,large-data,mode
I am trying to filter some 4672 by 3001 matrices with values of 0 and 1 by finding the most common value in a given window size. I.e. finding the mode in a window around each pixel. A solution is to use colfilt(A,[3 3],'sliding',@mode) The below link shows a solution...

Is there a way to find the first element to match a Predicate? [duplicate]

java,performance,filtering,predicate,java-stream
This question already has an answer here: Java 8 find first element by predicate 2 answers With Java 8+, you can easily find all elements of a collection that match a Predicate. someCollection.stream().filter(somePredicate) You could then find the first element: someCollection.stream().filter(somePredicate).findFirst() The problem with this, though, is that it...

PHP: Finding duplicates in multidimensional arrays and echo'ing the result

php,arrays,multidimensional-array,filtering
I've been stuck with this for a little while now and all I can find on the internet is how to remove the duplicates. I'm new to PHP so simple answers would be very well appreciated. So let's say I have a multidimensional array of surnames, addresses, time of accidents...