/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 vote113 views1 answer
Convert python float list to 2 digit
Python
0 vote102 views1 answer
Comment prendre la valeur absolue d'un nombre python
Python
12 votes107 views3 answers
Convert pandas dataframe to dict with a column as key
Python
2 votes108 views1 answer
How to make custom buttons tkinter
Python
6 votes103 views2 answers
Python datetime get all days between two dates
Python
0 vote100 views1 answer
Remove item from list if it exists python
Python
0 vote110 views1 answer
PHP echo multiple lines example Using Heredoc
Python
3 votes150 views4 answers
Delete row by index pandas
Python
0 vote140 views1 answer
Flask get uploaded file size
Python Flask
4 votes115 views4 answers
Binary to decimal in python
Python