edc-model-to-dataframe 1.0.1

Export EDC model data to pandas dataframe for clinicedc/edc projects

edc-model-to-dataframe

ModelToDataframe exports EDC subject data into a pandas dataframe. On export it will add subject_identifier and visit tracking columns specific to the EDC. Also, by default, encrypted fields are not exported.

M2M columns are joined into a single field value delimited by comma.

Note: If you are just exporting raw tables, use django_pandas read_frame.

Pass a model name:

from django.apps import apps as django_apps
from edc_model_to_dataframe import ModelToDataframe

model = "meta_subject.followupexaminiation"
m = ModelToDataframe(model)
df = m.dataframe

Pass a queryset:

# using a queryset
model_cls = django_apps.get_model("meta_subject.followupexaminiation")
m = ModelToDataframe(model_cls.objects.all())
df = m.dataframe

read_frame_edc: like in django_pandas, there is a read_frame -like function which wraps ModelToDataframe

from edc_model_to_dataframe import read_frame_edc

model_cls = django_apps.get_model(model)
df = read_frame_edc(model_cls.objects.all())