Pandas: Create a DataFrame with NaN, None, NaT

31 July 2020

Code

# Import library
import pandas as pd

# Create DataFrame
df = pd.DataFrame({
    'fruit': ['mango', None, np.nan, pd.NaT],
    'quantity': [100, None, np.nan, pd.NaT],
    'time_1': [pd.Timestamp('2020-07-31'), None, np.nan, pd.NaT],
    'time_2': pd.to_datetime([pd.Timestamp('2020-07-30'),None, np.nan, pd.NaT]),
})

# Output
print(df)
print(df.dtypes)

Output

   fruit quantity     time_1     time_2
0  mango      100 2020-07-31 2020-07-30
1   None     None        NaT        NaT
2    NaN      NaN        NaT        NaT
3    NaT      NaT        NaT        NaT

fruit               object
quantity            object
time_1      datetime64[ns]
time_2      datetime64[ns]
dtype: object






Any errors in code above?
Please send a message.