Python：一次读取两个元组数组并将它们并排放置在CSV-fi上

Question

所以我有两个元组数组，它们以餐厅名称和Int排列：

("Restaurant Name", 0)

一个称为ArrayForInitialSpots，另一个称为ArrayForChosenSpots。我要做的是在csv文件中以并排顺序写入两行的元组，如下所示：

"First Restaurant in ArrayForInitialSPots",0,"First Restaurant in ArrayForChosenSpots", 1

"Second Restaurant in ArrayForInitialSpots",0,"Second Restaurant in ArrayForChosenSpots",0

到目前为止，我试过这样做：

with open('data.csv','w') as out:
        csv_out=csv.writer(out)
        csv_out.writerow(['Restaurant Name','Change'])
        for x, y in zip(arrayForInitialSpots, arrayForChosenSpots):
            csv_out.writerow(x + y)
            #csv_out.writerow(y)

但我得到：

UnicodeEncodeError: 'ascii' codec can't encode characters in position 3-6: ordinal not in range(128)

如果我删除zip函数，就会得到too many values to unpack。有什么建议吗？事先非常感谢。你知道吗

Answer 1

有了mhawke的帮助，这里是我的解决方案

with open('data.csv','w') as out:
   csv_out=csv.writer(out)
   csv_out.writerow(['Restaurant Name','Change'])
   for x, y in zip(arrayForInitialSpots, arrayForChosenSpots):
      list_ = [str(word).decode("utf8") for word in (x+y)]
      counter = 0
      while counter < len(list_):
         s=""
         for i in range(counter,counter+4):
            s+=list_[i].encode('utf-8')
            s+=","
         counter = counter + 4
      csv_out.writerow(s[:-1])