pandas.NaT

pandas.NaT = NaT

(N)ot-(A)-(T)ime, the time equivalent of NaN.

NaT is used to denote missing or null values in datetime and timedelta objects in pandas. It functions similarly to how NaN is used for numerical data. Operations with NaT will generally propagate the NaT value, similar to NaN. NaT can be used in pandas data structures like Series and DataFrame to represent missing datetime values. It is useful in data analysis and time series analysis when working with incomplete or sparse time-based data. Pandas provides robust handling of NaT to ensure consistency and reliability in computations involving datetime objects.

See also

NA

NA (“not available”) missing value indicator.

isna

Detect missing values (NaN or NaT) in an array-like object.

notna

Detect non-missing values.

numpy.nan

Floating point representation of Not a Number (NaN) for numerical data.

Examples

>>> pd.DataFrame([pd.Timestamp("2023"), np.nan], columns=["col_1"])
        col_1
0  2023-01-01
1         NaT