|
Since the code will be launched from excel, you won't necessarily need an editor, but you will need to download python. At the time of installation, check from the beginning the addition of python.exe in the windows PATH.
You will also need to have the libraries to declare: pandas, seaborn, matplotlib. You will be able to use the "pip install pandas" statement, etc. in your command prompt to retrieve the libraries.
It is necessary to also load openpyxl to open excel files.
For some charts, you will also need to download other libraries: for example, scipy for hierarchical trees and statsmodels for linear regressions that deflect points (robust=True).
In summary:
Install Python by checking the addition in the PATH variable.
Download libraries: pandas ; openpyxl; Seaborn; scipy; statsmodels
|
Up