Code Snippet - Remove Nans From Excel Data

[stucork]

related post here - i’ve found the same problem before and came up with pretty much the same solution.

Please post the most simple example loading a .csv into a table

Here’s some code that might be useful: import pandas as pd @anvil.server.callable def load_csv_with_pandas(file_name): file_row = app_tables.files.get(name=file_name) file = file_row['file'] col_names = [f'column{i}' for i in range(18)] # these are the column headers for your datatable # change as appropriate with anvil.media.TempFile(file) as csv_file: df = pd.read_csv(csv_file, header=None, names=col_names) for row in df.to_dict('records'): row = {k:v for k,v i…