How to navigate common pitfalls with using Python in Excel

November 5, 2023 | George Mount

In an earlier post, I discussed typical challenges Excel users face when transitioning to Python: This article will explore the unique “gotchas” that arise specifically when integrating Python in Excel. Importing packages Python packages are crucial for streamlined and clear data analysis. Many standard data-related Python packages come pre-installed in ...
[...Read more...]

Python for Excel users: How to avoid common pitfalls

November 5, 2023 | George Mount

As an Excel trainer with a focus on data analytics, I have instructed thousands of spreadsheet users in Python. This extensive experience has allowed me to analyze patterns in the learning process. Below are several frequent errors and misconceptions I’ve observed, especially among Excel users, who often approach problems ... [...Read more...]

Cookies & Headers from Selenium

October 31, 2023 | Python - datawookie

One of my standard approaches to scraping content from a dynamic website is to diagnose the API behind the site and then use it to retrieve data directly. This means that I can make efficient HTTP requests using the requests package and I don’t need to worry about all ...
[...Read more...]

Custom OpenAI Chatbot Pt1: PDF scanning

October 30, 2023 | Mark Edney

Photo by Levart_Photographer on Unsplash Introduction I have recently completed a project at work, the creation of a custom ChatGPT chatbot. I will break the project into two parts, the first part will scan a folder of PDF files into a data...
[...Read more...]

Custom OpenAI Chatbot Pt1: PDF scanning

October 30, 2023 | Mark Edney

Photo by Levart_Photographer on Unsplash Introduction I have recently completed a project at work, the creation of a custom ChatGPT chatbot. I will break the project into two parts, the first part will scan a folder of PDF files into a data...
[...Read more...]
1 31 32 33 34 35 123