我目前正在嘗試使用此檔案：https ://vote.nyc/sites/default/files/pdf/election_results/2021/20211102General Election/00000200000Citywide Mayor Citywide EDLevel.csv
檔案的寫入方式具有在同一行中具有相應值的變數名稱，如
"AD","ED","County","EDAD 狀態","事件","黨/獨立機構","辦公室/職位名稱","區號","VoteFor","單位名稱", Tally","65","001","New York","IN-PLAY","General Election 2021 - 11/02/2021",,"Mayor","NYC",1,"Public Counter", 160 "AD","ED","County","EDAD 狀態","事件","黨/獨立機構","辦公室/職位名稱","區號","VoteFor","單位名稱", "Tally","65","001","紐約","IN-PLAY","2021 年大選 - 2021 年 11 月 2 日",,"市長","紐約市",1,"手動計數緊急情況",0
等等。
我們如何將其轉換為 R 中的普通資料幀格式？
uj5u.com熱心網友回復：
x <- read.csv("https://vote.nyc/sites/default/files/pdf/election_results/2021/20211102General Election/00000200000Citywide Mayor Citywide EDLevel.csv")%>%
select(-c(1:11))
colnames(x) <- c("AD","ED","County","EDAD Status","Event","Party/Independent Body","Office/Position Title","District Key","VoteFor","Unit Name","Tally")
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/409993.html
標籤：