Pandas: fill in NaN values with dictionary references another column

by

You can map dict values inside fillna

df.B = df.B.fillna(df.A.map(dict))

print(df)

    A   B
0   a   2
1   b   5
2   c   4

More Related Contents:

  1. How to split data into 3 sets (train, validation and test)?
  2. Pandas bar plot changes date format
  3. Show DataFrame as table in iPython Notebook
  4. Export from pandas to_excel without row names (index)?
  5. How to create a table with clickable hyperlink in pandas & Jupyter Notebook
  6. Pandas – Find and index rows that match row sequence pattern
  7. Trouble installing Pandas on new MacBook Air M1
  8. (pandas) Create new column based on first element in groupby object
  9. Pandas, group by count and add count to original dataframe?
  10. using time zone in pandas to_datetime
  11. Python/Pandas: counting the number of missing/NaN in each row
  12. Kalman filter with varying timesteps
  13. pandas dataframe group and sort by weekday
  14. Merge two data frames based on common column values in Pandas
  15. Why does it take ages to install Pandas on Alpine Linux
  16. Pandas: convert date in month to the 1st day of next month
  17. Splitting multiple columns into rows in pandas dataframe
  18. Getting Colorbar instance of scatter plot in pandas/matplotlib
  19. All possible combinations of columns in dataframe -pandas/python
  20. Why are Pandas and GeoPandas able to read a database table using a DBAPI (psycopg2) connection but have to rely on SQLAlchemy to write one?
  21. Pandas & AWS Lambda
  22. Scrape tables into dataframe with BeautifulSoup
  23. How to remove illegal characters so a dataframe can write to Excel
  24. Plot pandas dataframe containing NaNs
  25. Turn pandas dataframe into a file-like object in memory?
  26. How can I left justify text in a pandas DataFrame column in an IPython notebook
  27. concise way of flattening multiindex columns
  28. use Featureunion in scikit-learn to combine two pandas columns for tfidf
  29. Convert dataframe with start and end date to daily data
  30. Grouped seaborn.barplot from a wide pandas.DataFrame

Leave a Comment