Changing Values in multiindex pandas dataframe

Question

I have loaded a multiindex matrix from excel to a panda dataframe.

    df=pd.read_excel("filename.xlsx",sheet_name=sheet,header=1,index_col=[0,1,2],usecols="B:AZ")

The dataframe has three index colums and one header, so it has 4 indices. Part of the dataframe looks like this:

picture of part of dataframe

When I want to show a particular value, it works like this:

df[index1][index2][index3][index4]

I now want to change certain values in the dataframe. After searching through different forums for a while, it seemed like df.at would be the right method to do this. So I tried this:

df.at[index1,index2,index3,index4]=10 (or any random value)

but I got a ValueError: Not enough indexers for scalar access (setting)!. I also tried different orders for the indices inside the df.at-Brackets.

Any help on this would be much appreciated!

Vlad · Accepted Answer · 2019-12-08 15:08:18Z

0

It seems you need something like that:

df.loc[('Kosten','LKW','Sofia'),'Ruse']=10

edited Dec 8, 2019 at 15:08

answered Dec 8, 2019 at 15:01

Vlad

6092 gold badges5 silver badges16 bronze badges

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

2 Comments

Niklas Gauly Over a year ago

That is exactly what I needed, thank you very much!

Vlad Over a year ago

always glad to help!

Collectives™ on Stack Overflow

Changing Values in multiindex pandas dataframe

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related