3. Programming languages

Summary

Among the skills required of a data analyst, the use of programming languages stands out today. As mentioned earlier, up to a point this role can do without them. In fact, many of the activities covered from here on can be carried out without them. However, for the sake of professional growth, and given the context of data volume and complexity, programming languages are essential in practical terms. This is especially so when returning to what was said about the desired qualities of a well-done data analysis (recall: transparency, replicability, interoperability and scalability), which programming languages can address without difficulty.

This book gives priority to Python, although any language can be used. In practice, some languages are preferred over others for certain tasks. Python is quite general-purpose: it serves data analysis as well as data engineering and data science (the leading machine learning libraries are written in Python), and is also used as a backend in web development, for web scraping and for other tasks.

On the other hand, R is more closely tied to research and science, with its origins in computational statistics. Julia is an emerging language, with a very interesting range of developments and the aim of combining the best of Python and R.

And finally, JavaScript, which like Python is used in different fields, even more of them, but in data analysis can be considered a very good tool, especially for data visualization.

There are, of course, several other languages, more niche and/or proprietary (not open source), such as Stata, Scala, SPSS, SAS and Matlab, among others. There are even lower-level languages such as Java, Rust and C/C++ that may be used in data analysis processes requiring exceptional performance (directly or through compilers).

SQL deserves a separate mention because, when it comes to using databases (for storing and querying data), it is the norm. That is, its use is unavoidable, and any job posting for data analysis roles is likely to list it as a hard requirement. Different implementations of this language can be found depending on the company or organization promoting its own database. They usually all share a common set of commands and then another set of particular commands and functions / syntax, which is quickly picked up with practice.

Further reading

Python

Other languages