1286 search results for "excel"

Management of Research Data – a Shell+Python+Excel+R Approach

January 23, 2013
By
Management of Research Data – a Shell+Python+Excel+R Approach

I am a computer science researcher, usually working on both Windows and Linux system. Windows is the place where I do the document work, like reading paper, browsing the internet, writing papers with LaTex… Linux is where I run and generate experimental results. The Chaos After years of messy data management and recent data chaos,

Read more »

Please stop using Excel-like formats to exchange data

December 7, 2012
By
Please stop using Excel-like formats to exchange data

I know “officially” data scientists all always work in “big data” environments with data in a remote database, streaming store or key-value system. But in day to day work Excel files and Excel export files get used a lot and cause a disproportionate amount of pain. I would like to make a plea to my Related posts:

Read more »

Excel + Cytoscape + R = ExCytR

November 16, 2012
By
Excel + Cytoscape + R = ExCytR

My new project is coming along nicely and should be released early 2013. It builds on the structures developed in imDEV to link Excel, Cytoscape and R using RExcel,  RCytoscape, and CytoscapeRPC . This trio can be used to rapidly generate beautiful and  informative network representations of data. Here is an example of a  undirected Gaussian graphical

Read more »

Calling Minimum Correlation Algorithm from Excel using RExcel & VBA

September 26, 2012
By
Calling Minimum Correlation Algorithm from Excel using RExcel & VBA

I want to show the example of calling the Minimum Correlation Algorithm from Excel. I will use RExcel to connect R and Excel and will create a small VBA cell array function to communicate between Excel and R. I have previously discussed the concept of connecting R and Excel in the “Calling Systematic Investor Toolbox

Read more »

Importing data directly from MS Excel

August 10, 2012
By
Importing data directly from MS Excel

R is great for exploring, analysing and graphing your valuable data. No question about it. Unfortunately though, there’s no base package support for importing data directly from MS Excel. This means that you have to faff about saving it in another format, and THEN import this new file. This just adds another file to your

Read more »

Data Mining In Excel: Lecture Notes and Cases

July 10, 2012
By
Data Mining In Excel: Lecture Notes and Cases

by Yanchang Zhao, RDataMining.com It is a 270-page book on data mining with Excel. It can be downloaded as a PDF file at http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.83.1393&rep=rep1&type=pdf. Below is its table of contents. - Overview of the Data Mining Process - Data Exploration … Continue reading →

Read more »

MatLab, SAS, STATA, SPSS, Excel users: Try R, damn it!

July 2, 2012
By
MatLab, SAS, STATA, SPSS, Excel users: Try R, damn it!

Due to my work with a multitude of statistical packages in my career I may be able to evaluate a lot of them. I’ve first used Excel for my calculations as most of the normal users do. I like the idea behind a spreadsheet and the combination of data and click-to-do functions. Nevertheless I’ve often

Read more »

multiplicitiesoffreedom demonstrates Chaos Theory in Excel. If…

June 29, 2012
By
multiplicitiesoffreedom demonstrates Chaos Theory in Excel. If…

multiplicitiesoffreedom demonstrates Chaos Theory in Excel. If he filled in more initial values, you would see a thick bar—like a picture of white-noise. Butterflies flapping their wings in Vermont to change the wind in Hangzhou? A drop of water on ...

Read more »

Make R analysis Modules just like MS Excel Templates: Derivative Calculator study case

June 4, 2012
By

In this video tutorial, it will show you how to make R analysis Modules just like MS Excel Templates using the Building Derivative Calculator app as study case. Let’s say we wanted to know the derivative of tan(x^2 + 3), commonly, we will use th...

Read more »

Pasting Excel data into R on a Mac

June 2, 2012
By
Pasting Excel data into R on a Mac

When starting out with R, getting data in and out can be a bit of a pain. It should take long to work out a convenient method – depending on what OS you use and what other packages you work with. In my case I prefer to work with Excel spreadsheets (which are versatile and

Read more »