Overview:
The mul() method of DataFrame object multiplies the elements of a DataFrame object with another DataFrame object, series or any other Python sequence.
mul() does an elementwise multiplication of a DataFrame with another DataFrame, a pandas Series or a Python Sequence.
Calling the mul() method is similar to using the binary multiplication operator(*).
The mul() method provides a parameter fill_value using which values can be passed to replace the np.nan, None values present in the data.
Example:
|
import pandas as pd
# Create data dataSet1 = [(2, 0, 1, 0), (1, 0, 3, 0), (4, 3, 2, 0)];
dataSet2 = [(1, 1, 2, 1), (1, 2, 1, 1), (3, 1, 1, 3)];
# Construct pandas DataFrame instances dataFrame1 = pd.DataFrame(data=dataSet1); dataFrame2 = pd.DataFrame(data=dataSet2);
print("Elements present in DataFrame1:"); print(dataFrame1);
print("Elements present in DataFrame2:"); print(dataFrame2);
# Multiply two DataFrames multiplicationResults = dataFrame1.mul(dataFrame2); print("Result of element-wise multiplication of two Data Frames:"); print(multiplicationResults); |
Output:
|
Elements present in DataFrame1: 0 1 2 3 0 2 0 1 0 1 1 0 3 0 2 4 3 2 0 Elements present in DataFrame2: 0 1 2 3 0 1 1 2 1 1 1 2 1 1 2 3 1 1 3 Result of element-wise multiplication of two Data Frames: 0 1 2 3 0 2 0 2 0 1 1 0 3 0 2 12 3 2 0 |