[Python] Column named read as tuple instead of string in pandas

Discussão em 'Python' iniciado por Stack, Julho 30, 2025.

  1. Stack

    Stack Membro Participativo

    I have a column ContentVideo that exists in pandas df.

    Trying to do this trasnformation

    data.loc[data.ContentVideo == 0, "play_rate"] = 0

    however, when I am getting this error

    ~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File "/home/ray/anaconda3/lib/python3.12/site-packages/pandas/core/indexing.py", line 907, in __setitem__
    indexer = self._get_setitem_indexer(key)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File "/home/ray/anaconda3/lib/python3.12/site-packages/pandas/core/indexing.py", line 774, in _get_setitem_indexer
    return self._convert_tuple(key)
    ^^^^^^^^^^^^^^^^^^^^^^^^
    File "/home/ray/anaconda3/lib/python3.12/site-packages/pandas/core/indexing.py", line 989, in _convert_tuple
    keyidx = [self._convert_to_indexer(k, axis=i) for i, k in enumerate(key)]
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File "/home/ray/anaconda3/lib/python3.12/site-packages/pandas/core/indexing.py", line 1522, in _convert_to_indexer
    return self._get_listlike_indexer(key, axis)[1]
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File "/home/ray/anaconda3/lib/python3.12/site-packages/pandas/core/indexing.py", line 1558, in _get_listlike_indexer
    keyarr, indexer = ax._get_indexer_strict(key, axis_name)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File "/home/ray/anaconda3/lib/python3.12/site-packages/pandas/core/indexes/base.py", line 6200, in _get_indexer_strict
    self._raise_if_missing(keyarr, indexer, axis_name)
    File "/home/ray/anaconda3/lib/python3.12/site-packages/pandas/core/indexes/base.py", line 6249, in _raise_if_missing
    raise KeyError(f"None of [{key}] are in the [{axis_name}]")
    KeyError: "None of [Index([('C', 'o', 'n', 't', 'e', 'n', 't', 'V', 'i', 'd', 'e', 'o'), ('C', 'o', 'n', 't', 'e', 'n', 't', 'V', 'i', 'd', 'e', 'o')], dtype='object')] are in the [index]"


    I have verified that "ContentVideo exists as col name in dataframe.

    Sample df

    item_id user_id session_id post_id first_impression_timestamp ... ios ContentImage ContentLink ContentText ContentVideo
    0 urn:ContentVideo:105791 56071863.0 1c481691-a15b-4ec3-b3c5-89d7ceb16ff0 105791 2025-06-15 00:00:03.529 ... True False False False True
    1 urn:ContentText:103962 33716283.0 c8b001a3-8545-472c-acb9-0700fb7ba084 103962 2025-06-15 00:00:06.166 ... True False False True False
    2 urn:ContentImage:106951 46684903.0 5f26007f-fa14-44f6-aea7-8482508a750a 106951 2025-06-15 00:00:07.068 ... True True False False False
    3 urn:ContentImage:102602 41989204.0 ef53adda-f1f2-4c74-8274-831e1877fe3a 102602 2025-06-15 00:00:07.368 ... True True False False False
    4 urn:ContentVideo:100699 41008352.0 644597e0-4c0f-4a39-8550-2013cd149835 100699 2025-06-15 00:00:11.398 ... True False False False True

    Continue reading...

Compartilhe esta Página