Data science

How to create a Pandas DataFrame with Python in Excel (three ways)

November 20, 2023 | George Mount

Python in Excel provides a user-friendly and data analysis-optimized approach, especially suitable for general analysts beginning with Python. Notably, it defaults to loading all data inputs as Pandas DataFrames, a wise decision considering Excel users’ familiarity with tabular structures. Basic Python, on its own, isn’t inherently tailored for such ...
[...Read more...]

Cookies & Headers from Selenium

November 7, 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...]

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...]
1 43 44 45 46 47 136