上面这个是正确代码,将保存为csv格式的excel数据读入R,并将第一行作为列名(header = TRUE),设置分隔符为逗号(sep=","),以及每列的类型colClasses=c("integer","character","integer","character","integer","integer"))
下面问题是,如果我使用scan代替read.table,应该怎么写?
stu2=scan(file="E:/学习mysql+excel/学校数据/schoolData.csv",what=c("integer","character","integer","character","integer","integer"),sep=','),并不能得到正确结果