pands将GDELT的csv格式数据转为txt
代码及注释如下
import pandas as pd
import os
data = pd.read_csv(r'E:/WorkSpace/data/GDELT/20230825.export.csv',
delimiter='\t', encoding='utf-8', low_memory=False)
count = 0 #用于计数
write_max = 100 #确定写入行数
with open(r'E:/WorkSpace/data/GDELT/20230825.export.txt',
mode='w', encoding='utf-8') as f:
for line in data.values:
count += 1
for i in range(len(line)): #读取某一行的所有列
f.write((str(line[i])+'| ')) #不同列用竖线加空格'| '区分
f.write('\n\n') #不同行用两个换行'\n\n'区分
if(count >= 100): #写入write_max行
break