我正在嘗試與運動隊一起做一個資料專案，我想知道是否有一種方法可以將純文本變成一個小標題，并將資料分成城市和吉祥物。
tibble("City, Mascot,
Arizona Diamondbacks
Atlanta Braves
Baltimore Orioles
Boston Red Sox
Chicago White Sox
Chicago Cubs
Cincinnati Reds
Cleveland Indians
Colorado Rockies
Detroit Tigers
Houston Astros
Kansas City Royals
Los Angeles Angels
Los Angeles Dodgers
Miami Marlins
Milwaukee Brewers
Minnesota Twins
New York Yankees
New York Mets
Oakland Athletics
Philadelphia Phillies
Pittsburgh Pirates
San Diego Padres
San Francisco Giants
Seattle Mariners
St. Louis Cardinals
Tampa Bay Rays
Texas Rangers
Toronto Blue Jays
Washington Nationals
"
)
基本上能夠編輯代碼，這樣我就不必手動更改每個代碼，但如有必要，我可以進行小幅調整。我這樣做是為了我可以按城市將它與其他資料結合起來。
uj5u.com熱心網友回復：
一些正則運算式黑魔法
library(tidyverse)
example_data <- tibble::tribble(
~data,
"Arizona Diamondbacks",
"Atlanta Braves",
"Baltimore Orioles",
"Boston Red Sox",
"Chicago White Sox",
"Chicago Cubs",
"Cincinnati Reds",
"Cleveland Indians",
"Colorado Rockies",
"Detroit Tigers",
"Houston Astros",
"Kansas City Royals",
"Los Angeles Angels",
"Los Angeles Dodgers",
"Miami Marlins",
"Milwaukee Brewers",
"Minnesota Twins",
"New York Yankees",
"New York Mets",
"Oakland Athletics",
"Philadelphia Phillies",
"Pittsburgh Pirates",
"San Diego Padres",
"San Francisco Giants",
"Seattle Mariners",
"St. Louis Cardinals",
"Tampa Bay Rays",
"Texas Rangers",
"Toronto Blue Jays",
"Washington Nationals"
)
example_data |>
mutate(city = str_remove(data,'[[:alpha:]] $') |> str_trim(),
macot = str_extract(data,'[[:alpha:]] $'))
#> # A tibble: 30 x 3
#> data city macot
#> <chr> <chr> <chr>
#> 1 Arizona Diamondbacks Arizona Diamondbacks
#> 2 Atlanta Braves Atlanta Braves
#> 3 Baltimore Orioles Baltimore Orioles
#> 4 Boston Red Sox Boston Red Sox
#> 5 Chicago White Sox Chicago White Sox
#> 6 Chicago Cubs Chicago Cubs
#> 7 Cincinnati Reds Cincinnati Reds
#> 8 Cleveland Indians Cleveland Indians
#> 9 Colorado Rockies Colorado Rockies
#> 10 Detroit Tigers Detroit Tigers
#> # ... with 20 more rows
由reprex 包(v2.0.1)于 2021 年 10 月 18 日創建
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/324589.html
標籤：r
上一篇：如何創建滯后和領先列，按ID分組并按日期排列？[復制]
下一篇：頭部輸出包括行名而不是??行號