regarding controlling the setup of index column

Asked May 16 '22 at 05:38

Active May 16 '22 at 05:38

Viewed 5 times

I have a data frame, data_plot looks like the following,

After operating the data_plot as follows

data_plot['Time'] = pd.to_datetime(data_plot['Time'])
df = data_plot.resample('M', on='Time').sum()

I got df as follows, the Time column has become into index column.

I have to use df.reset_index(inplace=true) to ensure 'Time' column not index column. If I want to avoid the last step of reset_index, how to modify the step of df = data_plot.resample('M', on='Time').sum()

asked May 16 '22 at 05:38

user785099

5,323
10
44
62

1

Do you need `df = data_plot.resample('M', on='Time').sum().reset_index()` ? – jezrael May 16 '22 at 05:39
1

@jezrael, thanks for your quick response, that is what I need. I will just close my post. Thanks. – user785099 May 16 '22 at 05:41

regarding controlling the setup of index column

0 Answers0