Can't get R to Read Excel File

General
1

Upload Data Set

Housedata <- read.csv(file.choose()) ## Read housing table
View(Housedata)
names(Housedata)

There is a bunch of data in the table, but I cannot see it.

image

2

I thought I would ask for help getting this data set loaded, if I can't get it loaded, I can't even start the problem.

3

What is returned by

summary(Housedata)
4

Actually, I changed the excel file to a csv, and it then worked!

R is so finicky!

image

And it worked!

Thank you for responding!

5

To directly read an Excel file you need to use a something like the read_excel() command frorm the Readxl package or possibly the *read.xls() command from the gdata package. There are others.

6

This topic was automatically closed 21 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.