pandas.Timestamp¶

class pandas.Timestamp¶

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.
freqstr, DateOffset: Offset which Timestamp will have.
tzstr, 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 ‘D’, ‘h’, ‘m’, ‘s’, ‘ms’, ‘us’, and ‘ns’. For example, ‘s’ means seconds and ‘ms’ means milliseconds.
year, month, dayint
hour, minute, second, microsecondint, optional, default 0
nanosecondint, optional, default 0: New in version 0.23.0.
tzinfodatetime.tzinfo, optional, default None

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 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 in nanoseconds.
`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.
`freqstr`	Return the total number of days in the month.
`is_leap_year`	Return True if year is a leap year.
`is_month_end`	Return True if date is last day of month.
`is_month_start`	Return True if date is first day of month.
`is_quarter_end`	Return True if date is last day of the quarter.
`is_quarter_start`	Return True if date is 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.
`quarter`	Return the quarter of the year.
`tz`	Alias for tzinfo.
`week`	Return the week number of the year.
`weekofyear`	Return the week number of the year.

day
fold
freq
hour
microsecond
minute
month
nanosecond
second
tzinfo
value
year

Methods

`astimezone`(self, tz)	Convert tz-aware Timestamp to another time zone.
`ceil`(self, freq[, ambiguous, nonexistent])	return a new Timestamp ceiled to this resolution.
`combine`(date, time)	date, time -> datetime with same date and time fields.
`ctime`()	Return ctime() style string.
`date`()	Return date object with same year, month and day.
`day_name`(self[, locale])	Return the day name of the Timestamp with specified locale.
`dst`()	Return self.tzinfo.dst(self).
`floor`(self, freq[, ambiguous, nonexistent])	return a new Timestamp floored to this resolution.
`fromisoformat`()	string -> datetime from datetime.isoformat() output
`fromordinal`(ordinal[, freq, tz])	Passed an ordinal, translate and convert to a ts.
`fromtimestamp`(ts)	timestamp[, tz] -> tz’s local time from POSIX timestamp.
`isocalendar`()	Return a 3-tuple containing ISO year, week number, and weekday.
`isoweekday`()	Return the day of the week represented by the date.
`month_name`(self[, locale])	Return the month name of the Timestamp with specified locale.
`normalize`(self)	Normalize Timestamp to midnight, preserving tz information.
`now`([tz])	Return new Timestamp object representing current time local to tz.
`replace`(self[, year, month, day, hour, …])	implements datetime.replace, handles nanoseconds.
`round`(self, freq[, ambiguous, nonexistent])	Round the Timestamp to the specified resolution.
`strftime`()	format -> strftime() style string.
`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 ‘ns’ precision.
`to_julian_date`(self)	Convert TimeStamp to a Julian Date.
`to_numpy`()	Convert the Timestamp to a NumPy datetime64.
`to_period`(self[, freq])	Return an period of which this timestamp is an observation.
`to_pydatetime`()	Convert a Timestamp object to a native Python datetime object.
`today`(cls[, tz])	Return the current time in the local timezone.
`toordinal`()	Return proleptic Gregorian ordinal.
`tz_convert`(self, tz)	Convert tz-aware Timestamp to another time zone.
`tz_localize`(self, tz[, ambiguous, nonexistent])	Convert naive Timestamp to local time zone, or remove timezone from tz-aware Timestamp.
`tzname`()	Return self.tzinfo.tzname(self).
`utcfromtimestamp`(ts)	Construct a naive UTC datetime from a POSIX timestamp.
`utcnow`()	Return a new Timestamp representing UTC day and time.
`utcoffset`()	Return self.tzinfo.utcoffset(self).
`utctimetuple`()	Return UTC time tuple, compatible with time.localtime().
`weekday`()	Return the day of the week represented by the date.

isoformat