将熊猫系列的序列化json转变为熊猫系列dicts系列

Question

我有以下熊猫系列：

>>>df.A.head()

0    {"Date_": "2022-06-01T01:00:00+05:30", "submit...
1    {"Growth": [{"textField": "", "Change_Size": "...
2    {"submit": true, "HSI_Tag": "xyz...
3    {"submit": true, "HSI_Tag": "xyz...
4    {"submit": true, "roleList": "xy...
Name: A, dtype: object

该系列中的每个项目都是序列化的JSON 物品。我想将每个项目变成词典。我正在尝试执行以下操作，但是我会遇到错误：

for i in range(len(df.A)):
    df.A.iloc[i] = json.loads(df.A.iloc[i])

错误：

---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
<ipython-input-27-9b4e8d4e6d76> in <module>
      1 for i in range(len(df.A)):
----> 2     df.A.iloc[i] = json.loads(df.A.iloc[i])

C:\ANACONDA3\lib\site-packages\pandas\core\indexing.py in __setitem__(self, key, value)
    188             key = com.apply_if_callable(key, self.obj)
    189         indexer = self._get_setitem_indexer(key)
--> 190         self._setitem_with_indexer(indexer, value)
    191
    192     def _validate_key(self, key, axis):

C:\ANACONDA3\lib\site-packages\pandas\core\indexing.py in _setitem_with_indexer(self, indexer, value)
    640                 # setting for extensionarrays that store dicts. Need to decide
    641                 # if it's worth supporting that.
--> 642                 value = self._align_series(indexer, Series(value))
    643
    644             elif isinstance(value, ABCDataFrame):

C:\ANACONDA3\lib\site-packages\pandas\core\indexing.py in _align_series(self, indexer, ser, multiindex_indexer)
    774
    775         elif is_scalar(indexer):
--> 776             ax = self.obj._get_axis(1)
    777
    778             if ser.index.equals(ax):

C:\ANACONDA3\lib\site-packages\pandas\core\generic.py in _get_axis(self, axis)
    376
    377     def _get_axis(self, axis):
--> 378         name = self._get_axis_name(axis)
    379         return getattr(self, name)
    380

C:\ANACONDA3\lib\site-packages\pandas\core\generic.py in _get_axis_name(cls, axis)
    373                 pass
    374         raise ValueError('No axis named {0} for object type {1}'
--> 375                          .format(axis, type(cls)))
    376
    377     def _get_axis(self, axis):

ValueError: No axis named 1 for object type <class 'type'>

我该如何修复？

Answer 1

我最终用 和这样的lambda：

df.A = df.A.apply(lambda x: json.loads(x))