[R-gui] your favourite spreadsheet-like data viewer or editor?

9 messages · Gabor Grothendieck, ilhami visne, Ian Fellows +1 more

Original

1

9

ilhami visne

Fri, Nov 5, 2010 8:57 AM #

Hi,

Try this one here http://speedr.r-forge.r-project.org. You can use it to 
view, filter and import new datas.

If you like it or find a bug (in beta), please write on the forum.

best wishes,
ilhami visne

project is at

On 10/26/2010 7:13 AM, Liviu Andronic wrote:

David Katz

Fri, Nov 5, 2010 1:23 PM #

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-sig-gui/attachments/20101105/56b171fc/attachment.pl>

Ian Fellows

Fri, Nov 5, 2010 1:48 PM #

David,

rforge does not keep up to date builds of packages for R versions that are out of date. You are using R 2.10.x. I suggest you install from the source with:

install.packages("speedR", repos="http://R-Forge.R-project.org",type="source")

you will need to have RTools ( http://www.murdoch-sutherland.com/Rtools/ ) installed.

Ian

On Nov 5, 2010, at 1:23 PM, David Katz wrote:

I got an error trying to install speedR (after the preliminary installs went
ok):

install.packages(c("rJava","iplots"))
Warning in install.packages(c("rJava", "iplots")) :
 'lib = "c:/PROGRA~2/R/R-210~1.1/library"' is not writable
--- Please select a CRAN mirror for use in this session ---
trying URL 'http://cran.fhcrc.org/bin/windows/contrib/2.10/rJava_0.8-6.zip'
Content type 'application/zip' length 579833 bytes (566 Kb)
opened URL
downloaded 566 Kb

trying URL 'http://cran.fhcrc.org/bin/windows/contrib/2.10/iplots_1.1-3.zip'
Content type 'application/zip' length 415231 bytes (405 Kb)
opened URL
downloaded 405 Kb

package 'rJava' successfully unpacked and MD5 sums checked
package 'iplots' successfully unpacked and MD5 sums checked

The downloaded packages are in
C:\Users\dk\AppData\Local\Temp\RtmpjCVkHj\downloaded_packages

install.packages("speedR", repos="http://R-Forge.R-project.org")

Warning in install.packages("speedR", repos = "http://R-Forge.R-project.org")
:
 argument 'lib' is missing: using 'C:\Users\dk/R/win-library/2.10'
Warning: unable to access index for repository
http://R-Forge.R-project.org/bin/windows/contrib/2.10
Warning message:
In getDependencies(pkgs, dependencies, available, lib) :
 package 'speedR' is not available

install.packages("speedR")

Warning in install.packages("speedR") :
 argument 'lib' is missing: using 'C:\Users\dk/R/win-library/2.10'
Warning message:
In getDependencies(pkgs, dependencies, available, lib) :
 package 'speedR' is not available

Thanks for any help.
Regards,
David

On Fri, Nov 5, 2010 at 8:57 AM, ilhami visne <ilhami.visne at gmail.com> wrote:

Hi,

Try this one here http://speedr.r-forge.r-project.org. You can use it to
view, filter and import new datas.

If you like it or find a bug (in beta), please write on the forum.

best wishes,
ilhami visne

project is at

On 10/26/2010 7:13 AM, Liviu Andronic wrote:

Dear all
I've been looking for a solution to this problem ever since I started
learning R, and I still haven't found one I'm comfortable with. And I
would rather avoid exporting and importing into a spreadsheet just for
this. I am looking for a data viewer/editor that could, among other
things:
- have a 'view' mode (not an 'edit only' mode, to avoid bugs or
unintended modifications)
- have a 'filter' view mode (not a data-modifying subset)
- have a 'sort' view mode (not a data-modifying sort operation)
- select multiple rows/cols
- select multiple individual cells

Here's a list of what I've found sofar:
- View()/Edit(): rudimentary interface; don't interact very well with
tcltk (Rcmdr) on Linux
- relimp::showData(): nice viewer, but too often too unstable; lacks
most of the features above
- tcltk2::tk2edit(): allows multiple row/col/cell selections; has no
'view' mode nor 'filter' or 'sort', and pops up scary errors whenever
'cancelling' changes
- rdataviewer: the interface is too exotic for my habits, and lacks
most of the features above
- RGtk2Extras::dfedit(): allows multiple cell selections and can
perform a 'sort' and displays several features in the c-menu; it is
quite slow on my system with 'iris', no 'view' mode; since it uses
RGtk2 it interacts very badly with tcltk (Rcmdr)
- playwith: features a nice viewer hidden in Labels>  Select from
table, but it is awkwardly located, with no advanced features, and
RGtk2 based
- JGR/Deducer::data.viewer(): includes a nifty data editor, perhaps my
favourite from this list, but it is a bit awkward to use when using an
editor different than JGR (console monopolization); it also lacks a
'view' and 'filter' mode as well well as select multiple rows/cols; it
can sort, but not easily when outside JGR


Anything that I've missed? Regards
Liviu

_______________________________________________
R-SIG-GUI mailing list
R-SIG-GUI at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-gui

_______________________________________________
R-SIG-GUI mailing list
R-SIG-GUI at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-gui

Gabor Grothendieck

Fri, Nov 5, 2010 3:56 PM #

On Fri, Nov 5, 2010 at 4:48 PM, Ian Fellows <ian.fellows at stat.ucla.edu> wrote:

I can also confirm that I was able to install it from source on
Windows R 2.11 but not otherwise.

Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com

ilhami visne

Sat, Nov 6, 2010 5:30 AM #

Hi David,

As Ian's suggested, you can install the latest version of R or you can 
download speedR package to your local disk 
(https://r-forge.r-project.org/bin/windows/contrib/latest/speedR_1.0.zip) and 
install it by using the menu  "Install package(s) from local zip file...".

You will get a warning saying "package 'speedR' was built under R 
version 2.12.0" that you can ignore.

best wishes,
ilhami visne

P.S.: By mistake first i've uploaded a test version, which is fixed but 
maybe not rebuild yet by r-forge. Be sure you get the last one.

On 11/5/2010 9:48 PM, Ian Fellows wrote:

David,

rforge does not keep up to date builds of packages for R versions that are out of date. You are using R 2.10.x. I suggest you install from the source with:

install.packages("speedR", repos="http://R-Forge.R-project.org",type="source")

you will need to have RTools ( http://www.murdoch-sutherland.com/Rtools/ ) installed.

Ian


On Nov 5, 2010, at 1:23 PM, David Katz wrote:

I got an error trying to install speedR (after the preliminary installs went
ok):

install.packages(c("rJava","iplots"))
Warning in install.packages(c("rJava", "iplots")) :
  'lib = "c:/PROGRA~2/R/R-210~1.1/library"' is not writable
--- Please select a CRAN mirror for use in this session ---
trying URL 'http://cran.fhcrc.org/bin/windows/contrib/2.10/rJava_0.8-6.zip'
Content type 'application/zip' length 579833 bytes (566 Kb)
opened URL
downloaded 566 Kb

trying URL 'http://cran.fhcrc.org/bin/windows/contrib/2.10/iplots_1.1-3.zip'
Content type 'application/zip' length 415231 bytes (405 Kb)
opened URL
downloaded 405 Kb

package 'rJava' successfully unpacked and MD5 sums checked
package 'iplots' successfully unpacked and MD5 sums checked

The downloaded packages are in
C:\Users\dk\AppData\Local\Temp\RtmpjCVkHj\downloaded_packages

install.packages("speedR", repos="http://R-Forge.R-project.org")

Warning in install.packages("speedR", repos = "http://R-Forge.R-project.org")
:
  argument 'lib' is missing: using 'C:\Users\dk/R/win-library/2.10'
Warning: unable to access index for repository
http://R-Forge.R-project.org/bin/windows/contrib/2.10
Warning message:
In getDependencies(pkgs, dependencies, available, lib) :
  package 'speedR' is not available

install.packages("speedR")

Warning in install.packages("speedR") :
  argument 'lib' is missing: using 'C:\Users\dk/R/win-library/2.10'
Warning message:
In getDependencies(pkgs, dependencies, available, lib) :
  package 'speedR' is not available
Thanks for any help.
Regards,
David

On Fri, Nov 5, 2010 at 8:57 AM, ilhami visne<ilhami.visne at gmail.com>  wrote:

Hi,

Try this one here http://speedr.r-forge.r-project.org. You can use it to
view, filter and import new datas.

If you like it or find a bug (in beta), please write on the forum.

best wishes,
ilhami visne

project is at

On 10/26/2010 7:13 AM, Liviu Andronic wrote:

Dear all
I've been looking for a solution to this problem ever since I started
learning R, and I still haven't found one I'm comfortable with. And I
would rather avoid exporting and importing into a spreadsheet just for
this. I am looking for a data viewer/editor that could, among other
things:
- have a 'view' mode (not an 'edit only' mode, to avoid bugs or
unintended modifications)
- have a 'filter' view mode (not a data-modifying subset)
- have a 'sort' view mode (not a data-modifying sort operation)
- select multiple rows/cols
- select multiple individual cells

Here's a list of what I've found sofar:
- View()/Edit(): rudimentary interface; don't interact very well with
tcltk (Rcmdr) on Linux
- relimp::showData(): nice viewer, but too often too unstable; lacks
most of the features above
- tcltk2::tk2edit(): allows multiple row/col/cell selections; has no
'view' mode nor 'filter' or 'sort', and pops up scary errors whenever
'cancelling' changes
- rdataviewer: the interface is too exotic for my habits, and lacks
most of the features above
- RGtk2Extras::dfedit(): allows multiple cell selections and can
perform a 'sort' and displays several features in the c-menu; it is
quite slow on my system with 'iris', no 'view' mode; since it uses
RGtk2 it interacts very badly with tcltk (Rcmdr)
- playwith: features a nice viewer hidden in Labels>   Select from
table, but it is awkwardly located, with no advanced features, and
RGtk2 based
- JGR/Deducer::data.viewer(): includes a nifty data editor, perhaps my
favourite from this list, but it is a bit awkward to use when using an
editor different than JGR (console monopolization); it also lacks a
'view' and 'filter' mode as well well as select multiple rows/cols; it
can sort, but not easily when outside JGR


Anything that I've missed? Regards
Liviu

_______________________________________________
R-SIG-GUI mailing list
R-SIG-GUI at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-gui

_______________________________________________
R-SIG-GUI mailing list
R-SIG-GUI at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-gui

David Katz

Sat, Nov 6, 2010 10:59 AM #

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-sig-gui/attachments/20101106/94e4175d/attachment.pl>

4 days later

ilhami visne

Wed, Nov 10, 2010 2:01 PM #

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-sig-gui/attachments/20101110/b1cce647/attachment.pl>

Ian Fellows

Thu, Nov 11, 2010 1:12 PM #

Ilhami,

You have done a great job with this package. After the update, it works very smoothly under JGR. Keep up the good work.

Some things I liked:

1. I really like the ability to filter columns to obtain subsets. It works much more smoothly and intuitively than Deducer Subset dialog.
2. The ability to import .xls and .xlsx files is key and great.
3. I liked seeing the R code behind the data import/filter

A few thoughts/suggestions:

1. I couldn't find any documentation about which file types are supported by the data import panel (i.e. speedR.importany).

2. The following code appears at the beginning of the Filer Code block:

installed.pkgs = installed.packages()
required.pkgs = c("rJava","iplots")
toBeInstalled = required.pkgs[!(required.pkgs %in% installed.pkgs[,1])]
if (length(toBeInstalled) != 0){
	install.packages(toBeInstalled)
}

This code is more book keeping than user relevant. Perhaps you should hide it from the user.

3. Since this is a Java based project, it can be nicely integrated in with JGR and Deducer. You can add menu integration with:

if(exists(".jgr") && .jgr){
	jgr.insertMenuItem("Packages & Data","Filtering Data Editor","speedR()",2)
}

if(exists(".deducer") && !is.null(.deducer) ){
       deducer.addMenuItem("Filtering Data Editor",,"speedR()","Data")
}

4. It would be nice if the Filter Code was executed in the console as if the user typed it in when finnish is clicked. This can be accomplished (when Deducer is loaded) with something like:

engine.parseAndEval("J(\"org.rosuda.deducer.Deducer\")$execute(\"2+2\")");

Where engine is your REngine and 2+2 is what you want to execute in the console.



At one point I did get the following stack trace after I hit finish, though everything still worked fine:

Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 7 >= 0
	at java.util.Vector.elementAt(Vector.java:427)
	at javax.swing.table.DefaultTableColumnModel.getColumn(DefaultTableColumnModel.java:277)
	at sun.swing.SwingUtilities2.convertColumnIndexToModel(SwingUtilities2.java:1778)
	at javax.swing.JTable.convertColumnIndexToModel(JTable.java:2551)
	at javax.swing.JTable.isCellEditable(JTable.java:2734)
	at org.jdesktop.swingx.JXTable.isCellEditable(JXTable.java:1473)
	at org.jdesktop.swingx.JXTable.setValueAt(JXTable.java:1439)
	at at.ac.arcs.tablefilter.cell.FilterCellEditor$1.actionPerformed(FilterCellEditor.java:62)
	at javax.swing.JTextField.fireActionPerformed(JTextField.java:492)
	at at.ac.arcs.tablefilter.cell.JXFilterField.stopTimer(JXFilterField.java:140)
	at at.ac.arcs.tablefilter.cell.JXFilterField$2.actionPerformed(JXFilterField.java:111)
	at javax.swing.Timer.fireActionPerformed(Timer.java:271)
	at javax.swing.Timer$DoPostEvent.run(Timer.java:201)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:633)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)


I tried to open an unsupported file type and got:

ov 11, 2010 12:49:34 PM at.ac.ait.speedr.importwizard.steps.CSVDataImportWizardStep$StreamFeeder run
SEVERE: Un-terminated quoted (") field at end of CSV line
java.io.IOException: Un-terminated quoted (") field at end of CSV line
	at au.com.bytecode.opencsv.CSVParser.parseLine(CSVParser.java:255)
	at au.com.bytecode.opencsv.CSVParser.parseLine(CSVParser.java:168)
	at au.com.bytecode.opencsv.CSVReader.readNext(CSVReader.java:237)
	at at.ac.ait.speedr.importwizard.steps.CSVDataImportWizardStep$StreamFeeder.run(CSVDataImportWizardStep.java:338)



Ian

David Katz

Fri, Nov 12, 2010 8:10 AM #

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-sig-gui/attachments/20101112/6a233434/attachment.pl>