问题遇到的现象和发生背景
系统无法识别到我的csv文件
问题相关代码,请勿粘贴截图
import csv
path = 'survey.csv'
def run_main():
male_set = {'male', 'm'}
female_set = {'female', 'f'}
result_dict = {}
with open(path, 'r', newline='') as csvfile:
rows = csv.reader(csvfile)
for i, row in enumerate(rows):
if i == 0:
continue
if i % 50 == 0:
print('正在处理第{}行数据...'.format(i))
gender_val = row[2]
country_val = row[3]
gender_val = gender_val.replace(' ', '')
gender_val = gender_val.lower()
if country_val not in result_dict:
result_dict[country_val] = [0, 0]
if gender_val in female_set:
result_dict[country_val][0] += 1
elif gender_val in male_set:
result_dict[country_val][1] += 1
else:
pass
with open('survey.csv', 'w', newline='', encoding='utf-16') as csvfile:
csvwriter = csv.writer(csvfile, delimiter=',')
csvwriter.writerow(['国家', '男性', '女性'])
for k, v in list(result_dict.items()):
csvwriter.writerow([k, v[0], v[1]])
if __name__ == '__main__':
run_main()
运行结果及报错内容
FileNotFoundError Traceback (most recent call last)
C:\Users\GONEBU~1\AppData\Local\Temp/ipykernel_1500/3554812124.py in <module>
32 csvwriter.writerow([k, v[0], v[1]])
33 if __name__ == '__main__':
---> 34 run_main()
C:\Users\GONEBU~1\AppData\Local\Temp/ipykernel_1500/3554812124.py in run_main()
7 female_set = {'female', 'f'}
8 result_dict = {}
----> 9 with open(path, 'r', newline='') as csvfile:
10 rows = csv.reader(csvfile)
11 for i, row in enumerate(rows):
FileNotFoundError: [Errno 2] No such file or directory: 'survey.csv'
把csv文件移动到了temp文件夹,但还是不行
我想要达到的结果
希望能够让代码正常运行