'pandas first_valid_index() in a vectorized way

this bit of code is a part of a while loop in which I change the values of the "value_area" variables, so executing this for loop can be quite long, is there a way to use the .first_valid_index() across all the DataFrame?

a = [value_area[remaining_index][x].sort_index(ascending=False).first_valid_index() for x in value_area[remaining_index].columns]
pandasdataframemethods


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Using strings instead of enums?

Should virtual dispatch happen when a virtual method is called within a virtual method using object?

how to override the equals() method when you have to compare 7 instance variables? [duplicate]

Writing A Recursive Function That Counts Zeros

Having trouble creating overloaded constructor, instantiating an object

Why does passing and changing a class self-variable with an external function work for manipulating iterables but not variables?

Safe method to get value of nested dictionary

Communication between BroadcastReceiver and Activity - android

Class is public, should be declared in a file named .java

Pointer receiver method compilation problem: Cannot call a pointer method on 'MyObj{}'

C# map a list of abstract class objects to derived class for method overloading

I need to decrease a value of the property only from specific class objects

Cannot execute method in an NSPanel from a separate NSWindow in Objective-C

Javascript forEach Method

Any difference between str.capitalize() and str.title()?