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

Handling Missing Data in Pandas: isna(), isnull(), notna(), notnull(), pad(), replace()

by

The Pandas DataFrame/Series has several methods to handle Missing Data. When applied to a DataFrame/Series, these methods evaluate and modify the missing elements. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition … Read more

­­Handling Missing Data in Pandas: backfill(), bfill(), fillna(), dropna(), interpolate()

by

The Pandas DataFrame/Series has several methods to handle Missing Data. When applied to a DataFrame/Series, these methods evaluate and modify the missing elements. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition … Read more

Pandas reset_index(), sample(), set_axis(), set_index(), take(), truncate()

by

The Pandas DataFrame has several Re-indexing/Selection/Label Manipulations methods. When applied to a DataFrame, these methods evaluate, modify the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition … Read more

Pandas DataFrame Methods: idxmax(), idxmin(), reindex(), reindex_like(), rename(), rename_axis() – Part 9

by

The Pandas DataFrame has several Reindexing/Selection/Label Manipulations methods. When applied to a DataFrame, these methods evaluate, modify the elements and return the results. This is Part 9 of the DataFrame methods series: Part 1 focuses on the DataFrame methods abs(), all(), any(), clip(), corr(), and corrwith(). Part 2 focuses on the DataFrame methods count(), cov(), … Read more

Pandas DataFrame Methods equals(), filter(), first(), last(), head(), and tail()

by

The Pandas DataFrame has several Re-indexing/Selection/Label Manipulations methods. When applied to a DataFrame, these methods evaluate, modify the elements and return the results. Preparation Before any data manipulation can occur, one (1) new library will require installation: The Pandas library enables access to/from a DataFrame. To install this library, navigate to an IDE terminal. At … Read more

Pandas DataFrame Time, Drop, and Duplicates

by

The Pandas DataFrame has several Re-indexing/Selection/Label Manipulations methods. When applied to a DataFrame, these methods evaluate, modify the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition … Read more

­­Pandas add_prefix(), add_suffix(), align()

by

The Pandas DataFrame has several Re-indexing/Selection/Label Manipulations methods. When applied to a DataFrame, these methods evaluate, modify the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition … Read more

Pandas pct_change(), quantile(), rank(), round(), prod(), product()

by

The Pandas DataFrame has several methods concerning Computations and Descriptive Stats. When applied to a DataFrame, these methods evaluate the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices … Read more

Pandas mad(), min(), max(), mean(), median(), and mode()

by

The Pandas DataFrame has several methods concerning Computations and Descriptive Stats. When applied to a DataFrame, these methods evaluate the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices … Read more

­Pandas DataFrame describe(), diff(), eval(), kurtosis()

by

The Pandas DataFrame has several methods concerning Computations and Descriptive Stats. When applied to a DataFrame, these methods evaluate the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices … Read more

­Pandas Methods count(), cov() & cumX()

by

The Pandas DataFrame has several methods concerning Computations and Descriptive Stats. When applied to a DataFrame, these methods evaluate the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices … Read more

­Pandas DataFrame abs(), all(), any(), clip(), corr()

by

The Pandas DataFrame has several methods concerning Computations and Descriptive Stats. When applied to a DataFrame, these methods evaluate the elements and return the results. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices … Read more