如何使用 R 从列的每个单元格中删除重复的逗号分隔字符值 [英] How to remove duplicate comma separated character values from each cell of a column using R

问题描述

我有一个包含 2 列 ID 和 Product 的数据框，如下所示:

I have a data-frame with 2 columns ID and Product as below :

ID  Product
A   Clothing, Clothing Food, Furniture, Furniture
B   Food,Food,Food, Clothing
C   Food, Clothing, Clothing

我只需要为每个 ID 提供唯一的产品，例如:

I need to have only unique products for each ID, for example :

ID  Product
A   Clothing, Food, Furniture
B   Food, Clothing
C   Food, Clothing

我如何使用 R 来做到这一点

How do I do this using R

推荐答案

如果数据集中有多个分隔符，一种方法是使用所有分隔符拆分产品"列，获取 unique，然后将其 paste 在一起 (toString) 按ID"分组.这里我们使用 data.table 方法.

If there are multiple delimiters in the dataset, one way would be to split the 'Product' column using all the delimiters, get the unique and then paste it together (toString) grouped by 'ID'. Here we use data.table methods.

library(data.table)
setDT(df1)[, list(Product= toString(unique(strsplit(Product, 
            ',\s*|\s+')[[1]]))), by = ID]
#   ID                   Product
#1:  A Clothing, Food, Furniture
#2:  B            Food, Clothing
#3:  C            Food, Clothing

这篇关于如何使用 R 从列的每个单元格中删除重复的逗号分隔字符值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！