eschutho commented on code in PR #29898:
URL: https://github.com/apache/superset/pull/29898#discussion_r1769247070


##########
superset/charts/post_processing.py:
##########
@@ -151,6 +153,18 @@ def pivot_df(  # pylint: disable=too-many-locals, 
too-many-arguments, too-many-s
         # add subtotal for each group and overall total; we start from the
         # overall group, and iterate deeper into subgroups
         groups = df.columns
+        if not apply_metrics_on_rows:
+            for col in df.columns:
+                # we need to replace the temporary placeholder with either a 
string
+                # or np.nan, depending on the column type so that they can sum 
correctly
+                if pd.api.types.is_numeric_dtype(df[col]):
+                    df[col].replace("SUPERSET_PANDAS_NAN", np.nan, 
inplace=True)
+                else:
+                    df[col].replace("SUPERSET_PANDAS_NAN", "nan", inplace=True)
+        else:
+            # when we applied metrics on rows, we switched the columns and rows
+            # so checking column type doesn't apply. Replace everything with 
np.nan
+            df.replace("SUPERSET_PANDAS_NAN", np.nan, inplace=True)

Review Comment:
   @betodealmeida we need this section here when totaling so that we 1) can sum 
with numbers (by converting the string "SUPERSET_PANDAS_NAN" with np.nan or 2) 
can sum with a string value. I'm using "nan" so that we don't print 
"SUPERSET_PANDAS_NAN". 



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to