monkeymike.co.uk

auto save on exit with R

Fri, 03 Sep 2010 19:49:43 +0000

"C:\Program Files\R\R-2.10.0\bin\Rgui.exe" --save

Dual ordinate plots

Thu, 20 May 2010 21:25:08 +0000

###dual ordinate Plot in R
###################################
###par(mar=c(5,4,4,4))
plot(ae3$wait.med,type="l", col=2, ylim=c(0,150))
par(new=T)
plot(ae3$wait.N,type="l",axes=F, col=4,ylim=c(0,6500))
axis(side=4)
#######################################

sql access part 2 with boxplot and big query

Wed, 12 May 2010 20:05:30 +0000

##load the required bits
library(RODBC)
library(lattice)
##set up the connection
channel<-odbcConnect("mike_db", uid="mike")
##sqlTables(channel)
##a<-sqlFetch(channel,"AnE")
##b<-sqlFetch(channel,"vwAnE")
##b<-sqlQuery(channel, paste("select * from vwAnE order by loc, month_val"))
##xyplot(N~month_val|LOC,b, type="l")

##c<-sqlQuery(channel, paste("select CM,sum(numerator)"
## ,"from EP_2010_2011_ENHANCED"#
## , "WHERE not parnt like 'z_%' "
## ," group by CM"
## ))

##execute a query for the data
e<-sqlQuery(channel, paste("select CM,aggregate_02,spect,Numerator,denominator,value,target, year_month+'-01' as year_month"
,"from EP_2010_2011_ENHANCED"
,"where 1=1 and CM like '%e_01%'and TIME_TYPE='per-month'"
,"and parnt like 'z_t%'order by aggregate_02,spect,year_month"))
##convert the year_month value to a date

e$year_month<-as.Date(e$year_month)

##plot the lattice

xyplot(value~year_month|spect,e, type="l", cex=3)

xyplot(value+target~year_month|spect,e, type="l", size=5)

MS SQL access

Wed, 12 May 2010 05:20:50 +0000

library(RODBC)
channel<-odbcConnect("mike_db", uid="mike")
sqlTables(channel)
a<-sqlFetch(channel,"AnE")
b<-sqlFetch(channel,"vwAnE")
b<-sqlQuery(channel, paste("select * from vwAnE order by loc, month_val"))
xyplot(N~month_val|LOC,b, type="l")

add a username to receive ROOTs system mail

Thu, 15 Apr 2010 05:49:47 +0000

sudo gedit /etc/aliases

then change the line
#root: marc

dumping shell output to a file

Tue, 23 Feb 2010 06:48:57 +0000

find /home/user_name/Music > file_list_text_file_name.txt

http://www.cs.virginia.edu/~evans/cs216/guides/x86.html

Mon, 28 Dec 2009 20:44:55 +0000

http://www.cs.virginia.edu/~evans/cs216/guides/x86.html

Update query syntax

Thu, 17 Dec 2009 06:46:05 +0000

UPDATE Your_table_name_here
SET Your_field_name_here = your_value_to_update_here
WHERE your_logical_condition_here

Extract data from a ‘challenged’ tar.gz archive

Tue, 15 Dec 2009 07:26:07 +0000

gunzip < yourfilenamehere.tar.gz > OutputFileName.tar.part

Stop firefox using konquerer to open folders

Sat, 31 Oct 2009 20:11:42 +0000

under fedora 11 look in /usr/share/applications/ for the file gnome-nautilus-folder-handler and remove the line with the semi colon near the end.