def _get_data(table_name, url_args={}, as_dataframe=True): table_metadata = db.metadata_lookup(table_name) if not table_metadata: abort(404) row_keys = db.table_fields + (table_metadata['field'],) table_data = db.fetch_data(table_name, table_metadata, url_args) if as_dataframe: columns, data = row_keys, table_data df = pandas.DataFrame.from_records(data, columns=columns) # Fill NA values with a regular "None": # which we have to do before serializing to JSON df = df.where((pandas.notnull(df)), None) return df else: return row_keys, table_data
def _get_data(table_name, url_args={}, as_dataframe=True): table_metadata = db.metadata_lookup(table_name) if not table_metadata: abort(404) row_keys = db.table_fields + (table_metadata['field'], ) table_data = db.fetch_data(table_name, table_metadata, url_args) if as_dataframe: columns, data = row_keys, table_data df = pandas.DataFrame.from_records(data, columns=columns) # Fill NA values with a regular "None": # which we have to do before serializing to JSON df = df.where((pandas.notnull(df)), None) return df else: return row_keys, table_data