set_index by the index of the column PYTHON

Question

can I use dataframe.set_index with the index of the column or it only works with the name of the column??

Example:

df4 = df.set_index(0).T instead of df4 = df.set_index('Parametres').T

thank you

df.set_index(df.iloc[:,0]) ?

Chris Adams
– Chris Adams

2020-03-10 13:11:40 +00:00
Commented Mar 10, 2020 at 13:11 — Chris Adams
– Chris Adams, Commented Mar 10, 2020 at 13:11
stackoverflow.com/questions/38542419/…

Naga kiran
– Naga kiran

2020-03-10 13:22:15 +00:00
Commented Mar 10, 2020 at 13:22 — Naga kiran
– Naga kiran, Commented Mar 10, 2020 at 13:22

jezrael · Accepted Answer · 2020-03-10 13:12:15Z

2

If want create new index by first column use indexing:

df = pd.DataFrame({
        'A':list('abcdef'),
         'B':[4,5,4,5,5,4],
         'C':[7,8,9,4,2,3],
})

print (df.columns[0])
A

df = df.set_index(df.columns[0])
print (df)
   B  C
A      
a  4  7
b  5  8
c  4  9
d  5  4
e  5  2
f  4  3

answered Mar 10, 2020 at 13:12

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

set_index by the index of the column PYTHON

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related