Submitted by satimis on Fri, 08/20/2010 - 09:01
Posted in
Hi folks,
I followed 'intro to red-r.mp4"
to experience red-r without success.
On Win 7 (login as user)
Start R
Start Red-R
Red-R Canvas starts
Read Files <-data.frame-> Row Filtering <-Data Subset-> View Data Table (connected)
Clicking "Read Files" starts "Read Files" window
Load File - only "Select File", no files on the drop list
Clicking Browse starts "Open File" window
Libraries -> Documents -> My Documents -> Red-R -> Templates
only empty folder/directory
Libraries -> Documents -> Public Documents -> Red-R
-> Schemas
-> Templates
Both only empty folder/directory
Where/How can I import data files from R
On Ubuntu 10.04 (login as user)
Start R-Commander
Start Red-R
Red-R Canvas looks the same as in Win 7
Read Files <-data.frame-> Row Filtering <-Data Subset-> View Data Table (connected)
Clicking "Read Files" starts "Open File" window
Load File - only Select File, no files on the drop list
Clicking Browse starts "Open File" window
satimis -> Documents -> Red-R -> Templates
only empty folder/directory
Where/How can I import data files from R
TIA
B.R.
satimis
Hi Anup,
> Go to
> Help -> About Red-R
Revision 864
> Also did you try updated the permissions on those directories?
Could you pls explain in more detail. How to update the directories e.g in Win 7. Which directories?
TIA
B.R.
satimis
satimis,
Go to
Help -> About Red-R
There should be a Revision number there. Whats that number. If its less than 881, please download the newest version of Red-R. That should fix most of the problems you have listed.
Also did you try updated the permissions on those directories?
Hi Anup,
> Which revision of Red-R have you downloaded.
Red-R-1.75 x86
B.R.
satimis
satimis,
Which revision of Red-R have you downloaded. We had some permissions problems with r864 that did now allow the downloaded packages to be saved. That is why you are seeing the RODBC download pop-up every time.
You can download the new installer, or simply change the permissions read and write on
#RED-R Install dir#/R/library
#RED-R Install dir#/Red-R-1.75/libraries
Now the RODBC pop-up should appear only once and add the ORDBC dir into #RED-R Install dir#/R/library.
Anup
Hi Kyle,
Each time starts "Read Files" it says RODBC missing. I think this problem needs to fix first.
I can save iris data file on R as iris.csv file.
B.R.
satimis
RODBC doesn't have iris in it. RODBC is a package for using databases and interacting with Excel.
Read Files doesn't have any data associated with it. You have to read a text file from your machine. If I hadn't extracted the iris data from R and resaved it as a .txt file I couldn't have done the example either.
I'll fix this since it is causing confusion.
If you would like to try the example using your own data you can use any spreadsheet program to make a table and save that as a .csv or tab delimited file and then read that in using Read Files.
The dropdown is a memory of what you have read in in the past. It will be different from computer to computer and will change over time as you move files and load new ones.
Please let me know if you have to download RODBC every time. Once you download it it should be there.
But in the end ReadFiles doesn't know anything about what tables are in the R session and can only read in text files with some kind of delimitation.
If you want to have the Iris data;
Open RExecutor
Type 'iris' (no quotes) in the 'command' line.
Press 'Send'
Connect to View Data Table or any other data frame accepting widget.
Play with the Iris data.
Thanks.
Kyle
Hi Kyle,
My problem here is "I can't find iris data file on "Read Files" on both Win7 and Ubuntu 10.04". I have R installed on both environment. They are working.
On Win7
Each time clicking;
-> Data Input -> Read Files
Download R Library window popup
You are missing some key files for this widget
RODBC
Would you like to download it?
-> OK
Then "Read Files" icon displayed on the right window
(I don't know whether the file has been download?. Each time it ask for downloading it)
satimis
Read files reads any tab, comma, space, or arbitrary delimited file.
I don't think I moved the iris data into the temp directory but can do that.
If you would like to try yourself you can write the iris data to a delimited text file in R and then read in using Red-R (or do it in RExecutor if you don't have R installed).
Thanks, hope this helps.
Kyle