Sunday, March 29, 2009

Friday, March 27, 2009

Wednesday, March 25, 2009

Monday, March 23, 2009

Virtualbox: MS-Word

If MS-Word under Virtualbox becomes too slow,

Do Method 2 of http://support.microsoft.com/kb/280821 occasionally. Speed improvement for XP guest in my ubuntu machine was noticeable.

Sunday, March 22, 2009

TeX: Gnumeric to Tabular

Gnumeric has a built-in function.

(1) select area
(2) [File] --> [save as] --> Select [File type]: Latex2e(*.tex) table fragment

TeX: Open Office Calc to Tabular

1. Download "Calc2LaTeX" macro:

http://extensions.services.openoffice.org/project/Calc2LaTeX

2. How To:

http://www.derekhildreth.com/blog/how-to-install-and-use-calc2latex-tutorial/
Skip the installing part. It will be already there for OOs 2.0 & 3.0.

TeX: MS-Excel to Tabular

1. Download the macro file:

http://faq.ktug.or.kr/wiki/uploads/excel2tabular.zip (developed by Joo-Myung Kim)

2. Unzip "excel2tabular.zip"

into "C:\Documents and Settings\YourUserName\Application Data\Microsoft\AddIns"

3. Install "maketable.xla" in Excel

In Excel, [tools] --> [add-ins] --> [browse]
It will produce "LaTeX" menu bar.

4. Enjoy!

(1) Select area
(2) From Excel menu bar, [latex] --> [convert]

For a better explanation in Korean, go to http://faq.ktug.or.kr/faq/Excel2Tabular

Understanding the current economic crisis in 10 mins


The Crisis of Credit Visualized from Jonathan Jarvis.

http://www.youtube.com/watch?v=Q0zEXdDO5JU

Saturday, March 21, 2009

Reading Large datasets in R: filehash

Theoretically, the package 'filehash' makes R handle a large dataset by allowing a hard-disk space instead of a ram area for a dataset loading. I've tested this package with a 1G Stata-format dataset. It didn't work well. Anyway, here is howto:

(1) Install 'filehash'

> install.packages('filehash')
> library(filehash)

(2) Set an environment for the large dataset you'd like to use

> dumpDF(read.csv("largedata.csv"), dbName="dbname")
> envname <- db2env(db="dbname")

(3) Analyze with the environment

> with(envname, lm(y~x))

* envname & dbname can be any name you like.

filehash manual; howto by Yu-Sung Su

Wine: Korean non-unicode fonts 와인 한글 폰트

와인에서 설치 안내문이 한글로 작성된 프로그램 파일 인스톨할 때 한글 제대로 표시하기.

http://ubuntuforums.org/archive/index.php/t-383628.htmlLink

Beautiful Emacs: Deleting Weird-Characters

To remove weird UTF characters such as \335\277\210 in emacs windows, add the following sentences in ".emacs".

(setq locale-coding-system 'utf-8)
(set-terminal-coding-system 'utf-8)
(set-keyboard-coding-system 'utf-8)
(set-selection-coding-system 'utf-8)
(prefer-coding-system 'utf-8)

Beautiful Emacs: Korean 이맥스 한글 폰트

After doing "beautiful emacs", add two lines in ".emacs":

(set-fontset-font "fontset-default" '(#x1100 . #xffdc) '("UnBatang" . "unicode-bmp"))
(set-fontset-font "fontset-default" '(#xe0bc . #xf66e) '("UnBatang" . "unicode-bmp"))

"UnDotum" is a good alternative font.

Beautiful Emacs

Emacs default font change:

http://ubuntuforums.org/showthread.php?t=803119