Bookmarks (15) clear filters

Automating Excel File Creation and Distribution With Pandas And Outlook See how a little bit of Python can go a long way to automating manual processes and save businesses valuable time. CHRIS MOFFITT

Reading Poorly Structured Excel Files with Pandas - Practical Business Python Raise your hand if you’ve ever had to deal with a poorly formatted Excel spreadsheet. Wow, that’s a lot of you! Did you know you can use pandas and openpyxl to read even the craziest Excel sheets? CHRIS MOFFITT

Case Study: Processing Historical Weather Pattern Data With Python This article is a case study showing how to use Python to download and process historical temperature data in order to do analysis on the relationship between air temperature and power consumption. CHRIS MOFFITT

Reading HTML Tables With Pandas The pandas read_html() function can quickly scrape data from HTML tables. Learn how to use it, as well as some techniques for cleaning HTML data. CHRIS MOFFITT

Exploring an Alternative to Jupyter Notebooks for Python Development For many people, the Jupyter Notebook has become the de facto tool for exploratory data analysis. But is it really the bee’s knees? CHRIS MOFFITT

Using WSL to Build a Python Development Environment on Windows Learn how to set-up a development environment on Windows that leverages the power of the Windows Subsystem for Linux (WSL). From installing WSL, interfacing with Windows Terminal, setting up VS Code, and even running graphical Linux apps, this comprehensive tutorial covers everything you need to know to set-up a development workflow. CHRIS MOFFITT

Python Tools for Record Linking and Fuzzy Matching Useful Python tools for linking record sets and fuzzy matching on text fields. These concepts can also be used to deduplicate data. CHRIS MOFFITT

Using Markdown to Create Responsive HTML Emails This article describes how to use Python to transform a Markdown text file into a response HTML email and static page on a Pelican blog. CHRIS MOFFITT

Effectively Using Matplotlib “Now that I have taken the time to learn some of these tools and how to use them with matplotlib, I have started to see matplotlib as an indispensable tool. This post will show how I use matplotlib and provide some recommendations for users getting started” CHRIS MOFFITT

Creating Interactive Dashboards From Jupyter Notebooks This article discusses how to build an interactive dashboard to analyze reddit content and display interactive graphs of the result using Voilà. CHRIS MOFFITT

Cleaning Up Currency Data With Pandas Tips on how to clean up messy currency data in Pandas so that you may convert the data to numeric formats for further analysis. CHRIS MOFFITT

Binning Data With Pandas qcut And cut Pandas qcut and cut are both used to bin continuous values into discrete buckets or bins. This article explains the differences between the two commands and how to use each. CHRIS MOFFITT

Build a Celebrity Look-Alike Detector With Azure’s Face Detect and Python This article describes how to use Microsoft Azure’s Face API with Python to identify faces in images and determine if they are of the same person. CHRIS MOFFITT

Evangelizing Python For Business “Five to 10 years ago, it might have been quite an uphill battle to try to bring Python into your organization to solve your business problems. With the rise of Python’s popularity in the Data Science world, you will have a much smaller hill to climb.” CHRIS MOFFITT

Styling Output in Pandas Pandas has a relatively new API for styling output. This article shows examples of using the style API. CHRIS MOFFITT