/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 vote258 views1 answer
Get pixel color pygame
Python
0 vote327 views1 answer
Get table wikipedia
Python
2 votes281 views1 answer
Django setup allowed hosts
Python Django
1 vote251 views1 answer
Set and tuple in python
Python
0 vote247 views2 answers
Numpy index of first true value
Python
0 vote271 views1 answer
How to use drf pagination directly
Python
2 votes281 views2 answers
Split datetime to date and time pandas
Python
1 vote261 views1 answer
How to find magnitude of complex number in python
Python
0 vote261 views2 answers
In python, i am pustin two star before paramerter what is that men
Python
0 vote286 views1 answer
Using default as none in django mdoels
Python