Python Pandas merge only certain columns

by

You want to use TWO brackets, so if you are doing a VLOOKUP sort of action:

df = pd.merge(df,df2[['Key_Column','Target_Column']],on='Key_Column', how='left')

This will give you everything in the original df + add that one corresponding column in df2 that you want to join.

More Related Contents:

  1. Pandas Merging 101
  2. cartesian product in pandas
  3. Performant cartesian product (CROSS JOIN) with pandas
  4. pandas three-way joining multiple dataframes on columns
  5. Python: pandas merge multiple dataframes
  6. Apply pandas function to column to create multiple new columns?
  7. Merge two dataframes by index
  8. Combine two pandas Data Frames (join on a common column)
  9. Difference(s) between merge() and concat() in pandas
  10. Pandas left outer join multiple dataframes on multiple columns
  11. Pandas Merge on Name and Closest Date
  12. merging 2 dataframes vertically [duplicate]
  13. How to do “(df1 & not df2)” dataframe merge in pandas?
  14. How to merge pandas on string contains?
  15. How to merge multiple dataframes
  16. “Anti-merge” in pandas (Python)
  17. how to merge two data frames based on particular column in pandas python?
  18. Improve Pandas Merge performance
  19. In Pandas, how to delete rows from a Data Frame based on another Data Frame?
  20. MemoryError when I merge two Pandas data frames
  21. how to concat two data frames with different column names in pandas? – python
  22. Anti-Join Pandas
  23. Check if rows in one dataframe exist in another dataframe
  24. Merging two tables with millions of rows in Python
  25. Restart cumsum and get index if cumsum more than value
  26. Replace all occurrences of a string in a pandas dataframe (Python)
  27. ValueError: numpy.dtype has the wrong size, try recompiling
  28. Python Pandas: Is Order Preserved When Using groupby() and agg()?
  29. pandas divide row value by aggregated sum with a condition set by other cell
  30. Split Python sequence (time series/array) into subsequences with overlap

Leave a Comment