Can I access to DataFrame index and use it when calculating something in python?

Question

I'm reading the data I'm working on and making it organized with the following codes.

import pandas as pd
df = pd.read_csv("data.csv").assign(date=lambda x: pd.to_datetime(x['date']))
.groupby([pd.Grouper(key='date', freq='M'), pd.Grouper(key='item_id')]).count().reset_index()
.pivot('date', 'item_id').fillna(0).astype(int)

This way I can see the indexes and their values.

What should I do if I want to operate using the values in the indexes? How can I access them?

Talha Tayyab · Accepted Answer · 2022-12-26T13:30:43.200

0

You can treat your index as a normal column:

df['new_column'] = df.index

Or

df = df.reset_index(drop=False)

edited Dec 26 '22 at 13:30

answered Dec 26 '22 at 13:26

Talha Tayyab

8,111
25
27
44

Wouldn't you want to set `drop=False` to insert the index into the dataframe? – Plagon Dec 26 '22 at 13:29
Yes, you are right! – Talha Tayyab Dec 26 '22 at 13:30

Can I access to DataFrame index and use it when calculating something in python?

1 Answers1