/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

43 votes135 views6 answers
Remove char from string
Python
0 vote102 views1 answer
Abstract user in django
Python
0 vote106 views1 answer
What are data types in python
Python
1 vote103 views1 answer
Python __version__
Python
0 vote95 views1 answer
Opencv write text
Python
-1 vote97 views1 answer
Django custom primary key field
Python
27 votes100 views6 answers
Remove column from dataframe
Python
2 votes105 views2 answers
Add hours to date time in python
Python
0 vote126 views1 answer
Django raw without sql injection
Python Django
0 vote126 views1 answer
Show post id on django admin interface
Python Django