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,767 Nov-03-2023, 03:01 PM
Last Post: gulshan212
  concat 3 columns of dataframe to one column flash77 2 841 Oct-03-2023, 09:29 PM
Last Post: flash77
  Convert several columns to int in dataframe Krayna 2 2,398 May-21-2021, 08:55 AM
Last Post: Krayna
  Outputs "NaN" after "DataFrame columns" function? epsilon 7 3,659 Jan-27-2021, 10:59 AM
Last Post: epsilon
  Adapting a dataframe to the some of columns flyway 2 2,049 Aug-12-2020, 07:21 AM
Last Post: flyway
  Difference of two columns in Pandas dataframe zinho 2 3,363 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,115 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,459 Mar-14-2020, 09:19 AM
Last Post: scidam
  Interate for loop over certain columns in dataframe Finpyth 2 1,956 Mar-06-2020, 08:34 AM
Last Post: Finpyth
  How to highlight dataframe columns SriRajesh 1 1,858 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