/Python/Get first not null value from column dataframe

Get first not null value from column dataframe

s = pd.Series([np.nan,2,np.nan])
print (s)
0    NaN
1    2.0
2    NaN
dtype: float64

print (s.first_valid_index())
1

print (s.loc[s.first_valid_index()])
2.0

# If your Series contains ALL NaNs, you'll need to check as follows:

s = pd.Series([np.nan, np.nan, np.nan])
idx = s.first_valid_index()  # Will return None
first_valid_value = s.loc[idx] if idx is not None else None
print(first_valid_value)
None

Source: stackoverflow.com

Similar codes

0 vote245 views7 answers
Online python compailer
Python
2 votes243 views1 answer
Python gui capture user input
Python
0 vote237 views5 answers
Convert c++ code to python
Python
1 vote282 views1 answer
Batchnorm1d pytorch
Python
-2 votes224 views1 answer
How to print int in flutter
Python
0 vote224 views1 answer
Image completion inpainting with python
Python
-1 vote266 views1 answer
Let’s add a docstring to the greeting method. How about, “Outputs a message with the name of the person”.
Python
9 votes239 views2 answers
Get a list of all files python
Python
0 vote218 views1 answer
Calculating difference of elemetns in array python
Python
7 votes216 views2 answers
Python print for loop one line
Python