The recent incorporation of Python into Excel marks a substantial leap in data analytics, combining Python’s powerful features with the accessible Excel workbook interface. Employing Python directly within Excel’s formula bar is noteworthy, yet add-ins further enrich this capability. This enhancement is particularly important considering that Python programming ...

I’m not sure about your experience, but personally find Excel’s charting features antiquated at times. They can be quite finicky to use, particularly when it comes to customization. Iterating between various plots and executing tasks like combining different plot types or coloring by group proves to be challenging. ...

The Python in Excel environment is notably user-friendly, especially for those accustomed to Excel. It resonates with users familiar with writing formulas and functions in Excel cells, as this is precisely the approach Python in Excel adopts. However, Python workflows differ from those in Excel. Rather than relying on interdependent ...

I’ve long advocated for Excel users to enhance their skills by learning some Python. In fact, I’m so passionate about this idea that I authored a book on how Excel users can embrace Python. However, I recognize the hesitation. Python isn’t just another application where you can ...

Photo by Google DeepMind Introduction This is a continuation from a previous post about creating a custom ChatGPT bot with Langchain. From the previous post, we have created a CSV file which contains the text captured from a folder full of ...

Photo by Google DeepMind Introduction This is a continuation from a previous post about creating a custom ChatGPT bot with Langchain. From the previous post, we have created a CSV file which contains the text captured from a folder full of ...

All of our public training courses for the first half of 2024 are now open for registration! Head over to the public courses page on our website to book in and start building your programming skills in the new year! Below is a list of all of our ...

The concept of objects significantly distinguishes Python from Excel, enhancing its importance in programming. Integrating Python objects into Excel introduces unique behaviors and functionalities, which will be the focal point of this blog post. Download the following to explore this intriguing intersection of Python and Excel.   We’ll begin the ...

Data Analytics allows researchers to optimise the process of collecting processing and analysing data. Ensuring that you have collected quality data from reputable sources improves the data resources you have at hand when you are developing conclusions based on the data you have collected. If you want inspiration you should ...

Today we continue the saga on gradient boosting with a down-to-Earth tutorial on the essentials of solving classification problems with XGBoost. We’ll run through two examples: one for binary classification and another for multi-class classificati...