Causation is not in the data and cannot be. Data only contains correlation.
Most simply, if a variable $Y$ is correlated to $X$, $X$ can be seen as a cause of $Y$ if $X$ is controlled freely by the experimenter, which is done most often in a random way. This is not in the data but in the way the data was produced. Some frameworks were invented to broaden this limited definition, but the basic idea is still valid.
then I came to know correlation does not tell you what variables
affect other variables.
Usually the word "affect" has an intuitive psychobiological meaning of "cause", while practically and mathematically this is still used about correlation. I'll try to explain.
Causation is often the way we represent correlation mentally (in our imagination). This is very useful to figure out what happens, and understand the structure of the data in a human way, and possibly to invent/correct/improve things. But strangely it's not in the data. What you can do instead is show how some correlations are explained by others: consequences. Note that the words "implied", "consequences", "explained" are all about correlation and not about causation.
Does the word "pissed off" causes a negative score (say measuring how much people are satisfied)? Actually, in my imagination I see it like this: anger both causes the word "pissed off" and a negative score. But this imagination can't be validated by the data, and I don't need it: I'll just validate "pissed off" is correlated with the score. I'll say it affects the score. Now what if I record anger itself by plugging some electrodes in people's brain and gut. I'll prove that the variable "anger" both explains the score "pissed off". But saying it is a "cause" is only in the way my imagination sees reality. Nothing in the data says that the variable "anger" is special as being the true first source of causality.
Unless you change the way the data is produced, introducing controlled intervention at some point or formalize what your imagination says about causality, you can't say anything about causality by looking at the data.