/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 vote238 views1 answer
Select realted for foreign key table in django
Python
0 vote223 views1 answer
How to resolve This typically means that you attempted to use functionality that needed an active HTTP request. Consult the documentation on testing for information about how to avoid this problem. in thread python
Python
11 votes197 views2 answers
Adding to python path
Python
3 votes233 views2 answers
Check iterable python
Python
0 vote236 views1 answer
How to remove some lines border from plt plot
Python
0 vote204 views1 answer
Cos2x
Python
1 vote186 views2 answers
N factorial
Python
-1 vote183 views5 answers
Sudo apt install python3-pip
Python
0 vote261 views3 answers
How to print tables using python
Python
26 votes200 views6 answers
Convert list of strings to ints python
Python