scratch_1.py

import pandas as pd
import json

source_df = pd.read_csv('./data_agouti.csv')

def pd_row_to_dict(row):
    return {
        'taxon_id': row['taxon_id'],
        'scientific_name': row['scientific_name'],
        'vernacular_names': [
            {
                'name': row['name_en'],
                'language': 'en'
            },
            {
                'name': row['name_nl'],
                'language': 'nl'
            }
        ]
    }


result = [pd_row_to_dict(row) for _, row in source_df.iterrows()]

print(json.dumps(result))