Microsoft Excel is a cross-platform and battle-tested spreadsheet software widely used for data analysis and visualization. It is a powerful and user-friendly tool indeed! But how can we bring it to the next level? We can combine Excel with Python to read data from Excel, save data to Excel with formats, formulas, and even charts, … Read more
Overview Problem: How to check if a given value is NaN? Here’s a quick look at the solutions to follow: So, what is a NaN value? NaN is a constant value that indicates that the given value is Not a Number. It’s a floating-point value, hence cannot be converted to any other type other than … Read more
Problem Formulation and Solution Overview As a Pythonista, coding issues may occur where you need to apply a function against array/matrix elements. To make it more fun, we have the following running scenario: The organization Happy Mortgages has six (6) different Mortgage Terms available: 30-Year, 20-Year, 15-Year, 10-Year, 7-Year, and 5-Year terms. The US Federal … Read more
Problem Formulation and Solution Overview As a Python Coder, situations arise where you will need to apply a function against elements of a Series. To make it more fun, we have the following running scenario: Rivers Clothing does business with six (6) different countries. The Tax Rates for the associated countries have increased by 2%. … Read more
Problem Formulation and Solution Overview As a Python Coder, situations arise where you will need to apply a function against elements of a DataFrame Column. To make it more fun, we have the following running scenario: You have a DataFrame containing user information (including the column Recurring). This column is the Monthly Fee for a … Read more
Microsoft Excel is a cross-platform and battle-tested spreadsheet software widely used for data analysis and visualization. It is a powerful and user-friendly tool indeed! But how can we bring it to the next level? We can combine Excel with Python to read data from Excel, save data to Excel with formats, formulas, and even charts, … Read more
Related Article: Keras Developer — Income and Opportunity PyTorch Developer — Income and Opportunity Before we learn about the money, let’s get this question out of the way: What Is TensorFlow? Let’s have a look at the definition from the official TensorFlow website: “An end-to-end open source machine learning platform. The core open source library … Read more
Before we learn about the money, let’s get this question out of the way: What Is Apache Spark? Let’s have a look at the definition from the official Apache Spark website: “Apache Spark™ is a multi-language engine for executing data engineering, data science, and machine learning on single-node machines or clusters. Apache Spark™ is built … Read more
Summary: The following approaches will help you to fill a column with one value in Pandas: df[‘col_name’] = “value” df.insert(index, ‘col_name’, ‘value’) df.loc[:, ‘col_name’] = ‘value’ df = df.assign(‘col_name’=’value’) Introduction Problem Formulation: How do I fill a column with one value in Pandas? Example: Let’s consider that we have a DataFrame as shown below: Output: … Read more
Before we learn about the money, let’s get this question out of the way: What Is Pandas? Let’s have a look at the definition from the official Pandas website: “pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool, built on top of the Python programming language.” 💡 … Read more
Summary: df2 = pd.DataFrame(index=df1.index) can be used to to create an empty DataFrame. It will not have any columns but just an index which is the same as in the already given DataFrame, i.e., df1. Introduction Problem Statement: How to create an empty data frame with an index from another data frame? Example: Let’s consider … Read more
Overview This article will be a tutorial on how to merge two pandas dataframes. Often data might be stored in multiple places. Two or more dataframes containing different data but with a common denominator, and there is a need to merge these dataframes to get all the data into one dataframe Pandas offer a handy … Read more