在Azure Data Factory中用聚合函数求和遇类型不匹配错误求助

我在ADLS中有一个包含约40列的CSV文件，希望通过Azure Data Factory实现如下Python代码的功能：

fastfoodchain_grouped = df.groupby(['Fast Food Chain','State','Month'])
sum_each = fastfoodchain_grouped['Sales'].agg(np.sum)

示例数据 #

Fast Food Chain,State,Month,Sales
Mc Donalds,New York,February,1000.05
KFC,Boston,January,200.10
KFC,Texas,March,-1050
Mc Donalds,Boston,March,20000
Burger King,New York,February,1500.20
Burger King,New York,March,2500
Burger King,Texas,January ,4000
Wendy's ,Boston,January,3000
Mc Donalds,New York,February,-50
Mc Donalds,Texas,January,1000

数据流截图 #

我尝试在数据流中使用聚合函数，执行sum(Sales)对Sales列求和时出现类型不匹配错误，恳请提供帮助。谢谢！

内容的提问来源于stack exchange，提问作者pandasandnumpy