我想将数据帧拆分为两个数据帧,并且我有一个名为“产品类型”的列名。根据产品类型,我需要拆分主数据框并根据另一个列名“id”对其排序。id应该匹配
My data frame:
product, id, product_type
car1, FY-2, forecast
car1, FY-3, forecast
car1, FY-1, forecast
car3, FY-3, reference
car2, FY-1, reference
car4, FY-2, reference
Expected Result:
df1:
product, id, product_type
car1, FY-2, forecast
car1, FY-3, forecast
car1, FY-1, forecast
df2:
product, id, product_type
car3, FY-2, reference
car2, FY-3, reference
car4, FY-1, reference
two data frames are sorted based on the id split based on the product_type.
目前没有回答
相关问题 更多 >
编程相关推荐