PYTHON

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')

set index to column pandas

# method A
df = df.set_index('col')
# method B
df['col'] = df.index

how to set index pandas

# assignment copy
df = df.set_index('month')

# or inplace
df.set_index('month', inplace=True)

#      year   sale  month            month  year   sale
#  0   2012   55    1                1      2012   55
#  1   2014   40    4       =>       4      2014   40
#  2   2013   84    7                7      2013   84
#  3   2014   31    10               10     2014   31

pandas df make set index column

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

df set index

df.set_index(['col1', 'col2'])

pd df set index

df.set_index('month')

Pandas Set index

>>> college_idx = college.set_index('instnm')>>> sats = college_idx[['satmtmid', 'satvrmid']].dropna()>>> sats.head()

set index pandas

Pandas dataframe set-index

set index pandas

Pandas dataframe set-index()

set index pandas

Pandas dataframe set-index

set index pandas

Pandas dataframe set-index

set index pandas

Pandas dataframe set-index

pandas set index

>>> df.index = [x for x in range(1, len(df.values)+1)]
>>> df
             name                  job  score
1  'Pete Houston'  'Software Engineer'     92
2     'John Wick'           'Assassin'     95
3   'Bruce Wayne'             'Batman'     99
4    'Clark Kent'           'Superman'     96

set index pandas

Pandas dataframe set-index()

set index pandas

Pandas dataframe set-index()