Breaking News: Grepper is joining You.com. Read the official announcement!

pandas change diagonal

Add Answer

Busy Boar answered on June 3, 2020 Popularity 6/10 Helpfulness 1/10

answer pandas change diagonal

related How to replace both the diagonals of dataframe with 0 in pandas

related how to change the main diagonal in pandas

pandas change diagonal

Comment

In [21]: df.values[[np.arange(df.shape[0])]*2] = 0

In [22]: df
Out[22]: 
          0         1         2         3         4
0  0.000000  0.931374  0.604412  0.863842  0.280339
1  0.531528  0.000000  0.641094  0.204686  0.997020
2  0.137725  0.037867  0.000000  0.983432  0.458053
3  0.594542  0.943542  0.826738  0.000000  0.753240
4  0.357736  0.689262  0.014773  0.446046  0.000000

Popularity 6/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: diagonal pandas python

Link to this answer
Share Copy Link

Contributed on May 24 2021

Busy Boar

0 Answers Avg Quality 2/10

Closely Related Answers

How to replace both the diagonals of dataframe with 0 in pandas

Comment

import pandas as pd 
import numpy as np

df = pd.DataFrame(np.random.randint(1,100, 100).reshape(10, -1))

out = df.where(df.values != np.diag(df),0,df.where(df.values != np.flipud(df).diagonal(0),0,inplace=True))

Popularity 5/10 Helpfulness 6/10 Language python

Source: Grepper

Tags: dataframe python pandas replace

Link to this answer
Share Copy Link

Contributed on Jun 03 2020

regexp27

0 Answers Avg Quality 2/10

how to change the main diagonal in pandas

Comment

import numpy as np

s = pd.Series(data=[1,2,3],index=['a','b','c'])

df = pd.DataFrame(0, index=s.index, columns=s.index, dtype=s.dtype)

np.fill_diagonal(df.values, s)#you can also make s to be just a single float
print (df)
   a  b  c
a  1  0  0
b  0  2  0
c  0  0  3

Popularity 2/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: pandas python diagonal

Link to this answer
Share Copy Link

Contributed on Feb 21 2022

Eilay Koren

0 Answers Avg Quality 2/10

pandas change diagonal

Contents

More Related Answers

pandas change diagonal

Closely Related Answers

How to replace both the diagonals of dataframe with 0 in pandas

how to change the main diagonal in pandas

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.