Return multiple columns from pandas apply()

by

You can return a Series from the applied function that contains the new data, preventing the need to iterate three times. Passing axis=1 to the apply function applies the function sizes to each row of the dataframe, returning a series to add to a new dataframe. This series, s, contains the new values, as well as the original data.

def sizes(s):
    s['size_kb'] = locale.format("%.1f", s['size'] / 1024.0, grouping=True) + ' KB'
    s['size_mb'] = locale.format("%.1f", s['size'] / 1024.0 ** 2, grouping=True) + ' MB'
    s['size_gb'] = locale.format("%.1f", s['size'] / 1024.0 ** 3, grouping=True) + ' GB'
    return s

df_test = df_test.append(rows_list)
df_test = df_test.apply(sizes, axis=1)

More Related Contents:

  1. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  2. Why does df.apply(tuple) work but not df.apply(list)?
  3. Apply function to each cell in DataFrame
  4. pandas apply function that returns multiple values to rows in pandas dataframe
  5. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  6. How do I select rows from a DataFrame based on column values?
  7. Aggregation in Pandas
  8. Convert DataFrame column type from string to datetime
  9. How to convert an XML file to nice pandas dataframe?
  10. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  11. Can pandas automatically read dates from a CSV file?
  12. df.append() is not appending to the DataFrame
  13. pandas dataframe str.contains() AND operation
  14. Pandas groupby mean – into a dataframe?
  15. pandas groupby without turning grouped by column into index
  16. Tilde sign in pandas DataFrame
  17. Drop columns whose name contains a specific string from pandas DataFrame
  18. Find the unique values in a column and then sort them
  19. how do I calculate a rolling idxmax
  20. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  21. From password-protected Excel file to pandas DataFrame
  22. How to filter a pandas dataframe based on the length of a entry
  23. How can repetitive rows of data be collected in a single row in pandas?
  24. Row-wise average for a subset of columns with missing values
  25. Plot multiple columns of pandas DataFrame using Seaborn
  26. Dynamically filtering a pandas dataframe
  27. Anti-Join Pandas
  28. Python: How to drop a row whose particular column is empty/NaN?
  29. DataFrame object has no attribute append
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment