R: write.dbf()更改我的dataframe列名

Question

我有一个由循环foreach(.，.combine= rbind)生成的dataframe对象。命名其列后，由于使用.dbf函数，我将其保存在一个write.dbf文件中。但是，当我在LibreOffice Calc中打开匹配文件时，我的colunms的名称已经更改了，并且在它们后面附加了一些"，N,19,9"，"，N,5,0“或"，N,19,10”(等等)。

我正在使用Linux机器并使用RStudio。

  > c("ID","X","Y",unlist(LU_Named),paste(animalUsed,"_p",sep=""),"Alti_me20","Alti_ra20","Slope_me20","Slope_ra20")

  > print(names(datF_output))

  > write.dbf(datF_output, paste(Base2OutPath,"rANIMALS",sep = "/"), factor2char = FALSE, max_nchar = 254)

打印(NamesdatF_output)给出了正确的名称：

[1] "ID"           "X"            "Y"            "broad_AR"     "conif_AR"    
 [6] "arable_AR"    "imprg_AR"     "rough_AR"     "neutrg_AR"    "calcg_AR"    
[11] "acidg_AR"     "fen_AR"       "heath_AR"     "heathg_AR"    "bog_AR"      
[16] "monta_AR"     "inroc_AR"     "saltwat_AR"   "freshw_AR"    "slitro_AR"   
[21] "slitse_AR"    "litroc_AR"    "litsed_AR"    "saltma_AR"    "urban_AR"    
[26] "suburb_AR"    "Sheep_2003_p" "Alti_me20"    "Alti_ra20"    "Slope_me20"  
[31] "Slope_ra20" 

但我档案里的名字是：

ID,N,5,0    X,N,19,10   Y,N,19,9    broad_AR,N,19,9 conif_AR,N,19,9 arable_AR,N,19,9    imprg_AR,N,19,9 rough_AR,N,19,10    neutrg_AR,N,19,10   calcg_AR,N,19,9 acidg_AR,N,19,10    fen_AR,N,19,11  heath_AR,N,19,9 heathg_AR,N,19,11   bog_AR,N,19,9   monta_AR,N,19,10    inroc_AR,N,19,9 saltwat_AR,N,19,10  freshw_AR,N,19,9    slitro_AR,N,19,10   slitse_AR,N,19,10   litroc_AR,N,19,15   litsed_AR,N,19,11   saltma_AR,N,19,9    urban_AR,N,19,10    suburb_AR,N,19,11   Sheep_2003,N,19,13  Alti_me20,N,19,13   Alti_ra20,N,19,13   Slope_me20,N,19,14  Slope_ra20,N,19,14

Answer 1

write.dbf()更改数据栏的名称

不，没有；只是LibreOffice/OpenOffice以附加信息(字段类型、宽度和小数)的方式处理DBF文件。导入和导出dBASE文件 (…不要更改或删除导入文件中的第一行。此行包含dBASE数据库和连接dBase (xBase)所需的信息。附带注意: Excel不显示这些信息。