pivot drop Nan Values in pandas

Question

Having a pivot as below:

I was trying to drop the NaN values:

matrix = matrix.drop(index=None, columns=None)

Its not working.

ValueError: Need to specify at least one of 'labels', 'index' or 'columns'

Is there any other way to do this? Expected output:

if you dont provide labels,index or column name how it can drop? use `dropna` instead of `drop` — Mehmaam, Oct 21 '22 at 08:37

tturbo · Answer 1 · 2022-10-21T08:43:24.683

0

drop is for dropping entire rows or columns (independed of their values). Use dropna to delete rows or columns where values are NAN

edited Oct 21 '22 at 08:43

answered Oct 21 '22 at 08:35

tturbo

I need to drop entire row and column – Nikita Menon Oct 21 '22 at 08:38
Then specify the row or colum as your error message says – tturbo Oct 21 '22 at 08:39
..or use dropna as i suggested if you want to drop rows or columns automatically if they are nan – tturbo Oct 21 '22 at 08:40
1

check dupe for solution – jezrael Oct 21 '22 at 08:43

1 Answers1