Subscribe via RSS
  Looking for VBA Tutorials?

Pandas read_csv Examples for Importing Files

Oct 16, 2018

The Pandas read_csv function lets you import data from CSV and plain-text files into DataFrames. This tutorial provides several Pandas read_csv examples to show you how.

Pandas DataFrame from Dictionary, List, and List of Dicts

Oct 6, 2018

This tutorial will show you how to convert dictionaries and lists to Pandas DataFrames. We'll also explain how to create a Pandas DataFrame from a list of dicts and a list of lists.

Ultimate VBA Training Bundle

$80.00 $52.00

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

Python String Operations and String Formatting

Sep 20, 2018

This tutorial explains all the important Python string operations and Python string formatting methods. We'll discuss operations on the strings themselves, and methods of formatting output strings.

Python Exceptions Handling with Try Except Statements

Sep 15, 2018

This tutorial explores Python exceptions, or errors, and covers Python exceptions handling techniques, like the try except statement.

Python Namespaces, Variable Locations, and Scopes

Sep 7, 2018

This Python tutorial describes Python namespaces, variable scopes, and how to change the scopes of variables. Global and nonlocal statements are also discussed.

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.

Python I/O: Input and Output Examples and Tools

Aug 31, 2018

This tutorial describes Python input and output (I/O) from the terminal, using the os module, manually importing text files, using with statements, and the csv module.

Creating and Using Python Class Objects and Iterators

Aug 24, 2018

This tutorial discusses Python class objects, class constructors, Python methods, underscore naming convention, attribute name mangling, and class object inheritance.

Python Modules for Saving and Distributing Code

Aug 17, 2018

This tutorial covers Python modules, importing objects from modules, understanding the module search path, and it covers the scipy, numpy, pandas, and matplotlib modules.

Using Python Functions and Defining New Functions

Aug 3, 2018

This tutorial covers Python functions, user-defined functions, the map function, lambda functions, functions versus methods, and function objects.

Python Conditionals, Loops & Logical Operators

Jul 27, 2018

This tutorial covers Python conditionals, loops and logical operators, including basic boolean expressions, if statements, in statements, is statements, for loops, while loops, range function, and list comprehensions.

subscribe via RSS