python - 转换包含在数据框行值内的列表

Question

我有一个 Pandas 系列，每行都有列表元素。我想删除这些值并将它们存储回系列中。看起来像这样。有人可以帮忙吗？

0                           ['Harvard business review']
1                           ['Harvard business review']
2     ['Journal of Medical Marketing: Device, Diagno...
3                           ['Harvard business review']
4                    ['Science Translational Medicine']
5                    ['Science Translational Medicine']
6                                       ['Tetrahedron']
7                                       ['Tetrahedron']
8                                           ['bioRxiv']
9                                           ['Science']
10                                     ['Cell Systems']
11                                       ['Prescriber']
12                                             ['Cell']

我尝试将每个转换为列表，然后提取值，但它不会转换为列表。

Answer 1

用途:

import ast
df['column_name']=ast.literal_eval(df['column_name'])
df['column_name'].str[0]

或者，如果类型是对象，您可以尝试:

df['column_name'].str.extract('(\[(.*?)\])',expand=False)