Locate first and last non NaN values in a Pandas DataFrame

by

@behzad.nouri’s solution worked perfectly to return the first and last non-NaN values using Series.first_valid_index and Series.last_valid_index, respectively.

Related Contents:

  1. Convert Pandas Column to DateTime
  2. Converting between datetime, Timestamp and datetime64
  3. Extracting just Month and Year separately from Pandas Datetime column
  4. Keep only date part when using pandas.to_datetime
  5. Filtering Pandas DataFrames on dates
  6. How to print pandas DataFrame without index
  7. How to change the datetime format in Pandas
  8. Combine Date and Time columns using pandas
  9. pandas dataframe groupby datetime month
  10. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  11. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  12. how to test if a variable is pd.NaT?
  13. Convert dataframe index to datetime
  14. Converting between datetime and Pandas Timestamp objects
  15. pandas out of bounds nanosecond timestamp after offset rollforward plus adding a month offset
  16. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  17. How to convert string to datetime format in pandas python?
  18. Create a day-of-week column in a Pandas dataframe using Python
  19. Pandas: Subtracting two date columns and the result being an integer
  20. How to convert columns into one datetime column in pandas?
  21. Pandas: Convert Timestamp to datetime.date
  22. Getting min and max Dates from a pandas dataframe
  23. Find the end of the month of a Pandas DataFrame Series
  24. How do I properly set the Datetimeindex for a Pandas datetime object in a dataframe?
  25. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  26. Python Pandas Group by date using datetime data
  27. Python pandas convert datetime to timestamp effectively through dt accessor
  28. How to set a variable to be “Today’s” date in Python/Pandas
  29. Add days to dates in dataframe
  30. AttributeError: Can only use .dt accessor with datetimelike values
  31. Get weekday/day-of-week for Datetime column of DataFrame
  32. How to join two dataframes for which column values are within a certain range?
  33. datetime to string with series in pandas
  34. Comparison between datetime and datetime64[ns] in pandas
  35. Generating random dates within a given range in pandas
  36. Get total number of hours from a Pandas Timedelta?
  37. How do I round datetime column to nearest quarter hour
  38. pandas datetime to unix timestamp seconds
  39. Splitting timestamp column into separate date and time columns
  40. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  41. Pandas converting row with unix timestamp (in milliseconds) to datetime
  42. Subtract a year from a datetime column in pandas
  43. change multiple columns in pandas dataframe to datetime
  44. Convert column of date objects in Pandas DataFrame to strings
  45. Convert Pandas Series to DateTime in a DataFrame
  46. Converting a datetime column to a string column
  47. Converting time zone pandas dataframe
  48. In Pandas how do I convert a string of date strings to datetime objects and put them in a DataFrame?
  49. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  50. Python pandas integer YYYYMMDD to datetime

Leave a Comment