Changing the column index name in pandas

Question

I want to change the column index name

here the column index name (To be more preceise, sequence name) is 'Data Field':-

To a new sequence name, may be Column1, but when I'm doing

df.index.name = 'Column1'

It's adding Column1 at the bottom of the previous column index name. Which I don't want

Does this answer your question? [Rename specific column(s) in pandas](https://stackoverflow.com/questions/19758364/rename-specific-columns-in-pandas) — Joe Ferndz, Mar 23 '21 at 15:50
@Pygirl thanx, but tried with df.columns = df.columns.rename("Column1", level=1), it's throwing an exception TypeError: rename() got an unexpected keyword argument 'level' — Rajdip Roy, Mar 23 '21 at 16:12
in df.columns, 'Data Field' doesn't come, it's actually the column index of the sequence, we can say — Rajdip Roy, Mar 23 '21 at 16:37

score 0 · Answer 1 · answered Mar 23 '21 at 15:48

0

You can give df.rename(columns={}) to replace a specific column name.

df.rename(columns={'old column name':'new column name'}, inplace=True)

In your specific case, looks like you want to rename Data Field. You can give:

df.rename(columns={'Data Field': 'Column1'},inplace=True)

answered Mar 23 '21 at 15:48

Joe Ferndz

Actually, it's not making any change, while giving df.rename(columns={'Data Field':'Column1'}, inplace=True) – Rajdip Roy Mar 23 '21 at 16:06
It's more like changing the name of the sequence, thus, whenever I'm accessing and modifying it as a column name, it's not changing anything – Rajdip Roy Mar 23 '21 at 16:09
can you please share what df.columns shows? – Joe Ferndz Mar 23 '21 at 20:02

score 0 · Answer 2 · answered Mar 23 '21 at 15:49

0

df.rename(columns={'Data Field': 'Column1'},inplace=True)

answered Mar 23 '21 at 15:49

berkayln

1

It's not the name of the column, we cannot access it with df.columns, it's more like the sequence name, which appears on the left most side of the columns – Rajdip Roy Mar 23 '21 at 16:47

Laurent · Answer 3 · 2021-03-23T16:56:01.257

0

df.columns = df.columns.rename("Column1", level=0)

edited Mar 23 '21 at 16:56

answered Mar 23 '21 at 15:51

Laurent

It's actually adds 'Column1' under the column index I want to change 'Data Field', not removing it. – Rajdip Roy Mar 23 '21 at 16:41
I updated my answer following your comment. – Laurent Mar 23 '21 at 16:56

3 Answers3