Converting interview-based crop field histories into synthetic "cultivation practices" variables using R v1

This protocol proposes an automated method for converting ten years of data on agricultural operations in a crop field into a series of variables that synthesize the cultivation practices applied to the crop during that period. The two attached files allow you to (i) store the ten-year cultivation history of crop fields collected from farmer interviews in an Excel file and (ii) automatically synthesize these histories into a series of "cultivation practices" variables using an RMarkDown script. Although the files were designed for the Belgian context of 2023, they can be adapted for other countries and years by modifying the reference data.