Vectorized lookup on a pandas dataframe

by

Deprecation Notice: lookup was deprecated in v1.2.0

There’s a function aptly named lookup that does exactly this.

df2['looked_up'] = df1.lookup(df2.animal, df2.letter)

df2
 
    0   1   2   3   4 animal letter  looked_up
0   0   1   2   3   4    cat      a          0
1   5   6   7   8   9    dog      b          6
2  10  11  12  13  14   fish      c         12
3  15  16  17  18  19   bird      d         18

More Related Contents:

  1. Difference between map, applymap and apply methods in Pandas
  2. python pandas – creating a column which keeps a running count of consecutive values
  3. vectorize conditional assignment in pandas dataframe
  4. creating a column which keeps a running count of consecutive values
  5. How to identify and label similar rows in a pandas data frame
  6. Renaming column names in Pandas
  7. How can I use the apply() function for a single column?
  8. Pandas filtering for multiple substrings in series
  9. Filtering Pandas DataFrames on dates
  10. Python pandas insert list into a cell
  11. Pandas DataFrame Groupby two columns and get counts
  12. How can I map True/False to 1/0 in a Pandas DataFrame?
  13. Selection with .loc in python
  14. Pandas select rows and columns based on boolean condition
  15. How to flatten a hierarchical index in columns
  16. How can I subclass a Pandas DataFrame?
  17. How to create a dictionary of two pandas DataFrame columns
  18. AttributeError: ‘DataFrame’ object has no attribute ‘ix’
  19. Pandas dataframe – running sum with reset
  20. What is dtype(‘O’), in pandas?
  21. Writing large Pandas Dataframes to CSV file in chunks
  22. NumPy version of “Exponential weighted moving average”, equivalent to pandas.ewm().mean()
  23. Convert List to Pandas Dataframe Column
  24. How to merge a Series and DataFrame
  25. Pretty print a pandas dataframe in VS Code
  26. dataframe to dict such that one column is the key and the other is the value [duplicate]
  27. Transpose the data in a column every nth rows in PANDAS
  28. Remove ends of string entries in pandas DataFrame column
  29. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment