/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

39 votes262 views5 answers
How to calculate the sum of a list in python
Python
0 vote261 views1 answer
Python - notification messages
Python
0 vote294 views1 answer
Python class optional attributes
Python
1 vote273 views3 answers
How to use variable from another function in python
Python
-1 vote267 views1 answer
Count true in a dataframe
Python
3 votes271 views1 answer
Numpy how to calculate variance
Python
0 vote351 views1 answer
Dev.to flask heroku
Python
1 vote320 views1 answer
Posted data to flask
Python Flask
0 vote269 views1 answer
AttributeError: module 'psycopg2' has no attribute 'connection'
Python
1 vote278 views2 answers
Beautifulsoup python set text
Python