I am trying to read this file from IMF, https://www.imf.org/~/media/Files/Publications/WEO/WEO-Database/2020/02/WEOOct2020all.ashx
the file extension is xls
read_excel("WEOOct2020all.xls")
read_delim("WEOOct2020all.xls", "\t")
it gives me error or NA
please advise.
It is a strange file. I got this error trying to open it as an .xls.
libxls error: Unable to open file
but it opens fine when I converted it to a .csv. It is half the size too.
it is IMF file (an international organization) , and I even contacted them to find out what is the problem. they are always giving us hard time.
the trick is to use skipNul parameter of read.delim
read.delim("strange.tsv",skipNul = TRUE) # %>% as_tibble()
1 Like
system
Closed
5
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.