Problem Formulation and Solution Overview This article will show you how to find DataFrame row indices in Python with NaN or Null (empty) values. To make it more interesting, we have the following scenario: Rivers Clothing has given you a CSV file that requires a clean-up to make it usable for Payroll and Data Analysis. … Read more
Problem Formulation 💬 How to print a list without quotes in Python? Given a Python list of strings such as [‘1’, ‘2’, ‘3’]. If you print the list to the shell using print([‘1’, ‘2’, ‘3’]), the output is enclosed in square brackets and the strings have quotes like so: “[‘1’, ‘2’, ‘3’]”. This article will … Read more
Problem Formulation Given a Python list of elements. If you print the list to the shell using print([1, 2, 3]), the output is enclosed in square brackets and separated by commas like so: “[1, 2, 3]”. But you want the list without brackets and commas like so: 1 2 3. How to print the list … Read more
Use the tuple concatenation operation * with a tuple with one element (42,) as a right operand and the number of repetitions of this element as a left operand. For example, the expression (42,) * n creates the tuple (42, 42, 42, 42, 42) for n=5. Let’s play with an interactive code shell before you’ll … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to print a string and an integer together in Python. To make it more fun, we have the following running scenario: The Finxter Academy has decided to send its users an encouraging message using their First Name (a String) and Problems Solved (an Integer). … Read more
Use Python’s built-in min() function with a key argument to find the shortest string in a list. Call min(lst, key=len) to return the shortest string in lst using the built-in len() function to associate the weight of each string—the shortest string will be the minimum. Problem Formulation Given a Python list of strings. Find the … Read more
Problem Formulation and Solution Overview This article will show you how to convert a single Integer into a List in Python. Python has several built-in Data Type Structures: one of them being a List. The List Data Structure is made up of square brackets ([]) containing elements separated by a comma (,). These elements can … Read more
Use Python’s built-in max() function with a key argument to find the longest string in a list. Call max(lst, key=len) to return the longest string in lst using the built-in len() function to associate the weight of each string—the longest string will be the maximum. Problem Formulation Given a Python list of strings. Find the … Read more
Problem Formulation Given the following DataFrame df: 💬 Challenge: How to apply a function f to each cell in the DataFrame? For example, you may want to apply a function that replaces all odd values with the value ‘odd’. Solution: DataFrame applymap() The Pandas DataFrame df.applymap() method returns a new DataFrame where the function f … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to ignore (upper/lower/title) case characters when dealing with Strings in Python. The main reason for ignoring the case of a String is to perform accurate String comparisons or to return accurate search results. For example, the following three (3) Strings are not identical. If … Read more
Given an HTML table (code) in a file or at a given URL. First, load all HTML tables into the Python script by calling Pandas’ pd.read_html() passing the URL of the HTML document. The result is a list of DataFrames, one per HTML table in the document. Second, convert any specific DataFrame to a CSV … Read more
The Pandas read_html() function is an easy way to convert an HTML table (e.g., stored at a given URL) to a Pandas DataFrame. You pass a location string or path to it and it returns a list of DataFrames, each representing one table from the location path or URL. The following code, for example, reads … Read more