sql access part 2 with boxplot and big query

Posted on by
Reply 
##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)

Programs I tend to install when re-installing Linux (in no particular order)

Posted on by
Reply

setup sudo: 

echo 'monkeymike ALL=(ALL) ALL' >> /etc/sudoers

sudo rpm -ivh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
sudo rpm -ivh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm


sudo yum localinstall --nogpgcheck http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-$(rpm -E %fedora).noarch.rpm
sudo yum localinstall --nogpgcheck http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-$(rpm -E %fedora).noarch.rpm


sudo yum install yumex yum-plugin-fastestmirror espeak mc stellarium kdeedu codeblocks easytag gparted bluefish rkward k3b gnome-tweak-tool codeblocks htop stellarium  gpodder vlc scite easytag amarok phpmyadmin mysql-workbench kile xine evince evince-dvi p7zip unrar qcomicbook phpmyadmin mariadb filezilla audacious audacious-plugins-freeworld* xine-lib-extras-freeworld alacarte

sudo yum groupinstall MATE-Desktop
sudo yum localinstall --nogpgcheck -y https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm

…and possibly:

SAGE math (don't forget to copy over the .sage directory from /home)
Game Menu
wine
kmod nvidia
GoogleEarth

and make sure some stuff is running:

sudo systemctl start httpd
sudo systemctl enable httpd.service
sudo systemctl start mysqld
sudo systemctl enable mariadb.service

oh and how to run a jar, minecraft for instance:

java -jar Minecraft.jar