Excel VLOOKUP equivalent in pandas

by

I think you need map by column A:

df['C'] = df.B.map(df.A)
print (df)
              A          B      C
Index                            
2001-06-30  100 2001-08-31  300.0
2001-07-31  200 2001-09-30  400.0
2001-08-31  300 2001-10-31    NaN
2001-09-30  400 2001-11-30    NaN

It is same as:

df['C'] = df.B.map(df.A.to_dict())
print (df)
              A          B      C
Index                            
2001-06-30  100 2001-08-31  300.0
2001-07-31  200 2001-09-30  400.0
2001-08-31  300 2001-10-31    NaN
2001-09-30  400 2001-11-30    NaN

More Related Contents:

  1. how many countries have organised more than one edition of olympic games? using python pandas [closed]
  2. How to sort a dataFrame in python pandas by two or more columns?
  3. Converting between datetime, Timestamp and datetime64
  4. What are the ‘levels’, ‘keys’, and names arguments for in Pandas’ concat function?
  5. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  6. Large, persistent DataFrame in pandas
  7. Pandas DENSE RANK
  8. Plot a horizontal line on a given plot
  9. Pandas “Can only compare identically-labeled DataFrame objects” error
  10. How to have clusters of stacked bars
  11. Pandas GroupBy and select rows with the minimum value in a specific column
  12. pandas concat generates nan values
  13. Constructing a co-occurrence matrix in python pandas
  14. Pandas Groupby and Sum Only One Column
  15. pandas xlsxwriter, format table header – not sheet header
  16. Pandas – Number of Months Between Two Dates
  17. “unstack” a pandas column containing lists into multiple rows [duplicate]
  18. Pandas Replace NaN with blank/empty string
  19. Python pandas Filtering out nan from a data selection of a column of strings
  20. pandas merging based on a timestamp which do not match exactly
  21. pandas fill missing dates in time series
  22. How to drop unique rows in a pandas dataframe?
  23. How to deal with NaN values when plotting a boxplot
  24. Pandas How to filter a Series
  25. List of Tuples to DataFrame Conversion [duplicate]
  26. Pivot table subtotals in Pandas
  27. Convert percent string to float in pandas read_csv
  28. What is the equivalent of SQL “GROUP BY HAVING” on Pandas?
  29. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  30. How to GroupBy a Dataframe in Pandas and keep Columns

Leave a Comment