Question about exporting field labels about pycap HOT 2 CLOSED

I see now that the behavior is determined by the REDCap API, not by PyCap. That one bit of documentation could stand to be clarified, however.

from pycap.

Thanks for the doc suggestion, @murphyke. You might consider something like this to get you 90% towards a manual export through the API…

project = Project(foo, bar)
field_to_label = {f['field_name']: f['field_label'] for f in project.metadata}
df = project.export_records(format='df')
df = df.rename(columns=field_to_label)
df.to_csv('exported.csv', index_label=project.def_field)

The ordering is difficult to ensure. Also, all the [form_name]_complete columns will not be renamed. Form status fields are unfortunately not in the data dictionary. You might use project.forms to add renaming keys to the field_to_label dict.

Note, the above requires the pandas library. You could just as easily double-loop through the records and keys, but pandas makes so many things so easy.

from pycap.