How to Extract Numbers from a String

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

How to Add a Column to a CSV

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

How to Access a Dictionary Key by Index

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

How to Count Vowels in a String

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

How to Find Max Value in Dictionary

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

Pandas DataFrame to_coo() Method

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

Pandas DataFrame to_gbq() Method

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