Solution for SpecificationError: nested renamer is not supported while agg() along with groupby()

change

temp['total'] = pd.DataFrame(project_data.groupby(col1)[col2].agg({'total':'count'})).reset_index()['total']

temp['Avg'] = pd.DataFrame(project_data.groupby(col1)[col2].agg({'Avg':'mean'})).reset_index()['Avg']

to

temp['total'] = pd.DataFrame(project_data.groupby(col1)[col2].agg(total='count')).reset_index()['total']
temp['Avg'] = pd.DataFrame(project_data.groupby(col1)[col2].agg(Avg='mean')).reset_index()['Avg']

reason: in new pandas version named aggregation is the recommended replacement for the deprecated “dict-of-dicts” approach to naming the output of column-specific aggregations (Deprecate groupby.agg() with a dictionary when renaming).

source: https://pandas.pydata.org/pandas-docs/stable/whatsnew/v0.25.0.html

Related Posts:

  1. Pandas group-by and sum
  2. Pandas group-by and sum
  3. how to sort pandas dataframe from one column
  4. Delete a column from a Pandas DataFrame
  5. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  6. How to iterate over rows in a DataFrame in Pandas
  7. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  8. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  9. Writing a pandas DataFrame to CSV file
  10. Modifing data while using iterrows() does not work
  11. What does `ValueError: cannot reindex from a duplicate axis` mean?
  12. Pandas DataFrame Groupby two columns and get counts
  13. How to show all columns’ names on a large pandas dataframe?
  14. ValueError: Unknown label type: ‘continuous’
  15. How to groupby based on two columns in pandas?
  16. How to deal with SettingWithCopyWarning in Pandas
  17. ImportError: No module named pandas
  18. TypeError: ‘Series’ objects are mutable, thus they cannot be hashed problemwith column
  19. Create a Pandas Dataframe by appending one row at a time
  20. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  21. Creating an empty Pandas DataFrame, then filling it?
  22. Python Pandas Counting the Occurrences of a Specific value
  23. Count unique values per groups with Pandas
  24. DataFrame constructor not properly called
  25. Convert pandas Series to DataFrame
  26. ImportError: Missing required dependencies [‘numpy’]
  27. How to iterate over rows in a DataFrame in Pandas
  28. Pandas “Can only compare identically-labeled DataFrame objects” error
  29. Pandas: ValueError: cannot convert float NaN to integer
  30. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  31. ‘DataFrame’ object has no attribute ‘sort’
  32. pandas: merge (join) two data frames on multiple columns
  33. Why do I get: “Length of values does not match length of index” error?
  34. why should I make a copy of a data frame in pandas
  35. Pandas, merging two dataframes on multiple columns, and multiplying result
  36. How to customize a scatter matrix to see all titles?
  37. What is dtype(‘O’), in pandas?
  38. How to read a .xlsx file using the pandas Library in iPython?
  39. Plot pie chart and table of pandas dataframe
  40. What is dtype(‘O’), in pandas?
  41. Pandas ‘count(distinct)’ equivalent
  42. Python TypeError: cannot convert the series to when trying to do math on dataframe
  43. ValueError: ‘object too deep for desired array’
  44. What does axis in pandas mean?
  45. How to take column-slices of dataframe in pandas
  46. Combine two columns of text in pandas dataframe
  47. Group by index + column in pandas
  48. Pandas: change data type of Series to String
  49. Normalize data in pandas
  50. Convert a Pandas DataFrame to a dictionary
  51. Selecting with complex criteria from pandas.DataFrame
  52. Create a Pandas Dataframe by appending one row at a time
  53. module ‘pandas’ has no attribute ‘rolling_mean’
  54. Modify the legend of pandas bar plot
  55. Count unique values using pandas groupby
  56. Ignoring NaNs with str.containsv
  57. Count unique values per groups with Pandas [duplicate]
  58. Map to List error: Series object not callable
  59. Pandas DataFrame: replace all values in a column, based on condition
  60. How to convert string to datetime format in pandas python?
  61. No numeric types to aggregate – change in groupby() behaviour?
  62. Pandas – How to flatten a hierarchical index in columns
  63. Pandas OR statement ending in series contains
  64. ValueError: Expected object or value when reading json as pandas dataframe
  65. How to check if a column exists in Pandas
  66. How to get a value from a cell of a dataframe?
  67. Pandas split DataFrame by column value
  68. How to get row number in dataframe in Pandas?
  69. AttributeError: ‘Series’ object has no attribute ‘reshape’
  70. Pandas – Drop function error (label not contained in axis)
  71. datetime to string with series in pandas
  72. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  73. Coalesce values from 2 columns into a single column in a pandas dataframe
  74. Unknown format code ‘f’ for object of type ‘str’- Folium
  75. How to add pandas data to an existing csv file?
  76. Find the unique values in a column and then sort them
  77. pandas groupby sort within groups
  78. Convert Pandas Column to DateTime
  79. if else function in pandas dataframe
  80. cannot convert the series to
  81. Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
  82. Read data (.dat file) with Pandas
  83. How to convert index of a pandas dataframe into a column
  84. pandas replace multiple values one column
  85. Boolean Series key will be reindexed to match DataFrame index
  86. Converting Pandas dataframe into Spark dataframe error
  87. Must have equal len keys and value when setting with an iterable
  88. Difference between data type ‘datetime64[ns]’ and ‘
  89. Merging two DataFrames
  90. pandas: multiple conditions while indexing data frame – unexpected behavior
  91. How to print a specific row of a pandas DataFrame?
  92. Logical operators for Boolean indexing in Pandas
  93. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  94. vectorize conditional assignment in pandas dataframe
  95. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  96. Convert list of dictionaries to a pandas DataFrame
  97. Python Pandas : pivot table with aggfunc = count unique distinct
  98. Compare two columns using pandas
  99. AttributeError: ‘Series’ object has no attribute ‘split’ error in sending emails
  100. alueError: ordinal must be >= 1

Leave a Comment

error code: 523