system.dataset.join

[JosephTLockwood]

Function to join to datasets.

Currently, I only use the left joins. I am assuming this would most likely be able to do left, right, and inner joins.

def dataSetToDict(dataSet, headers = None):
	finalDict = {}
	if headers is None:
		headers = dataSet.getColumnNames().toArray()	
	
	for col in range(dataSet.getColumnCount()):	
		tempArray = []
		for row in range(dataSet.getRowCount()):
			value = dataSet.getValueAt(row, col)
			if value != 'None' and value is not None:
				#print(value)
				tempArray.append(value)
		finalDict[headers[col]] = tempArray
	
	return finalDict

Will work on this in free time.