Pandas
keyboard_arrow_down 655 guides
chevron_leftTime Series
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Pandas DataFrame | last_valid_index method
schedule Aug 12, 2023
Last updated local_offer
Tags Python●Pandas
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
Pandas DataFrame.last_valid_index(~) method returns the index of the last occurrence of a row containing a non-NaN value. The check is performed row-wise, starting from the first row.
Note that in the following cases, None is returned:
if all entries of the source DataFrame are
NaNif the source DataFrame is empty
Parameters
This method has no parameters.
Return Value
The row label of the last occurrence of non-NaN value. The returned type hence depends on the index of your DataFrame.
Examples
Consider the following DataFrame:
df = pd.DataFrame({"A":[3,np.NaN,np.NaN],"B":[np.NaN,6,np.NaN]}, index=["a","b","c"])df
A Ba 3.0 NaNb NaN 6.0c NaN NaN
The label of the last occurrence of a row containing non-NaN value in the DataFrame is:
df.last_valid_index()
'b'
Here, the output is "b" because the last row with a non-NaN value has the label of "b".
Published by Isshin Inada
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
Official Pandas Documentation
https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.last_valid_index.html
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
