/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 vote106 views1 answer
Discord python tts
Python
1 vote107 views1 answer
Selenium select element by id
Python
14 votes119 views6 answers
If condition python
Python
15 votes176 views4 answers
Q django
Python Django
2 votes113 views1 answer
String module in python
Python
0 vote120 views1 answer
How to sort a list of dictionary by value in descending order?
Python
0 vote127 views1 answer
PY | websocket - server
Python
2 votes121 views2 answers
Save a Dictionary to File in Python Using the dump Function of the pickle Module
Python
1 vote124 views2 answers
TypeError: can’t multiply sequence by non-int of type ‘float’
Python
0 vote164 views1 answer
Python if column is null then
Python