Pandas Groupby Agg Function Does Not Reduce

by

I can’t really explain you why, but from my experience list in pandas.DataFrame don’t work all that well.

I usually use tuple instead.
That will work:

def MakeList(x):
    T = tuple(x)
    if len(T) > 1:
        return T
    else:
        return T[0]

DF_Agg = DFGrouped.agg({'s.m.v.' : MakeList})

     date line_code           s.m.v.
0  2013-04-02    401101   (7.76, 25.564)
1  2013-04-02    401102           25.564
2  2013-04-02    401103             9.55
3  2013-04-02    401104             4.87
4  2013-04-02    401105   (7.76, 25.564)
5  2013-04-02    401106  (5.282, 25.564)
6  2013-04-02    401107            5.282

More Related Contents:

  1. How to split a dataframe string column into two columns?
  2. Comparing two dataframes and getting the differences [duplicate]
  3. Pandas: How to easily share a sample dataframe using df.to_dict()?
  4. Pandas: Get Dummies
  5. Get the name of a pandas DataFrame
  6. Calculate weighted average using a pandas/dataframe
  7. Comparing previous row values in Pandas DataFrame
  8. What is the difference between join and merge in Pandas?
  9. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  10. How to read a .xlsx file using the pandas Library in iPython?
  11. Counting unique values in a column in pandas dataframe like in Qlik?
  12. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  13. Pandas SettingWithCopyWarning [duplicate]
  14. flattening nested Json in pandas data frame
  15. How to reorder indexed rows based on a list in Pandas data frame
  16. How can I count the number of consecutive TRUEs in a DataFrame?
  17. Why apply sometimes isn’t faster than for-loop in a Pandas dataframe?
  18. Max and Min date in pandas groupby
  19. Pandas data precision [duplicate]
  20. Pandas rolling apply using multiple columns
  21. pd.read_html() imports a list rather than a dataframe
  22. pandas bar plot combined with line plot shows the time axis beginning at 1970
  23. how to test if a variable is pd.NaT?
  24. How to change the plot order of the categorical x-axis
  25. Plotting histograms from grouped data in a pandas DataFrame
  26. making matplotlib scatter plots from dataframes in Python’s pandas
  27. Pandas pivot warning about repeated entries on index
  28. Convert a pandas groupby object to list of dataframes
  29. How does one insert statistical annotations (stars or p-values)
  30. What’s the alternative to pandas chain indexing?

Leave a Comment