how to change the column numbers of excel in panda

Asked Aug 18 '22 at 05:41

Active Aug 18 '22 at 06:54

Viewed 36 times

0

I have a record of n columns after some changes the last 3 columns should be on the first three columns how can I change them I know how to swap the columns: title[1],title[2]= title[2],title[1] But I want to change the order of entire column(with values) Foreg: Srno.|FullName|Phone.no|EmailId|City|State|Country|FirstName|MiddleName|Lastname

i want the out put to be

Srno.|FirstName|MiddleName|Lastname|Phone.no|EmailId|City|State|Country

edited Aug 18 '22 at 06:15

asked Aug 18 '22 at 05:41

vishakha abnave

17
3

Define your answer in a clear way. So community can help you. – Mehmaam Aug 18 '22 at 05:46
Do you just want to change the name or also the values? – Jacob Aug 18 '22 at 05:46

1 Answers1

0

You want to reorder the columns In Excel? If It so then you can refer this code.

df=df[["Srno.","FirstName","MiddleName","Lastname","Phone.no","EmailId","City","State","Country"]]

You can also refer How to change the order of DataFrame columns?

answered Aug 18 '22 at 06:54

Lokeshwar G

136
6