Nothing to do with PY or AErender. This si a known limitation of the process and would occur e.g. in AME as well. In order for data to be usable for such render methods, the CSV file has to be added to the timeline and the references linked from there. Just connecting from the project won't work. It only works in a full AE due to how expressions work and resolve project items.