Filter rows in a table

[ines_jukic]

Hi everyone,

I want to filter rows in a column of a table that is in a tag, the value of the filter is in another tag. I´ve tried with this code but it's not working

valor_filtro = system.tag.read("[default]Mecanizado/InputPallet").value
tagtabla = "[default]Mecanizado/Blocks-Pallets"
datatabla = system.dataset.toPyDataSet(system.tag.read(tagtabla).value) 

tabla_filtrada = datatabla[datatabla['Pallet'] == valor_filtro]

system.tag.write("[default]Mecanizado/tablaimpresion",tabla_filtrada.value)

I would appreciate any help or information you could give me. Thank you!

[pascal.fragnoud]

@ines_jukic

tabla_filtrada = datatabla[datatabla['Pallet'] == valor_filtro]

That's not valid python.

Problem to filter dataset

def filter_dataset(ds, condition): return system.dataset.toDataSet(list(ds.columnNames), filter(condition, system.dataset.toPyDataSet(ds))) filter_dataset(ds, lambda row: row['zone'] == 'A')

[ines_jukic]

sorry i don't understand

[pascal.fragnoud]

Tell me what you don't understand and I'll try to explain.

[Transistor]

@ines_jukic

tabla_filtrada = datatabla[datatabla['Pallet'] == valor_filtro]

What do you want this line to do?

[PGriffith]

Some possible solutions in this other thread:

Problem to filter dataset

Hello I have this dataset: [image] And I would like filtering row of my dataset where zone =A I want obtain this data below : [image] how can I filtering it please.