Pandas: drop columns with all NaN’s

by

From the dropna docstring:

Drop the columns where all elements are NaN:
df.dropna(axis=1, how='all')


   A    B    D
0  NaN  2.0  0
1  3.0  4.0  1
2  NaN  NaN  5

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Aggregation in Pandas
  3. Convert DataFrame column type from string to datetime
  4. How to apply a function to two columns of Pandas dataframe
  5. How to convert an XML file to nice pandas dataframe?
  6. Dynamically evaluate an expression from a formula in Pandas
  7. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  8. Can pandas automatically read dates from a CSV file?
  9. df.append() is not appending to the DataFrame
  10. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  11. pandas dataframe str.contains() AND operation
  12. Pandas groupby mean – into a dataframe?
  13. pandas groupby without turning grouped by column into index
  14. Tilde sign in pandas DataFrame
  15. Drop columns whose name contains a specific string from pandas DataFrame
  16. Find the unique values in a column and then sort them
  17. how do I calculate a rolling idxmax
  18. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  19. Redefining the Index in a Pandas DataFrame object
  20. From password-protected Excel file to pandas DataFrame
  21. How to filter a pandas dataframe based on the length of a entry
  22. How can repetitive rows of data be collected in a single row in pandas?
  23. Group dataframe and get sum AND count?
  24. How is pandas groupby method actually working?
  25. Replace value for a selected cell in pandas DataFrame without using index
  26. Anti-Join Pandas
  27. What values are valid in Pandas ‘Freq’ tags?
  28. How to convert DataFrame.append() to pandas.concat()?
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment