/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

11 votes159 views3 answers
Python pandas convert nan to 0
Python
0 vote157 views1 answer
X not defined python
Python
4 votes155 views1 answer
Change default option optionmenu tkinter
Python
2 votes168 views1 answer
Termcolor python
Python
0 vote147 views1 answer
How to record pyttsx3 file using python
Python
2 votes167 views2 answers
Discord.py ping command
Python
6 votes141 views6 answers
Pandas drop missing values for any column
Python
2 votes147 views1 answer
Django mysql
Python
0 vote145 views1 answer
Pytho ntoday as string
Python
1 vote153 views1 answer
Skeppy python
Python