pandas.Timestamp#

class pandas.Timestamp(ts_input=<object object>, year=None, month=None, day=None, hour=None, minute=None, second=None, microsecond=None, tzinfo=None, *, nanosecond=None, tz=<object object>, unit=None, fold=None)#

Pandas replacement for python datetime.datetime object.

Timestamp is the pandas equivalent of python’s Datetime and is interchangeable with it in most cases. It’s the type used for the entries that make up a DatetimeIndex, and other timeseries oriented data structures in pandas.

Parameters:
ts_inputdatetime-like, str, int, float

Value to be converted to Timestamp.

yearint

Value of year.

monthint

Value of month.

dayint

Value of day.

hourint, optional, default 0

Value of hour.

minuteint, optional, default 0

Value of minute.

secondint, optional, default 0

Value of second.

microsecondint, optional, default 0

Value of microsecond.

tzinfodatetime.tzinfo, optional, default None

Timezone info.

nanosecondint, optional, default 0

Value of nanosecond.

tzstr, zoneinfo.ZoneInfo, pytz.timezone, dateutil.tz.tzfile or None

Time zone for time which Timestamp will have.

unitstr

Unit used for conversion if ts_input is of type int or float. The valid values are ‘W’, ‘D’, ‘h’, ‘m’, ‘s’, ‘ms’, ‘us’, and ‘ns’. For example, ‘s’ means seconds and ‘ms’ means milliseconds.

For float inputs, the result will be stored in nanoseconds, and the unit attribute will be set as 'ns'.

fold{0, 1}, default None, keyword-only

Due to daylight saving time, one wall clock time can occur twice when shifting from summer to winter time; fold describes whether the datetime-like corresponds to the first (0) or the second time (1) the wall clock hits the ambiguous time.

See also

Timedelta

Represents a duration, the difference between two dates or times.

datetime.datetime

Python datetime.datetime object.

Notes

There are essentially three calling conventions for the constructor. The primary form accepts four parameters. They can be passed by position or keyword.

The other two forms mimic the parameters from datetime.datetime. They can be passed by either position or keyword, but not both mixed together.

Examples

Using the primary calling convention:

This converts a datetime-like string

>>> pd.Timestamp('2017-01-01T12')
Timestamp('2017-01-01 12:00:00')

This converts a float representing a Unix epoch in units of seconds

>>> pd.Timestamp(1513393355.5, unit='s')
Timestamp('2017-12-16 03:02:35.500000')

This converts an int representing a Unix-epoch in units of weeks

>>> pd.Timestamp(1535, unit='W')
Timestamp('1999-06-03 00:00:00')

This converts an int representing a Unix-epoch in units of seconds and for a particular timezone

>>> pd.Timestamp(1513393355, unit='s', tz='US/Pacific')
Timestamp('2017-12-15 19:02:35-0800', tz='US/Pacific')

Using the other two forms that mimic the API for datetime.datetime:

>>> pd.Timestamp(2017, 1, 1, 12)
Timestamp('2017-01-01 12:00:00')
>>> pd.Timestamp(year=2017, month=1, day=1, hour=12)
Timestamp('2017-01-01 12:00:00')

Attributes

asm8

Return numpy datetime64 format with same precision.

day

day_of_week

Return day of the week.

day_of_year

Return the day of the year.

dayofweek

Return day of the week.

dayofyear

Return the day of the year.

days_in_month

Return the number of days in the month.

daysinmonth

Return the number of days in the month.

fold

hour

is_leap_year

Return True if year is a leap year.

is_month_end

Check if the date is the last day of the month.

is_month_start

Check if the date is the first day of the month.

is_quarter_end

Check if date is last day of the quarter.

is_quarter_start

Check if the date is the first day of the quarter.

is_year_end

Return True if date is last day of the year.

is_year_start

Return True if date is first day of the year.

max

microsecond

min

minute

month

nanosecond

quarter

Return the quarter of the year.

resolution

second

tz

Alias for tzinfo.

tzinfo

unit

The abbreviation associated with self._creso.

value

week

Return the week number of the year.

weekofyear

Return the week number of the year.

year

Methods

as_unit(unit[, round_ok])

Convert the underlying int64 representaton to the given unit.

astimezone(tz)

Convert timezone-aware Timestamp to another time zone.

ceil(freq[, ambiguous, nonexistent])

Return a new Timestamp ceiled to this resolution.

combine(date, time)

Combine date, time into datetime with same date and time fields.

ctime()

Return ctime() style string.

date()

Return date object with same year, month and day.

day_name([locale])

Return the day name of the Timestamp with specified locale.

dst()

Return the daylight saving time (DST) adjustment.

floor(freq[, ambiguous, nonexistent])

Return a new Timestamp floored to this resolution.

fromisocalendar

int, int, int -> Construct a date from the ISO year, week number and weekday.

fromisoformat

string -> datetime from datetime.isoformat() output

fromordinal(ordinal[, tz])

Construct a timestamp from a a proleptic Gregorian ordinal.

fromtimestamp(ts)

Transform timestamp[, tz] to tz's local time from POSIX timestamp.

isocalendar()

Return a named tuple containing ISO year, week number, and weekday.

isoformat([sep, timespec])

Return the time formatted according to ISO 8601.

isoweekday()

Return the day of the week represented by the date.

month_name([locale])

Return the month name of the Timestamp with specified locale.

normalize()

Normalize Timestamp to midnight, preserving tz information.

now([tz])

Return new Timestamp object representing current time local to tz.

replace([year, month, day, hour, minute, ...])

Implements datetime.replace, handles nanoseconds.

round(freq[, ambiguous, nonexistent])

Round the Timestamp to the specified resolution.

strftime(format)

Return a formatted string of the Timestamp.

strptime(string, format)

Function is not implemented.

time()

Return time object with same time but with tzinfo=None.

timestamp()

Return POSIX timestamp as float.

timetuple()

Return time tuple, compatible with time.localtime().

timetz()

Return time object with same time and tzinfo.

to_datetime64()

Return a numpy.datetime64 object with same precision.

to_julian_date()

Convert TimeStamp to a Julian Date.

to_numpy([dtype, copy])

Convert the Timestamp to a NumPy datetime64.

to_period([freq])

Return an period of which this timestamp is an observation.

to_pydatetime([warn])

Convert a Timestamp object to a native Python datetime object.

today([tz])

Return the current time in the local timezone.

toordinal()

Return proleptic Gregorian ordinal.

tz_convert(tz)

Convert timezone-aware Timestamp to another time zone.

tz_localize(tz[, ambiguous, nonexistent])

Localize the Timestamp to a timezone.

tzname()

Return time zone name.

utcfromtimestamp(ts)

Construct a timezone-aware UTC datetime from a POSIX timestamp.

utcnow()

Return a new Timestamp representing UTC day and time.

utcoffset()

Return utc offset.

utctimetuple()

Return UTC time tuple, compatible with time.localtime().

weekday()

Return the day of the week represented by the date.