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
– ansev, Commented Jan 14, 2020 at 9:27
you have to call the Styler.hide_index each time you want to hide your index — Shijith
– Shijith, Commented Jan 14, 2020 at 9:33
Does this answer your question? Pandas dataframe hide index functionality? — Joshua Voskamp
– Joshua Voskamp, Commented Jan 9, 2023 at 21:30

wjandrea · Accepted Answer · 2023-08-04 23:21:28Z

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 4, 2023 at 23:21

wjandrea

34k10 gold badges69 silver badges105 bronze badges

answered Jan 14, 2020 at 10:15

François B.

1,18610 silver badges21 bronze badges

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

2 Comments

Gel Over a year ago

this changes my index to 0, it does not completely gets ommited out of the result

wjandrea Over a year ago

@Gel As they said, "You can't remove it. You can only reset it"

wjandrea · Accepted Answer · 2023-08-04 23:23:29Z

-2

Try df.to_csv(filename, index=False)

– tbhaxor Jan 14, 2020 at 9:27

edited Aug 4, 2023 at 23:23

wjandrea

34k10 gold badges69 silver badges105 bronze badges

answered Jan 7, 2023 at 10:23

rpagrawal

172 silver badges4 bronze badges

1 Comment

Joshua Voskamp Over a year ago

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 stackoverflow.com/questions/21256013 (which has an accepted, correct, answer)

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related