/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

2 votes224 views1 answer
Kivy changing screen in python
Python
6 votes217 views3 answers
Python how to draw a square
Python
0 vote213 views1 answer
Ppcm python
Python
2 votes225 views1 answer
Scikit learn dataset into pandas dataframe
Python
0 vote223 views1 answer
Python plot draw the goal line
Python
3 votes260 views2 answers
Python selenium go back
Python
1 vote204 views1 answer
Postgres django settings
Python
9 votes217 views3 answers
Difference between two dates in days python
Python
1 vote227 views1 answer
Issue Pandas TypeError: no numeric data to plot
Python
0 vote215 views1 answer
Root.iconbitmap
Python