Problem when downloading data table as csv

[campopianoa]

That is the row ID. You could put your DataTable rows into a Pandas DataFrame and save that to a CSV file. For example:

Using pandas with Anvil

Hi @ldelfin, If you want to construct a Pandas data frame out of data held in your Anvil data tables, I’d suggest you construct a list of dicts with the information you want, and then call DataFrame.from_dict() on it. Eg, if I have a table called “people”, which has name and age columns, plus group which is a link to a row from the “groups” table, and the “groups” table has a column called name, I could do: from anvil.tables import app_tables import pandas # Get an iterable object with all t…

Once you have your data in a DataFrame, you can download it by making it an Anvil Media object. Explained more here:

Pandas dataframe directly as DB media column type

You can get to a media object from a DataFrame by serializing the DataFrame. You can get to a DataFrame from a media object by reading the media object’s bytes. Here is an example showing some back-and-forth conversions for both json and csv content types. [com-gif-maker%20(1)] clone the app: https://anvil.works/build#clone:FIMSJJBV5EYKZQ7K=NJH74Q6AGAH4HHPWH7N2TVID

I’m not sure if there is an easier way, but there might be.