/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 vote317 views1 answer
Dictionary Get All Keys
Python
15 votes313 views1 answer
Api in python
Python
0 vote317 views1 answer
All the symbols on a keyboard python list
Python
0 vote326 views2 answers
How to add space before capital letter in python
Python
19 votes315 views3 answers
Pil image to numpy array
Python
0 vote296 views1 answer
Plt grid linestyles options
Python
0 vote294 views1 answer
How to get all values from class in python
Python
1 vote307 views1 answer
Python array append extend
Python
0 vote354 views2 answers
Fetching data from multiple tables using related name in django
Python Django
2 votes313 views3 answers
Python multi-line string
Python