Remove rows with repeated index in multiindex dataframe

Question

I have the following dataframe with a double index. How could I delete those rows where the first index is equal to the second index?

First_index             Second_index          Column                          

PitchAngle              RotorSpeed         -0.163742
GenSpeed                PitchAngle         -0.163689
GearboxBearingTemp      PitchAngle         -0.063614                                              
GenSpeed                GenSpeed            0.325689
AmbientTemperature      AmbientTemperature  0.569469
WindDirection           WindDirection      -0.152658

Do you really mean remove the row or do you mean adapt the multi-index where first index is equal to second? — Ruthger Righart
– Ruthger Righart, Commented Dec 11, 2020 at 11:10
I mean removing the row, so I'm only interesed in getting those rows where first and second index are different — MustardRecord
– MustardRecord, Commented Dec 11, 2020 at 11:12

Ruthger Righart · Accepted Answer · 2020-12-11 11:13:57Z

1

Do the following:

Load modules

import io
import pandas as pd

Create the data

df = pd.read_csv(io.StringIO("""
First_index             Second_index          Column                          
PitchAngle              RotorSpeed         -0.163742
GenSpeed                PitchAngle         -0.163689
GearboxBearingTemp      PitchAngle         -0.063614                                              
GenSpeed                GenSpeed            0.325689
AmbientTemperature      AmbientTemperature  0.569469
WindDirection           WindDirection      -0.152658
"""), sep="\s\s+", engine="python")

Do not select the rows where first index is equal to second index

df[~(df.First_index == df.Second_index)]

answered Dec 11, 2020 at 11:13

Ruthger Righart

4,9692 gold badges32 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Remove rows with repeated index in multiindex dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related