Drop rows with all zeros in pandas data frame

by

One-liner. No transpose needed:

df.loc[~(df==0).all(axis=1)]

And for those who like symmetry, this also works…

df.loc[(df!=0).any(axis=1)]

More Related Contents:

  1. Delete a column from a Pandas DataFrame
  2. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  3. What is the most efficient way to loop through dataframes with pandas?
  4. Pandas: Drop consecutive duplicates
  5. Split cell into multiple rows in pandas dataframe
  6. Handling Variable Number of Columns with Pandas – Python
  7. Pandas filling missing dates and values within group
  8. No module named ‘pandas._libs.tslibs.timedeltas’ in PyInstaller
  9. Use groupby in Pandas to count things in one column in comparison to another
  10. Reset color cycle in Matplotlib
  11. pandas unique values multiple columns
  12. Use index in pandas to plot data
  13. How to find which columns contain any NaN value in Pandas dataframe
  14. Python pandas: Keep selected column as DataFrame instead of Series
  15. Refresh Excel External Data with Python
  16. Pandas – dataframe groupby – how to get sum of multiple columns
  17. How to plot multiple dataframes to the same plot axes
  18. python pandas read_csv delimiter in column data
  19. Fixed effect in Pandas or Statsmodels
  20. Resample hourly TimeSeries with certain starting hour
  21. Pandas how to apply multiple functions to dataframe
  22. Select the max row per group – pandas performance issue
  23. Convert a Pandas DataFrame into a single row DataFrame
  24. How do I fill a column with one value in Pandas?
  25. Filtering pandas dataframe rows by contains str
  26. ValueError when using pandas.read_json
  27. Why does max() sometimes return nan and sometimes ignores it?
  28. How to fill the missing record of Pandas dataframe in pythonic way?
  29. Pandas analogue to SQL MINUS / EXCEPT operator, using multiple columns
  30. Pandas Groupby Agg Function Does Not Reduce

Leave a Comment