這個問題在這里已經有了答案： 如何修剪前導和尾隨空白？ (15 個回答) 3天前關閉。
我目前有一個腳本，它撰寫一個 Excel 檔案并從 R 發送一封電子郵件。我的回圈失敗，因為當創建 excel 路徑時，無論出于何種原因，都會有一個空間（見下文）。如何擺脫供應商名稱后的空格？如果有人可以提供 dplyr 解決方案，那就太好了。
舊：
Vendor_Name
<chr>
1 "INTERLINE BRANDS"
2 "GENERAC SO"
3 "SO DIMPLEX NORTH AMERIC"
4 "ZEPENFORCER"
5 "SO TORO "
6 "SO MTDARNOLD PRODUCTS "
7 "SO IMPERIAL INDUSTRIAL "
8 "SO QUICKIE "
9 "SO RUBBERMAID SPECIALTY"
10 "TIGER SUPPLIES "
理想：
Vendor_Name
<chr>
1 "INTERLINE BRANDS"
2 "GENERAC SO"
3 "SO DIMPLEX NORTH AMERIC"
4 "ZEPENFORCER"
5 "SO TORO"
6 "SO MTDARNOLD PRODUCTS"
7 "SO IMPERIAL INDUSTRIAL"
8 "SO QUICKIE"
9 "SO RUBBERMAID SPECIALTY"
10 "TIGER SUPPLIES"
uj5u.com熱心網友回復：
使用trimws：
trimws(x$Vendor_Name)
# [1] "INTERLINE BRANDS" "GENERAC SO" "SO DIMPLEX NORTH AMERIC" "ZEPENFORCER"
# [5] "SO TORO" "SO MTDARNOLD PRODUCTS" "SO IMPERIAL INDUSTRIAL" "SO QUICKIE"
# [9] "SO RUBBERMAID SPECIALTY" "TIGER SUPPLIES"
library(dplyt)
x %>%
mutate(Vendor_Name = trimws(Vendor_Name))
# Vendor_Name
# 1 INTERLINE BRANDS
# 2 GENERAC SO
# 3 SO DIMPLEX NORTH AMERIC
# 4 ZEPENFORCER
# 5 SO TORO
# 6 SO MTDARNOLD PRODUCTS
# 7 SO IMPERIAL INDUSTRIAL
# 8 SO QUICKIE
# 9 SO RUBBERMAID SPECIALTY
# 10 TIGER SUPPLIES
資料
x <- structure(list(Vendor_Name = c("INTERLINE BRANDS", "GENERAC SO", "SO DIMPLEX NORTH AMERIC", "ZEPENFORCER", "SO TORO ", "SO MTDARNOLD PRODUCTS ", "SO IMPERIAL INDUSTRIAL ", "SO QUICKIE ", "SO RUBBERMAID SPECIALTY", "TIGER SUPPLIES ")), class = "data.frame", row.names = c(NA, -10L))
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/418894.html
標籤：
上一篇：pandas.Series.str.cat()不適用于pandas系列的最后一個元素
下一篇：提取引號內的物件型別