Pandas lookup from one of multiple columns, based on value

by

There is a built in lookup function that can handle this type of situation (looks up by row/column). I don’t know how optimized it is, but may be faster than the apply solution.

In [9]: df['value'] = df.lookup(df.index, df['best'])

In [10]: df
Out[10]: 
   Date best   a  b   c   d  value
0  1990    a   5  4   7   2      5
1  1991    c  10  1   2   0      2
2  1992    d   2  1   4  12     12
3  1993    a   5  8  11   6      5

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Binning a column with Python Pandas
  3. Performant cartesian product (CROSS JOIN) with pandas
  4. String concatenation of two pandas columns
  5. Pandas read_csv low_memory and dtype options
  6. How can I split a column of tuples in a Pandas dataframe?
  7. replace() method not working on Pandas DataFrame
  8. Calculate average of every x rows in a table and create new table
  9. Find column name in pandas that matches an array
  10. Conditionally fill column values based on another columns value in pandas
  11. How to check if a value is in the list in selection from pandas data frame?
  12. Group duplicate column IDs in pandas dataframe
  13. Pandas finding local max and min
  14. Select multiple ranges of columns in Pandas DataFrame
  15. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  16. how do I calculate a rolling idxmax
  17. how to read certain columns from Excel using Pandas – Python
  18. which is faster for load: pickle or hdf5 in python
  19. vectorize conditional assignment in pandas dataframe
  20. Why is np.where faster than pd.apply
  21. How can I count the number of consecutive TRUEs in a DataFrame?
  22. Binning a column with pandas
  23. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  24. Unpivot Pandas Data
  25. Filling in date gaps in MultiIndex Pandas Dataframe
  26. Get first and second highest values in pandas columns
  27. Store numpy.array in cells of a Pandas.DataFrame
  28. Python pandas: how to remove nan and -inf values
  29. Filtering pandas dataframe with multiple Boolean columns
  30. What’s the best way to sum all values in a Pandas dataframe? [duplicate]

Leave a Comment