/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 vote187 views1 answer
Without @tf.function OOM
Python
-1 vote220 views2 answers
Django cleanup
Python Django
0 vote196 views1 answer
Python How To Check Operating System
Python
-1 vote199 views1 answer
Matplotlib draw a line between two points
Python
1 vote205 views2 answers
Number of columns with no missing values
Python
0 vote203 views1 answer
Discord bot slash
Python
0 vote222 views1 answer
Change form type flask from text to selection flask admin
Python Flask
1 vote186 views1 answer
Warning: this is a development server. do not use it in a production deployment.
Python
1 vote231 views1 answer
Django admin slug auto populate
Python Django
1 vote218 views1 answer
Set the root directory when starting jupyter notebooks
Python