当我尝试在实体集之间创建关系(使用我自己的数据)时遇到了问题。没有错误,但它只是没有为我的实体之一(“prods”实体)创建功能,尽管一切都应该连接得很好。我不能分享我的数据,但我用一些模拟数据创建了一个最小的例子:import pandas as pdimport featuretools as ft创建模拟数据cust = pd.DataFrame([[1,50],[2,60]], columns=['CUST_ID','AGE'])#orders = pd.DataFrame([[1,1,50,33.0],[2,1,60,20],[3,2,66,999.9]], columns=['ORD_ID','CUST_ID','QTY','PRICE'])order_items = pd.DataFrame([[1,1,1,2,3.0],[2,2,2,8,5.0],[3,2,1,2,3.0],[4,3,3,2,3.0]], columns=['ORD_ITM_ID','ORD_ID','PROD_ID','QTY','PRICE'])prods = pd.DataFrame([[1,3.0],[2,5.0],[3,3.0]], columns=['PROD_ID','PRICE'])定义实体集es = ft.EntitySet('test')## Adding Customers Entityes.entity_from_dataframe(dataframe=cust, entity_id='cust', index='CUST_ID')## Adding Orders Entityes.entity_from_dataframe(dataframe=orders, entity_id='orders', index='ORD_ID')## Adding Order Items Entityes.entity_from_dataframe(dataframe=order_items, entity_id='order_items', index='ORD_ITM_ID')## Adding Products Entityes.entity_from_dataframe(dataframe=prods, entity_id='prods', index='PROD_ID')建立关系customer_relationship = ft.Relationship(es["cust"]["CUST_ID"], es["orders"]["CUST_ID"])orderitems_relationship = ft.Relationship(es["orders"]["ORD_ID"], es["order_items"]["ORD_ID"])products_relationship = ft.Relationship(es["prods"]["PROD_ID"], es["order_items"]["PROD_ID"])### Add Relationshipses = es.add_relationship(customer_relationship)es = es.add_relationship(orderitems_relationship)es = es.add_relationship(products_relationship)这也应该向我展示产品变量的功能,但事实并非如此。所以我所期望的是 SUM 会将每个客户的产品价格相加。相反,什么都没有。
添加回答
举报
0/150
提交
取消