What is the conceptual difference between Microsoft Excel, R languages ​​and Python + mathlibs in the field of data analysis?

Question

data mining

The question concerns the field of data processing, data analysis, machine learning, statistical analysis.
If:
- take the data processing language R, with all its libraries and other statistical modules;
- take the spreadsheet Microsoft Excel, with all its add-ons in statistics and mathematics;
- take the Python programming language, with all its mathematical modules and libraries,
then what are the main PRACTICAL differences between them for solving various problems?
After all, both R and Excel and Python allow you to process large amounts of data, build graphs, various statistical models, perform analysis and mathematical processing, but why does this or that tool use this or that big data analyst?
What is the difference between these tools? Where is each of them most applicable? In what tasks and areas is the use of each of these tools applicable and recommended? What are the most powerful competitors for the above tools?

Answer 1

Apart from the obvious "the choice of language depends on the task" and "the best tool is the one you have a good command of", I would say this:
- Throw out excel if you are not godlike in it and solve more or less complex problems. That is, the tool is good, but too clumsy and slow on large volumes.
- from R and Python, you need to look at the area. The former is a more mathematically oriented language, while the latter is more general. Moreover, if, together with the Python libraries, it can easily be compared with R in terms of the complexity of the tasks being solved, then on the contrary, everything is not so cool - R clearly loses to Python in terms of speed (there are proof links on the Internet).
Concerning

why does this or that tool use this or that bigdata analyst?

, then I repeat once again - what he understands better, what is more convenient, then he uses it.
If you are at the beginning of the journey and choose a tool - I recommend Python, it has a better community.