快捷導(dǎo)航

Python獲取時(shí)間的操作示例詳解

更新時(shí)間：2022年07月24日 14:29:28 作者：lxw-pro

這篇文章主要為大家詳細(xì)介紹了一些Python中獲取時(shí)間的操作，例如：獲取時(shí)間戳、獲取當(dāng)前時(shí)間、獲取昨天日期等，感興趣的可以參考一下

21讀取本地EXCEL數(shù)據(jù)
22查看df數(shù)據(jù)前5行
23將popularity列數(shù)據(jù)轉(zhuǎn)換為最大值與最小值的平均值
24將數(shù)據(jù)根據(jù)project進(jìn)行分組并計(jì)算平均分
25將test_time列具體時(shí)間拆分為兩部分（一半日期，一半時(shí)間）

獲得當(dāng)前時(shí)間時(shí)間戳

# 注意時(shí)區(qū)的設(shè)置
import time

# 獲得當(dāng)前時(shí)間時(shí)間戳
now = int(time.time())

# 轉(zhuǎn)換為其他日期格式，如："%Y-%m-%d %H:%M:%S"
timeArr = time.localtime(now)
other_StyleTime = time.strftime("%Y-%m-%d %H:%M:%S", timeArr)
print(other_StyleTime)

獲取當(dāng)前時(shí)間

import datetime

# 獲得當(dāng)前時(shí)間
now = datetime.datetime.now()

other_StyleTime = now.strftime("%Y-%m-%d %H:%M:%S")
print(other_StyleTime)

獲取昨天日期

import datetime


def getYesterday():
    today = datetime.date.today()
    oneday = datetime.timedelta(days=1)
    yesterday = today - oneday
    return yesterday


print("昨天的日期：", getYesterday())

生成日歷

# 引入日歷模塊
import calendar

# 輸入指定年月
yy = int(input("輸入年份："))
mm = int(input("輸入月份："))

# 顯示指定年月
print(calendar.month(yy, mm))

運(yùn)行效果如下：

計(jì)算每個(gè)月天數(shù)

import calendar

???????monthRange = calendar.monthrange(2022, 4)
print(monthRange)

計(jì)算3天前并轉(zhuǎn)換為指定格式

import time
import datetime

# 先獲得時(shí)間數(shù)組格式的日期
threeDayAgo = (datetime.datetime.now() - datetime.timedelta(days=3))
# 轉(zhuǎn)換為時(shí)間戳
timeStamp = int(time.mktime(threeDayAgo.timetuple()))

# 轉(zhuǎn)換為其他字符串格式
otherStyleTime = threeDayAgo.strftime("%Y-%m-%d %H:%M:%S")
print(otherStyleTime)

獲取時(shí)間戳的舊時(shí)間

import time
import datetime

# 給定時(shí)間戳
timeStamp1 = 1643892140
dateArray = datetime.datetime.utcfromtimestamp(timeStamp1)

threeDayAgo = dateArray - datetime.timedelta(days=3)
print(threeDayAgo)

獲取時(shí)間并指定格式

import time

timeStamp = 1825135462
timeArr = time.localtime(timeStamp)
other_StyleTime = time.strftime("%Y-%m-%d %H:%M:%S", timeArr)
print(other_StyleTime)

或

import datetime

timeStamp = 2022020321
dateArr = datetime.datetime.utcfromtimestamp(timeStamp)
other_StyleTime = dateArray.strftime("%Y-%m-%d %H:%M:%S")
print(other_StyleTime)

pandas 每日一練

print()只為換行用，方便看運(yùn)行結(jié)果

# -*- coding = utf-8 -*-
# @Time : 2022/7/22 19:46
# @Author : lxw_pro
# @File : pandas-5 練習(xí).py
# @Software : PyCharm

import pandas as pd

21讀取本地EXCEL數(shù)據(jù)

df = pd.read_excel('test-5.xlsx')
print("EXCEL數(shù)據(jù)如下：\n", df)

print()

22查看df數(shù)據(jù)前5行

print("df數(shù)據(jù)前5行為：\n", df.head())

print()

23將popularity列數(shù)據(jù)轉(zhuǎn)換為最大值與最小值的平均值

import re
def func(df):
    zfg = df['popularity'].split('-')
    smin = int(zfg[0].strip('f'))
    smax = int(zfg[1].strip('f'))
    df['popularity'] = int((smin+smax)/2)
    return df


df = df.apply(func, axis=1)
print(df)

print()

24將數(shù)據(jù)根據(jù)project進(jìn)行分組并計(jì)算平均分

fzj = df.groupby('project').mean()
print("分組后的平均分為:\n", fzj)

print()

25將test_time列具體時(shí)間拆分為兩部分（一半日期，一半時(shí)間）

df['date'] = df['test_time'].dt.date
df['time'] = df['test_time'].dt.time

print(df.head())

df.to_excel('text5.xlsx')	# 也可將所運(yùn)行的結(jié)果導(dǎo)入另一個(gè)新的EXCEL

相關(guān)程序運(yùn)行結(jié)果如下：

21-22：