Select a Node by ID
sdth:DataframeInstance
http://www.w3.org/2000/01/rdf-schema#Class
sdth:FileInstance
sdth:ProgramStep
sdth:VariableInstance
sdtest:DFIns001
PoliticalData
sdtest:VarIns001
sdtest:VarIns002
sdtest:VarIns003
sdtest:VarIns004
sdtest:VarIns005
sdtest:VarIns006
sdtest:VarIns007
sdtest:VarIns008
sdtest:FileIns001
Q3
Q244_NEW
Q356
Q330A
Q330C
Q27
Q1010
ID
SmallTestPolitical.csv
A FileInstance cannot be used with sdth:assignsVariable
sdtest:DFIns002
sdtest:VarIns009
sdtest:VarIns010
sdtest:VarIns011
sdtest:VarIns012
sdtest:FileIns002
A FileInstance, DataframeInstance, or a VariableInstance should have a name
PPEDUCAT
PPHHSIZE
PPRENT
SmallTestPersonal.csv
sdtest:DFIns003
PersonalData
sdtest:VarIns013
HHsize
sdtest:DFIns004a
sdtest:VarIns014a
A DataframeInstance cannot be used with sdth:assignsVariable
HHcateg
sdtest:DFIns004b
sdtest:VarIns014b
"Integer"
">
"Ordinal"
"Integer"
sdtest:DFIns004c
sdtest:VarIns014c
2
"2"
3
"3-4"
5
"5-6"
7
"7-9"
10
"10+"
">
1
"1"
2
"2"
3
"3-4"
5
"5-6"
7
"7-9"
10
"10+"
sdtest:DFIns004ca
sdtest:DFIns005
MergedData
sdtest:FileIns003
SmallTestMerged.csv
A FileInstance or a DataframeInstance usually has at least one variable instance
sdtest:ProgStep001
"command": "NoTransformOp"
import pandas as pd
sdtest:ProgStep002
"command": "Load"
PoliticalData = pd.read_csv("SmallTestPolitical.csv")
A ProgramStep cannot be used with sdth:hasVarInstance
sdtest:ProgStep003
PersonalData = pd.read_csv("SmallTestPersonal.csv")
sdtest:ProgStep004
"command": "Compute"
PersonalData = PersonalData.assign(HHsize=PersonalData['PPHHSIZE'] )
sdtest:ProgStep005a
PersonalData['HHcateg'] = pd.cut(PersonalData['HHsize'], [1, 2, 3, 5, 7, 10, 999], include_lowest=True, right=False, labels=['1', '2', '3-4', '5-6', '7-9', '10+'] )
sdtest:ProgStep005b
"command": "SetDataType"
sdtest:ProgStep005c
"command": "SetValueLabels"
sdtest:ProgStep006
MergedData = PersonalData.merge(PoliticalData, on="ID", how="inner")
sdtest:ProgStep007
MergedData.to_csv("SmallTestMerged.csv")
sdtest:ProgramEx5
sdth:Program
Reset Selection