Hello,
I've been using: tmp.df = read.xls(filename, stringsAsFactors = FALSE) to
read in my files. Even though I get the "There were 50 or more warnings" thing,
for the most part most of the data is read in correctly. However, there are a
few select rows where there are values but they are being read in as NA. I copy
and pasted those rows to their own individual xls file and when I tried to read
in that sheet, it worked fine. This makes me wonder if it has something to do
with the way that the cells are formatted, but I've checked the individual cell
formats and they are all indeed the same.
Another strange thing that happens is something like the following. Say you
have the following cash flows: NA NA NA NA 16000 0 0 0 0 0 0 900000 700000 0 0
0 0 0 0 0 -2000000. It won't read anything until the 700000 and after.
Finally, it actually looks like for ALL rows, the first few columns are
being read in as NA even though some of them have values (while others are read
in correctly as NA)
Any help would be great!
Thank you
THIS MESSAGE AND ANY ATTACHMENTS ARE CONFIDENTIAL, PROPRIETARY, AND MAY BE
PRIVILEGED. If this message was misdirected, BlackRock, Inc. and its
subsidiaries, ("BlackRock") does not waive any confidentiality or privilege.
If you are not the intended recipient, please notify us immediately and destroy
the message without disclosing its contents to anyone. Any distribution, use
or copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. The views and opinions expressed in this
e-mail message are the author's own and may not reflect the views and opinions
of BlackRock, unless the author is authorized by BlackRock to express such
views or opinions on its behalf. All email sent to or from this address is
subject to electronic storage and review by BlackRock. Although BlackRock
operates anti-virus programs, it does not accept responsibility for any damage
whatsoever caused by viruses being passed.
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
