Skip to content
Advertisement

Pandas sort column values with “0” values at end of column

I have a dataframe which looks like this

JavaScript

I would like to have “0” values at the end when sorting so my resulting dataframe looks like this.

JavaScript

Is there a simple (1 line of code) solution?

Advertisement

Answer

First mask the zeros then use argsort on column A to get the indices that would sort the dataframe:

JavaScript

JavaScript
User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement