python增加工作日列,使用Python在Pandas数据框中创建一个星期列

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

I’d like to read a csv file into a pandas dataframe, parse a column of dates from string format to a date object, and then generate a new column that indicates the day of the week.

This is what I’m trying:

What I’d like to do is something like:

import pandas as pd

import csv

df = pd.read_csv('data.csv', parse_dates=['date']))

df['day-of-week'] = df['date'].weekday()

AttributeError: 'Series' object has no attribute 'weekday'

Thank you for your help.

James

解决方案

EDIT:

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:

See this:

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