remove pandas index name?

Asked Oct 04 '17 at 14:52

Active Oct 04 '17 at 14:59

Viewed 540 times

I want to get rid of column/column name from pandas dataframe that I get after using pivot. I am not sure

temp = {'NOL' : [2016,2016,2016,2017, 2017, 2017],
   'A1': ['M1','M2', 'M3','M1','M2', 'M3'],
   'Val':[100, 110, 130, 140, 150, 160]}
dd = pd.DataFrame(temp)
dd2 = dd.pivot(index = 'A1', columns = 'NOL', values='Val').reset_index()

dd2.columns give me Index(['A1', 2016, 2017], dtype='object', name='NOL')

Here I want to get rid of NOL index or column with NOL. I've tried options here. with dd2.index.name = None and del dd2.index.name but it does not work.

edited Oct 04 '17 at 14:59

cs95

379,657
97
704
746

asked Oct 04 '17 at 14:52

user1430763

1

Are you referring to the columns name attribute? if so then you want `dd2.columns.name = None` There is a dupe of this somewhere – EdChum Oct 04 '17 at 14:54
1

@cᴏʟᴅsᴘᴇᴇᴅ you are really good at finding dupes. : ) – Bharath M Shetty Oct 04 '17 at 15:00

remove pandas index name?

0 Answers0