pandas left join and update existing column

by

You can use merge() between left and right with how='left' on 'a' column.

In [74]: final = left.merge(right, on='a', how='left')

In [75]: final
Out[75]:
   a  b  c_x  c_y   d
0  1  4    9    7  13
1  2  5   10    8  14
2  3  6   11    9  15
3  4  7   12  NaN NaN

Replace NaN value from c_y with c_x value

In [76]: final['c'] = final['c_y'].fillna(final['c_x'])

In [77]: final
Out[77]:
   a  b  c_x  c_y   d   c
0  1  4    9    7  13   7
1  2  5   10    8  14   8
2  3  6   11    9  15   9
3  4  7   12  NaN NaN  12

Drop unwanted columns, and you have the result

In [79]: final.drop(['c_x', 'c_y'], axis=1)
Out[79]:
   a  b   d   c
0  1  4  13   7
1  2  5  14   8
2  3  6  15   9
3  4  7 NaN  12

More Related Contents:

  1. error when applying function to a series object
  2. How to group dataframe rows into list in pandas groupby
  3. Groupby value counts on the dataframe pandas
  4. Creating dataframe from a dictionary where entries have different lengths
  5. Pandas: Chained assignments [duplicate]
  6. Apply pandas function to column to create multiple new columns?
  7. Reading an Excel file in python using pandas
  8. How to delete rows from a pandas DataFrame based on a conditional expression [duplicate]
  9. Convert pandas DataFrame to a nested dict
  10. Random row selection in Pandas dataframe
  11. converting currency with $ to numbers in Python pandas
  12. groupby weighted average and sum in pandas dataframe
  13. Lookup Values by Corresponding Column Header in Pandas 1.2.0 or newer
  14. How to spread a column in a Pandas data frame
  15. Python Pandas: Boolean indexing on multiple columns [duplicate]
  16. Python Pandas write to sql with NaN values
  17. How to merge pandas on string contains?
  18. Pandas style function to highlight specific columns
  19. Python pandas convert datetime to timestamp effectively through dt accessor
  20. Locate first and last non NaN values in a Pandas DataFrame
  21. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  22. Time Series Analysis – unevenly spaced measures – pandas + statsmodels
  23. Move column by name to front of table in pandas
  24. matplotlib savefig() size control
  25. Is there a way to speed up handling large CSVs and dataframes in python?
  26. Add numpy array as column to Pandas data frame
  27. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  28. Why is NaN considered as a float?
  29. Pandas Rolling Computations on Sliding Windows (Unevenly spaced)
  30. DataFrame object has no attribute append

Leave a Comment