Scrapped this massive (10M+ entries) Twitter dataset using academictwitteR, and as I am preparing to do some network analysis, I’ve come up against an issue whereby the dataset only identifies the used ID if a particular tweet is responding to another user (see mockup below). What I am trying to do across this dataset is a conditional replace whereby the user ID in the “in response to” column is replaced by the username.