我有一个csv文件(world.csv)如下所示:
"city","city_alt","lat","lng","country"
"Mjekić","42.6781","20.9728","Kosovo"
"Mjekiff","42.6781","20.9728","Kosovo"
"paris","42.6781","10.9728","France"
"Bordeau","16.6781","52.9728","France"
"Menes","02.6781","50.9728","Morocco"
"Fess","6.6781","3.9728","Morocco"
"Tanger","8.6781","5.9728","Morocco"
我想按国家将其拆分为多个文件,如下所示:
科索沃.csv:
"city","city_alt","lat","lng","country"
"Mjekić","42.6781","20.9728","Kosovo"
"Mjekiff","42.6781","20.9728","Kosovo"
France.csv:
"city","city_alt","lat","lng","country"
"paris","42.6781","10.9728","France"
"Bordeau","16.6781","52.9728","France"
Morroco.csv:
"city","city_alt","lat","lng","country"
"Menes","02.6781","50.9728","Morocco"
"Fess","6.6781","3.9728","Morocco"
"Tanger","8.6781","5.9728","Morocco"
试试这个:
根据国家名称筛选列。然后使用
pandas
中的to_csv
将其转换为csv文件如果不能使用pandas,可以使用内置的
csv
模块和itertools.groupby()
函数。您可以使用此选项按国家分组最简单的方法如下: #例如,在工作目录中创建一个名为“adata”的文件夹 #导入glob
相关问题 更多 >
编程相关推荐