- On Way to Omni-Channel, Retailers Try Beacons and More
- Chief Data Officer Role Continues to Evolve
- What Is Sales Enablement Software and Do You Need It?
- 5 Ways to Use Virtual Reality in the Enterprise
- 8 Open Source BPM Software Options
- How HTAP Database Technology Can Help You
- 9 Apps Empowering Finance
Why continue to manually fiddle with Excel for tables?
Excel can cluster data, but when working with business analytics data, this Smart Data Collective report says that the process of making a nice looking table for a presentation is still a manual process of pasting into Excel and fiddling. This article looks at how to build a good analytics table using statistical computing open source software, R.
"Here are just 13 of the many ways to make tables in R: table, xtabs, ftable, ctab, summary (from hmisc), contingency.tables (from Deducer), VCDs structable, aggregate, epis stat.table, rreport (but exports only Latex), xtable, gmodels CrossTable, ecodists crosstab. Here are all the ways to make a true banner table: (cricket chirp, cricket chirp)
"So, thats painful. Another problem is the lack of graphical output. Since all of Rs table commands spit out text formatted tables, you cant just copy and paste them into Excel (or other spreadsheet tools) to reformat them. This is a huge stopper to productivity. Instead, what you really want is either a) formatting control in the program to create a graphically appealing, copy and pastable table, or b) direct output to a system which facilitates this, like Openoffice, Excel, or HTML. Some R commands output to Latex (via sweave), but for the average analyst, this is unusable (I love academics, but come on, asking analysts to use Latex is just wrong!)."
Read the Full Story at Smart Data Collective
This article was originally published on June 7, 2010