Saturday, May 28, 2011

Make a Heatmap from CSV/tab delimited file: R - Project Scripts:

I tried this and it is working well:
http://flowingdata.com/2010/01/21/how-to-make-a-heatmap-a-quick-and-easy-solution/

Heatmap:

1. In R-commander, load the Matrix (from CSV, tab delimeted etc) for
heatmap in a name, say "Dataset"

2. Now change the data into matrix
> Dataset <- data.matrix(Dataset)
> Dataset_Matrix <- data.matrix(Dataset)
> Dataset_Heatmap <- heatmap(Dataset_Matrix,Rowv=NA, Colv=NA,col = cm.colors(256), scale="column", margins=c(5,10))

Now you should see a heatmap window

3. Change color
> Dataset_Heatmap <- heatmap(Dataset_Matrix,Rowv=NA, Colv=NA,col = heat.colors(256), scale="column", margins=c(5,10))

Another:
http://www2.warwick.ac.uk/fac/sci/moac/students/peter_cock/python/heatmap/

Merge two CSV files to a single file Excel worksheet based on a common/unique key

If you have two CSV files (any delimited files) that have a common field, sometimes we need to merge the data into a single worksheet.  Intelligently use VLOOKUP function as explained here to accomplish this task.

http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/

Tuesday, May 3, 2011

Convert your LAN to a WiFi for free with your laptop

If the WiFi in your office is quite weak or non-existent and if you don't wanna use your smartphone's data plan bandwidth for streaming music, checking your personal mails, sync-ing your online calendar etc, why don't you convert your laptop to a high-speed WiFi hot-spot for free? You can connect your iPhone, iPod Touch, Android Phone all to your laptop (connected to a LAN Ethernet connection) using free software like these:

1.Connectifi



http://download.cnet.com/Connectify/3000-18508_4-75024171.html

2. Virtual Router
http://download.cnet.com/Virtual-Router/3000-18508_4-75332523.html

3. Virtual Access Point
http://download.cnet.com/Virtual-Access-Point/3000-18508_4-10957727.html

I tried the first two; Virtual Router, the 2nd one, didn't work for me. Connectifi worked quite well. Now I have high-speed internet on my androd phone for free. Kudos to the developers.