"C5", "C6", "C7", "C8", "C9", "C10", "C11", "C12", "C13", "C14"你帮我改成用单引号的
时间: 2023-12-25 20:29:54 浏览: 98
你可以使用pandas库中的replace()函数来将双引号替换为单引号。下面是一个示例代码:
```python
import pandas as pd
# 创建DataFrame
data = {'C1': [124832, 80501],
'C2': ['Zehut Sh\'ula"', 'Co-Host Andy Cohen; "Steel Magnolias" Cast: Queen Latifah, Alfre Woodard, Jill Scott'],
'C3': [None, None],
'C4': [7, 7],
'C5': [1997, 2012],
'C6': [None, None],
'C7': ['Z324', 'C2353'],
'C8': [124831, 80464],
'C9': [1, 2],
'C10': [3, 26],
'C11': [None, None],
'C12': [None, None],
'C13': ['3ecbb0386bee44d925ff0fcdb11e11b8', '4ec914112555c0fb2180cc7cab41c671'],
'C14': [None, None]}
df = pd.DataFrame(data)
# 使用replace()函数将双引号替换为单引号
df.replace('"', "'", regex=True, inplace=True)
# 打印修改后的DataFrame
print(df)
```
这段代码将会输出以下结果:
```
C1 C2 C3 C4 C5 \
0 124832 Zehut Sh'ula' None 7 1997
1 80501 Co-Host Andy Cohen; 'Steel Magnolias' Cast: Qu... None 7 2012
C6 C7 C8 C9 C10 C11 C12 C13 \
0 None Z324 124831 1 3 None None 3ecbb0386bee44d925ff0fcdb11e11b8
1 None C2353 80464 2 26 None None 4ec914112555c0fb2180cc7cab41c671
C14
0 None
1 None
```