Python Pandas replace NaN in one column with value from corresponding row of second column

by

Assuming your DataFrame is in df:

df.Temp_Rating.fillna(df.Farheit, inplace=True)
del df['Farheit']
df.columns="File heat Observations".split()

First replace any NaN values with the corresponding value of df.Farheit. Delete the 'Farheit' column. Then rename the columns. Here’s the resulting DataFrame:

resulting DataFrame

More Related Contents:

  1. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  2. How to replace NaNs by preceding or next values in pandas DataFrame?
  3. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  4. Set value for particular cell in pandas DataFrame using index
  5. How to check if any value is NaN in a Pandas DataFrame
  6. pandas concat generates nan values
  7. How to find which columns contain any NaN value in Pandas dataframe
  8. Replace invalid values with None in Pandas DataFrame
  9. Left justify string values in a pandas DataFrame
  10. Shift NaNs to the end of their respective rows
  11. Pandas Replace NaN with blank/empty string
  12. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  13. How to drop column according to NAN percentage for dataframe?
  14. Remove NaN/NULL columns in a Pandas dataframe?
  15. Convert DataFrame column type from string to datetime
  16. How to convert an XML file to nice pandas dataframe?
  17. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  18. Can pandas automatically read dates from a CSV file?
  19. df.append() is not appending to the DataFrame
  20. pandas dataframe str.contains() AND operation
  21. Pandas groupby mean – into a dataframe?
  22. Pandas fill missing values in dataframe from another dataframe
  23. pandas groupby without turning grouped by column into index
  24. Find the unique values in a column and then sort them
  25. how do I calculate a rolling idxmax
  26. How to filter a pandas dataframe based on the length of a entry
  27. How is pandas groupby method actually working?
  28. Anti-Join Pandas
  29. Python: Adding hours to pandas timestamp
  30. Pandas: Join dataframe with condition

Leave a Comment