r - How to convert .plt file to csv file and also attributes are missing? -
first converted .plt file .txt file imported in r.
but when try read text file, error:
`20081023025304` <- read.table("c:/users/admin/desktop/dataset/final_geolife trajectories 1.3/geolife trajectories 1.3/data/000/trajectory/20081023025304.plt", header=true, quote="\"") error in read.table("c:/users/admin/desktop/dataset/final_geolife trajectories 1.3/geolife trajectories 1.3/data/000/trajectory/20081023025304.plt", : more columns column names view(`20081023025304`) error in view : object '20081023025304' not found
i having 7 attributes in datasets getting 5 attributes , error. want full attributes can analyze process.
geolife trajectory wgs 84 altitude in feet reserved 3 0,2,255,my track,0,0,2,8421376 0 39.984702,116.318417,0,492,39744.1201851852,2008-10-23,02:53:04 39.984683,116.31845,0,492,39744.1202546296,2008-10-23,02:53:10 39.984686,116.318417,0,492,39744.1203125,2008-10-23,02:53:15 39.984688,116.318385,0,492,39744.1203703704,2008-10-23,02:53:20 39.984655,116.318263,0,492,39744.1204282407,2008-10-23,02:53:25 39.984611,116.318026,0,493,39744.1204861111,2008-10-23,02:53:30 39.984608,116.317761,0,493,39744.1205439815,2008-10-23,02:53:35 39.984563,116.317517,0,496,39744.1206018519,2008-10-23,02:53:40 39.984539,116.317294,0,500,39744.1206597222,2008-10-23,02:53:45 39.984606,116.317065,0,505,39744.1207175926,2008-10-23,02:53:50 39.984568,116.316911,0,510,39744.120775463,2008-10-23,02:53:55 39.984586,116.316716,0,515,39744.1208333333,2008-10-23,02:54:00
you need skip 7 lines before reading data. also, separator ,
. need like
read.table("file.plt", header = true, quote = "\"", skip = 7, sep = ",")
Comments
Post a Comment