Pandas dataframe fillna() only some columns in place

by

You can select your desired columns and do it by assignment:

df[['a', 'b']] = df[['a','b']].fillna(value=0)

The resulting output is as expected:

     a    b    c
0  1.0  4.0  NaN
1  2.0  5.0  NaN
2  3.0  0.0  7.0
3  0.0  6.0  8.0

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Aggregation in Pandas
  3. Compare two DataFrames and output their differences side-by-side
  4. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  5. Can pandas automatically read dates from a CSV file?
  6. Selecting a row of pandas series/dataframe by integer index
  7. How do I find the closest values in a Pandas series to an input number?
  8. How do I count the NaN values in a column in pandas DataFrame?
  9. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  10. Get column index from column name in python pandas
  11. Replace invalid values with None in Pandas DataFrame
  12. How to filter a dataframe of dates by a particular month/day?
  13. How to show all columns’ names on a large pandas dataframe?
  14. Count number of words per row
  15. Shift column in pandas dataframe up by one?
  16. pandas DataFrame output end of csv
  17. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  18. Pandas compare next row
  19. Appending a list or series to a pandas DataFrame as a row?
  20. Convert Pandas Series to DateTime in a DataFrame
  21. Loading multiple csv files of a folder into one dataframe
  22. Why is np.where faster than pd.apply
  23. Extract column value based on another column in Pandas
  24. Python Pandas: Get index of rows where column matches certain value
  25. Change the color of text within a pandas dataframe html table python using styles and css
  26. Row-wise average for a subset of columns with missing values
  27. Plot multiple columns of pandas DataFrame using Seaborn
  28. Dynamically filtering a pandas dataframe
  29. Remove substring from column based on another column
  30. How to get number of groups in a groupby object in pandas?

Leave a Comment