set column as index pandas code example

Example 1: rename column pandas

>>> df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
>>> df.rename(columns={"A": "a", "B": "c"})
   a  c
0  1  4
1  2  5
2  3  6

Example 2: pandas set a column as index

df = pd.DataFrame({'month': [1, 4, 7, 10],
                   'year': [2012, 2014, 2013, 2014],
                   'sale': [55, 40, 84, 31]})

df.set_index('month')

Example 3: set index to column pandas

df = df.set_index('col')
df['col'] = df.index

Example 4: change name of column pandas

#df.rename() will only return a new df with the new headers
#df = df.rename() will change the heders of the current dataframe 
df = df.rename(columns={"old_col1": "new_col1", "old_col2": "new_col2"})

Example 5: define a column as index pandas

myDataFrame.set_index('column_name')

Example 6: how to change indeces in pandas dataframe

>>> df.set_index('month')
       year  sale
month
1      2012    55
4      2014    40
7      2013    84
10     2014    31