/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 vote343 views1 answer
Count number of zeros in a number python
Python
0 vote286 views1 answer
Python move all txt files
Python
1 vote290 views2 answers
Python list iterator
Python
0 vote335 views1 answer
How to have framer read json timestamps
Python
0 vote323 views1 answer
Python save base64 temp file
Python
2 votes321 views6 answers
K
Python
0 vote323 views1 answer
Encrypt password with sha512 + python
Python
0 vote310 views1 answer
‘A’, ‘Q’, ‘BM’, ‘BA’, ‘BQ’ meaning in resample
Python
0 vote337 views1 answer
Ipywidgets label text color
Python
0 vote324 views1 answer
Resize cmd using python
Python