Typeerror object of type series is not json serializable

In this article, we will walk you through how to solve the “typeerror object of type series is not json serializable” error message.

We can’t deny the fact that if you are a developer or programmer, you will always encounter such errors.

And one of them is “object of type series is not json serializable.”

But before we jump into the solutions, let’s have a better understanding with regards to this error.

What is “typeerror object of type series is not json serializable”?

The “typeerror: object of type series is not json serializable” is an error message that is raised when you’re trying to convert a Pandas Series object into a JSON format.

However, it is not possible because JSON serialization does not support the Series data type.

JSON serialization is the process of converting a Python object into a JSON string, and not all Python objects can be converted to JSON.

How to fix “typeerror object of type series is not json serializable”?

To fix this “object of type series is not json serializable you have to convert the Series object into a format that can be serialized into JSON, such as a Python list or dictionary, before converting it to JSON.

You can do this using the tolist() or to_dict() methods provided by Pandas.

Then you can convert the resulting object into JSON using the json.dumps() method.

1. Convert the series using tolist() method

You have to convert the Pandas Series object into a Python list using the tolist() method provided by Pandas.

Then serialize the resulting list into a JSON string using the json.dumps() method provided by Python’s built-in json module.

import pandas as pd
import json

data = pd.Series([10, 20, 30, 40, 50])

# Convert Series to list
data_list = data.tolist()

# Serialize list to JSON
json_data = json.dumps(data_list)

print(json_data)

Output:

[10, 20, 30, 40, 50]

2. Convert the series using to_dict() method

You can also convert the Pandas Series object into a Python dictionary using the to_dict() method provided by Pandas.

Then serialize the resulting dictionary into a JSON string using the json.dumps() method provided by Python’s built-in json module.

import pandas as pd
import json

data = pd.Series([10, 20, 30, 40, 50])

# Convert Series to dictionary
data_dict = data.to_dict()

# Serialize dictionary to JSON
json_data = json.dumps(data_dict)

print(json_data)

Output:

{"0": 10, "1": 20, "2": 30, "3": 40, "4": 50}

3. Use the json.JSONEncoder class to create a custom encoder that can handle the Series object

You have to define a custom encoder class that extends the JSONEncoder class provided by Python’s built-in json module.

Override the default() method of the class to handle the Pandas Series data type by converting it to a Python list using the tolist() method provided by Pandas.

import pandas as pd
import json

class CustomEncoder(json.JSONEncoder):
    def default(self, obj):
        if isinstance(obj, pd.Series):
            return obj.tolist()
        return json.JSONEncoder.default(self, obj)

data = pd.Series([10, 20, 30, 40, 50])

# Serialize using custom encoder
json_data = json.dumps(data, cls=CustomEncoder)

print(json_data)

Then serialize the resulting object using the json.dumps() method provided by Python’s built-in json module, passing an instance of the custom encoder class using the cls parameter.

Ouput:

[10, 20, 30, 40, 50]

Conclusion

That’s the end of our discussion about the “typeerror object of type series is not json serializable” error message.

This article already provides different solutions that you may use to fix this “object of type series is not json serializable” type error.

We are hoping that this article provided you with sufficient solutions to get rid of the error.


You could also check out other “typeerror” articles that may help you in the future if you encounter them.

Thank you very much for reading to the end of this article