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.