使用DayofWeek名称创建列

Question

我想在我的数据框中转换成这样的格式df'Start Date‘2013-12-02，我想创建一个列，它根据开始日期告诉我星期几的名称。

def with_weekday(dataframe, date_field):
    
    dataframe = dataframe.copy(deep=True)
    
    dataframe ['Weekday'] = day_name(dataframe['Start Date']) #help here
    
    return dataframe
   

#the 'Start Date' is the column with dates that I want to convert with this format2013-12-02

Answer 1

你可以这样做

df['day_name'] = pd.to_datetime(df['start_date']).dt.day_name()

Answer 2

对于日期名称，您可以编写一个简单的方法

def get_day_name(date):
    day_name= ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday','Sunday']
    day = datetime.datetime. strptime(date, '%d %m %Y'). weekday()
    return day_name[day]

df['day_name'] = df['start_date'].apply(lambda x: get_day_name(x))