Master Pandas Series arithmetic & data conversion for efficient ML preprocessing. Learn vectorized operations & Python data type transformations.

Pandas Series: Arithmetic Operations and Data Conversion

This document provides a comprehensive guide to performing arithmetic operations and converting Pandas Series objects into various Python data formats. Pandas Series is a fundamental, one-dimensional labeled data structure that supports efficient handling of diverse data types like integers, floats, and strings. Its vectorized arithmetic operations enable calculations across entire datasets without explicit loops, and its conversion methods facilitate flexible data manipulation and analysis.

Arithmetic Operations on Pandas Series

Pandas Series supports powerful arithmetic operations, which are executed element-wise.

Vectorized Arithmetic with Scalar Values

You can directly apply arithmetic operations between a Pandas Series and a scalar value. These operations are performed on each element of the Series. The supported operations include addition, subtraction, multiplication, division, exponentiation, modulus, and floor division.

Operation	Syntax	Example Description
Addition	`+`	Adds a scalar to each element in the Series.
Subtraction	`-`	Subtracts a scalar from each element.
Multiplication	`*`	Multiplies each element by a scalar.
Division	`/`	Divides each element by a scalar.
Exponentiation	`**`	Raises each element to the power of a scalar.
Modulus	`%`	Computes the remainder when each element is divided by a scalar.
Floor Division	`//`	Performs division and rounds down the result to the nearest integer.

Example: Arithmetic Operations with a Scalar

import pandas as pd

# Create a Pandas Series
s = pd.Series([1, 2, 3, 4, 5], index=['a', 'b', 'c', 'd', 'e'])

print("Input Series:\n", s)

# Apply arithmetic operations
print("\nAddition:\n", s + 2)
print("\nSubtraction:\n", s - 2)
print("\nMultiplication:\n", s * 2)
print("\nDivision:\n", s / 2)
print("\nExponentiation:\n", s ** 2)
print("\nModulus:\n", s % 2)
print("\nFloor Division:\n", s // 2)

Output:

Input Series:
 a    1
b    2
c    3
d    4
e    5
dtype: int64

Addition:
a    3
b    4
c    5
d    6
e    7
dtype: int64

Subtraction:
a   -1
b    0
c    1
d    2
e    3
dtype: int64

Multiplication:
a     2
b     4
c     6
d     8
e    10
dtype: int64

Division:
a    0.5
b    1.0
c    1.5
d    2.0
e    2.5
dtype: float64

Exponentiation:
a     1
b     4
c     9
d    16
e    25
dtype: int64

Modulus:
a    1
b    0
c    1
d    0
e    1
dtype: int64

Floor Division:
a    0
b    1
c    1
d    2
e    2
dtype: int64

Arithmetic Operations Between Two Pandas Series

Pandas enables arithmetic operations between two Series by automatically aligning them based on their index labels. If an index label exists in one Series but not the other, the resulting operation for that label will yield NaN (Not a Number).

Example: Arithmetic Between Two Series

import pandas as pd

s1 = pd.Series([1, 2, 3, 4, 5], index=['a', 'b', 'c', 'd', 'e'])
s2 = pd.Series([9, 8, 6, 5], index=['x', 'a', 'b', 'c'])

print("Series 1:\n", s1)
print("\nSeries 2:\n", s2)

print("\nAddition:\n", s1 + s2)
print("\nSubtraction:\n", s1 - s2)
print("\nMultiplication:\n", s1 * s2)
print("\nDivision:\n", s1 / s2)

Output:

Series 1:
 a    1
b    2
c    3
d    4
e    5
dtype: int64

Series 2:
 x    9
a    8
b    7
c    6
dtype: int64

Addition:
a    9.0
b    9.0
c    9.0
d    NaN
e    NaN
x    NaN
dtype: float64

Subtraction:
a   -7.0
b   -5.0
c   -3.0
d    NaN
e    NaN
x    NaN
dtype: float64

Multiplication:
a     8.0
b    14.0
c    18.0
d     NaN
e     NaN
x     NaN
dtype: float64

Division:
a    0.125000
b    0.285714
c    0.500000
d         NaN
e         NaN
x         NaN
dtype: float64

Converting Pandas Series to Other Data Formats

Converting a Pandas Series to different formats is a common task for integration with other libraries or workflows. Pandas provides several convenient methods for this purpose.

1. Convert Series to Python List

The .to_list() method converts a Series into a Python list, preserving the data types of its elements.

Example:

import pandas as pd

s = pd.Series([1, 2, 3])
result_list = s.to_list()

print("Output:", result_list)
print("Type:", type(result_list))

Output:

Output: [1, 2, 3]
Type: <class 'list'>

2. Convert Series to NumPy Array

The .to_numpy() method converts a Series into a NumPy ndarray. This method offers options to specify the data type and handle missing values.

Example:

import pandas as pd
import numpy as np

s = pd.Series([1, 2, 3])
result_array = s.to_numpy()

print("Output:", result_array)
print("Type:", type(result_array))
print("Data Type:", result_array.dtype)

Output:

Output: [1 2 3]
Type: <class 'numpy.ndarray'>
Data Type: int64

3. Convert Series to Dictionary

Use the .to_dict() method to convert a Series into a Python dictionary. The Series' index labels become the dictionary's keys, and the corresponding Series values become the dictionary's values.

Example:

import pandas as pd

s = pd.Series([1, 2, 3], index=['a', 'b', 'c'])
result_dict = s.to_dict()

print("Output:", result_dict)
print("Type:", type(result_dict))

Output:

Output: {'a': 1, 'b': 2, 'c': 3}
Type: <class 'dict'>

4. Convert Series to DataFrame

The .to_frame() method converts a Series into a DataFrame, with the Series occupying a single column. You can specify the column name using the name parameter.

Example:

import pandas as pd

s = pd.Series([1, 2, 3], index=['a', 'b', 'c'])
result_df = s.to_frame(name='Numbers')

print("Output:\n", result_df)
print("Type:", type(result_df))

Output:

Output:
   Numbers
a        1
b        2
c        3
Type: <class 'pandas.core.frame.DataFrame'>

5. Convert Series to String

The .to_string() method provides a string representation of the entire Series, including its index and values. This is particularly useful for display purposes or when exporting Series content as plain text.

Example:

import pandas as pd

s = pd.Series([1, 2, 3], index=['r1', 'r2', 'r3'])
result_string = s.to_string()

print("Output:", repr(result_string))
print("Type:", type(result_string))

Output:

Output: 'r1    1\nr2    2\nr3    3'
Type: <class 'str'>

Conclusion

Pandas Series offers robust capabilities for performing efficient arithmetic operations, both with scalar values and between Series objects, leveraging automatic index alignment. Furthermore, it provides straightforward methods to convert Series into various Python data structures, ensuring flexibility in data processing and interoperability with other libraries. Mastering these operations and conversions significantly enhances data manipulation efficiency and boosts coding productivity when working with Pandas.

Pandas Series: Arithmetic & Data Conversion for ML

Pandas Series: Arithmetic Operations and Data Conversion

Arithmetic Operations on Pandas Series

Vectorized Arithmetic with Scalar Values

Example: Arithmetic Operations with a Scalar

Arithmetic Operations Between Two Pandas Series

Example: Arithmetic Between Two Series

Converting Pandas Series to Other Data Formats

1. Convert Series to Python List

Example:

2. Convert Series to NumPy Array

Example:

3. Convert Series to Dictionary

Example:

4. Convert Series to DataFrame

Example:

5. Convert Series to String

Example:

Conclusion

On this page