我想在csv文件的每一行末尾附加一個值列表，除了標題。我嘗試了以下代碼，但它從csv文件中刪除了所有行，并且不會將任何值附加到csv文件中。import tensorflowfrom fer.fer import FERimport cv2from os import listdirfrom os.path import isfile, joinimport numpyimport csvf1 = open("C:/Yasir/Thesis/4/FaceDetectionLatest/bin/Debug/Data/demoScoringData9.csv", "a+")reader = csv.reader(f1)images = numpy.empty(len(onlyfiles), dtype=object)for n in range(0, len(onlyfiles)): images[n] = cv2.imread( join(mypath,onlyfiles[n]) ) # cv2.imshow(join(mypath,onlyfiles[n]),0) img = cv2.imread( join(mypath,onlyfiles[n]) ) detector = FER() emotion = detector.detect_emotions(img) dict = emotion[0] emoList = dict['emotions'] dict_writer = csv.DictWriter(f1, emoList) dict_writer.writerow(emoList)我想將以下值附加到已創建的csv文件中。我的意思是，除了如下所示的標題值之外，dict值應該附加到每行csv中。{'憤怒'： 0.15， '厭惡'： 0.0， '恐懼'： 0.05， '快樂'： 0.06， '悲傷'： 0.24， '驚喜'： 0.02， '中性'： 0.49}我還在分享我的csv文件截圖的屏幕截圖
1 回答
MYYA
TA貢獻1868條經驗 獲得超4個贊
下面是將列追加到現有 CSV 的基本示例：
數據.csv（原始）
col1,col2,col3
1,2,3
4,5,6
7,8,9
test.py
import csv
with open('data.csv',newline='') as fin:
r = csv.DictReader(fin)
lines = list(r)
with open('data.csv','w',newline='') as fout:
# Create writer with existing column headers plus new column headers
w = csv.DictWriter(fout,fieldnames=r.fieldnames + 'angry disgust fear happy sad surprise neutral'.split())
w.writeheader()
for line in lines:
emolist = {'angry': 0.15, 'disgust': 0.0, 'fear': 0.05, 'happy': 0.06, 'sad': 0.24, 'surprise': 0.02, 'neutral': 0.49}
line.update(emolist)
w.writerow(line)
數據.csv （最終）
col1,col2,col3,angry,disgust,fear,happy,sad,surprise,neutral
1,2,3,0.15,0.0,0.05,0.06,0.24,0.02,0.49
4,5,6,0.15,0.0,0.05,0.06,0.24,0.02,0.49
7,8,9,0.15,0.0,0.05,0.06,0.24,0.02,0.49
添加回答
舉報
0/150
提交
取消