Converting dataset to json HELP

General Discussion
1

I am in need of help, I have a dataset that i need to make a json.

This is the dataset:
image

How can i convert it to a json so i can parse column data?

2
3

Thank you sir

1 Like
4

Anyway I can insert rows into this? I would like to add Denier rows with names in the column. Then have a Doff_Number default value of 0 on each row, then when something in that row it replaces that 0 with a value?

	columnnames = [
		{
			'Doff_Number':Doff_Number,
			'Denier':Denier,
		} for Doff_Number,Denier in system.dataset.toPyDataSet(value)
	]
	
	return columnnames

So it would resemble something like this:
image

Then if only the 1385 row had doff_number data it will fill it in but leave the rest at 0, like this:
image

5 
columnnames = [
		{
			'Doff_Number':Doff_Number if Doff_Number else 0,
			'Denier':Denier,
		} for Doff_Number,Denier in system.dataset.toPyDataSet(value)
	]
	
	return columnnames

I think this will get you what you’re looking for, but it’s sort of dangerous depending on the type of the column.

For example, if Doff_Number is a string column, and a row contains a value of "0" in that column, then you’ll get String “0” instead of 0 because bool("0") equates to True. So you need to be aware of what type a given column is.

6

Just for posterity, below is useable for converting any dataset into a json object Py objects. Of course, it doesn't provide the extra condition in the OP, but this could be added with an if

pds = system.dataset.toPyDataSet(value)
columnNames = pds.columnNames 
ret = [
	{
		col: row[col]
		for col in columnNames
	} for row in pds
]

return ret
6 Likes
7

this worked like a charm. thanks!