rattle on Windows

[Marcin Szewczyk]

Hello,

I have just installed rattle. I’ve tried to load data from Excel 2010 but I have received following error:

require(xlsx, quietly=TRUE)

crs$dataset <- read.xlsx("/C:/Europainting/rozne/typy_dokumentów_enova.xlsx", sheetIndex=1)

crs$dataset. 

The error message was:

Error in loadWorkbook(file) : 

  Cannot find /C:/Europainting/rozne/typy_dokumentów_enova.xlsx

I’m running rattle on Windows 8, 64 bit version. The file can not be find due to '/' sign at the beginning of the path – for Windows system there should be no '/' at the beginning of path to file. When I replicate crs$dataset <- read.xlsx in console and delete '/' sign from the path function runs without problem.

When I run rattle I receive communicate that object 'crs was shadowed/overridden by _by_ ‘.GlobalEnv’'

Above translation may not be 100% correct as I receive communicates in polish language.

Please help me find solution to the problem.

Output of rattleInfor():

Rattle: version 3.0.2 r169 cran 3.0.2

R: version 3.0.2 (2013-09-25) (Revision 63987)

Sysname: Windows

Release: 7 x64

Version: build 9200

Nodename: PC

Machine: x86-64

Login: hp

User: hp

Effective_user: hp

Installed Dependencies

RGtk2: version 2.20.25

pmml: version 1.4.1

bitops: version 1.0-6

colorspace: version 1.2-4

ada: version 2.0-3

amap: version 0.8-7

arules: version 1.1-1 upgrade available 1.1-2

arulesViz: version 0.1-8

biclust: version 1.0.2

cairoDevice: version 2.19

cba: version 0.2-14

corrplot: version 0.73

descr: version 1.0.2

doBy: version 4.5-10

e1071: version 1.6-1 upgrade available 1.6-2

ellipse: version 0.3-8

fBasics: version 3010.86

foreign: version 0.8-55 upgrade available 0.8-59

fpc: version 2.1-7

gdata: version 2.13.2

ggdendro: version 0.1-14

ggplot2: version 0.9.3.1

gplots: version 2.12.1

gtools: version 3.3.0

gWidgetsRGtk2: version 0.0-82

hmeasure: version 1.0

Hmisc: version 3.13-0 upgrade available 3.14-0

kernlab: version 0.9-19

latticist: version 0.9-44

Matrix: version 1.1-2

mice: version 2.21

network: version 1.9.0

nnet: version 7.3-7

odfWeave: version 0.8.4

party: version 1.0-13

playwith: version 0.9-54

plyr: version 1.8

psych: version 1.4.2.3

randomForest: version 4.6-7

RColorBrewer: version 1.0-5

reshape: version 0.8.4

rggobi: version 2.1.19

RGtk2Extras: version 0.6.1

ROCR: version 1.0-5

RODBC: version 1.3-10

rpart: version 4.1-3 upgrade available 4.1-5

rpart.plot: version 1.4-4

SnowballC: version 0.5

stringr: version 0.6.2

survival: version 2.37-4 upgrade available 2.37-7

timeDate: version 3010.98

tm: version 0.5-10

verification: version 1.36

weightedKmeans: version 1.2.0

XML: version 3.98-1.1

xlsx: version 0.5.5

That was 58 packages.

Update the packages with either of the following commands:

  > install.packages(c("arules", "e1071", "foreign", "Hmisc", "rpart", "survival"))

  > install.packages(rattleInfo())

Alternatively update all installed packages:

  > update.packages()

Kind regards,

Marcin

[birda simret]

hey,

Use spreadsheet,: first save your file in excel *.csv format, then from rattle --> data --> spreadsheet, load the file *.csv  from your local. that is all ;)

Birda

[Marcin Szewczyk]

Hi Birda,

Thank you for help. It works fine now.

Kind regards,
Marcin