python - 如何在单独的行和列上正确写入 CSV 文件？

Question

我正在用 Python 制作一个小的食谱输入和输出程序，但是我在将成分写入 CSV 文件时遇到了问题。我正在尝试使用以下代码将列表的每个项目打印到逗号分隔的文件中:

with open('recipes/' + recipeName + '.csv', 'w') as csvfile:
    recipewriter = csv.writer(csvfile)
    recipewriter.write(ingredientList[0])
    recipewriter.write(ingredientList[1])
    recipewriter.write(ingredientList[2])

在列表中，有三个项目。例如，这可能是我要保存到文件中的列表:

ingredientList = ['flour', '500', 'g']

我希望数据在 CSV 文件中显示如下:

flour,
500,
g,

相反，它看起来像这样:

f,l,o,u,r,
5,0,0,
g,

如何让它以我想要的格式显示？

这是我的源代码:

#Python 3.3.3

import sys #Allows use of the 'exit()' function
import csv #Allows use of the CSV File API

def mainMenu():
    print("########################################################")
    print("# Welcome to the recipe book, please select an option: #")
    print("# 1. Add new recipe                                    #")
    print("# 2. Lookup existing recipe                            #")
    print("# 3. Exit                                              #")
    print("########################################################")

    selectedOption = None
    inputtedOption = input()

    try:
        inputtedOption = int(inputtedOption)
    except ValueError:
        print("Invalid option entered")

    if inputtedOption == 1:
        selectedOption = inputtedOption
    elif inputtedOption == 2:
        selectedOption = inputtedOption
    elif inputtedOption == 3:
        print("Exiting...")
        sys.exit(0)

    return selectedOption

def validateInput(inputtedData):
    try: #Test if data is an integer greater than 1
        inputtedData = int(inputtedData)
        if int(inputtedData) < 1: #Recipes cannot contain less than 1 ingredient
            print("Sorry, invalid data entered.\n('%s' is not valid for this value - positive integers only)" % inputtedData)
            return False
        return int(inputtedData)
    except ValueError:
        print("Sorry, invalid data entered.\n('%s' is not valid for this value - whole integers only [ValueError])\n" % inputtedData)
        return False

def addRecipe():
    print("Welcome to recipe creator! The following questions will guide you through the recipe creation process.\nPlease enter the name of your recipe (e.g. 'Pizza'):")
    recipeName = input()
    print("Recipe Name: %s" % recipeName)
    print("Please enter the amount of people this recipe serves (e.g. '6'):")
    recipeServingAmount = input()
    if validateInput(recipeServingAmount) == False:
        return
    else:
        recipeServingAmount = validateInput(recipeServingAmount)
    print("Recipe serves: %s" % recipeServingAmount)
    print("Please enter the number of ingredients in this recipe (e.g. '10'):")
    recipeNumberOfIngredients = input()
    if validateInput(recipeNumberOfIngredients) == False:
        return
    else:
        recipeNumberOfIngredients = validateInput(recipeNumberOfIngredients)
    print("Recipe contains: %s different ingredients" % recipeNumberOfIngredients)
    ingredientList = {}
    i = 1
    while i <= recipeNumberOfIngredients:
        nthFormat = "st"
        if i == 2:
            nthFormat = "nd"
        elif i == 3:
            nthFormat = "rd"
        elif i >= 4:
            nthFormat = "th"
        ingredientNumber = str(i) + nthFormat
        print("Please enter the name of the %s ingredient:" % ingredientNumber)
        ingredientName = input()
        print("Please enter the quantity of the %s ingredient:" % ingredientNumber)
        ingredientQuantity = input()
        print("Please enter the measurement value for the %s ingredient (leave blank for no measurement - e.g. eggs):"  % ingredientNumber)
        ingredientMeasurement = input()
        print("%s ingredient: %s%s %s" % (ingredientNumber, ingredientQuantity, ingredientMeasurement, ingredientName))
        finalIngredient = [ingredientName, ingredientQuantity, ingredientMeasurement]
        print(finalIngredient[1])
        ingredientList[i] = finalIngredient
        with open('recipes/' + recipeName + '.csv', 'w') as csvfile:
            recipewriter = csv.writer(csvfile)
            recipewriter.write(ingredientList[0])
            recipewriter.write(ingredientList[1])
            recipewriter.write(ingredientList[2])

        i = i + 1

def lookupRecipe():
    pass  # To-do: add CSV reader and string formatter

#Main flow of program
while True:
    option = mainMenu()

    if option == 1:
        addRecipe()
    elif option == 2:
        lookupRecipe()

Answer 1

csv.writer 没有 write() 方法。在 Python 3 中，您可以这样做:

with open('recipes/' + recipeName + '.csv', 'w', newline='') as csvfile:
    recipewriter = csv.writer(csvfile)
    recipewriter.writerow([ingredientList[0]])
    recipewriter.writerow([ingredientList[1]])
    recipewriter.writerow([ingredientList[2]])