How to swap two DataFrame columns?

Question

In MATLAB, to swap the first and second columns of a table A, one would do this¹

A = A(:, [2 1 3:end]); 

Is there a similarly convenient way to do this if A were a pandas DataFrame instead?

_{¹ MATLAB uses 1-based indexing.}

Answer 1

pandas has reindex method that does it. You just need to give a list with the column names in the order you wish:

columns_titles = ["B","A"] df=df.reindex(columns=columns_titles) 

Cheers