/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

3 votes185 views3 answers
Run python from c#
Python
3 votes171 views3 answers
Matplotlib transparency
Python
0 vote191 views1 answer
Ubuntu install pip for python 3.8
Python
0 vote180 views1 answer
Convert string input into a nested tuple in python
Python
0 vote187 views3 answers
Finding path of a module in python
Python
5 votes178 views2 answers
Value count a list python
Python
0 vote271 views1 answer
How to insert item at specifc index python
Python
0 vote171 views1 answer
Calculating difference of elemetns in array python
Python
-1 vote221 views1 answer
Django queryset count
Python Django
0 vote176 views1 answer
Insert video in tkinter
Python