Subscribe via RSS
  Looking for VBA Tutorials?

Introduction to Seaborn Plots for Python Data Visualization

Oct 18, 2019

This tutorial introduces the Python Seaborn library for data visualization and includes Seaborn plot examples so you can see how it helps visualize Python data.

Creating Interactive Python Choropleth Maps with Plotly

Sep 7, 2019

This tutorial will show you how to create an interactive choropleth map of US States using Python and Plotly. A choropleth map is a geographic color heatmap.

Ultimate VBA Training Bundle

$100.00 $52.00

Want to learn more programming languages? We've combined each of our comprehensive VBA reference guides into a single bundle with over 180 tips and macros covering the 100 most important topics in VBA.

Create a Python Voronoi Diagram with GeoPandas and Geoplot

Aug 23, 2019

This tutorial will teach you how to create a Python Voronoi Diagram over a map of the United States using a Pandas DataFrame with GeoPandas and Geoplot.

Using Python stdin, stdout, and stderr with the sys Module

Aug 9, 2019

This tutorial will explain how to use shell standard input (stdin), standard output (stdout), and standard error (stderr) in Python programs using the sys module.

Using Command Line Arguments with Python sys.argv

Jul 26, 2019

This tutorial describes how to use command line arguments passed to a Python script execution with the sys module's argv list.

Mouse to Macro Excel Add-in


Use Excel to record your mouse clicks and cursor movements and convert them directly into VBA macros so you can easily automate complex tasks, like copying data from a website.

Grouping DataFrame Data with the Pandas groupby Operation

Jul 12, 2019

Use the Python Pandas groupby operation to group and aggregate data in a DataFrame. The Pandas groupby operation can group data by a single or multiple columns.

Using Python Regex Groups to Capture Substrings

Jun 28, 2019

This tutorial describes how to use Python Regex Groups to capture a substring or submatch, and it describes how to refer to a group's substring inside a regex.

Exporting DataFrames to Excel with Pandas ExcelWriter

Jun 14, 2019

This tutorial will teach you how to export a Pandas DataFrames to a Microsoft Excel spreadsheet using the to_excel and Pandas ExcelWriter functions.

Understanding Python Regex Matching

Jun 7, 2019

Understanding Python Regex (concatenation, alternation, and repetition) and how to use the Python re module to match strings and byte sequences to a regular expression.

Making New Collations with Python SQLite create_collation

May 24, 2019

Learn how to make your own collations, or collate sequences, with the Python SQLite3 create_collation method. We will also describe the predefined collations.

subscribe via RSS