Map a pandas dataframe to django model

dataframe_to_model.py

def dataframe_to_django(
    df: Series | Any,
    model: type[models.Model],
    dbmapping: dict[str, str | None],
    convmapping: dict[str, Any],
    replace: bool = False,
) -> None:
    """Uses bulk_create to insert data in table.

    KeywordArguments:
      df           --  the dataframe.
      model        --  the django table in to which the dataframe should be inserted.
      dbmapping    --  mapping from dataframe name to db name. Typically {"ProductName": "product_name", "SkuDescription": None, ...}
      convmapping  --  converters for spesific fields. Typically, {"StartDate": pd.to_datetime, ...} .
      replace      --  bool False|True. If set to True it will wipe the table before import.
    """

    if replace:
        model.objects.all().delete()

    df.replace([np.nan], ["N/A"], inplace=True)
    for key in convmapping:
        df[key] = convmapping[key](df[key])

    model_list: list[models.Model] = [
        model(**{dbmapping[k]: v for k, v in x.items() if dbmapping[k] is not None}) for x in df.to_dict("records")
    ]
    model.objects.bulk_create(model_list)