Iterate rows in table

Anvil Q&A
1

Hi
I have a table that looks like:
Name - Value 1 - Value 2 - … - Value N
Alpha - 500 - 620 - 650

When the user select the Name on the dropdown I want to be able to perform some numpy operations on the rows and columns that have as key the Name= “something”
Can I import the rows in an array?

2

If your data are in Anvil’s DataTables, you would have to iterate through the table in a loop and place the data into a numpy array or Pandas DataFrame.

Please check out the docs on DataTables to see how to iterate through them if you have not already.

https://anvil.works/docs/data-tables

3

For now I converted the row in a list, after in an array.
The problems are two:
1)the sorting seems to be arbitrary (but always the same)
2)the shape of the array is odd
I hoped there was a quicker way to iterate through the rows with an index
I’ll try saving it as a Dataframe and see what comes out
Thanks!