Create a day-of-week column in a Pandas dataframe using Python

by

Pandas 0.23+

Use pandas.Series.dt.day_name(), since pandas.Timestamp.weekday_name has been deprecated:

import pandas as pd


df = pd.DataFrame({'my_dates':['2015-01-01','2015-01-02','2015-01-03'],'myvals':[1,2,3]})
df['my_dates'] = pd.to_datetime(df['my_dates'])

df['day_of_week'] = df['my_dates'].dt.day_name()

Output:

    my_dates  myvals day_of_week
0 2015-01-01       1    Thursday
1 2015-01-02       2      Friday
2 2015-01-03       3    Saturday

Pandas 0.18.1+

As user jezrael points out below, dt.weekday_name was added in version 0.18.1
Pandas Docs

import pandas as pd

df = pd.DataFrame({'my_dates':['2015-01-01','2015-01-02','2015-01-03'],'myvals':[1,2,3]})
df['my_dates'] = pd.to_datetime(df['my_dates'])
df['day_of_week'] = df['my_dates'].dt.weekday_name

Output:

    my_dates  myvals day_of_week
0 2015-01-01       1    Thursday
1 2015-01-02       2      Friday
2 2015-01-03       3    Saturday

Original Answer:

Use this:

http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.dt.dayofweek.html

See this:

Get weekday/day-of-week for Datetime column of DataFrame

If you want a string instead of an integer do something like this:

import pandas as pd

df = pd.DataFrame({'my_dates':['2015-01-01','2015-01-02','2015-01-03'],'myvals':[1,2,3]})
df['my_dates'] = pd.to_datetime(df['my_dates'])
df['day_of_week'] = df['my_dates'].dt.dayofweek

days = {0:'Mon',1:'Tues',2:'Weds',3:'Thurs',4:'Fri',5:'Sat',6:'Sun'}

df['day_of_week'] = df['day_of_week'].apply(lambda x: days[x])

Output:

    my_dates  myvals day_of_week
0 2015-01-01       1       Thurs
1 2015-01-02       2         Fri
2 2015-01-01       3       Thurs

More Related Contents:

  1. Converting between datetime, Timestamp and datetime64
  2. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  3. Convert Excel style date with pandas
  4. datetime dtypes in pandas read_csv
  5. pandas dataframe groupby datetime month
  6. How to convert columns into one datetime column in pandas?
  7. pandas out of bounds nanosecond timestamp after offset rollforward plus adding a month offset
  8. Find the end of the month of a Pandas DataFrame Series
  9. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  10. Converting between datetime and Pandas Timestamp objects
  11. Removing the timestamp from a datetime in pandas dataframe
  12. Subtract a year from a datetime column in pandas
  13. Convert a column of datetimes to epoch in Python
  14. Pandas: How to create a datetime object from Week and Year?
  15. How to define format when using pandas to_datetime?
  16. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  17. pandas bar plot combined with line plot shows the time axis beginning at 1970
  18. Specifying date format when converting with pandas.to_datetime
  19. how to test if a variable is pd.NaT?
  20. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  21. Datetime conversion – How to extract the inferred format?
  22. Python: Datetime to season
  23. filter pandas dataframe by time
  24. Convert a column of timestamps into periods in pandas
  25. Average time for datetime list
  26. Python: Adding hours to pandas timestamp
  27. how to specify the datetime format in read_csv
  28. How to combine year, month, and day columns to single datetime column?
  29. Pandas datetimes with different formats in the same column
  30. Python generating a list of dates between two dates

Leave a Comment