Python Forum
Does the order of columns in the DataFrame matter?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Does the order of columns in the DataFrame matter?
#11
Thanks. I tried
A_new = A.reindex(['Ohio', 'Colorado'], axis=1, level=1)
but it returned:

IndexError: Too many levels: Index has only 1 level, not 2
Reply
#12
Can't completely reproduce the problem. Below is working example:

import pandas as pd
import numpy as np
df = pd.DataFrame({'key1': ['Ohio', 'Ohio', 'Ohio', 'Nevada', 'Nevada'], 
                            'key2': [2000, 2001, 2002, 2001, 2002], 
                           'data': np.arange(5.)})  

gg = df.set_index(['key1', 'key2']).unstack('key1')
Output:
data key1 Nevada Ohio key2 2000 NaN 0.0 2001 3.0 1.0 2002 4.0 2.0
gg.reindex([['data', 'data'],['Ohio', 'Nevada']], axis='columns')
Output:
data key1 Ohio Nevada key2 2000 0.0 NaN 2001 1.0 3.0 2002 2.0 4.0
This works for pandas v. 1.0.1. Behavior can depend on Pandas version.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to add columns to polars dataframe sayyedkamran 1 1,689 Nov-03-2023, 03:01 PM
Last Post: gulshan212
  concat 3 columns of dataframe to one column flash77 2 778 Oct-03-2023, 09:29 PM
Last Post: flash77
  Convert several columns to int in dataframe Krayna 2 2,364 May-21-2021, 08:55 AM
Last Post: Krayna
  Outputs "NaN" after "DataFrame columns" function? epsilon 7 3,573 Jan-27-2021, 10:59 AM
Last Post: epsilon
  Adapting a dataframe to the some of columns flyway 2 2,034 Aug-12-2020, 07:21 AM
Last Post: flyway
  Difference of two columns in Pandas dataframe zinho 2 3,317 Jun-17-2020, 03:36 PM
Last Post: zinho
  DataFrame: To print a column value which is not null out of 5 columns mani 2 2,080 Mar-18-2020, 06:07 AM
Last Post: mani
Question Dividing a single column of dataframe into multiple columns based on char length darpInd 2 2,418 Mar-14-2020, 09:19 AM
Last Post: scidam
  Interate for loop over certain columns in dataframe Finpyth 2 1,921 Mar-06-2020, 08:34 AM
Last Post: Finpyth
  How to highlight dataframe columns SriRajesh 1 1,828 Feb-28-2020, 11:02 PM
Last Post: Marbelous

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020