将文本转换为表格,分隔符为#

概述我正在努力将我的文本文件转换为R中的表.问题是列用“#”分隔但是当我使用sep =“#”的read.table()函数时,它仍然看起来不像普通表并返回大量的错误. 我怎么能解决这个问题？ 文本文件如下所示： Hotel Van Walsum#121800#3#4.2#70#0.7 miles to City centre?#Bilderberg Parkhotel Rotterdam#12454 我正在努力将我的文本文件转换为R中的表.问题是列用“#”分隔但是当我使用sep =“#”的read.table()函数时,它仍然看起来不像普通表并返回大量的错误.

我怎么能解决这个问题？

文本文件如下所示：

Hotel Van Walsum#121800#3#4.2#70#0.7 miles to City centre?#Bilderberg Parkhotel Rotterdam#124547#4#3.7#83#0.5 miles to City centre?#NH Atlanta Rotterdam#208643#4#3.9#55#0.3 miles to City centre?#Nhow Rotterdam#439534#4#4.3#83#1.3 miles to City centre?#The Manhattan Hotel Rotterdam#173187#5#4.5#101#0.1 miles to City centre?#Mainport#427255#5#4.7#112#0.8 miles to City centre?#easyHotel Rotterdam City Centre#438095#2#3.8#49#0.5 miles to City centre?#ss Rotterdam Hotel & Restaurants#277518#4#4.3#84#1.8 miles to City centre?#H2otel#276462#3#4.1#67#0.7 miles to City centre?#Van der Valk Hotel Rotterdam-Blijdorp#272914#4#4.1#71#1.4 miles to City centre?#NH Capelle#139024#4#4.1#55#4.5 miles to City centre?#The Student Hotel Rotterdam#434163#3#4.2#62#1.3 miles to City centre?#NoVotel Rotterdam Brainpark#124868#4#4.4#69#2.4 miles to City centre?#Hotel Van Walsum#121800#3#4.2#70#0.7 miles to City centre?#Hampshire Hotel - Savoy Rotterdam#115253#4#3.7#65#0.8 miles to City centre?#Delta Hotel Rotterdam#179050#4#4.2#80#5.8 miles to City centre?#NoVotel Rotterdam SchIEdam#144828#4#4.3#69#4.2 miles to City centre?#Hotel Rotterdam#209923#4#3.7#74#0.4 miles to City centre?#

解决方法 我们需要在read.table中指定字段分隔符和注释字符：

read.table("myfile.txt",sep = "#",comment.char = "")

总结

以上是内存溢出为你收集整理的将文本转换为表格,分隔符为#全部内容，希望文章能够帮你解决将文本转换为表格,分隔符为#所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。