r - 在 R 数据框中，是否有类似于 SQL 中的函数 %LIKE% 的函数？

Question

在 R 数据框中，是否有类似于 SQL 中的函数 %LIKE% 的函数？

例如，在下面的数据框“md”中，如果包含“A”返回“A”，则我想根据现有列添加新列“类型”，否则为“其他”。我试过md$type <- ifelse(md$ori_character %like% 'A','A','Other')了，它不能工作。

任何人都可以帮忙吗？谢谢！

md <- data.frame(ori_character=c("USDFCHARGEBACKREFUNDQUANTITY","USGWCHARGEBACKREFUNDQUANTITY","USJTQUANTITY","CAJTADJUSTMENTQUANTITY","JPLDADJUSTMENTQUANTITY","JPXDREFUNDQUANTITY","DEHAORDERQUANTITY","DEHAREFUNDQUANTITY","ESGHADJUSTMENTQUANTITY","ESHAORDERQUANTITY","ESHAREFUNDQUANTITY","ESNIORDERQUANTITY","ESNIREFUNDQUANTITY","FRATADJUSTMENTQUANTITY","FRHAREFUNDQUANTITY","FRHAQUANTITY","FRHTADJUSTMENTQUANTITY","FRLJADJUSTMENTQUANTITY","ITATADJUSTMENTQUANTITY","ITHAREFUNDQUANTITY","ITLJREFUNDQUANTITY","ITLJORDERQUANTITY","ITMEORDERQUANTITY","ITMEREFUNDQUANTITY","UKFUKADJUSTMENTQUANTITY","UKHMZORDERQUANTITY","UKHMZQUANTITY","UKHMZREFUNDQUANTITY","UKHUKADJUSTMENTQUANTITY","NLHKADJUSTMENTQUANTITY","SETZADJUSTMENTQUANTITY","JPXDREFUNDPRODUCTSALES","DEHAORDERPRODUCTSALES","DEHAREFUNDPRODUCTSALES","ESHAORDERPRODUCTSALES","ESHAREFUNDPRODUCTSALES","ESNIORDERPRODUCTSALES","ESNIREFUNDPRODUCTSALES","FRHAREFUNDPRODUCTSALES","ITHAREFUNDPRODUCTSALES","ITLJREFUNDPRODUCTSALES","ITLJORDERPRODUCTSALES","ITMEORDERPRODUCTSALES","ITMEREFUNDPRODUCTSALES","UKHMZORDERPRODUCTSALES","UKHMZREFUNDPRODUCTSALES","USKNREFUNDSHIPPINGCREDITS","USLDREFUNDSHIPPINGCREDITS","JPLDREFUNDSHIPPINGCREDITS","DEHAORDERSHIPPINGCREDITS","DEHTREFUNDSHIPPINGCREDITS","ESHAORDERSHIPPINGCREDITS","ESHAREFUNDSHIPPINGCREDITS","ESNIORDERSHIPPINGCREDITS","FRHAREFUNDSHIPPINGCREDITS","FRMEREFUNDSHIPPINGCREDITS","FRNIREFUNDSHIPPINGCREDITS","ITHAREFUNDSHIPPINGCREDITS","ITMEORDERSHIPPINGCREDITS","ITMEREFUNDSHIPPINGCREDITS","UKFUKREFUNDSHIPPINGCREDITS","UKHMZORDERSHIPPINGCREDITS","ESHAORDERGIFTWRAPCREDITS","FRHAORDERGIFTWRAPCREDITS","FRLJREFUNDGIFTWRAPCREDITS","FRMEREFUNDGIFTWRAPCREDITS","FRNIORDERGIFTWRAPCREDITS","FRNIREFUNDGIFTWRAPCREDITS","ITHAORDERGIFTWRAPCREDITS","UKHUKORDERGIFTWRAPCREDITS","JPLDREFUNDCOSTOFPOINTS","JPXDREFUNDCOSTOFPOINTS","ESATORDERRETROCHARGEMARKETPLACEFACILITATORTAX","ESATREFUNDRETROCHARGEMARKETPLACEFACILITATORTAX","FRNIORDERMARKETPLACEFACILITATORTAX","ITLJREFUNDMARKETPLACEFACILITATORTAX","ITLJORDERMARKETPLACEFACILITATORTAX","UKHMZORDERMARKETPLACEFACILITATORTAX","UKHUKREFUNDMARKETPLACEFACILITATORTAX","JPXDREFUNDPROMOTIONALREBATES","DEHAORDERPROMOTIONALREBATES","DEHTREFUNDPROMOTIONALREBATES","ESHAORDERPROMOTIONALREBATES","ESHAREFUNDPROMOTIONALREBATES","ESNIORDERPROMOTIONALREBATES","ESNIREFUNDPROMOTIONALREBATES","FRHAREFUNDPROMOTIONALREBATES","FRNIREFUNDPROMOTIONALREBATES","ITHAREFUNDPROMOTIONALREBATES","ITMEORDERPROMOTIONALREBATES","UKHMZORDERPROMOTIONALREBATES","UKHMZREFUNDPROMOTIONALREBATES","JPXDREFUNDSALESTAXCOLLECTED","FRNIORDERSALESTAXCOLLECTED","ITHAORDERSALESTAXCOLLECTED","ITHAREFUNDSALESTAXCOLLECTED","ITLJREFUNDSALESTAXCOLLECTED","ITLJORDERSALESTAXCOLLECTED","UKHMZORDERSALESTAXCOLLECTED","UKHMZREFUNDSALESTAXCOLLECTED","JPXDREFUNDSELLINGFEES","DEHAORDERSELLINGFEES","DEHAREFUNDSELLINGFEES","ESHAORDERSELLINGFEES","ESHAREFUNDSELLINGFEES","ESNIORDERSELLINGFEES","ESNIREFUNDSELLINGFEES","FRHAREFUNDSELLINGFEES","ITHAREFUNDSELLINGFEES","ITLJREFUNDSELLINGFEES","ITLJORDERSELLINGFEES","ITMEORDERSELLINGFEES","ITMEREFUNDSELLINGFEES","UKHMZORDERSELLINGFEES","UKHMZREFUNDSELLINGFEES","USLDREFUNDFBAFEES","CAJTREFUNDFBAFEES","JPLDREFUNDFBAFEES","DEHAORDERFBAFEES","ESHAORDERFBAFEES","ESHAREFUNDFBAFEES","ESNIORDERFBAFEES","FRHAREFUNDFBAFEES","FRLJREFUNDFBAFEES","FRMEREFUNDFBAFEES","FRNIREFUNDFBAFEES","ITLJFBACUSTOMERRETURNFEEFBAFEES","ITLJORDERFBAFEES","ITMEORDERFBAFEES","ITMEREFUNDFBAFEES","UKFUKREFUNDFBAFEES","UKHMZORDERFBAFEES","JPLDLIGHTNINGDEALFEEOTHERTRANSACTIONFEES"))
md$type <- ifelse(md$ori_character %like% 'A','A','Other')

标签： rdataframe