/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 vote135 views1 answer
Python add hyphen to string
Python
1 vote130 views1 answer
Python implode list
Python
0 vote124 views1 answer
Preventing players to make entry in the same block in a python tic tac toe game
Python
1 vote116 views1 answer
Qmessagebox icon pyqt5
Python
1 vote140 views1 answer
Require http method django view
Python Django
6 votes124 views3 answers
Django filter install
Python
1 vote153 views1 answer
Django don't redirect on submission
Python Django
1 vote146 views8 answers
Fadaei
Python
0 vote135 views1 answer
Delete file in django terminal
Python
0 vote128 views3 answers
Short name in python
Python