how to make a column as index in pandas code example

Example 1: 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 2: pandas create a column from index

df.reset_index(level=0, inplace=True)

Example 3: define a column as index pandas

myDataFrame.set_index('column_name')

Example 4: how to change index in dataframe python

index = [1,2]
df.index = index

Example 5: how to change indeces in pandas dataframe

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

Tags:

Misc Example