• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Programming Expert

Solving All of Your Programming Headaches

  • HTML
  • JavaScript
  • jQuery
  • PHP
  • Python
  • SAS
  • Ruby
  • About
You are here: Home / Python / pandas product – Get Product of Series or DataFrame Columns

pandas product – Get Product of Series or DataFrame Columns

January 19, 2022 Leave a Comment

To find the product of the values in columns in a DataFrame, or the product of the values of a Series in pandas, the easiest way is to use the pandas prod() function.

df.prod() # Calculate products for all columns
df["Column"].prod() #calculate product for 1 column

The pandas product() function is equivalent to the pandas prod() function.

You can also use the numpy prod() function.

np.prod(df["Column"]) #calculate sum for 1 column

When working with data, many times we want to calculate summary statistics to understand our data better. One such statistic is the product, or the multiplicative total of a list of numbers.

Finding the product of a column, or the product for all columns in a DataFrame using pandas is easy. We can use the pandas prod() function to find the total of a column of numbers, or a DataFrame.

Let’s say we have the following DataFrame.

df = pd.DataFrame({'Age': [43,23,71,49,52,37], 
      'Test_Score':[90,87,92,96,84,79]})

print(df)
# Output: 
   Age  Test_Score
0   43          90
1   23          87
2   71          92
3   49          96
4   52          84
5   37          79

To get the product for all columns, we can call the pandas prod() function.

print(df.prod())

# Output:
Age             6619966444
Test_Score    458909660160
dtype: int64

If we only want to get the product of just one column, we can do this using the pandas prod() function in the following Python code:

print(df["Test_Score"].prod())

# Output:
458909660160

If you want to see how the product is calculated step by step, you can use the pandas cumprod() function and return a Series for each column with the cumulative product at each point.

Using numpy prod to Calculate a Product in pandas DataFrame

We can also use the numpy prod() function to calculate the product of the numbers in a column in a pandas DataFrame.

To get the product of the numbers in the column “Test_Score”, we can use the numpy prod() function in the following Python code:

print(np.prod(df["Test_Score"]))

# Output:
458909660160

As you can see above, this is the same value we received from the pandas prod() function.

Hopefully this article has been helpful for you to understand how to find the product of numbers in a Series or DataFrame in pandas.

Other Articles You'll Also Like:

  • 1.  Using Python to Split String into Dictionary
  • 2.  pandas ceil – Find the Ceiling of a Column Using Numpy ceil
  • 3.  How to Write Python Dictionary to File
  • 4.  Count Number of Keys in Dictionary in Python
  • 5.  How to Check If File is Empty with Python
  • 6.  Using pandas sample() to Generate a Random Sample of a DataFrame
  • 7.  math gcd Python – Find Greatest Common Divisor with math.gcd() Function
  • 8.  How to Divide Two Numbers in Python
  • 9.  PROC REG Equivalent in Python
  • 10.  Python sin – Find Sine of Number in Radians Using math.sin()

About The Programming Expert

The Programming Expert is a compilation of a programmer’s findings in the world of software development, website creation, and automation of processes.

Programming allows us to create amazing applications which make our work more efficient, repeatable and accurate.

At the end of the day, we want to be able to just push a button and let the code do it’s magic.

You can read more about us on our about page.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

About The Programming Expert

the programming expert main image

Welcome to The Programming Expert. We are a group of US-based programming professionals who have helped companies build, maintain, and improve everything from simple websites to large-scale projects.

We built The Programming Expert to help you solve your programming problems with useful coding methods and functions in various programming languages.

Search

Learn Coding from Experts on Udemy

Looking to boost your skills and learn how to become a programming expert?

Check out the links below to view Udemy courses for learning to program in the following languages:

Copyright © 2023 · The Programming Expert · About · Privacy Policy