User Tools

Site Tools


Examples of common export calls are provided below.

It is convenient to set up one or more import directory paths up front. For example:

string $exportDir= $modelHome + "/exportData"

csv coordinate format

This code exports a 2-dimensional population TOOL object (by age, by time) to a csv file with age in the rows and time in the columns.

export (refPop[a,ts]; dataFormat=coordinate, fileFormat=text, allCoord=off, delimiter=",", \
			heading=on, file=$exportDir/refPop.csv)

tab delimited text odometer (block) format

This format is useful for migrating data between models in a human-readable format, as opposed to binary tool-format files. Note the use of expForm and decimals parameters to preserve precision.

export (immigration[s,ts1,a]; dataFormat=odometer, fileFormat=text, \
	expForm=on, decimals=6, \

produces the following (header not shown):

!	sex=male
! 	0		1		2	
"1977"	1.049407e+02	1.314661e+02	1.317941e+02
"1978"	9.129648e+01	1.133035e+02	1.212180e+02
"1979"	8.643492e+01	9.573391e+01	9.366822e+01
"1980"	9.673356e+01	9.806976e+01	9.806976e+01

See the corresponding import call.

TOOL format

This is an example of exporting to whatIf's native (binary) TOOL file format:

export (customCensusPop[pzce,s,byrs,acc]; format=tool, file=$exportDir/customCensusPop)
howtos/workwithdata/export_quick_reference.txt · Last modified: 2013/01/31 16:52 by marcus.williams