/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 vote265 views1 answer
Is python good for competitive programming
Python
0 vote267 views1 answer
Time addition in python
Python
2 votes269 views4 answers
Max in python
Python
0 vote266 views2 answers
Mountain array leetcode
Python
0 vote307 views3 answers
Removing duplicates from django models data
Python Django
4 votes302 views1 answer
Re python3
Python
42 votes266 views4 answers
Replace column values pandas
Python
1 vote276 views1 answer
How to ungrid something tkinter
Python
0 vote285 views1 answer
Django redirect to external url
Python Django
0 vote273 views1 answer
Stdfilt python
Python