I have a huge DataFrame (~4 million rows) and I need to search it for a row which has specific columns values for about a million time. Based on the conditions governing my problem, there is only one true answer (one row) for each query. So as soon as the search finds the first result, there's no need to continue the search. But as we know df.loc[df['column']==value]
has to read all the data every time! even if the first row satisfies the search conditions, other 4 million rows has to be read and evaluated! which creates a huge overhead for the search. Is there a way to get the first row satisfying the search conditions without reading and evaluating the rest of the rows?
How to search a pandas DataFrame for the first row satisfying set of conditions without reading the rest of the rows?
232 Views Asked by MHDMYZ At
1
There are 1 best solutions below
Related Questions in PYTHON
- Opening tool panel in ag-grid
- Ag-grid fullWidthCellRendererFramework adding my own properties
- Ag-grid and Angular2 using angular-cli
- Angular2 ag-grid-ng2
- ag-grid: column pinning not working
- event callback argument is empty
- Using ag-grid, how can I get the `api` attribute to not be null when working with angular 1.5 and directives?
- How to set cell style in ag-Grid while processing nodes?
- How to access a cell value when the column has been defined with ag-grid expression/value getters?
- How to get custom values for each richSelect in ag-grid
Related Questions in PANDAS
- Opening tool panel in ag-grid
- Ag-grid fullWidthCellRendererFramework adding my own properties
- Ag-grid and Angular2 using angular-cli
- Angular2 ag-grid-ng2
- ag-grid: column pinning not working
- event callback argument is empty
- Using ag-grid, how can I get the `api` attribute to not be null when working with angular 1.5 and directives?
- How to set cell style in ag-Grid while processing nodes?
- How to access a cell value when the column has been defined with ag-grid expression/value getters?
- How to get custom values for each richSelect in ag-grid
Related Questions in DATAFRAME
- Opening tool panel in ag-grid
- Ag-grid fullWidthCellRendererFramework adding my own properties
- Ag-grid and Angular2 using angular-cli
- Angular2 ag-grid-ng2
- ag-grid: column pinning not working
- event callback argument is empty
- Using ag-grid, how can I get the `api` attribute to not be null when working with angular 1.5 and directives?
- How to set cell style in ag-Grid while processing nodes?
- How to access a cell value when the column has been defined with ag-grid expression/value getters?
- How to get custom values for each richSelect in ag-grid
Related Questions in SEARCH
- Opening tool panel in ag-grid
- Ag-grid fullWidthCellRendererFramework adding my own properties
- Ag-grid and Angular2 using angular-cli
- Angular2 ag-grid-ng2
- ag-grid: column pinning not working
- event callback argument is empty
- Using ag-grid, how can I get the `api` attribute to not be null when working with angular 1.5 and directives?
- How to set cell style in ag-Grid while processing nodes?
- How to access a cell value when the column has been defined with ag-grid expression/value getters?
- How to get custom values for each richSelect in ag-grid
Related Questions in PANDAS-LOC
- Opening tool panel in ag-grid
- Ag-grid fullWidthCellRendererFramework adding my own properties
- Ag-grid and Angular2 using angular-cli
- Angular2 ag-grid-ng2
- ag-grid: column pinning not working
- event callback argument is empty
- Using ag-grid, how can I get the `api` attribute to not be null when working with angular 1.5 and directives?
- How to set cell style in ag-Grid while processing nodes?
- How to access a cell value when the column has been defined with ag-grid expression/value getters?
- How to get custom values for each richSelect in ag-grid
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
firstly you have to set that column as index (as you said you have no duplicated value). then change your data frame to dictionary, and then search your value.