Kat McKelvie

At university, I found my love of writing and coding. Both of which I was able to use in my career.During the past 15 years, I have held a number of positions such as:In-house Corporate Technical Writer for various software programs such as Navision and Microsoft CRM Corporate Trainer (staff of 30+) Programming Instructor Implementation Specialist for Navision and Microsoft CRM Senior PHP Coder

Pandas DataFrame GroupBy and Window – Part 2

by

The Pandas DataFrame has several Function Applications, GroupBy & Window methods. When applied to a DataFrame, these methods modify the output of a DataFrame. Part 2 of this series focuses on GroupBy & Window methods and delves into each item listed above. Preparation Before any data manipulation can occur, two (2) new libraries will require … Read more

Pandas DataFrame Function Application – Part 1

by

The Pandas DataFrame has several Function Applications, GroupBy & Window methods. When applied to a DataFrame, these methods modify the output of a DataFrame. Part 1 of this series focuses on Function Applications and delves into each of the following methods. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. … Read more

Pandas DataFrame Comparison Operators and Combine – Part 3

by

The Pandas DataFrame has several binary operator methods. When applied to a DataFrame, these methods combine two DataFrames and return a new DataFrame with the appropriate result. This is Part 3 of the following series on Pandas DataFrame operators: Part 1: Pandas DataFrame Arithmetic Operators Part 2: Pandas DataFrame Reverse Methods Part 3: Pandas DataFrame … Read more

Python DataFrame Reverse Methods – Part 2

by

The Pandas DataFrame has several binary operator methods. When applied to a DataFrame, these methods combine two DataFrames and return a new DataFrame with the appropriate result. This is Part 2 of the following series on Pandas DataFrame operators: Part 1: Pandas DataFrame Arithmetic Operators Part 2: Pandas DataFrame Reverse Methods Part 3: Pandas DataFrame … Read more

Pandas DataFrame Arithmetic Operators – Part 1

by

The Pandas DataFrame has several binary operator methods. When applied to a DataFrame, these methods combine two DataFrames and return a new DataFrame with the appropriate result. This is Part 1 of the following series on Pandas DataFrame operators: Part 1: Pandas DataFrame Arithmetic Operators Part 2: Pandas DataFrame Reverse Methods Part 3: Pandas DataFrame … Read more

Pandas DataFrame Methods

by

The Pandas DataFrame is a data structure that organizes data into a two-dimensional format. If you are familiar with Excel or Databases, the setup is similar. Each DataFrame contains a schema that defines a Column (Field) Name and a Data Type.   This article delves into the methods available for DataFrame Iteration. This article also … Read more

Pandas DataFrame Indexing

by

The Pandas DataFrame is a data structure that organizes data into a two-dimensional format. If you are familiar with Excel or Databases, the setup is similar. Each DataFrame contains a schema that defines a Column (Field) Name and a Data Type.   This article delves into the methods available for DataFrame Indexing. This article also … Read more

Pandas DataFrame Conversion

by

The Pandas DataFrame is a data structure that organizes data into a two-dimensional format. If you are familiar with Excel or Databases, the setup is similar. Each DataFrame contains a schema that defines a Column (Field) Name and a Data Type. Below is the Database Schema for our Hockey Teams example. This article delves into … Read more

A Guide to XML with Pandas

by

XML stands for Extensible Mark-Up Language. This language is another way to store data. Python can parse, modify and store this file with the appropriate libraries installed. This article covers the commonly used parameters for each function listed above. For a complete list of all parameters and their use, click here. Preparation Before any data … Read more

Pandas Read and Write HTML Files

by

Over your career as a Data Scientist or a Web Scraper, there may be instances where you will work with data to/from a DataFrame to HTML format.  This article shows you how to manipulate this data using the above functions. This article covers the commonly used parameters for each function listed above. For a complete … Read more