Kat McKelvieProblem Formulation and Solution Overview In this article, you’ll learn how to print the contents of a List without surrounding brackets in Python. To make it more fun, we have the following running scenario: You are a student and need to memorize the first 10 elements in the Periodic Table. This data is currently saved … Read more
Problem Formulation and Solution Overview This article will show you how to count duplicates in a Pandas DataFrame in Python. To make it more fun, we have the following running scenario: Rivers Clothing has a CSV containing all its employees. However, their CSV file has more rows than employees. This is a definite problem! They … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to check a List for Duplicates in Python. To make it more fun, we have the following running scenario: The Finxter Academy has given you an extensive list of usernames. Somewhere along the line, duplicate entries were added. They need you to check if … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to extract numbers from a string in Python. To make it more fun, we have the following running scenario: This article references an Albanian proverb written by Driton Selmani in 2012. We will leave the interpretation up to you. 💬 Question: How would we … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to add a new column to a CSV file in Python. To make it more fun, we have the following running scenario: The owner of the Finxter Academy has asked you to add a new column to their existing CSV file called Total_Chrgs. 💬 … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to Sum Dictionary Values in Python. To make it more fun, we have the following running scenario: As a Python Freelancer, you would like to know how much money you made over the past few months. This data is stored in a Dictionary format. … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to access a Dictionary key by index in Python. To make it more fun, we have the following running scenario: Rivers Clothing has a list of Employees. They would like to find the name of their youngest staff member. They know this person is … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to count the number of vowels in a string. To make it more fun, we have the following running scenario: In Canada, we have a province called Saskatchewan. This province has a large amount of flat land. In this article, we reference their local … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to find the maximum value in a Python dictionary. To make it more fun, we have the following running scenario: You are in the market for a car and have narrowed the search to a few possibilities. Your final choice will be based on … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to split a string into a List of Letters in Python. To make it more fun, we have the following running scenario: The Finxter Academy would like a text version of their logo by splitting the string into a List of Elements and applying … Read more
Preparation Before any data manipulation can occur, four (4) 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 to a collection of mathematical functions. The pandas_gbq allows access to Google Big Query (GBQ) The google.auth authentication. To install these libraries, navigate … Read more
This article focuses on the serialization and conversion methods of a Python DataFrame: to_gbq(), to_coo(). Let’s get started! Preparation Before any data manipulation can occur, four (4) 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 to a collection of mathematical … Read more