如何将NumPy datetime64转换为Timestamp
在这篇文章中,我们将讨论如何将NumPy datetime64转换成Timestamp。为了更好地理解,首先让我们看看下面的例子。
If the current datetime64 is as follows: 2020-08-18 09:31:51.944622
then,
the required timestamp in seconds will be: 1597743111.944622
the required timestamp in minutes will be: 26629051.8657437
the required timestamp in an hour will be: 443817.53109572834
方法:
- 通过np.datetime64()获取日期。
- 从默认的系统日期(1970-01-01T00:00:00Z)减去该日期。
- 在np.timedelta64()的帮助下将日期转换为秒、分和小时。
示例 1:
# importing required library
import numpy as np
from datetime import datetime
# extracting current date
# in utc format
date = datetime.utcnow()
print("Printing the Current date:",
date)
# converting the current date
# in datetime64 format
date64 = np.datetime64(date)
# converting date time into second timestamp
ts = (date64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 's')
print("Printing the converted datetime in Timestamp in seconds:",
ts)
# converting date time into minute timestamp
tm = (date64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'm')
print("Printing the converted datetime in Timestamp in minutes:",
ts)
# converting date time into hour timestamp
th = (date64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'h')
print("Printing the converted datetime in Timestamp in hour:",
th)
输出:
打印当前日期:2020-08-26 10:07:54.820878
以秒为单位,打印转换后的日期时间的Timestamp。1598436474.820878
打印转换后的日期时间,以分钟为单位的Timestamp。1598436474.820878
打印转换后的日期时间,以小时为单位的时间戳。444010.13189468835
示例2:将2020年8月15日以秒、分和小时的时间戳进行转换。
#importing required library
import numpy as np
from datetime import datetime
print("Printing the date:")
# extracting current date in utc format
dt64 = np.datetime64('2020-08-15');
print(dt64)
# converting date time into second timestamp
ts = (dt64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 's')
print("Printing the converted datetime in Timestamp in seconds:",
ts)
print("Printing the converted datetime in Timestamp in minutes")
# converting date time into minute timestamp
tm = (dt64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'm')
print(tm)
print("Printing the converted datetime in Timestamp in hour")
# converting date time into hour timestamp
th = (dt64 - np.datetime64('1970-01-01T00:00:00Z')) / np.timedelta64(1, 'h')
print(th)
输出:
Printing the date:
2020-08-15
Printing the converted datetime in Timestamp in seconds:
1597449600.0
Printing the converted datetime in Timestamp in minutes
26624160.0
Printing the converted datetime in Timestamp in hour
443736.0