Python – Pandas merge TypeError: object of type ‘NoneType’ has no len()

pandaspython

I'm experimenting with pandas merge left_on and right_on params.
According to Documentation 1 and Documentation 2

Documentation 1: states that left_on and right_on are field names to join on in left/right DataFrame.
Documentation 2: Columns from the left DataFrame to use as keys

What does keys means?

Following documentation 1:

left_frame = pd.DataFrame({'key': range(5),
                       'left_value': ['a', 'b', 'c', 'd', 'e']})
right_frame = pd.DataFrame({'key': range(2,7),
                       'right_value': ['f', 'g', 'h', 'i', 'j']})

I did this:

df = pd.merge(left_frame,right_frame,how='right',right_on='key')

left_frame has 'key' as field name, but yet it returns

TypeError: object of type 'NoneType' has no len()

Best Answer

It seems you need:

df = pd.merge(left_frame, right_frame, how='right', on='key')

because same left and right column names.

If columns names are different:

df = pd.merge(left_frame, right_frame, how='right', right_on='key1', left_on='key2')

What does keys means?

If check merge:

on : label or list

Field names to join on. Must be found in both DataFrames. If on is None and not merging on indexes, then it merges on the intersection of the columns by default.

And it means values in columns to join on.

Related Solutions

Python – How to know if an object has an attribute in Python

Try hasattr():

if hasattr(a, 'property'):
    a.property

See zweiterlinde's answer below, who offers good advice about asking forgiveness! A very pythonic approach!

The general practice in python is that, if the property is likely to be there most of the time, simply call it and either let the exception propagate, or trap it with a try/except block. This will likely be faster than hasattr. If the property is likely to not be there most of the time, or you're not sure, using hasattr will probably be faster than repeatedly falling into an exception block.

Python – Determine the type of an object

There are two built-in functions that help you identify the type of an object. You can use type() if you need the exact type of an object, and isinstance() to check an object’s type against something. Usually, you want to use isinstance() most of the times since it is very robust and also supports type inheritance.

To get the actual type of an object, you use the built-in type() function. Passing an object as the only parameter will return the type object of that object:

>>> type([]) is list
True
>>> type({}) is dict
True
>>> type('') is str
True
>>> type(0) is int
True

This of course also works for custom types:

>>> class Test1 (object):
        pass
>>> class Test2 (Test1):
        pass
>>> a = Test1()
>>> b = Test2()
>>> type(a) is Test1
True
>>> type(b) is Test2
True

Note that type() will only return the immediate type of the object, but won’t be able to tell you about type inheritance.

>>> type(b) is Test1
False

To cover that, you should use the isinstance function. This of course also works for built-in types:

>>> isinstance(b, Test1)
True
>>> isinstance(b, Test2)
True
>>> isinstance(a, Test1)
True
>>> isinstance(a, Test2)
False
>>> isinstance([], list)
True
>>> isinstance({}, dict)
True

isinstance() is usually the preferred way to ensure the type of an object because it will also accept derived types. So unless you actually need the type object (for whatever reason), using isinstance() is preferred over type().

The second parameter of isinstance() also accepts a tuple of types, so it’s possible to check for multiple types at once. isinstance will then return true, if the object is of any of those types:

>>> isinstance([], (tuple, list, set))
True

Best Answer

Related Solutions

Python – How to know if an object has an attribute in Python

Python – Determine the type of an object

Related Topic