API- Filter columns when downloading

Questions & Help
1

Hi!

I am following the tutorial in this link to download some data from Advan: GitHub - Dewey-Data/deweydatapy: Dewey Data Inc. Python API

Is there a way to select which variables I want, either by name or index, instead of downloading it all? There is a size issue as some of the columns have long floating points, and I don’t need those.

I was thinking something like this (as an example of what I am looking for, although this doesn’t actually work):
files_df = ddp.get_file_list(apikey_, pp_advan_wp,
start_date = ‘2023-09-03’,
end_date = ‘2023-12-31’,
vars = [1:12, 14], # select certain variables
print_info = True);

Thanks!

2

Hi @johnna.berryhil,

This feature is not currently available, but we are always looking for ways to improve. We will be sure to consider this as we continue to make product improvements.

In the mean time, you can index the data similar to how you have done by reading in each file, indexing, then saving/overwriting the filtered data to memory.

Hope this helps.

Thank you!