我正在尝试替换非结构化列表中的字符串,该列表已移动到数据帧中的一列:
my_list = [
['1001100', 'xxx', '', '1100', 'PAR_200', '21651947694', '0', '0', '20210301', '20210331', '1630,51', '1', '']
['1001110', 'sss', '', '1110', 'C-200', '20210307', '1630,51', '1', '7252048000136', '']
['1001115', 'ddd', '', '1115', '21', '', 'NO6520058050362', '0', '08', '110433', '1630,51', '1', '', '']
['1001120', 'fff', '', '1120', 'MG', '', '', '73895137480', '']
['101100', 'ees', '', '1100', 'PAR_200', '21653346587', '0', '0', '20210301', '20210331', '1013,84', '1', '']
['101110', 'fsc', '', '1110', 'C-200', '20210307', '1013,84', '1', '7252048000136', '']
['101115', 'fer', '', '1115', '1', '', 'LI1600081181694N2K346', '0', '06', '110433', '1013,84', '1', '', '']
['101120', 'ter', '', '1120', 'MG', '', '', '17651232321', '']
]
df1 = pd.DataFrame({'test_set': my_list})
我想将分隔符更改为管道“|”,然后写入文本文件。
但替换功能不起作用。我做错了什么?
df1 = df1.replace(to_replace =['[', ', '],
value ='|')
df1["test_set"] = df1["test_set"].replace('[', '|')
df1 = df1.test_set.replace([','], ['|'], regex=True)
df1['test_set'] = df1['test_set'].str.replace('[','|')