Using DataFrame Index Dates for Date Column Creation

Question

I am trying to reduce the code bloat in my project for the process of creating various date columns (weekday, business day, day index, week index) and I was wondering how I can take the index of my dataframe and build datetime attribute columns from the index.

I thought I could access the .index or index.values and then reference the datetime attributes like month, weekday, etc., but it doesn't appear that Index has those attributes. Would I need to convert the index values to a new list and then build the columns off of that?

Here is my code:

historicals = pd.read_csv("2018-2019_sessions.csv", index_col="date", na_values=0)
type(historicals)

// date formate = 2018-01-01, 2018-01-02, etc.

# Additional Date Fields
date_col = historicals.index
date_col.weekday

// AttributeError: 'Index' object has no attribute 'weekday'

Andy L. · Accepted Answer · 2019-12-05 21:40:51Z

1

Your index is in string format. You historicals.index probably looks like this

print(historicals.index)

Index(['2018-01-01', '2018-01-02'], dtype='object')

You need to convert it to datetimeindex and get its weekday attribute and assign to new column

historicals['weekday'] = pd.to_datetime(historicals.index).weekday

Or

date_col = pd.to_datetime(historicals.index)
print(date_col.weekday)

answered Dec 5, 2019 at 21:40

Andy L.

25.3k4 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

cphill Over a year ago

That was exactly it. The index was actually in date format, but same issue. Only way to resolve it was to convert to datetime. Thank you!

Collectives™ on Stack Overflow

Using DataFrame Index Dates for Date Column Creation

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related