Weekday name from a pandas dataframe Date object

python-3.x python-datetime
John Doe picture John Doe · Feb 21, 2020 · Viewed 7.2k times · Source

I would like to get the weekday name for all my date. I have a pandas df which has a Date column formatted to datetime64[ns]

i have tried the following

data['Date'].dt.weekday_name

and I get the response

data['Date'].dt.weekday_name
Traceback (most recent call last):

  File "<ipython-input-207-e57074c4e346>", line 1, in <module>
    data['Date'].dt.weekday_name

AttributeError: 'DatetimeProperties' object has no attribute 'weekday_name'

Please help

Answer

zipa picture zipa · Feb 21, 2020

Maybe you can use day_name:

df['Date'].dt.day_name()

Related questions

Converting datetime string to datetime in numpy (python)

I would like to convert ['17-10-2010 07:15:30', '13-05-2011 08:20:35', "15-01-2013 09:09:09"] into a Numpy datetime object. import numpy as np [np.datetime64(x) for x in ['17-10-2010 07:15:30', '13-05-2011 08:20:35', "15-01-2013 09:09:09"]] …

Read More
Adding years in python

If I want to add 100 years in my program, why is it showing the wrong date? import datetime stringDate= "January 10, 1920" dateObject= datetime.datetime.strptime(stringDate, "%B %d, %Y") endDate= dateObject+datetime.timedelta(days=100*365) print dateObject.date() print endDate.date()

Read More
get lastweek dates using python?

I am trying to get the date of the last week with python. if date is : 10 OCT 2014 means It should be print 10 OCT 2014, 09 OCT 2014, 08 OCT 2014, 07 OCT 2014, 06 OCT 2014, 05 OCT 2014, 04 OCT 2014 I tried: today = (10 OCT 2014) dates = [today + datetime.timedelta(days=i) for …

Read More