w3resource

Pandas: Datetime and is interchangeable with it in most cases


2. Timestamp-Based Date Creation

Write a Pandas program to create
a) a specific date using timestamp.
b) date and time using timestamp.
c) a time adds in the current local date using timestamp.
d) current date and time using timestamp.

Sample Solution:

Python Code :

import pandas as pd
#from datetime import datetime
print("\nA specific date using timestamp:")
print(pd.Timestamp('2016-11-10'))
print("\nDate and time using timestamp:")
print(pd.Timestamp('2012-05-03 11:30'))
print("\nA time adds in the current local date using timestamp:")
print(pd.Timestamp('11:30'))
print("\nCurrent date and time using timestamp:")
print(pd.Timestamp("now"))

Sample Output:

A specific date using timestamp:
2016-11-10 00:00:00

Date and time using timestamp:
2012-05-03 11:30:00

A time adds in the current local date using timestamp:
2020-08-17 11:30:00

Current date and time using timestamp:
2020-08-17 10:49:29.945939         

For more Practice: Solve these Related Problems:

  • Write a Pandas program to create a Timestamp from a given Unix epoch integer and verify its nanosecond precision.
  • Write a Pandas program to generate a Timestamp from a float value and then localize it to 'Europe/London'.
  • Write a Pandas program to create a future Timestamp by adding a specific timedelta to a base Timestamp.
  • Write a Pandas program to convert a string timestamp into a Timestamp object and reformat it into a custom date string.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to create the datetime, day, and time objects.
Next: Write a Pandas program to create a date from a given year, month, day and another date from a given string formats.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.