Differences

This shows you the differences between two versions of the page.

--- howtos:workwithdata:createsetsfromdatafile [2011/05/06 20:36]
shona.weldon
+++ howtos:workwithdata:createsetsfromdatafile [2011/05/06 21:00]
shona.weldon
@@ Line 28: / Line 28: @@
 **firstLine** - use this only if you want to start on any row other than the first row with no consideration of commented out lines. Note this overrides the "heading" setting!
+===== Example Reading in sets =====
+This is a sample .csv file from which we will read some sets
+<file>
+Region,,,ALBERTA,,,,,,,,,,,
+Year,,,2006,,,,,,,,,,,
+Table 10:,,,Sectoral Greenhouse Gas Emission Summary,,,,,,,,,,,
+,,,,,,,,,,,,,,
+Greenhouse Gas Categories,,,,,Greenhouse Gases,,,,,,,,,
+,,,,,CO2,CH4,CH4e,N2O,N2Oe, HFCs , PFCs ,SF6,TOTAL,
+,,,,Global Warming Potential,,,21,,310,,,,,
+,,,,Unit,kt,kt,kt CO2  equivalent, kt ,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent,kt CO2 equivalent,
+TOTAL,,,,," 179,823 "," 1,921 "," 40,339 ", 43.0 ," 13,328 ", 674 , -   , -   ,"234,163",
+ENERGY,,,,," 167,914 "," 1,402.0 "," 29,443 ", 7.8 ," 2,429 ",,,,"199,786",
+a.,Stationary Combustion Sources,,,," 123,801 ", 74 ," 1,557 ", 3 , 819 ,,,,"126,177",
+,Electricity and Heat Generation,,,," 53,600 ", 2 , 31.7 , 1 , 304.3 ,,,,"53,936",
+,Fossil Fuel Production and Refining,,,," 38,618 ", 70 ," 1,475.0 ", 1 , 287.4 ,,,,"40,380",
+,Mining & Oil and Gas Extraction,,,," 11,408 ", 0 , 4.5 , 0 , 83.5 ,,,,"11,496",
+,Manufacturing Industries,,,," 6,978 ", 0 , 5.9 , 0 , 56.6 ,,,,"7,041",
+</file>
+Here it is as a .csv you can download and open with Excel to see it better and to test the code below
+{{:howtos:workwithdata:emtestfile.csv|}}
+==== Read from a column ====
+The following code reads the second column as
+<code>
+string $importPath, $fileName
+buildstring ($importPath, $home, "/testScripts")
+buildstring ($fileName, $importPath, "/emtestfile.csv")
+localinformant ECemRowTitles[] = create (; object=set, delimiter=",", \
+	allowDuplicate=on, \
+	elemNamesFromColNum=2, firstLine=9, \
+	searchElemName1=",", replaceElemName1="-", \
+	searchElemName2="&", replaceElemName2="and", \
+	replaceWhiteSpaceInElemName="_" , \
+	file=$fileName)
+display (ECemRowTitles[])
+export (ECemRowTitles[]; file=$importPath/ECemRowTitles.txt)
+</code>
+==== Read from a line/row ====
+The following code reads the second column as
+<code>
+string $importPath, $fileName
+buildstring ($importPath, $home, "/testScripts")
+buildstring ($fileName, $importPath, "/emtestfile.csv")
+localinformant GHGInvEmType[] = create (; object=set, delimiter=",", \
+	allowDuplicate=on, \
+	elemNamesFromLineNum=6, firstCol=4, \
+	file=$fileName)
+display (GHGInvEmType[])
+export (GHGInvEmType[]; file=$importPath/GHGInvEmType.txt)
+</code>

whatIf? Wiki

User Tools

Site Tools

Differences

Page Tools