/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

1 vote121 views1 answer
Get maximum calue df column
Python
0 vote170 views1 answer
Initial TypedMultipleChoiceField django
Python Django
1 vote147 views1 answer
How to do key sensing in python
Python
0 vote170 views1 answer
Open file rw python
Python
0 vote90 views0 answer
Python
0 vote137 views1 answer
Matplotlib scatter increase marker size
Python
5 votes130 views2 answers
Making variable if it is none python
Python
1 vote124 views1 answer
What is kali
Python
20 votes134 views3 answers
Check if a string is a palindrome python
Python
-1 vote156 views2 answers
Rename folder python
Python