/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

1 vote95 views2 answers
Python string copy
Python
0 vote102 views1 answer
In <lambda> tk.Button(self.frame, text = text, command= lambda:self.new_window(number, _class)).grid(padx= 5, pady= 5, sticky= N + E + W + S) File "C:\Users\CSB\Desktop\python program\triple_window.py", line 50, in new_window
Python
0 vote110 views1 answer
Tkinter how to update optionmenu contents
Python
0 vote111 views1 answer
Python copy sequence
Python
0 vote101 views1 answer
Transcript with timestamps in python
Python
0 vote113 views1 answer
Multiplication table for number python codewars
Python
0 vote110 views1 answer
Python write data to file with permissions
Python
1 vote101 views1 answer
Python increase one item in list
Python
0 vote108 views1 answer
Amazing Trees with python turtle
Python
15 votes114 views5 answers
Confusion matrix python code
Python