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

Python Input/Output – JSON

by

Over your career as a Data Scientist, there may be instances where you will work with data to/from a DataFrame to JSON 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 list of all parameters … Read more

Python Input/Output – The Clipboard

by

Over your career as a Data Scientist, there may be instances where you will work with data to/from the system Clipboard. This article shows you how to manipulate this data. 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 … Read more

Python Pandas Input/Output – Flat File

by

Over your career as a Pythonista, there may be instances where you will work with Flat Files. This file type is an ASCII character-based file, usually with commas (,) separating the fields. Other common field separators are the following: Semi-colon (;) Tab character (\t) Colon (:) and so on. This article covers the commonly used … Read more

Python Pandas Input/Output – Pickling

by

If you are leaning towards a career as a Data Scientist or just a coder looking to expand your skillset, the art of pickling is a must-have. This article focuses on creating, saving, and reading various object types to/from a pickle file. Syntax pandas.read_pickle(filepath_or_buffer, compression=’infer’, storage_options=None) The return value is an unpickled object of the … Read more

Python Working with the Pandas DataFrame & MySQL – Part 3

by

Background & Preparation Part 3 of this series centers around creating a MySQL table and inserting records from the CSV file referenced in Part 2. Working with MySQL is a must-have if you are interested in pursuing a career as a Data Scientist. After completing Part 2, you should be comfortable: Connecting to a Localhost/Server … Read more

Python Working with the Pandas DataFrame & MySQL – Part 2

by

Background Part 2 of this series centers around running more complex MySQL queries. This skill is a must-have if you are interested in pursuing a career as a Data Scientist. After completing Part 1 of this series, you should be comfortable: Installing Libraries Downloading and saving a CSV file from the web. Creating a Pandas … Read more

Python Working with the Pandas DataFrame & MySQL – Part 1

by

Background To provide a solid understanding of data manipulation using the Pandas DataFrame and MySQL, the Finxter Academy has created a 3-part series to take the user from beginner to advanced. This article assumes you have access to a localhost/server with MySQL. Part 2 and Part 3 also assumes you possess the login credentials with … Read more

Python Named Tuple Methods

by

Background Python’s namedtuple() is an integral part of the Collections library and an immutable container type. Values, once set, can not be modified. You can access values by referencing them via the index or name attribute. The namedtuple() work similar to tuples. However, namedtuple() has additional functionality. This article touches on a few of these … Read more

Python requests.get() – The Ultimate Guide

by

Syntax requests.get(url, args) You can replace args with one or more of the following arguments, comma-separated: Parameter Description url Required The URL of the request params Optional Send data using a URL query string. Dictionary, list of tuples, or bytes. allow_redirects Optional By default, True: allowing redirects. If False, the code prevents redirection to another … Read more

Python Requests Library – Exception Handling & Advanced request.get() Parameters

by

This is the first part of a 3-part series on the Python request library: Python Requests Library – Your First HTTP Request in Python Python Requests Library – Understanding requests.get() Parameters Python Requests Library – Exception Handling & Advanced request.get() Parameters Syntax Background & Preparation The Requests library has several methods for GET. Part 1 … Read more

Python Requests Library – Understanding requests.get()

by

This is the first part of a 3-part series on the Python request library: Python Requests Library – Your First HTTP Request in Python Python Requests Library – Understanding requests.get() Parameters Python Requests Library – Exception Handling & Advanced request.get() Parameters Syntax requests.nameofmethod(parameters) Background and Preparation The Requests library has several options for GET. Part … Read more

Python Requests Library – Your First HTTP Request in Python

by

This is the first part of a 3-part series on the Python request library: Python Requests Library – Your First HTTP Request in Python Python Requests Library – Understanding requests.get() Parameters Python Requests Library – Exception Handling & Advanced request.get() Parameters Syntax Background There are many libraries around that make HTTP requests. However, the requests … Read more