Is there anyway to remove index number in python when using pandas?

Question

This is just a simple code that can take out some dataframes by using input dates. It works right, but my issues has suddenly appeared once more.

import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
import datetime

plt.rc('font', family = 'Malgun Gothic')
df = pd.read_csv('seoul.csv', encoding = 'cp949', index_col=False)
df.style.hide_index()
del df['지점']

a = input("날짜 입력 yyyy-mm-dd: ")
b = input("날짜 입력 yyyy-mm-dd: ")

df['날짜'] = pd.to_datetime(df['날짜'])
mask = (df['날짜']>=a) & (df['날짜']<=b)
df.loc[mask]

And this is the result.

How can I remove these numbers?(the row that I point out with a red box)

oh edit: change index_col=0 is not work since some of rows are in a different level.

you can use `d.reset_index(drop=True)` to reset it, but you can't remove it, if you remove the index how you access ? — ansev, Jan 14 '20 at 09:27
you have to call the `Styler.hide_index` each time you want to hide your index — Shijith, Jan 14 '20 at 09:33
Does this answer your question? [Pandas dataframe hide index functionality?](https://stackoverflow.com/questions/21256013/pandas-dataframe-hide-index-functionality) — Joshua Voskamp, Jan 09 '23 at 21:30

score 1 · Answer 1 · edited Aug 04 '23 at 23:21

1

The index is the way the rows are identified. You can't remove it.
You can only reset it, if you make some selection and want to reindex your dataframe.

df = df.reset_index(drop=True)

If the argument drop were set to False, the indexes would come in an additional column named index.

edited Aug 04 '23 at 23:21

wjandrea

28,235
9
60
81

answered Jan 14 '20 at 10:15

François B.

1,096
7
19

1

this changes my index to 0, it does not completely gets ommited out of the result – Gel Aug 26 '22 at 13:20
@Gel As they said, *"You can't remove it. You can only reset it"* – wjandrea Aug 04 '23 at 23:21

score -2 · Answer 2 · edited Aug 04 '23 at 23:23

-2

Try df.to_csv(filename, index=False)

– tbhaxor Jan 14, 2020 at 9:27

edited Aug 04 '23 at 23:23

wjandrea

28,235
9
60
81

answered Jan 07 '23 at 10:23

rpagrawal

17
2
4

2

This is a copy-paste of a comment from another user on the question, which doesn't address the question. Incidentally, the question is a duplicate of https://stackoverflow.com/questions/21256013 (which has an accepted, correct, answer) – Joshua Voskamp Jan 09 '23 at 21:28

Is there anyway to remove index number in python when using pandas?

2 Answers2