library(RODBC)
library(lattice)
library(treemap)
ch<-odbcConnect("mike_db",uid="mike")
c<-sqlQuery(ch, paste("select"
,"ward,year(end_Dttm) as [year]"
,",sum(datediff(mi,start_Dttm,end_Dttm)/1440.0) as LOS"
,"from [wardstays_examples]"
,"GROUP BY ward ,year(end_Dttm)"
))
str(c)
treemap (c
,index=c("year","ward") # the different levels
,vSize = "LOS" # the value on which to scale the squares
)
Monthly Archives: September 2013
Excel: replace a character or string with CR LF
This is a technique aimed at splitting up a long cumbersome string held in a single cell using new line breaks. It requires that we replace a normal character with the special characters [CR][LF].
Why would you want to do this?
Well sometimes it looks nice and it makes life easier, or it can make the data easier to scan through. I first used it to show ICD10 Diagnosis code strings from a concatanated string into a single readable cell.
To start off generate your file so that each part of the string that you want on a seperate line has a unique character (or unique string) at the end of the subsection.
In this example I’ve used “: ”
Now highlight the section you want to change. Ctrl + A on a section etc.
Then bring up the find and replace dialog using Ctrl + H
In this example I needed to replace “: ” (thats colon followed by a space)
Now place your cursor in the replace section:
Hold down ALT + 010 release (the ALT key) and then ALT + 013 then release again.
Press the replace all button and away it goes, It can take longer doing this than a normal find and replace.
…and that’s what you get newlines instead of “: ”
Set Grub2 (Fedora 19) default boot to…something other
grep menuentry /boot/grub2/grub.cfg
Copy the name of the OS you want as default
then access the /etc/default/grub file as root
sudo gedit /etc/default/grub
Replace whatever is currently being given to GRUB_DEFAULT with the OS name you want as the default (enclose the OS name in “”)
Then run as root:
grub2-mkconfig -o /boot/grub2/grub.cfg
…and reboot to test
I don’t think this survives a Kernel update, but the process is not onerous, and no sacrifices to the gods are required.