Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]

by

Seems you forgot the '' of your string.

In [43]: df['Value'] = df.apply(lambda row: my_test(row['a'], row['c']), axis=1)

In [44]: df
Out[44]:
                    a    b         c     Value
          0 -1.674308  foo  0.343801  0.044698
          1 -2.163236  bar -2.046438 -0.116798
          2 -0.199115  foo -0.458050 -0.199115
          3  0.918646  bar -0.007185 -0.001006
          4  1.336830  foo  0.534292  0.268245
          5  0.976844  bar -0.773630 -0.570417

BTW, in my opinion, following way is more elegant:

In [53]: def my_test2(row):
....:     return row['a'] % row['c']
....:     

In [54]: df['Value'] = df.apply(my_test2, axis=1)

More Related Contents:

  1. How to display pandas DataFrame of floats using a format string for columns?
  2. How do I create test and train samples from one dataframe with pandas?
  3. How to map numeric data into categories / bins in Pandas dataframe
  4. Why does df.apply(tuple) work but not df.apply(list)?
  5. Apply function to each cell in DataFrame
  6. Return multiple columns from pandas apply()
  7. pandas apply function that returns multiple values to rows in pandas dataframe
  8. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  9. Group DataFrame in 5-minute intervals
  10. Why does the following code cant get value of n_fold = 1?
  11. Filter dataframe rows if value in column is in a set list of values [duplicate]
  12. Add missing dates to pandas dataframe
  13. Converting a Pandas GroupBy output from Series to DataFrame
  14. Pandas: sum DataFrame rows for given columns
  15. Replacing blank values (white space) with NaN in pandas
  16. Is there a way in Pandas to use previous row value in dataframe.apply when previous value is also calculated in the apply?
  17. How can I split a column of tuples in a Pandas dataframe?
  18. Insert a row to pandas dataframe
  19. Convert unix time to readable date in pandas dataframe
  20. How to count the NaN values in a column in pandas DataFrame
  21. pandas dataframe columns scaling with sklearn
  22. Python Pandas update a dataframe value from another dataframe
  23. Mapping columns from one dataframe to another to create a new column [duplicate]
  24. Action with pandas SettingWithCopyWarning
  25. python dataframe pandas drop column using int
  26. How to plot two columns of a pandas data frame using points
  27. which is faster for load: pickle or hdf5 in python
  28. Python Pandas – Merge based on substring in string
  29. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  30. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it

Leave a Comment