想要将如下这个字段按照逗号分离，但是在某些字符串中带有逗号，希望能不要分离字符串中的逗号
6898,"RAAF Williams, Laverton Base","Laverton","Australia",\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"
希望能分离成如下形式
6898
RAAF Williams, Laverton Base
Laverton
Australia
直接使用 Python 中的 split 方法会将"RAAF Williams"与"Laverton Base"分离开，请问有什么办法可以避免
 |
qwjhbFeb 11, 2020
1
exec('a=[6898,"RAAF Williams, Laverton Base","Laverton","Australia","YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"]')
|
 |
retanojFeb 11, 2020 via iPhone
2
好方法，命令执行 /代码执行严重漏洞都你这么写出来的
|
 |
4
正则表达式，如果单词是有引号的话
|
 |
5
@wuwukai007 #4 看来只能用 ^(\d+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+)$ 这种来分离了
|
|
retanojFeb 11, 2020
6
|
|
retanojFeb 11, 2020
7
不好意思，贴乱了
试试这个 import csv >>> list(csv.reader([your_string])) |
 |
yuanhegoFeb 11, 2020
8
|
 |
noreply69Feb 11, 2020
9
import csv
s = '6898,"RAAF Williams, Laverton Base","Laverton","Australia",\\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"' splitted = list(csv.reader([s], delimiter=',', quotechar='"'))[0] print(splitted) |
|
noreply69Feb 11, 2020
10
```
import csv s = '6898,"RAAF Williams, Laverton Base","Laverton","Australia",\\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"' splitted = list(csv.reader([s], delimiter=',', quotechar='"'))[0] print(splitted) ``` |
 |
12
ast.literal_eval('[6898,"RAAF Williams, Laverton Base","Laverton","Australia","YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"]')
|
 |
17
当中那个\N 能去掉吗？不去掉的话好像报错？
|
 |
18
直接整个 csv 文件也可以读进来的
|
 |
19
s = your_str
shuangyinhao_count = 0 result = [] temp = '' for i in s: if i == '"': shuangyinhao_count += 1 elif i == ',': if shuangyinhao_count == 1: # 当双引号数量为 1 时,继续添加字符而不做处理 temp += i else: result.append(temp) temp = '' else: temp += i if shuangyinhao_count == 2: shuangyinhao_count = 0 result.append(temp) print(result) |
 |
20
正则分隔
import re str = '6898,"RAAF Williams, Laverton Base","Laverton","Australia",\\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"' pattern = re.compile(r'\"[^\"]+\"\,|[^\"\,]+\,'); print(pattern.findall(str)) |
 |
21
@qwjhb @retanoj 安全地解析字符串成 Python 对象可以用 ast.literal_eval，遇到运算符会抛出异常
import ast ast.literal_eval('6898,"RAAF Williams, Laverton Base","Laverton","Australia","N","YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"') (6898, 'RAAF Williams, Laverton Base', 'Laverton', 'Australia', 'YLVT', -37.86360168457031, 144.74600219726562, 18, 10, 'O', 'Australia/Hobart', 'airport', 'OurAirports') |
|
23
@smallpython #19 感谢 这种相当于 C 语言中 getchar 最初想到这个方法就是感觉麻烦些
|
 |
larsenlouisFeb 14, 2020
27
pandas 用条件扩充字段
|
1
Select Language