python - 更改 pandas csv 列的值样式 python

Question

我有一个如下数据集：

我的问题在注释列中，我想将上面显示的列表样式更改为如下所示：

• ['flight-sth sth sth]

我的意思是注释列值有多种样式，我只想将该样式更改为我的样式:)
示例：

['flight_search.price_range'] ==> ['flight-search price range']  
['flight_search.stops'] ==> ['flight-search stop']  
['flight_search.date.depart_origin'] ==> ['flight-search date depart origin']  

并在进行此转换后，将其完全替换为旧 注释列:)

---

注释样本：

anotation
['flight_search.destination1']  
['flight_search.origin']  
['flight_search.destination1']  
['flight_search.type']  
['flight_search.type']  
['flight_search.airline']  
['flight_search.stops']  
['flight_search.stops']  
['flight_search.price_range']  
['flight_search.price_range']  
['flight1_detail.from.time']  
['flight_search.date.depart_origin']  

标签： pythonpandasdst

Answer 1

annotation = [['flight_search.destination1'],  
['flight_search.origin'],
['flight_search.destination1']  ,
['flight_search.type']  ,
['flight_search.type']  ,
['flight_search.airline'],  
['flight_search.stops']  ,
['flight_search.stops']  ,
['flight_search.price_range']  ,
['flight_search.price_range']  ,
['flight1_detail.from.time']  ,
['flight_search.date.depart_origin']]  

empty = []
for i in annotation:
    empty.append([i[0].replace("_","-").replace("."," ")])

输出

[['flight-search destination1'],
 ['flight-search origin'],
 ['flight-search destination1'],
 ['flight-search type'],
 ['flight-search type'],
 ['flight-search airline'],
 ['flight-search stops'],
 ['flight-search stops'],
 ['flight-search price-range'],
 ['flight-search price-range'],
 ['flight1-detail from time'],
 ['flight-search date depart-origin']]

数据帧

# for dataframe

df["annotation"].apply(lambda x: [x[0].replace("_","-").replace("."," ")])

我相信这应该可以解决问题，如果没有错别字的话