我想了解以下内容:给定一个日期(datetime对象),一周中对应的日期是什么?
例如,星期天是第一天,星期一是第二天。。等等
然后如果输入的内容类似于今天的日期。
实例
>>> today = datetime.datetime(2017, 10, 20)
>>> today.get_weekday() # what I look for
产量可能是6(因为现在是星期五)
我想了解以下内容:给定一个日期(datetime对象),一周中对应的日期是什么?
例如,星期天是第一天,星期一是第二天。。等等
然后如果输入的内容类似于今天的日期。
实例
>>> today = datetime.datetime(2017, 10, 20)
>>> today.get_weekday() # what I look for
产量可能是6(因为现在是星期五)
当前回答
我们可以帮助熊猫:
import pandas as pd
如上所述,我们有:
datetime(2017, 10, 20)
如果在jupyter笔记本中执行这一行,我们将得到如下输出:
datetime.datetime(2017, 10, 20, 0, 0)
使用weekday()和weekday_name:
如果您希望工作日为整数格式,请使用:
pd.to_datetime(datetime(2017, 10, 20)).weekday()
输出将为:
4
如果你想把它作为一天的名字,比如星期天、星期一、星期五等,你可以使用:
pd.to_datetime(datetime(2017, 10, 20)).weekday_name
输出将为:
'星期五'
如果Pandas数据帧中有日期列,则:
现在假设您有一个panda数据帧,其日期列如下:pdExampleDataFrame['Dates'].head(5)
0 2010-04-01
1 2010-04-02
2 2010-04-03
3 2010-04-04
4 2010-04-05
Name: Dates, dtype: datetime64[ns]
现在,如果我们想知道工作日的名称,比如星期一、星期二。。等等,我们可以按如下方式使用.weekday_name:
pdExampleDataFrame.head(5)['Dates'].dt.weekday_name
输出将是:
0 Thursday
1 Friday
2 Saturday
3 Sunday
4 Monday
Name: Dates, dtype: object
如果我们希望从“日期”列中得到工作日的整数,那么我们可以使用:
pdExampleDataFrame.head(5)['Dates'].apply(lambda x: x.weekday())
输出将如下所示:
0 3
1 4
2 5
3 6
4 0
Name: Dates, dtype: int64
其他回答
如果您不完全依赖datetime模块,日历可能是更好的选择。例如,这将为您提供日期代码:
calendar.weekday(2017,12,22);
这将给你一天:
days = ["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
days[calendar.weekday(2017,12,22)]
或者以python的风格,作为一行:
["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"][calendar.weekday(2017,12,22)]
假设你得到了日期、月份和年份,你可以做到:
import datetime
DayL = ['Mon','Tues','Wednes','Thurs','Fri','Satur','Sun']
date = DayL[datetime.date(year,month,day).weekday()] + 'day'
#Set day, month, year to your value
#Now, date is set as an actual day, not a number from 0 to 6.
print(date)
import numpy as np
def date(df):
df['weekday'] = df['date'].dt.day_name()
conditions = [(df['weekday'] == 'Sunday'),
(df['weekday'] == 'Monday'),
(df['weekday'] == 'Tuesday'),
(df['weekday'] == 'Wednesday'),
(df['weekday'] == 'Thursday'),
(df['weekday'] == 'Friday'),
(df['weekday'] == 'Saturday')]
choices = [0, 1, 2, 3, 4, 5, 6]
df['week'] = np.select(conditions, choices)
return df
import datetime
import calendar
day, month, year = map(int, input().split())
my_date = datetime.date(year, month, day)
print(calendar.day_name[my_date.weekday()])
输出示例
08 05 2015
Friday
假设您有timeStamp:字符串变量YYYY-MM-DD HH:MM:SS
步骤1:使用blow代码将其转换为dateTime函数。。。
df['timeStamp'] = pd.to_datetime(df['timeStamp'])
步骤2:现在您可以提取所有必需的功能,如下所示,这将为每个字段创建新的列-小时、月、星期、年、日期
df['Hour'] = df['timeStamp'].apply(lambda time: time.hour)
df['Month'] = df['timeStamp'].apply(lambda time: time.month)
df['Day of Week'] = df['timeStamp'].apply(lambda time: time.dayofweek)
df['Year'] = df['timeStamp'].apply(lambda t: t.year)
df['Date'] = df['timeStamp'].apply(lambda t: t.day)