CODEWITHSUNDEEP
pythonpandasnumpy
Shuman_tov
Shuman_tov

Reputation: 49

replace all floats in df with corresponding index name

I want to replace all values in my df that are float (excluding nans), with the name of the index of the corresponding row.

I have this:

index1                10.0                          190.6   
index2                17.9                          NaN   
index3                NaN                           8.0
index4                9.0                           70.0

I want to have this:

index1                index1                        index1                
index2                index2                        NaN   
index3                NaN                           index3                
index4                index4                        index4

Any ideas?

Upvotes: 1

Views: 49

Answers (2)

Gabino Antuña Ortiz
Gabino Antuña Ortiz

Reputation: 23

if you want to do it for all columns of your df:

for column in df.columns:

    df[column] = [e for e in df.index if df[column].notna]

If you want to do it for some columns, replace df.columns for a list with the columns you want to handle

Regards,

Upvotes: 0

Nuri Taş
Nuri Taş

Reputation: 3845

Technically, np.nan is also float. If you want to replace non-null values with the index values, you can use df.where:

output = df.where(df.isna(), df.index.tolist())

Output:

           1     2
0       
index1  index1  index1
index2  index2  NaN
index3  NaN index3
index4  index4  index4

Upvotes: 2

Related Questions